A prototype rule-based front end expert system for integrity enforcement in relational data bases: An application to the naval aircraft flight records data base

摘要

An important goal of any data base system is to model the real world accurately in a manner consistent with the user's perception of the data. One way to accomplish the accuracy of information in relational data bases is through the enforcement of integrity constraints that represent rules pertaining to the organization. Unfortunately, most DBMSs today do not provide adequate integrity features to ensure the accuracy of data in their databases. This paper discusses the design and implementation of a prototype rule-based front end expert system for integrity enforcement for the Naval Aircraft Flight Record relational data base. The expert system includes a set of rules that define (a) the update operation that triggers the testing of an integrity rule, (b) a specification of the condition to be tested, and (c) the action to be taken in case of attempted violation. These rules are stored in a knowledge base, which the inference engine of the expert system uses to enforce data base integrity.