Model 204: Difference between revisions

From m204wiki
Jump to navigation Jump to search
No edit summary
 
(28 intermediate revisions by 6 users not shown)
Line 1: Line 1:
'''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.  
<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>[[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> 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.  <var class="product">Model 204</var>'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, <var class="product">Model 204</var> is characterized by its high level of integration and the ease and variety of programming approaches for application development.
The internal structure of <var class="product">Model 204</var> 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 <var class="product">Model 204</var>. 


Model 204 is a database management system (DBMS) that provides facilities for the creation, control, query and maintenance of database filesAccess to the data is provided by an internal language known as '''User Language''', by a variety of Host Language Interfaces (e.g. you can embed queries to Model 204 data in COBOL, Assembler, Fortran, etc.) and via SQL using Horizon and CRAM interfaces.
While a <var class="product">Model 204</var> database can be fully ''Normalized'', this too is not enforced by the structure of <var class="product">Model 204</var>.  In fact, <var class="product">Model 204</var> records can be completely free-form, with varying lengths of records and varying numbers of occurrences of same-named fieldsBecause records, and the fields that are populated on records, do not require or use any preallocated space, <var class="product">Model 204</var> 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 two or three children, but many will have none, and a few will have dozens, or even hundreds. In a <var class="product">Model 204</var> 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.


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.
==Documentation==
The [[Model 204 documentation]] has largely been coverted from PDF manuals to M204wiki articles.


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.
Additionally, these [[M204wiki main page#Model 204|wiki articles]] introduce Model 204 commands, parameters, and core functionality.


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 tables are sized 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.
==Technical details==
<ul>
<li>[[Model 204 configurations and operating environments]] </li>


==Relationship to other Vendors==
<li>[[Model 204 system requirements]] </li>


[Sirius Software] develops add-on software for Model 204, including the Janus family of connectivity products and a wide variety of performance, tuning and functional enhancements.
<li>[[Model 204 add-ons and applications]] </li>


Eclipsys Corporation owns and develops a hospital system using Model 204 as the database engine.
<li>[http://www.rocketsoftware.com/m204 Rocket M204 product family (Rocket website overviews)] </li>


 
<li>[[Model 204 installation]] </li>
==References==
</ul>
 
Rocket Software: http://www.rocketsoftware.com
 
Computer Corporation of America: http://www.cca-int.com/
 
Sirius Software, Inc.: http://sirius-software.com
 
Eclipsys Corporation: http://www.eclipsys.com/

Latest revision as of 21:43, 17 July 2019

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 preallocated 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 two or three 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.

Documentation

The Model 204 documentation has largely been coverted from PDF manuals to M204wiki articles.

Additionally, these wiki articles introduce Model 204 commands, parameters, and core functionality.

Technical details