| Filesystem | DBMS |
|---|
| Data is stored into directories and sub-directories | Data is stored in a table, graph, documents or key-value pairs |
| Data redundancy is an issue | Data redundancy can be prevented by Database Normalisation |
| Data inconsistency is an issue | Data inconsistency is prevented by data centralisation |
| Provides less security | Provides a lot of security mechanisms |
| Cheaper and easier to set up | Relatively costlier and complex to setup |
| Data independence (immunity of user apps to changes made in the data definition and organisation) | Data independence exists |
No major recovery mechanisms (fsync or write ahead logging) | Provides crash recovery mechanisms (RDB & AOF restore in Redis) |
| Ex: Ext-4, NTFS, FAT-32, BTRFS, etc. | Ex: Oracle MySQL, Neo4j, Redis, etc. |
Refs §
- File system imperfect recovery solutions