In the Normal file processing system, the traditional operating system is used. In this case, each program programs has its own various files to keep documents in different formats and therefore there may arise many issues like data redundancy, data inconsistency, difficulty in obtaining data, integrity, and security problem, etc.. These issues have promoted the growth of database management system. In this section we discuss some of the advantages and disadvantages of using a DBMS as follows:
From the Conventional computer file processing program, files and software programs are made by different programs over a longtime period and so the replicated copies of the very same data are created at several areas causing redundancy of data. In DBMS, all the data of a company is integrated into one database and the redundancy has been eliminated. But redundancy cannot be removed completely as sometimes it’s necessary to create duplicate copies of the very same data items so as to make relationship one of the tables.
If a data Item appears more than once in a database and also assume the database management system not mindful of the duplication then updating of among these may not upgrade others. This is called inconsistency. By controlling the redundancy the data consistency can be found.
Sharing of data:
Sharing of Data implies that the information could be shared by the existing program in addition to the new program. In DBMS, data could be shared effectively by an authorized user who is granted rights by DBA to access the information. However, in traditional file-processing system information cannot be retrieved in a convenient and efficient method.
Integrity This can be maintained by implementing integrity constraints or consistency rules. The limitations may be applied to information item within one record or they might be applied to connections between records. Example of integrity constraint is the greatest marks obtained in a subject cannot exceed 100.
Data Security means the security of information from unauthorized users. Only the authorized user can access the database. Some users are allowed to retrieve data, some are allowed to recover in addition to upgrade data and so forth. The DBA creates the account of consumers and provides rights to access the database for security.
Multiple Users are allowed to update data concurrently in order to enhance the overall operation of the system. In the traditional file-processing systems this concurrent updates might cause conflicting data. For example, if the two users attempt to perform update operation on precisely the exact same record, then you can overwrite the values recorded by another.
In typical file-processing system, information is Determined by the information file and vice-versa because the structure of data items are made into the respective application programs. But in DBMS, we can easily alter the data structure of the database without altering the software program. This is called data independence.
Even though there are many advantages of DBMS, these are also some disadvantages of this and they’re as follows:
A memory of large size is necessary for running DBMS applications and this hardware is pricey.
Difficulty in data conversion from File-processing system:
it is very difficult and time-consuming method to convert information from the file processing system into account system while replacing the former system with a database system.
Paying a huge amount for your training Of staff:
It is required training for users to use DBMS as most database management systems are complex systems. Since training is expected in any way levels so the organization has to pay a lot of amounts.
Appointing technical personnel:
Different types of technical staffs, Like DBA, developers, etc. are required to handle DBMS and so the machine cost increases due to the pay of handsome cash to such persons.