Database Systems vs. File Systems
 

DBMS
A computerized record-keeping system

File System
A collection of individual files accessed by applications programs.

Limitations File System Databases

  • Separated and Isolated Data makes access, update and management difficult
  • Data Duplication - Wastes space and can lead to data integrity (inconsistency) problems
  • Depends on Application Program - Changes to a single file require changes to programs
  • Incompatible Files on different systems
  • Not standardized = private standards by applications

Advantages of a DBMS

  • Minimize data duplication
  • Independence of Application programs
  • Data stored in a uniform structure
  • Data sharing is concurrent
  • Increased Security and Privacy
  • Multiple views of same data
  • Expandability, Flexibility, Scalability
  • Reduced application development time
  • Standards enforcement
(c) Shilpa Sayura Foundation 2006-2017