ADABAS

ADABAS (acronym for Adaptable DAta BAse System [Harvnb | Pratt | Adamski | 1987 | p=471 | Ref=Pratt&Adamski1987 ] ) is Software AG’s primary database management system.

History

First released in 1970, ADABAS is considered by some to have been one of the earliest commercially available database products. Initially released on IBM mainframe systems using DOS/360, OS/MFT or OS/MVT, ADABAS is now available on a range of other systems including OpenVMS, Unix (including Linux and Linux on zSeries) and Windows servers. ADABAS has maintained its position as one of the world's fastest OLTP databases,Fact|date=August 2008 offering 24x7 functioning, Parallel Sysplex support, real-time replication capability, SQL and XML access and other leading edge capabilities. Historically, ADABAS was used in conjunction with Software AG's programming language NATURAL, so that many legacy applications that use ADABAS as a database on the back-end are also developed with NATURAL as well.

Technical information

ADABAS is an inverted list database. It has been described as "Post-relational" but “Relational Like" in its characteristics. Some differences:
*Files, not Tables as the major organizational unit
*Records, not Rows as content unit within the organizational unit
*Fields, not Columns as components of a content unit
*No embedded SQL engine, an external query mechanism must be provided.
*Search facilities may use indexed fields or non indexed fields or both.
*Supports two methods of denormalization: repeating groups in a record ("periodic groups"); and multiple field values in a record ("multi-value fields").

It has proven to be very successful in providing efficient access to data and maintaining the integrity of the database.Fact|date=July 2008 ADABAS is now widely used in applications that require very high volumes of data processing or in high transaction online analytical processing environments.Fact|date=July 2008

See also

*Adabas D

Bibliography

*cite book | last = Pratt | first = Philip J. | authorlink = | coauthors = Adamski, Joseph J. | title = DATABASE SYSTEMS: Management and Design | publisher = Boyd & Fraser Publishing Company | year = 1987 | location = Boston | pages = | url = | doi = | ref = Pratt&Adamski1987 | isbn = 0-87835-227-9

External links

* [http://www1.softwareag.com/Corporate/products/adabas/default.asp ADABAS product home page]
* [http://communities.softwareag.com/ecosystem/communities/public/businesscommunity/OtherSAGCommunities/Adabas_and_Natural_Community.html ADABAS and Natural Developer Community]
* [http://www.tiburontech.com ADABAS Training, Outsourcing and Modernization]
* [http://www.bphx.com ADABAS Platform and Database Modernization]
* [http://www.nams-if.org ADABAS Modernization Forum]
* [http://www.editgrid.com/user/ken/HISTORY_OF_SPREADSHEETS] ADABAS Use in spreadsheets at [ICI] in 1974

References