Database Models and Legacy Systems
Database Models and Legacy Systems
The evolution of the information age demanded robust management systems for storing large volume of data, efficiency in retrieval, and enhanced data security and sharing; hence, the development of databases from flat file systems. Despite this advancement in technology, many organizations such as Colorado Financial Reporting System (COFRS) continue to use legacy database systems.
Colorado Financial Reporting System (COFRS)
The Colorado Financial Reporting System (COFRS) is an accounting system in the state of Colorado, which is responsible for storing records and processes annual expenditures (Russell, 2012). Russell (2012) opines that the COFRS is an aging legacy system that utilizes outdated technology in which the complexity of the programming structure is difficult to maintain, and costly to support the system.
Benefits and Drawbacks of Continued use of the Legacy Database
Based on the nature of the COFRS, the state of Colorado needs to discontinue the use of this legacy system. The benefits of continuing to use a legacy database within a business are to keep the system as a backup system or for specified business operational processes (Lin, 2008).
However, with the continued use of the legacy database of the COFRS by the state of Colorado, there are possible drawbacks. These drawbacks include redundant data, inconsistency in data formatting, and the inability to share data among other departments. Russell (2012) states that potential failures of the legacy system are detrimental, expensive to maintain due to outdated technology, and difficult to support based on the complexity of the database design
The Database Models and the COFRS
For efficiency and improved productivity, it is essential that COFRS reduce the risk and cost of its operation and the state’s ability to enhance financial control, reporting, and forecasting (Russell, 2012). The COFRS main responsibility is processing annual expenditure across
The evolution of the information age demanded robust management systems for storing large volume of data, efficiency in retrieval, and enhanced data security and sharing; hence, the development of databases from flat file systems. Despite this advancement in technology, many organizations such as Colorado Financial Reporting System (COFRS) continue to use legacy database systems.
Colorado Financial Reporting System (COFRS)
The Colorado Financial Reporting System (COFRS) is an accounting system in the state of Colorado, which is responsible for storing records and processes annual expenditures (Russell, 2012). Russell (2012) opines that the COFRS is an aging legacy system that utilizes outdated technology in which the complexity of the programming structure is difficult to maintain, and costly to support the system.
Benefits and Drawbacks of Continued use of the Legacy Database
Based on the nature of the COFRS, the state of Colorado needs to discontinue the use of this legacy system. The benefits of continuing to use a legacy database within a business are to keep the system as a backup system or for specified business operational processes (Lin, 2008).
However, with the continued use of the legacy database of the COFRS by the state of Colorado, there are possible drawbacks. These drawbacks include redundant data, inconsistency in data formatting, and the inability to share data among other departments. Russell (2012) states that potential failures of the legacy system are detrimental, expensive to maintain due to outdated technology, and difficult to support based on the complexity of the database design
The Database Models and the COFRS
For efficiency and improved productivity, it is essential that COFRS reduce the risk and cost of its operation and the state’s ability to enhance financial control, reporting, and forecasting (Russell, 2012). The COFRS main responsibility is processing annual expenditure across
References: Chhabra, Jatin. (2013, April 1). Benefits and Limitations of the Relational Database Model for Business Applications today. Retrieved from http://www.scribd.com/doc/133350294/benefits-limitations-of-the-relational-database-model-for-business-application-today-Why-is-the-object-oriented-database-model-gaining-acceptance Lin, Chang-Yang. (2008, December). Migrating to Relational System: Problems, Methods, and Strategies. Contemporary Management Research (pages 369-380, Vol. 4, No. 4). Oppel, A. J. (2009). Databases: A Beginner 's Guide. New York, NY: McGraw-Hill Professional. Retrieved from the Walden Library: http://site.ebrary.com/lib/waldenu/docDetail.action?docID=10286217 e-Book ISBN: 9780071608473 Russell, Kristen D. (2012, December). Transforming Colorado Government for Today and the Future. Denver, CO: Governor’s Office of Information Technology. Retrieved from http://www.colorado.gov/cs/Satellite?blobcol=urldata&blobheadername1=Content-Disposition&blobheadername2=Content-Type&blobheadervalue1=inline%3B+filename%3D%22OIT 's+2012+Annual+Report.pdf%22&blobheadervalue2=application%2Fpdf&blobkey=id&blobtable=MungoBlobs&blobwhere=1251841393695&ssbinary=true Thakur, Dinesh. (n.d.). Database Models. Posted in Computer Notes. Retrieved from http://ecomputernotes.com/fundamental/what-is-a-database/database-model