The core migration and management engine that delivers a fully functional and modern DB2 database, key for leveraging business analytics, cloud, and mobile computing.
AO Foundation migrates the legacy ISAM-like database engine (DDS) to the native SQL database (DDL). The resulting database supports SQE and incorporates sound risk and SDM/MDM management principles.
The import/migration process builds the metadata from object descriptions. AO Foundation toolset simplifies the process of sanitizing data definitions, implementing constraints, and generating triggers & I/O servers.
The metadata repository is central to the modernization process. Changes made to the metadata can be implemented at your discretion. You are in control of when the metadata changes are implemented, right down to the field level. The flexibility provided by AO Foundation takes the big bang out of modernization.
Sanitize, consolidate and reduce heritage code base by up to 80%, reducing code complexity and improving code readability and maintainability.
AO Foundation manages the sanitizing of the data elements and the purification of the field reference file. It would not be uncommon to find multiple definitions for customer numbers in multiple files perhaps with just a unique prefix but possibly other small differences
By taking advantage of the DB2 database engine ( constraints & triggers), we can reduce your code base by on average 80% (depending on coding standards and techniques) at the same time providing dramatic performance improvements.
The standardization of the code improves maintainability. The structure of the trigger programs is such that each field has its procedure containing the validation code. This makes locating issues and deploying resources easier. The efficiency results from standardizing business logic in the database and provides a boost to readability and maintainability.
DB2: The foundation of true modernization
We (IBMi users) have probably the most advanced commercial implementation of the DB2 database at our disposal. However, most installations continue to use it primarily the way we used to do things in the early 1990’s. As a result, most of the advances in the database engine on this wonderful platform have passed us by.
AO Foundation and the SQL engine are used to gradually start sanitizing your heritage database and manage the database using the metadata repository. Then start an enrichment process of the Metadata, using the new Open Access (OA) Metadata Open Standard.
If you’re still accessing your Database using ISAM (DDS/CQE) and not taking advantage of SQL (DDL/SQE) you are working harder than you need to. If you want to get even more productive with SQL, Constraints, Trigger programs, and I/O servers you need the structure & experience built into AO Foundation