Chapter 2-2: Data Dictionary Concepts

Integrity

Integrity represents the accuracy, consistency, and completeness of a database. Referential integrity refers to the condition whereby all references between interconnected items of information in a database remain sound. It ensures that customer number 200 is not deleted when there are existing sales orders that reference customer 200, for example.

APPX includes features that, when properly implemented, ensure the integrity of a database. For example, the dictionary can be used to:

·     Prevent orphan records by providing Delete Protect and Key Protect options.

·     Prohibit duplication of primary keys.

·     Prevent referencing nonexistent data by providing the basis for online data validation throughout APPX and all APPX-based applications.

Other APPX components work with the dictionary to ensure database integrity. The process facility, for example, includes specifications that tell APPX to automatically update fields in a child process if equivalent fields are updated in its parent process. Other specifications require APPX to automatically delete records in a child process based upon deletion of related records in its parent process.

APPX Application Design Manual (01/13/03)

© 2003 by APPX Software, Inc. All rights reserved