Model 204
Template:Short description Model 204 (M204) is a database management system for IBM and compatible mainframe computers developed and commercialized by Computer Corporation of America. It was announced in 1965,<ref name=sug2005>{{#invoke:citation/CS1|citation |CitationClass=web }}</ref>Template:Rp<ref name=ssm204 /> and first deployed in 1972. It incorporates a programming language and an environment for application development. Implemented in assembly language<ref name=ssm204>{{#invoke:citation/CS1|citation |CitationClass=web }}</ref> for IBM System/360 and its successors, M204 can deal with very large databases<ref>"with Model 204 you get excellent performance, even with large databases and ... of America's largest companies— for financial applications, inventory control." Template:Cite magazine</ref> and transaction loads of 1000 TPS.<ref name=sug2005 />Template:Rp
Product descriptionEdit
Model 204 relies on its own type of bitmap index, originally devised by Bill Mann, and combines the use of hash table, B-tree, and partitioned record list technologies to optimize speed and efficiency of database access.<ref name="model204">Template:Cite conference</ref><ref>{{#invoke:citation/CS1|citation |CitationClass=web }}</ref>
It has been described as "one of the three major inverted-list [database systems] ... the other two being" ADABAS and ADR's Datacom/DB.<ref>{{#invoke:citation/CS1|citation |CitationClass=web }}</ref>
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.<ref name=m204sql>{{#invoke:citation/CS1|citation |CitationClass=web }}</ref>
UsersEdit
Model 204 is commonly used in government and military applications.<ref>"Model 204 is commonly used in government and military applications. Among other things, it runs Australia's social security system." {{#invoke:citation/CS1|citation |CitationClass=web }}</ref><ref>{{#invoke:citation/CS1|citation |CitationClass=web }}</ref><ref name="centrelink">{{#invoke:citation/CS1|citation |CitationClass=web }}</ref>
It was used commercially in the UK by Marks & Spencer.Template:Citation needed It was also used at the Ventura County Property Tax system in California,<ref>{{#invoke:citation/CS1|citation |CitationClass=web }}</ref> the Harris County, Texas, Justice Information Management System,<ref>{{#invoke:citation/CS1|citation |CitationClass=web }}</ref> and in the New York City Department of Education's Automate The Schools system. An informal list of past and present Model 204 users, compiled in 2010, identified more than 140 organizations worldwide.<ref>{{#invoke:citation/CS1|citation |CitationClass=web }}</ref> Beginning in 1986, it was used by the US Navy Fleet Intelligence Center Europe and Atlantic (FICEURLANT).<ref>Template:Cite book</ref>
Model 204 has been a central part of Australian social security for decades. Services Australia have used it for their ISIS system that pays over $110 billion in welfare payments to around 6 million Australians.<ref>{{#invoke:citation/CS1|citation |CitationClass=web }}</ref> A 1.5 billion Australian dollar project to replace ISIS was expected to be completed in 2022 but was delayed.<ref>{{#invoke:citation/CS1|citation |CitationClass=web }}</ref><ref>{{#invoke:citation/CS1|citation |CitationClass=web }}</ref><ref>{{#invoke:citation/CS1|citation |CitationClass=web }}</ref> The project was scrapped in July 2023 having spent AUD 191 million, since the replacement system (based on Pegasystems business process automation software) took minutes to complete tasks Model 204 could complete in seconds.<ref>{{#invoke:citation/CS1|citation |CitationClass=web }}</ref>
In a 2014 media interview, then Treasurer of Australia Joe Hockey stated that the Australian social security system and the Pentagon were the only remaining active Model 204 customers in the world.<ref>{{#invoke:citation/CS1|citation |CitationClass=web }}</ref>
Corporate informationEdit
Add-on products for Model 204 database were formerly available from Sirius Software, Inc.<ref>not to be confused with the video-game publisher described at Sirius Software that opened and folded in the 1980s.</ref> Sirius, located in Cambridge, Massachusetts, USA, was acquired by Rocket Software in 2012.<ref>Template:Cite news</ref>