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.