Database management Systems

Unit 1

What is a Database?

- Database is a organisesd collection of data.
- DBMS refers to the technology for creating and managing the data.
- Most databases contain the most simple for of data storage called **Table** Which conatains rows and coloumns.

History of DBMS

- Network Data Model
- Hieriacial Data Model
- Relational Data Model
- SQL

File System vs DBMS

Unstructered                            Structured
No Concurrency                          Concurrent Access
No Recovery                             Crash Recovery
Redundency is more                      Redundancy is less
Inconsistant Data                       Consistant Data
less Secure                             More Secure
Mutex locking issue                     No mutex locking issue

Advantages of DBMS

- Data Independence
- Efficient Data Access
- Data Initgerty and Security
- Data Administration
- Cocurrency and Dashboard control