DBMS – Database System Various File System

Tutorials Point 

Topics: DBMS, File Systems, Software

Transcript Summary

DBMS and file systems related topics are discussed. Database Management System (DBMS) is a software designed to store, retrieve, define, and manage data in a database. The presenter discusses the difference between database systems versus file systems.  

In the case of a high level programming language, data files can be kept and that type of data carries out, insert, delete, update, searching operations. In the case of a database, organized collection of interrelated data of an enterprise and operations like insert, delete, update, searching and sorting is used. A file processing system can replace our database systems because that is the cheaper solution, however, file processing systems will have multiple disadvantages and failures compared to DBMS systems.  

The first point is data redundancy and inconsistency. One file processing system might have been developed through a long period of time. As a result of that, the same data might have gotten replicated and copied onto the multiple data files. Suppose a particular age of a person is written onto the multiple data files. During the update operation on that particular edge value, which might have somehow carried out partial auditions, this will have some of the instances of that age updated and some remained unaltered in that case. If a user wants to know what the age of the person is, you will be getting more than one answer. This is known as data redundancy. Different programming might have been used to develop that file processing environment and the same data might have got replicated into multiple sections. In the case of database systems, queries are executed through SQL queries. In the case of file processing systems such advantages are missing through data isolation. 

The next point is difficulty in accessing data. Multiple different queries in the structured query language and a user can switch required data out from the DBMS. In the case of file processing systems, that is, suppose some programming has been made to find out the maximum marks in mathematics. In the case of database systems, we can easily execute queries through SQL queries. In the case of a file processing system, such advantages are missing. Suppose the same data has different data types and formats in different data files and the gender of a person in one data file. The file has been written as male female, however in other data files, the gender has been written as M&F. This means they are the gender of the type character in another data file.  

Suppose the science students cannot take any book from the Library of the Commerce Department. Commerce students cannot issue any book from the Arts Department or from the Science Department book libraries, so these are the different constants. Third year students can take the maximum at a time. Professors can take a maximum of 12 books at a time from the library, so these are the different integrity constraints. In the case of file systems, such integrity constraints are very difficult to get implemented, however,  in the case of DBMS, it can easily handle such integrity ground constants. 


DBMS – Database Users and User Interfaces