Question

Differentiate between file system and database system with an example.

•  

Answer 1

File System	Database System
Organizes data into files and directories	Organizes data into tables, rows, and columns
Accessed through a hierarchical directory structure	Accessed through SQL queries
Offers limited data manipulation options (e.g. file rename, copy, delete)	Offers extensive data manipulation options (e.g. INSERT, UPDATE, DELETE)
Provides limited data integrity features (e.g. file permissions, backups)	Provides strong data integrity features (e.g. data validation, transaction management)
Offers limited concurrency control options (e.g. file locking)	Offers strong concurrency control options (e.g. locking, multi-version concurrency control)
Limited scalability options (e.g. storage capacity)	High scalability options (e.g. distributed databases, sharding)
Offers limited performance optimizations (e.g. file access speed)	Offers high performance optimizations (e.g. indexing, query optimization)