Essay on The Limitations Of A File Based System
Separation and isolation of data
In a file-based system, data are isolated in separate files, making it very difficult to access the data that is available. For example, if a university wanted to extract a list of all the applications it received, and wanted to filter out the prospective students who wanted to start in fall 2016 for a marketing campaign. In a file based system the application programmer would first have to create a temporary file for all future student applications, and then run a search for all applicants whose start date was “fall 2016”. The application developer must then match the processing of both files, to ensure that the extracted data is accurate. As tedious and manual as it sounds, it increases in difficulty as more filter criteria is added in. This is what makes processing data in file-based systems so difficult (Connolly, 2014).
In database management systems (DBMS), on the other hand elevates this difficulty from the end user wanting to extract this information. A database is generally used for storing related, structured data in well-defined data formats. This allows DBMS to easily provide a means of storing relational data, in addition to a flexible way of retrieving that data. Databases uses rich query language to retrieve data through controlled access (Davidson, 2015).
Duplication of Data
The duplication of data, or data redundancy is what a file-based system does all so well due to…