---
title: "M204 – Model 204 Database"
description: "The complete tutorial for M204 also called model 204 database. Model 204 is a database management system for IBM and compatible mainframe computers, “born” 1965 October 13, and first deployed in 1972."
url: https://srinimf.com/2014/09/11/m204-model-204-database/
date: 2014-09-11
modified: 2026-10-10
author: "Srini"
image: https://i0.wp.com/srinimf.com/wp-content/uploads/2014/09/pexels-photo-6476124.jpeg?fit=1880%2C1253&ssl=1
categories: ["Categories"]
tags: ["M204 - Model 204 Database Tutorial"]
type: post
lang: en
---

# M204 – Model 204 Database

Model 204 is a database management system for IBM compatible mainframe computers, “born” 1965 October 13, and first deployed in 1972. It incorporates a programming language and an environment for application development.

Implemented in assembly language for IBM System/360 and its successors, M204 can deal with very large databases, and transaction loads of 1000 TPS. **[ DB2 is 5800 TPS ]**

## How M204 Database Works

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

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.

Related[SQL-PLSQL GURU](https://srinimf.com/2014/04/30/sql-plsql-guru/)

### M204 Applications

- Model 204 is most commonly used in government and military applications. Among other things, it runs Australia’s social security system (Centrelink). It is used commercially in the UK by Marks & Spencer.
- It is also used at the Ventura County Property Tax system in California, the Harris County, Texas, Justice Information Management System, 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.
- It is 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.

**References:**

- [Programming with M204](https://m204wiki.rocketsoftware.com/index.php/Model_204)
- [DB2 Performance capabilities](http://www.gse-nordic.org/2012/s207%20best%20practices%20for%20performance%20tuning%20with%20cics%20and%20db2%20for%20zos.pdf)

### Share this:

-
- [Tweet](https://twitter.com/share)
- [![](https://i0.wp.com/assets.pinterest.com/images/pidgets/pinit_fg_en_rect_gray_20.png)](https://www.pinterest.com/pin/create/link/?url=https%3A%2F%2Fsrinimf.com%2F2014%2F09%2F11%2Fm204-model-204-database%2F&media=https%3A%2F%2Fi0.wp.com%2Fsrinimf.com%2Fwp-content%2Fuploads%2F2014%2F09%2Fpexels-photo-6476124.jpeg%3Ffit%3D1200%252C800%26ssl%3D1&description=M204%20-%20Model%20204%20Database)
-
- [Share on Tumblr](https://www.tumblr.com/share)
- [Share on WhatsApp (Opens in new window) WhatsApp](https://srinimf.com/2014/09/11/m204-model-204-database/?share=jetpack-whatsapp)
- [More](#)
-

- [Print (Opens in new window) Print](https://srinimf.com/2014/09/11/m204-model-204-database/?share=print)
- [Share on Reddit (Opens in new window) Reddit](https://srinimf.com/2014/09/11/m204-model-204-database/?share=reddit)
- [Share on Telegram (Opens in new window) Telegram](https://srinimf.com/2014/09/11/m204-model-204-database/?share=telegram)
- [Email a link to a friend (Opens in new window) Email](mailto:?subject=%5BShared%20Post%5D%20M204%20-%20Model%20204%20Database&body=https%3A%2F%2Fsrinimf.com%2F2014%2F09%2F11%2Fm204-model-204-database%2F&share=email)
-

### Like this:

Like Loading…