Introduction to Data Management

Database: A large and persistent collection of (more-or-less similar) pieces of information organized in a way that facilitates efficient retrieval and modification.

Examples:

Common circumstances:

State of business in 1950s/60s

Solution

Abstract common functions to create a uniform, well defined interface for applications accessing data

DBMS provides core functionality:

Fundamental principle

Data independence: Applications do not access data directly but instead through an abstract data model provided by the DBMS.

Three Level Schema Architecture

Formalized by ANSI/SPARC (American National Standards Institute, Standards Planning And Requirements Committee) in 1975

ANSI/SPARC Three Level Architecture diagram

Types of Database Users

Brief History of Database Management