CS 348- Midterm Exam Guide - Comprehensive Notes for the exam ( 60 pages long!)
5 Oct 2017
School
Department
Course
Professor
Document Summary
What is a database: data representation of facts, concepts, or instructions, operations on data or data items, volatile vs persistent data supply some information. A large and persistent collection of (more-or-less similar) pieces of information organized in a way that facilitates e cient retrieval and modi cation. Structure of the db determined by the abstract data model used. A program (or set of programs) that manages details related to storage and access for a database. Data model formalism that de nes what the structure of the data are. A database instance is a database (real data) that conforms to a given schema. Why database technology: data constitute an organizational asset. Integrated control: reduction of redundancy, avoidance of inconsistency, data integrity, sharability, improved security, programmer productivity. Data independence: programmers do not have to deal with data organization. Abstracts common functions and creates a uniform well de ned interface for applications accessing data.
