Database Management Systems: Advantages, Disadvantages, Users, and History, Slides of Introduction to Database Management Systems

Download Database Management Systems: Advantages, Disadvantages, Users, and History and more Slides Introduction to Database Management Systems in PDF only on Docsity!

Database

Management

Systems

Lecture - 2

Overview of

lecture-

Database definitions

File processing systems

Advantages of database

Malik Sharif 23 55 Sh. M. Akmal 24 55 M. A. Butt 20 40 Malik Junaid 19 20

Emp Name Age Salary

Company: Super Soft Dept: Sales

Data & Information

Schema

Database Applications

Database Management System (DBMS)

Economy of scale Better concurrency control Better backup and recovery procedures

They also provide

BUT

Its not always just the

SUGAR

Data As Resource

Resource

Any asset that is of

value to an organization

and that incurs cost

Is data a resource?

YES

name, age, qual, sal

Employee

Emp Name text Age number Sal number Malik Sharif 23 55 Sh. M. Akmal 24 55 M. A. Butt 20 40 Malik Junaid (^19 20) Docsity.com

Levels of Data

Real-world data

Metadata

Data Occurrence

Database Users

Database Administrator (DBA)

A person who has central control over data and programs that access this data

Functions of DBA

Schema definition Granting data access Routine Maintenance  Backups  Monitoring disk space  Monitoring jobs running Docsity.com

Database

Architecture

Initiates in 1960s; IMS, IDS

Conference on DAta Systems Languages (CODASYL)

Data Base Task Group (DBTG)

General architecture in 1971

History