CSIT 355 Lecture Notes - Lecture 1: Transaction Processing, Conceptual Schema, Referential Integrity
Document Summary
Define the following terms: data, database, dbms, database system, database catalog, program-data independence, user view, dba, end user, canned transaction, deductive database system, persistent object, meta-data, transaction-processing application. Data known facts that can be recorded and have implicit meaning. Database represents some aspect of the real world (mini-world). Collection of related data (a random assortment of data is not a database). A db is designed, built, and populated with data for a specific purpose. It has an intended group of users and some a preconceived applications in which the users are interested. Dbms a collection of programs that enables users to create and maintain a database. Metadata about the structure of each file, the type and storage format of each data item, and various constraints on the data. Program-data independence the structure of data files is stored in the dbms catalog separately from the access programs.