DBMS Vs Traditional File System
Difference between Data Base Management System and Traditional File System
Basis | DBMS | Traditional File System |
Data Organization | Structured (tables) | Unstructured files |
Redundancy | Low | High |
Consistency | High | Low |
Security | Strong | Weak |
Data Access | Easy (SQL) | Difficult |
Backup & Recovery | Automatic | Manual |
Traditional File System
In a traditional file system, data is stored in separate files, and each application program manages its own files.
Database Management System (DBMS)
A DBMS is software that stores data in a central database and lets many users and programs access it in a controlled way. Examples: MySQL, Oracle, MS Access, PostgreSQL.
Differences
- Redundancy: the file system repeats the same data in many files; a DBMS reduces duplication.
- Consistency: duplicate data in files can become inconsistent; a DBMS keeps data consistent.
- Data access: files need a separate program for every query; a DBMS uses a query language such as SQL.
- Security: files have limited protection; a DBMS gives user accounts and access rights.
- Sharing: files are hard to share safely; a DBMS supports many users at once.
- Backup and recovery: manual in a file system; built into a DBMS.
- Integrity: a DBMS can enforce rules (constraints) such as primary keys.
Limitations of DBMS
DBMS software can be costly, needs trained staff and more hardware, and a failure of the central database affects all users.
Important Questions
Q. Write any three advantages of DBMS over a traditional file system.
Ans. Reduced data redundancy, better data security, and easy data sharing among multiple users.
Q. What is data redundancy?
Ans. Data redundancy means the same data is stored in more than one place.
Q. Name any two DBMS software.
Ans. MySQL and Oracle.