Difference between traditional and DBMS system

There are different-2 types of systems are there for storing data and information. But the oldest one technique is the file system or traditional system but now a days it has been replaced by the DBMS system because of so many reasons. DBMS stands for database management system which stores the data using SQL. The difference between traditional and DBMS system proves that how file system is not good in comparison of DBMS system.

Difference between traditional and DBMS system

The  difference between traditional and DBMS system is given below.  With this difference you will be able to differentiate both of the systems.

 

Issues of file system

As per difference between traditional and DBMS system you will get to know that file system is comparatively less good than DBMS system. So now we will discussing about what type of issues are we facing while in file system.

1. Redundancy of data :- Redundancy of data means duplicates of data. In file system duplicates data are recorded at many places. Thus for removing redundancy you have to delete the whole data of particular student. Thus it involves lot of redundancy of data.

2. Inconsistency of data :- Data is said to be inconsistent or not consistent if the data is not sequentially or logically defined or places. In simple words data that should not be in proper order or lot of copies of same data is found than it is called the inconsistent data.

3. Data dependencies :-  Files and records were described by specific physical formats that were code in the application program by the programmers , difficulty in representing the data from the user point of view.

4. No concurrent access :- Concurrent access means multiple access at the same time. In file system there is no concurrent access or multiple access. Thus if one user accessing the data than no other user can access the same data at same time. This is the major issue in file system.

5. Difficult data access :- In file system only the user should know that how to access data. So if user want to access the employee data from the thousands of employees so you can think how difficult it to access and retrieve the data.

6. Unauthorized access :- In file system there is less security. Thus unauthorized access should be easily happen in the file system. Suppose if student is the unauthorized user and access the marks of thus he can easily change their marks in file system. But in DBMS system it is not possible.

7. No backup and recovery :- One of the major difference between traditional and DBMS system is that there is no backup and recovery of data in file system. Thus it is very difficult to access or recover the lost data of anyone.

Above is the following reasons for the difference between traditional and DBMS system.