The file management system is a traditional mechanism to store data permanently into secondary devices but in today digital word TBs of data need to be stored in an organized place which needs security as well as retrieval in seconds of time
Traditional file systems have the very lowest level of storage and processing capabilities which created problems regarding security, integrity, memory storage and duplicate data, data inconsistency and so on
If you want to retrieve data from the flat file then we must develop application programs in a high-level language, so that data can be stored and retrieved fastly and securely within the time bound
Ex: SQL – structured query language
In any storage, we need to make copies of data for backup but in traditional file management systems once we update data in one location sometimes it fails to get updated in the copy of the data, so that it may create problems of inconsistency this rate is called duplicate data or redundant data
Data integrity ensure that only required data is stored in the database.e data is validated before entered into the database using integrity constraints such as primary key, foreign key, etc.
In traditional file management, there is no authentication mechanism at high-end whereas DBMS provides levels of security authentication which can be done at user level admin level, etc
If you want to retrieve data very fastly from the database we are using indexing mechanism whereas Flat files don’t support indexing and solely depend upon secondary storage devices
Indexing is a mechanism where data is uniquely identified and stored using some computational techniques so that data is retrieved very fastly.