Discuss the advantages of a relational data base management system over a traditional sequential file Essay Paper
Relational database management system helps in organizing large amounts of data by using multiple tables to define different types of data. This is not the case in the traditional sequential file system, which organizes files according to the simplest method of writing the data records. The files can be retrieved in the order in which they are stored (Nagpal, 2011). Below are the advantages of relational database management over the traditional sequential file system.
Relational database management system enables multiple users to access the database simultaneously. The system has a built-in functionality that enables users to access files while they are changes. The functionality also helps in preventing collision between multiple users who are updating the data. It also restricts users from accessing records that have partially updated by other users. Multiple users do not have access to a file under the traditional sequential file system. A language referred to Structured Query Language (SQL) enables users to ‘insert’, ‘update’, and ‘delete’ files in the system (Sølvberg & Kung, 2012).
Relational database management has better security than the traditional sequential file system. This is because it splits data into tables, thereby making it possible to make certain tables confidential. When a user logs into the database with their username and password, the database management system limits their access to only the tables that they have the permission to view. For instance, a salesman may only see the performance of his sales team but not the performance of other teams (Sølvberg & Kung, 2012).
Relational database management also caters future requirements in data more effectively than the traditional sequential file system. It separates data into tables, which makes it easy to add records that are currently not needed but may be necessary in the future. For instance, a city table may be amended to include all cities within the country. This is despite the fact that other records in the database are not using the information at the time (Nagpal, 2011).
This sample paper will help answer the following questions. If you need help writing your database essay, database term paper, database dissertation or thesis, our team of experts are ready to assist you.
- advantages of dbms over traditional file system
- advantages of traditional file system
- traditional file system vs database system
- disadvantages of traditional file system
- traditional file processing system in dbms
- traditional file processing system advantages and disadvantages
- disadvantages of dbms over file system
- difference between traditional file system and dbms in tabular form
Nagpal, D.P. (2011). Textbook on management information systems. New Delhi: S Chand.
Sølvberg, A., & Kung, D.C. (2012). Information Systems Engineering: An Introduction. Berlin, Heidelberg: Springer Berlin Heidelberg.