File System Vs DBMS – Why File Systems were replaced by DBMS ?. Difference between file system and DBMS. Before the database management system started the file system was used extensively for storage of our database. So the question comes what happened to the file system or why it was replaced by the database management system. Also, the Database management may have replaced the file system but it does not mean it is not used today. For example, the operating system till today uses a file system for storing new data, you might have stored the newly downloaded movie in mp4 format in the downloads folder, these folders are arranged in the hierarchical form you can see the hierarchy of the file from the windows explorer. Therefore the file system can be used to store the data in a hierarchical structure.
File System Vs DBMS: Search of Information
So, if the file system were able to fulfill our requirement then why the database management system, because of the introduction of the internet and usage of the world wide web what caused the DBMS to become a worldwide hit. The world wide web introduced us to the client-server architecture, in this architecture, there is only one server and there can exist many clients performing their work on the server.
The file system became very inefficient in such scenarios. Let’s take the example of searching of particular flight information, if you use the file system method than in that case information of all morning flight maybe in one file and information of all-night flights in another file, therefore in this case which uses file system in a hierarchical structure you will have to download all the file hierarchy if you want the complete information about the flight that you need.
But in a database management system to find the flight that you are looking for you just have to use relational algebra and ask the information from the database based on this mathematical query such as if you want to ask the server about the information about the flight time of a particular flight you just have to type “SELECT flightTime FROM flight;” and this query will provide you that specific piece of information in just a few bytes than downloading gigabytes of data in the file system. The database system has improved our searching strategy and delivers more accurate results with fewer data.
File System Vs DBMS: Attribute Information
If you want any form of information that has to be extracted and that in a file-based system then you will require the information about the file location and other attributes or in other words metadata about the file system. For example, if you have to access a particular video clip on your computer then you will have to exactly know where it is present that is in the media under the videos folder. Without this information, you cannot access the required information. Your access to information is more dependent on your knowledge of the location of the file.
In the database management system, your access to information is not dependent on the knowledge of the location. For example, if you want to know the status of your flight then you can simply type the name of the flight in the web app and you will know all the details about the flight. When you type some words in the search bar your words get embedded with the SQL query and they are sent to the server requesting the information that you want and the server finds from its huge database with the help of various relations and then respond to your query by sending the retrieved information back to the web app. This is what makes DBMS better than a file-based system.
File System Vs DBMS: Concurrent access of data
When many users try to access the information at the same time then it is called concurrent access to the information. The database management system is well equipped to handle the concurrent access of the data. For example, in a school, there will be a database about the information about the student and teachers, and the teachers of the same grade are allowed to access and change the records of the student in the same grade. Therefore there can be many teachers who can access the database and change the data that is present on the database this is concurrent access of the data but also they have the permission to change the data in the database and this can create some clashes in the database because if more than one teachers attempt to change the same record of the same student then it will have two different data for the same student therefore many protocols exists in the concurrent access in DBMS so that it can avoid such clashes which can lead to a discrepancy in the database.
When we talk about a file-based system there are no such protocols to deal with concurrent access and the change in the data can be only in either read or write mode therefore either anyone can change the data or no one can change the data.
File System Vs DBMS: Security of Information
When your large database is available to thousands of users the information in the database must be secured. Some information that is stored in the database is private and is meant to be confidential only a few people are authorized to access that knowledge or it can compromise the privacy of data. In a file-based system, there is no security for access to information. There will be one key to access all the data in the database and this method is not at all effective to safeguard the information. Therefore the database management system has role-based security it means that you can give different permission to access data to different users. For example, to access the school database, there can be a different level of permission that is granted to the teacher and student such as the students can view their scores only and cannot view the scores of their class their permission limits them to data access of their record but the teacher can view the marks of all the students because the permission allowed to the teacher can access the records of their class and not some other. In this way, many permissions can be granted to other users making the information more secure than the file-based system.