COE126 : Database Systems Flashcards
The overall logical structure of the database.
Logical Schema
The overall physical structure of database.
Physical Schema
The actual content of the database at a particular point in time.
Instances
The ability to modify the modify schema without changing the logical schema.
Physical Data Independence
Specification notation for defining the database schema
Data Definition Language (DDL)
ID uniquely identifies instructors
Primary Key
Language for accessing and updating the data organized by the appropriate data model. Also known as query model.
Data Manipulation Language (DML)
Require a user to specify what data are needed and how to get those data.
Procedural DML
Require a user to specify what data are needed without specifying how to get those data.
Declarative DML
__________ is nonprocedural. A query takes as input several tables (possibly only one) and always returns a single table.
SQL Query Language
Are programs that are used to interact with the database in this fashion.
Application Programs
Deciding on the database schema. It requires what we find a “good” collection of relation schemas.
Logical Design
Deciding on the physical layout of the database.
Physical Design
A database system in partitioned into modules that deal with each of the responsibilities of the overall system.
Database Engine
A program module that provides interface between the low-leveled data stored in the database and the application programs and queries submitted to the system.
Storage Manager
Interprets DDL statements and records the definitions in the data dictionary.
DDL interpreter
Translates DML statements in a query language into are evaluation plan consisting of low-level instructions that the query evaluation engine understands.
DML compiler
Executes low-level instructions generated by the DML compiler.
Query Evaluation Engine
A ___________ is a collection of operation that performs a single logical function in a database application.
transaction
Ensures that the database remain in a consistent (correct) state despite the failures and transaction failures.
Transaction-management component