Modeling of Database Constraints in Active Databases
Final rept. Jun 1992-Jun 1993
GEORGIA INST OF TECH ATLANTA
Pagination or Media Count:
This report deals with the problems of specification, modeling, and enforcement of constraints in databases. The active database area is emerging as a viable alternative for implementation of large scale database applications particularly those involving data that needs close monitoring and control due to its dynamic nature. Applications in monitoring of personnel, equipment materials etc. need capabilities available in modern database systems. The entire area of command and control engineering is likely to benefit immensely from the emerging active database technology. This report presents an enhanced conceptual data model which is based on the popular entity relationship ER data model. This model has been enhanced with a capability of modeling active database behavior at a higher level than the event condition-action rules used in other systems. A high level specification language is presenting and then showing how it can be mapped into the facilities of an active commercial DBMS such as INGRES. This report addresses three different types of constraints integrity constraints, the invariant properties of the model as constraints, and dynamic constraints that deal with a change of state that occurs during update operations. The facility described can be thought of as a part of the design tools that are needed to exploit the active capabilities in a database management system.
- Computer Programming and Software
- Computer Systems