Now, let’s go deeper!! Let’s understand what a file-system is. Along with why we need to use DBMS over file-system.
File-system – filesystem is a method and data structure that the operating system uses to control how data is stored and retrieved. After storing data into a file, we can retrieve data from the file by its name, size, location, date, permissions etc.
Different types of operating systems use different file-systems like – windows [NTFS] , Ubuntu Linux[EXT4], garuda-linux[BTRFS] etc.
Why do we use DBMS over file-system?
Ans – let’s say, if you want to get admission into a college, you need first visit the corresponding university website and search for your subject, that is how many colleges offer that course for you.
Now, for that you need to fill-up a form which will search for the right college for you. But the question arrives, how does that work behind? Ans is that particular university uses some DBMS for doing this operation. If it uses any file-system then its processing will obviously be very slow.
If you want to see if a particular college offers a particular degree or not, and you query data amount let’s say 2KB,So will search into a database about it and return some result around max 2KB.if the university uses any DBMS system then this operation will happen smoothly. But say, if that university uses a file-system, then it will fetch not only college name along with its faculty details, total departments records, location, creation date etc.(data around 2GB) which seems to be unnecessary.
Let’s a difference between file-system and DBMS
| Topics | DBMS | file-system |
| Data storing process | It stores data in the form of table/relation(row and column) | It stores the data, in the form of a file with file’s name, size, location, creation date, permission etc. |
| security | For each user we can set custom permissions. | It’s not much good like DBMS |
| Speed | Information retrieval process is very fast | Information retrieval process much slower than any DBMS |
Notes – Data independence is not possible in file systems. A concurrency facility is provided by a database management system. File system doesn’t provide the facility of recovery, in case of data loss.
Now let’s understand the common term difference between DBMS and RDBMS .
RDBMS – Relational Database Management System (RDBMS) is a more advanced version of a DBMS system that allows access to data in a more efficient way. It is used to store or manage only the data that are in the form of tables.
RDBMS VS DBMS
DBMS stands for Database Management System, and RDBMS is the acronym for the Relational Database Management system. In DBMS, the data is stored as a file, whereas in RDBMS, data is stored in the form of tables. To know what is the difference between RDBMS and DBMS, check out the table below.