Database Models and Legacy Systems

Topics: Relational model, Database, SQL Pages: 4 (1007 words) Published: October 15, 2014
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...

References: Chhabra, Jatin. (2013, April 1). Benefits and Limitations of the Relational Database Model for Business Applications today. Retrieved from
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:
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 '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
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • database system Research Paper
  • Relational Database Model Essay
  • Database Management System Essay
  • Database Essay
  • Database Management System Essay
  • Database Systems And HealthCare Essay
  • Relational Database Management System (Dbms) Essay

Become a StudyMode Member

Sign Up - It's Free