Database Management System (Dbms)

Database Management System (DBMS)
COMP 3850 PROF. RAFAEL RODRÍGUEZ

Agenda
 Why use a DBMS?

 Downsize of using a File Processing System (FPS)
 Upside of using a DBMS  Costs and risks ofusing a DBMS  Elements of a DBMS  Components of a Database Environment  Database Examples

Why use a DBMS?

Why use a DBMS?
 Before the DBMS came to life, the norm was to use atechnology called “File Processing System”.
 The File Processing System (FPS) is the process of

creating, storing and obtaining the contents from a document.

Downsize of using a File Processing System(FPS)

Downsize of using a File Processing System (FPS) (1/4)
 Program-Data Dependencies  All of the programs store metadata for each stored document/value/data.  Data Duplicity  Differentsystems or programs have multiple copies of the same data.  Lack of a centralized data control unit  Sharing the data gets difficult.

Desventajas de un Sistema de Procesamiento de Datos (FPS)(2/4)
 Extensive Performance Time  Programmers should design their own file formats.  Program maintenance gets lengthy/extensive.

Desventajas de un Sistema de Procesamiento de Datos (FPS) (3/4)
Problems with Program-Data dependencies  Every programmers needs to store the data of each application.  Every program needs to maintain the metadata for each data used.  Every program needs tohave their own routine for reading, inserting, updating and erasing the data.  There is no central control unit.  It contains uncommon file formats.

Desventajas de un Sistema de Procesamiento deDatos (FPS) (4/4)
 Problems with Data Duplicity  It is a waste of space  It causes problems when the data needs to be updated or maintained.


CHANGES IN DATA WILL CAUSE INCONSISTENCIES
It compromises the data integrity.

Upside of using a DBMS

Upside of using a DBMS
 Program-Data Dependency is eliminated

 Data Duplicity is eliminated
 Information consistency and...