Model 204: Difference between revisions

From m204wiki
Jump to navigation Jump to search
mNo edit summary
Line 1: Line 1:
<var class="product"><b>Model 204</b></var> is a DBMS for IBM and compatible mainframes, which was first deployed as a product in 1972.  Formerly owned by Computer Corporation of America (CCA), <var class="product">Model 204</var> was purchased in 2010 by Rocket Software, of Newton, Massachusetts.
<var class="product"><b>Model 204</b></var> is a DBMS for IBM and compatible mainframes, which was first deployed as a product in 1972.  Formerly owned by Computer Corporation of America (CCA), <var class="product">Model 204</var> was purchased in 2010 by Rocket Software, of Newton, Massachusetts.
   
   
<var class="product">Model 204</var> is a database management system (DBMS) that provides facilities for the creation, control, query and maintenance of database files.  Access to the data is provided by an internal language known as '''<var class="product"><b>User Language</b></var>''', by a variety of Host Language Interfaces (for example, you can embed queries to <var class="product">Model 204</var> data in COBOL, Assembler, Fortran, etc.) and via SQL using Horizon and CRAM interfaces.
<var class="product">Model 204</var> is a database management system (DBMS) that provides facilities for the creation, control, query and maintenance of database files.  Access to the data is provided by an internal language known as '''<var class="product"><b>SOUL</b></var>''' (formerly '''<var class="product"><b>User Language</b></var>'''), by a variety of Host Language Interfaces (for example, you can embed queries to <var class="product">Model 204</var> data in COBOL, Assembler, Fortran, etc.) and via SQL using Horizon and CRAM interfaces.
   
   
<var class="product">Model 204</var> contains an embedded TP monitor that provides for user sessions directly in the DBMS address space.  Note that this makes <var class="product">Model 204</var> unique in the DBMS world:  Rather than users viewing the data from an external application, <var class="product">Model 204</var> users typically hold full-screen sessions directly inside <var class="product">Model 204</var>.
<var class="product">Model 204</var> contains an embedded TP monitor that provides for user sessions directly in the DBMS address space.  Note that this makes <var class="product">Model 204</var> unique in the DBMS world:  Rather than users viewing the data from an external application, <var class="product">Model 204</var> users typically hold full-screen sessions directly inside <var class="product">Model 204</var>.
Line 14: Line 14:
==Relationship to other vendors==
==Relationship to other vendors==
   
   
[[Sirius Software]] develops add-on software for <var class="product">Model 204</var>, including the Janus family of connectivity products and a wide variety of performance, tuning and functional enhancements.
[[Sirius Software]] developed add-on software for <var class="product">Model 204</var>, including the Janus family of connectivity products and a wide variety of performance, tuning, and functional enhancements. After its purchase by Rocket late in 2012, some of the Sirius software became incorporated into <var class="product">Model&nbsp;204</var> (beginning with version 7.5), and some became available from Rocket as separate products working with <var class="product">Model&nbsp;204</var>.
   
   
Allscripts Corporation owns and develops a hospital system using <var class="product">Model 204</var> as the database engine.
Allscripts Corporation owns and develops a hospital system using <var class="product">Model 204</var> as the database engine.

Revision as of 01:37, 22 August 2013

Model 204 is a DBMS for IBM and compatible mainframes, which was first deployed as a product in 1972. Formerly owned by Computer Corporation of America (CCA), Model 204 was purchased in 2010 by Rocket Software, of Newton, Massachusetts.

Model 204 is a database management system (DBMS) that provides facilities for the creation, control, query and maintenance of database files. Access to the data is provided by an internal language known as SOUL (formerly User Language), by a variety of Host Language Interfaces (for example, you can embed queries to Model 204 data in COBOL, Assembler, Fortran, etc.) and via SQL using Horizon and CRAM interfaces.

Model 204 contains an embedded TP monitor that provides for user sessions directly in the DBMS address space. Note that this makes Model 204 unique in the DBMS world: Rather than users viewing the data from an external application, Model 204 users typically hold full-screen sessions directly inside Model 204.

Model 204 is highly parameterized and can be configured for environments that are quite compact and also for environments spanning the largest IBM and IBM-compatible multiprocessor machines. Model 204's strengths lie in its ability to handle very large volumes of data accessed by very large numbers of users, processing very high volumes of transactions. In addition, Model 204 is characterized by its high level of integration and the ease and variety of programming approaches for application development.

The internal structure of Model 204 database files is based on a set of tables which hold file parameters, data records, indexes, procedures and binary large objects. The sizing of the tables is based on expected use of the file. Typically, procedures are held in separate files from data, but this is more of a standard practice and is not enforced by Model 204.

While a Model 204 database can be fully Normalized, this too is not enforced by the structure of Model 204. In fact, Model 204 records can be completely free-form, with varying lengths of records and varying numbers of occurrences of same-named fields. Because records, and the fields that are populated on records, do not require or use any pre-allocated space, Model 204 lends itself to applications where record sizes vary greatly and where the largest records or greatest number of occurrences of any field or set of fields, is unpredictable. Family records, for instance, are well-suited to Model 204 databases, as the average family might have 2 or 3 children, but many will have none, and a few will have dozens, or even hundreds. In a Model 204 file, the smallest "Family" record takes up only the space that it requires, and lives happily alongside other "Family" records that are many times larger.

Relationship to other vendors

Sirius Software developed add-on software for Model 204, including the Janus family of connectivity products and a wide variety of performance, tuning, and functional enhancements. After its purchase by Rocket late in 2012, some of the Sirius software became incorporated into Model 204 (beginning with version 7.5), and some became available from Rocket as separate products working with Model 204.

Allscripts Corporation owns and develops a hospital system using Model 204 as the database engine.

Documentation

References