Datama1

-  collection of programs that enables user to create and maintain a database. General purpose software system facilitates process.

• DBMS

• Metadata

• Database

• Data Models

-  file processing system data stored each individual app in org - each dept within org has its own set of files - no overall map, plan, or model guided app growth.

• DBMS

• Instances

• File system

• Metadata

descriptions of properties of data, include data types, field sizes, allowable values.

• DBMS

• Data Abstraction

• Database

• Metadata

central repository of shared data, managed by a controlling agent. Stored in a standardized, convenient form. - requires a Database Management System (DBMS)

• Database

• File system

• Schema

• DBMS

data are logically stored in databases managed by DBMS

• Data manipulation

• Database Approach

• Database

• Schema

design of the database

• Schema

• Data models

• Instances

• Database

contains a snapshot of the database

• Data models

• Database Approach

• Instances

• Data Independence

capacity to change schema at one level w/out having change schema at next higher level.

• Data independence

• DBMS

• DBMS Language

• Data models

  provides conceptual tools for describing the design of a database at each level of data abstraction.

• Data models

• Data Independence

• DBMS

• Data manipulation

capacity to change schema at one level w/out having change schema at next higher level.

• Data independence

• DBMS

• DBMS Language

• Data models