Compared with the file processing approach, which there are large volume of repetitive data in computer files and the work for changing data stored in different places is extremely heavy and complex when the programming code were altered, DBMS avoids the redundancy and inconsistency of processing data. Under a DBMS, most databases usually manage several files, tables, or entities, and hundreds, or even thousands, of tables can be managed simultaneously. (Jessup, Valacich, and Wade, 2008) For example, when change is done in a certain table, other interrelated data through all parts of DBMS in a business can be changed automatically; when changing programming code in any application, the business’ database does not need to be changed. Therefore, there are lots of advantages using DBMS to manage the data of business and organizations.
Under DBMSs, programs and data are separate, so it is easy to change either some programs or data according to business needs; for example, while a student’s address in the database of a university needs altering, no needs change any programs. Because of using a centralized DBMS, it is much more convenient and easier to share data and enforce standards and rules for processing data among an organization; the standardized data in DBMS make it easier to build and modify application; because using DBMS can minimize redundancy and inconsistency, data quality can be largely improved. In addition, either new personnel in an organization or outside users can have access to the organizational data easily due to centralized database system. Using DBMS can increase productivity and reduce the time of maintaining programs. There are also other advantages of DBMSs, including data-oriented and user-oriented security, administration software, and data recovery support. A practical benefit is reduced application development time: the system is already built, it needs only data and queries to access the data.
References
Jessup, L., Valacich, J. & Wade, M. (2008). Information System Today: Why IS Matters. Pearson Education, Inc.
MACurran & Kellum, S. (July15, 2000). Nursing Informatics: Advantages & Disadvantages. Retrieved March 31, 2009,
form http://personal.uncc.edu/macurran/macurran3/coni/advdisadv.htm
No comments:
Post a Comment