Db vs File System

Topics: Database, File system, Operating system Pages: 2 (536 words) Published: June 8, 2013
DB vs File System
My primary concern is availability, integrity, quality and easy accessibility of information resources. A customised file system provides hierarchical storage and organization of files mostly on a single computer and it is usually part of the operating system of the computer the files are stored. File system stores bytes on a computer and the structure is imposed by the creator of the file. For a database system the records can be arrange logically and organized for efficient and easy access. In view of the above reasons I prefer a Database system than a customized file system.

Advantages and Disadvantages

Transaction support

Database systems guaranteed atomic transactions which determine the failure or success of an operation and concurrent access to the same set of data. Most file systems lack this feature. Fast Indexing

Database systems have ability to retrieve data quickly based on indexing of attributes and data property. The functionality cannot be found in files system. For example a files system cannot separately retrieve files created at a particular time. Desktop application such as Google desktop that searches files still requires indexing the complete file system and storing them in an internal relational-database before it can provide result. Snapshots

A database snapshot provides a read-only, static view of a source database as it existed at snapshot creation, minus any uncommitted transactions. Uncommitted transactions are rolled back in a newly created database snapshot because the Database Engine runs recovery after the snapshot has been created (transactions in the database are not affected). The features are essential in backup applications where copies of data are needed at a point in time. Most file-systems except VxFS and ZFS do not have features. In a files system backup operation depend running application or underlying storage for snapshots. Clustering

File systems do not support clustering. Clustering...

References: File systems and databases [Online] Princeton: Princeton University. Available from http://www.cs.princeton.edu/courses/archive/fall11/cos109/09filesys.pdf (Accessed 1 June 2013).
Jaspreet S. (2009). File-systems vs. Databases [Online] Available from
http://www.druva.com/blog/2009/01/25/file-systems-vs-databases/ (Accessed 1 June 2013).
Microsoft Developer Network (2013) How Database Snapshots Work [Online] Available from
http://msdn.microsoft.com/en-us/library/ms187054(v=sql.105).aspx (Accessed 1 June 2013).
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Database System vs. File System Essay
  • Comparative analysis of File System of Operating System Essay
  • File System Essay
  • Disadvantages of File Processing System Essay
  • File Management and File Systems Essay
  • Essay on File System and Configuration File
  • Operating System File Systems Essay

Become a StudyMode Member

Sign Up - It's Free