Why is database approach more advantageous compared to the traditional file processing system?
Show File Processing
Systems Two Major Weaknesses • Data Redundancy — Each department or area in an organization has its own files in a file processing system. Thus, the same fields are stored in multiple files. Duplicating data in this manner wastes resources such as storage space and people’s time. Data redundancy also can increase the chance of errors. • Isolated Data — Often it is difficult to access data stored in separate files in different departments. Sharing data from multiple, separate files is a complicated procedure and usually requires the experience of a computer programmer. The Database Approach Strengths of the Database
Approach: • Improved Data Integrity — When users modify data in the database, they make changes to
• Easier Access — The database approach allows nontechnical users to access and maintain data, What are the advantage of database approach over the traditional file system?Data redundancy and inconsistency: Redundancy is the concept of repetition of data i.e. each data may have more than a single copy. The file system cannot control the redundancy of data as each user defines and maintains the needed files for a specific application to run.
What is an advantage of a database approach compared to file processing?Flexible: Database systems are more flexible than file processing systems. DBMS systems are scalable, the database size can be increased and decreased based on the amount of storage required. It also allows addition of additional tables as well as removal of existing tables without disturbing the consistency of data.
Is database management system is better than the traditional file system for an Organisation?Storing and retrieving of data can't be done efficiently in a file system. DBMS is efficient to use as there are a wide variety of methods to store and retrieve data. It does not offer data recovery processes. There is a backup recovery for data in DBMS.
|