The pros and cons of a database management system a.
The other notable advantage of database management system (DBMS) is data integration: since related data is stored in one single database, enforcing data integrity is much easier. Moreover, the functions of the database management system (DBMS) can be used to entorce the integrity rules witn minimum programming in the application programs. Data sharing is another advantage of a database management system (DBMS): Related data can be shared across programs since the data is stored in a centralized manner.
Even new applications can be eveloped to operate against the same data since several users can access and use the same data for different purposes, provided they are authorized users, as you might be aware that databases are normally protected by passwords to avoid unauthorized users from accessing and or manipulating such database content (Date, 2003:268-276). Enforcement of standards and better controls are also achieved due to the centralized nature of the system.
Standards in the organization and structure of data files is required, and is also easy in a data system since it is one single set of programs which is always interacting with the data files. Another dvantage which gives database management system (DBMS) a plus is application development ease: the application programmer need not build the functions for handling issues like concurrent access, security, data integrity to mention but a few, the programmer instead only needs to implement the application business rules.
This hence brings in application development ease because addition of additional functional modules becomes easier than in file-based systems. NiJssen, (1976:158) outlines that data independence is yet another merit of database management system (DBMS): He outlines that data independence is isolating an upper level from he changes in the organization or structure of a lower level. For example, if changes in the file organization of a data file do not demand for changes in the functions in the database management system (DBMS) or in the application programs, data independence is achieved.
He further defines that data as immunity of applications to change in physical representation and access techniques. The provision of data independence is one of the major objectives of database systems due to the architectural nature of a database management system (DBMS) which can be viewed as a three level system comprising the internal or physical level where the data esides, the conceptual level which the level of the DBMS functions and last but not the least the external level which is the level of application programs or the end users.
Due to the centralized nature of a database management system (DBMS) maintenance cost is reduced thus accounting for yet another advantage of DBMS. It is generally acceptable that it costs much less to create a system of smaller computers with the equivalent power as a single large and expensive computer. This makes it more cost-effective for corporate divisions and departments to obtain separate and less expensive computers. It is also much more cost-effective to add workstations to a network than to update a mainframe system.