A prototype semantic integrity front end expert system for a relational database.

Abstract

Information is a critical resource in today's enterprises. Whether they are industrial, commercial, educational, or military, these organizations maintain an ever increasing amount of information in databases. Ensuring the accuracy of information in a database is paramount to the organizations that maintain these databases. Many decisions are made from the information extracted from the database, and incorrect data will lead to incorrect decision making. This thesis examines the feasibility of using expert systems for enforcing semantic integrity constraints to relational databases. To accomplish this goal, the thesis develops a classification for semantic integrity constraints, applies it to develop rules for the Navy' s Naval Aircraft Flight Record application, and builds a front end expert system to enforce these rules dynamically. The expert system enforces integrity rules for all maintenance operations (UPDATE, INSERT, and DELETE.)