Model 204

From Wikipedia, the free encyclopedia
Jump to navigation Jump to search

Model 204 (M204) is a database management system for IBM and compatible mainframe computers, “born” 1965 October 13,[1]:66[2] and first deployed in 1972. It incorporates a programming language and an environment for application development. Implemented in assembly language[2] for IBM System/360 and its successors, M204 can deal with very large databases[3] and transaction loads of 1000 TPS.[1]:4

Product description[edit]

Model 204 relies on its own type of bitmap index, originally devised by Professor Patrick E. O'Neil, and combines the use of hash table, B-tree, and record list technologies to optimize speed and efficiency of database access.[4][5]

It was described as "one of the three major inverted-list (database systems) ... the other two being" ADABAS and ADR's Datacom/DB.[6]

Although M204 is a pre-SQL (and pre-relational) database product, it is possible to manually map the files of an M204 database to approximate SQL equivalents and provide some limited SQL functionality using Model 204 SQL Server.[7]

Model 204 is commonly used in government and military applications.[8][9][10]

Model 204 was a product of Computer Corporation of America (CCA). In April 2010, CCA was acquired by Rocket Software, a Boston-based developer of enterprise infrastructure products.[11]

Computer Corporation of America[edit]

Computer Corporation of America (CCA) was a computer software and database systems company that was founded in 1965[12] and was acquired by Rocket Software, a Boston-based developer of enterprise infrastructure products[13] in April 2010.

Corporate information[edit]

Add-on products for Model 204 database were formerly available from Sirius Software, Inc.[14] Sirius, located in Cambridge, Massachusetts, USA, was acquired by Rocket Software in 2012.[15]

Computer Corporation of America also purchased the System 1022 and System 1032 assets of Software House; these database systems were designed for systems produced by Digital Equipment Corporation.[16]

See also[edit]


  1. ^ a b Scinta, Gina (2005-10-10). "Model 204 v6r1: Opening New Doors" (PDF). Computer Corporation of America. Archived from the original (PDF) on January 24, 2013. Retrieved 2012-10-26.
  2. ^ a b "Model 204, A Novel DBMS and Application Platform". Sirius Software. Retrieved 2012-10-26.
  3. ^ "with Model 204 you get excellent performance, even with large databases and ... of America's largest companies— for financial applications, inventory control." "Model 204 database". ComputerWorld. December 1980. p. 36.
  4. ^ O'Neil, Patrick (1987). "Model 204 Architecture and Performance". Proceedings of the 2nd International Workshop on High Performance Transaction Systems. Springer-Verlag. pp. 40–59.
  5. ^ Sandy Stanhope, Database Administrator. "What is Model 204?". The Youngstown State University Computing Newsletter. Department of Computer Services. Retrieved 11 January 2008.
  6. ^ "Software AG memories". March 25, 2011. ADABAS was .. one of the three major inverted-list DBMS, the other two being Computer Corporation of America’s Model 204 and ADR’s Datacom/DB.
  7. ^ "Rocket Model 204 SQL Server Users Guide". Rocket Software. May 2012. Retrieved 2012-10-27.
  8. ^ "Model 204 is commonly used in government and military applications. Among other things, it runs Australia's social security system." "What is Model 204?". December 17, 2013.
  9. ^ Rodney Gedda (Techworld Australia) (May 2009). "Centrelink ups IT reform, keeps Model 204 'legacy'". Retrieved 9 February 2011.
  10. ^; acquired June 13, 2010
  11. ^ "Company Overview of Computer Corporation of America".
  12. ^; acquired June 13, 2010
  13. ^ not to be confused with the video-game publisher described at Sirius Software that opened and folded in the 1980s.
  14. ^ Seiffert, Don (2012-11-29). "Rocket Software buys fifth company this year". Boston Business Journal. Retrieved 2016-05-02.
  15. ^ "System 1022 Database System".

External links[edit]