Modeling of Database Constraints in Active Databases
Abstract
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.
Document Details
- Document Type
- Technical Report
- Publication Date
- Oct 01, 1993
- Accession Number
- ADA273484
Entities
People
- A. K. Tanaka
- S. B. Navathe
Organizations
- Georgia Tech