Model 204 (M204) is a

database management system In computing, a database is an organized collection of data stored and accessed electronically. Small databases can be stored on a file system, while large databases are hosted on computer clusters or cloud storage. The design of databases span ...

for IBM and compatible mainframe computers developed and commercialized by

Computer Corporation of America Computer Corporation of America (CCA) was a computer software and database systems company founded in 1965. It was best known for its Model 204 (M204) database system for IBM and compatible mainframes. It was acquired by Rocket Software in 2010. ...

. It was announced in 1965, and first deployed in 1972. It incorporates a programming language and an environment for application development. Implemented in

assembly language In computer programming, assembly language (or assembler language, or symbolic machine code), often referred to simply as Assembly and commonly abbreviated as ASM or asm, is any low-level programming language with a very strong correspondence be ...

for

IBM System/360 The IBM System/360 (S/360) is a family of mainframe computer systems that was announced by IBM on April 7, 1964, and delivered between 1965 and 1978. It was the first family of computers designed to cover both commercial and scientific applica ...

and its successors, M204 can deal with very large databases and transaction loads of 1000 TPS.

Product description

Model 204 relies on its own type of bitmap index, originally devised by Bill Mann, and combines the use of

hash table In computing, a hash table, also known as hash map, is a data structure that implements an associative array or dictionary. It is an abstract data type that maps keys to values. A hash table uses a hash function to compute an ''index'', als ...

B-tree In computer science, a B-tree is a self-balancing tree data structure that maintains sorted data and allows searches, sequential access, insertions, and deletions in logarithmic time. The B-tree generalizes the binary search tree, allowing for n ...

, and partitioned record list technologies to optimize speed and efficiency of database access. It has been described as "one of the three major inverted-list atabase systems... the other two being"

ADABAS Adabas, a contraction of “adaptable database system," is a database package that was developed by Software AG to run on IBM mainframes. It was launched in 1971 as a non-relational database. As of 2019, Adabas is marketed for use on a wider ran ...

and ADR's Datacom/DB. 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.

Users

Model 204 is commonly used in government and military applications. It is used commercially in the UK by

Marks & Spencer Marks and Spencer Group plc (commonly abbreviated to M&S and colloquially known as Marks's or Marks & Sparks) is a major British multinational retailer with headquarters in Paddington, London that specialises in selling clothing, beauty, home ...

. It is also used at the

Ventura County Ventura County () is a county in the southern part of the U.S. state of California. As of the 2020 census, the population was 843,843. The largest city is Oxnard, and the county seat is the city of Ventura. Ventura County comprises the Oxnar ...

Property Tax system in California, the Harris County,

Texas Texas (, ; Spanish language, Spanish: ''Texas'', ''Tejas'') is a state in the South Central United States, South Central region of the United States. At 268,596 square miles (695,662 km2), and with more than 29.1 million residents in 2 ...

, Justice Information Management System, and in the

New York City Department of Education The New York City Department of Education (NYCDOE) is the department of the government of New York City that manages the city's public school system. The City School District of the City of New York (or the New York City Public Schools) is t ...

Automate The Schools Automate The Schools (ATS) is the school-based administrative system used by all New York City public schools since 1988. It has many functions, including recording biographical data for all students, handling admissions, discharges, and transfer ...

system. An informal list of past and present Model 204 users, compiled in 2010, identified more than 140 organizations worldwide. Beginning in 1986, it was used by the US Navy Fleet Intelligence Center Europe and Atlantic (FICEURLANT). Model 204 has been a central part of Australian social security for decades.

Services Australia Services Australia, formerly the Department of Human Services and before that the Department of Social Security, is an executive agency of the Australian Government, responsible for delivering a range of welfare, health, child support payment ...

have used it for their ISIS system that pays over $110 billion in welfare payments to around 6 million Australians. A 1.5 billion Australian dollar project to replace ISIS was expected to be completed in 2022 but has experienced delays.

Corporate information

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

References

External links

Model 204 at Rocket Software
Proprietary database management systems IBM mainframe software {{database-software-stub

Product description

Users

Corporate information

See also

References

External links