DBMS vs File System

Leave a comment

February 8, 2013 by Ozgur Ozden

Mike Chapple, author of the about.com explains the database as “ organized mechanism Imagefor storing, managing and retrieving information” There are two ways of managing this databas as Database Management System (DBMS) and File Management System (FMS) therefore before we start comparing these two systems, let us summarize each one.
Database Management System (DBMS): Group of collected data which is called database is accessed by special software and purpose built hardware called DBMS. Main purpose of DBMS is to make the necessary connection, store and delete, data from the database. I have try to list some advantages and disadvantages of DBMS

Advantages

Disadvantages

customizable Complicated
Suitable for large database not embedded, sold separately (Oracle, DB2, MS Access etc…)
good processing power slow speeds
Suitable for midsize or large companies requires administrators
Supports multi-access – Shared data Expensive
custom made data extraction data is centralized
regular backups
Secure – Restricted – Access
Stores any kind of data
Controlling duplicate data

File Management System (FMS): is another database management system which access files or tables one by one. File system organizes and manages the data, available space on disk, files, directories. In addition to these features users should be able to create, delete and modify files, access control to files- basic ownership, back-up data and disk monitoring, organizing the data by file names. In FMS system files are stored locally to temporary places by means of a “file manager”

Advantages

Disadvantages

Cheap system Multi-user is not supported
Easy to use Only suitable for small database
Suitable for home and small business users Data spreaded
embedded into OS(MS Works, Cardfile) Integration problems
Transaction is not possible
Search mechanism is time consuming
Duplicated or separated data

File system and DBMS are two different way of managing data on the disk or network. clearly DBMS has more features and advantages compare to file system.
But I would prefer FS for small and home users and DBMS when more data manipulation is needed for large scale applications.
References:
1-  Database Management Systems Versus File Management Systems, [Online] Available from: http://www.scribd.com/doc/48143820/Database-Management-Systems-Versus-File-Management-Systems (Accessed 31 January 2013)
2- Difference Between DBMS and File System [Online] Available from: http://www.differencebetween.com/difference-between-dbms-and-vs-file-system/ (Accessed 31 January 2013)
3- Brookshear, J.G. (2011) Computer Science An Overview. 11th ed. New York: Addison-Wesley

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: