Transcript DATABASE MANAGEMENT & PROGRAMMING Introduction to Database Processing      Four database examples File-Processing Systems Database processing Systems Definition of a database The history of database processing Four Database Examples      Mary Richards.

DATABASE MANAGEMENT
& PROGRAMMING
Introduction to Database
Processing





Four database examples
File-Processing Systems
Database processing Systems
Definition of a database
The history of database processing
2
Four Database Examples





Mary Richards Housepainting
(Fig. 1-1, 1-2, 1-3)
Treble Clef Music (Fig. 1-4, 1-5)
State Licensing and Vehicle
Registration Bureau
Calvert Island Reservations (Fig. 1-6)
Comparison of Database Applications
(Fig. 1-8)
3
File Processing Systems


Data are stored as groups of records in
separate files
Some characteristics:
Separated and isolated data
Data duplication (Data integrity problems if the
data are not logically consistent)
Application program dependency
Incompatible files
Difficulty in representing data
4
Database Processing Systems
The relationship of application
programs and the DBMS (Fig. 1-9)
 Some characteristics

Integrated data
Reduced data duplication
Program/Data independence
Easier representation of the users’
perspectives
5
Definition of a Database

A database is a self-describing
collection of integrated records.
– Self-describing because it includes the
user’s source data and a description of its
own structure called the data dictionary or
metadata.
– A collection of integrated records: User
data + metadata + Indexes (relationships
among data), application metadata.
– A database is a model of the user’s model.
6
History of Database Processing

The Relational Model
Data is stored as tables, and relationships
among rows of tables are visible in the
data.
 Microcomputer DBMS Products (e.g.
dBase)

Client-Server Database Applications
Multiuser database processing occurs in a
LAN-based multiuser architecture
7