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 range of platforms, including Linux, Unix, and Windows.
Adabas can store multiple data relationships in the same table.
Initially released by Software AG in 1971 on IBM mainframe systems using DOS/360, OS/MFT, or OS/MVT, Adabas is currently available on a range of enterprise systems, including BS2000, z/VSE, z/OS, Unix, Linux, and Microsoft Windows. Adabas is frequently used in conjunction with Software AG's programming language Natural; many applications that use Adabas as a database on the back end are developed with Natural. In 2016, Software AG announced that Adabas and Natural would be supported through the year 2050 and beyond.
In a 2015 white paper, IBM said, "applications that are written in a pre-relational database, such as Adabas, are no longer mainstream and do not follow accepted IT industry standards." However, an Adabas database can be designed in accordance with the relational model. While there are tools and services to facilitate converting Adabas to various relational databases, such migrations are usually costly.
Hardware zIIP boost
Adabas Data Model
Adabas is an inverted list data base, with the following characteristics or terminology:
- Works with tables (referred to as files) and rows (referred to as records) as the major organizational units
- Columns (referred to as fields) are components of rows
- No embedded SQL engine. SQL access via the Adabas SQL Gateway was introduced through an acquired company, CONNX, in 2004. It provides ODBC, JDBC, and OLE DB access to Adabas and enables SQL access to Adabas using COBOL programs.
- Search facilities may use indexed fields or non-indexed fields or both.
- Does not natively enforce referential integrity constraints, and parent-child relations must be maintained by application code.
- Supports two methods of denormalization: repeating groups in a record ("periodic groups") and multiple value fields in a record ("multi-value fields").
Adabas access is normally through Natural modules using one of several Natural statements including READ, FIND, and HISTOGRAM. These statements generate additional commands, under the covers, like open and close file. Adabas data can also be retrieved via direct calls.
Example of Natural program running against Adabas
FIND EMPLOYEE WITH NAME = 'JONES' OR = 'BAKER' AND CITY = 'BOSTON' THRU 'NEW YORK' AND CITY NE 'CHAPEL HILL' SORTED BY NAME WHERE SALARY < 28000 DISPLAY NAME FIRST-NAME CITY SALARY END-FIND END
Output of Program:
NAME FIRST-NAME CITY SALARY --------------------------------- BAKER PAULINE DERBY 4450 JONES MARTHA KALAMAZOO 21000 JONES KEVIN DERBY 7000
Natural programs can be "run" interpretively or "executed" as compiled objects. Compiled programs can more directly use operating system services, and run faster.
Natural, which includes a built-in screen-oriented editor, has two main components: the system and the language.
The system is the central vehicle of communication between the user and all other components of the processing environment.
The language is structured and less procedural than conventional languages.
Natural objects (programs, maps, data areas, etc.) are stored in libraries, similar in structure to a DOS directory, and can be named with identifiers up to 8 characters.
Objects, even if they are of different types, cannot have the same name.
Natural provides both online and batch execution and programming testing utilities.
Versions exist for z/OS, z/VSE, BS2000/OS, Linux, Unix and Windows.
DEFINE DATA LOCAL 01 EMPLOYEES VIEW OF EMPLOYEES 02 SALARY (1) END-DEFINE READ EMPLOYEES BY NAME AT END OF DATA DISPLAY MIN (EMPLOYEES.SALARY(1)) (EM=ZZZ,ZZZ,ZZ9) AVER(EMPLOYEES.SALARY(1)) (EM=ZZZ,ZZZ,ZZ9) MAX (EMPLOYEES.SALARY(1)) (EM=ZZZ,ZZZ,ZZ9) END-ENDDATA END-READ END
Page 1 18-08-22 16:42:22 ANNUAL ANNUAL ANNUAL SALARY SALARY SALARY ----------- ----------- ----------- 0 240,976 6,380,000
The language is strongly-typed, using explicit typing of variables, which may be one of:
- Numeric Zoned decimal up to 27 total digits, of which a total of 7 may be to the right of decimal point
- Packed Decimal, same limits as "Numeric")
- Integer (1, 2 or 4 bytes, ranging from -128 to 127 / -32,768 to 32,767 and -2,147,483,648 to 2,147,483,647)
- Logical (True or False)
- Binary (a single byte, according to the translator)
- Control variable paralleling CICS map attribute
- Floating Point (4 or 8 bytes)
The system file
The system file is an Adabas file reserved for use by Natural, which contains, but is not limited to, the following:
- All Natural programs, both in source format (programs) and in object format (compiled), grouped in libraries;
- File Definition Modules, or Data Definition Modules (DDM), with the definition for the Natural or Adabas files and their userviews;
- Natural error messages;
- The texts of the Help function.
The system file is not limited to Adabas. Natural can also store programs in VSAM on mainframe operating systems. Natural uses the file system on Windows and various Unix implementations.
Natural objects are identified by names up to 8 characters, the first of which must be alphabetical.
The Natural program editor allows source in rows of up to 72 positions. Lines are numbered by 4 digits. This numbering is generated by Natural during program creation. Line numbers used by the compiler and editors, and can have important logical functions in the programs.
Within the lines, instructions (statements or program commands) have no positional parameters.
Comments can be included in two ways:
- Full-line comments are identified by a "*" or "**" prefix.
- Annotated code lines have a "/*" - everything to its right is a comment.
0010 * These two lines (0010 and 0020) 0020 ** are comments. 0030 FORMAT LS = 80 /* As well as this part of the line (0030) 0040 * NOTE: The "/*" form has no space between the SLASH and ASTERISK. . . 0200 END
"END" or "." indicates the end of a program.
A Hello World code example:
* Hello World in NATURAL WRITE 'Hello World!' END
- S.M. Deen (1977). Fundamentals of Data Base Systems. p. 174. ISBN 1349158437.
- "Adaptable Data Base System, or ADABAS, was developed by Software AG of Darmstadt, West Germany. Its first version appeared in 1971, and by now it has over 80 installations in Europe and the United States."
- "Historically, the solution was to use nonrelational structures, such as the inverted structure used by Adabas ..." John Watson (2007). Pro Oracle Collaboration Suite 10g. p. 324. ISBN 978-1430202356.
- formerly named with ALL-caps, today as Adabas
- "Adabas for Linux, UNIX & Windows".[permanent dead link]
- "Adabas continues to play a vital role for installed base". Retrieved 12 February 2017.
- "Adabas & Natural Database Management System - Software AG". Retrieved 12 February 2017.
- "Software AG Announces New "Adabas & Natural 2050" Agenda". 31 August 2016.
- "Software AG memories". March 25, 2011.
ADABAS was .. one of the three major inverted-list DBMS, the other two being Computer Corporation of America’s Model 204 and ADR’s Datacom/DB.
- "Adabas new products". Computerworld. May 29, 1978. p. 27.
- "Both the Adabas Data Dictionary System and the Adacom batch report writer are due out in July while Natural, a natural programming language, is expected to be ... Described as entirely reentrant, multithreaded and priority dispatched, the system is in Alpha testing and scheduled for general release in January 1979.
- "SAS/ACCESS 9.2 Interface to ADABAS: Reference" (PDF).
- "Converting Adabas to IBM DB2 for z/OS" (PDF).
- "ADABAS Database Migration to IBM DB2, Oracle, Microsoft SQL Server".
- "... including the conversion of any applications written in 4th Generation languages (4GL) to more contemporary languages, and the adaptation of any applications in standard programming languages to directly access the new relational database. Included in that coverage is Adabas and Natural from Software AG ..."
- "Adabas to DB2 conversion".
- "COSTS: "So far its been 2 years and 30 million dollars to convert." _versus_ BENEFITS: (but) "a single SQL statement (with joins) to replace pages of code."
- "5 Ways to Simplify Access to Adabas & Natural with Data Virtualization" (PDF). 1990.
- Pratt & Adamski 1987, p. 471
- "CONNX for Adabas | CONNX Solutions". www.connx.com. Retrieved 2017-09-01.
- "WHAT IS ADABAS?".
- "Adabas / Natural – From pioneer to relegator - fast and proprietary for over 40 years".[permanent dead link]
- "Natural Program Activity".
- "Which is better, COBOL/DB2 or Natural/ADABAS". July 6, 2011.
- "Packed-Decimal Format". June 2012.
- Pratt, Philip J.; Adamski, Joseph J. (1987). DATABASE SYSTEMS: Management and Design. Boston: Boyd & Fraser Publishing Company. ISBN 0-87835-227-9.