An event/trigger mechanism to enforce complex consistency constraints in design databases
- 1 September 1986
- journal article
- Published by Association for Computing Machinery (ACM) in ACM SIGMOD Record
- Vol. 15 (3), 22-36
- https://doi.org/10.1145/15833.15836
Abstract
Data objects in engineering applications, especially computer aided design, show highly complex structures and a lot of intricate dependencies. Hence a large amount of variably composed consistency constraints have to be dealt with. Furthermore, long transactions which are typical for CAD result in the need to tolerate inconsistencies over unpredictably long periods of time. The demands on mechanisms to enforce consistency in design database systems thus differ from those in business and administrative applications. Comprehensive consistency of the design data can only be attained by degrees. The time and extent of checking have to be determined dynamically and under control by the user. In the case of consistency violations, flexible kinds of reaction are necessary. In this paper we propose an event/trigger mechanism to enforce consistency in design databases that complements the transaction-oriented mechanisms suitable for traditional applications. The underlying ideas are derived from exception handling in programming languages. We present in detail the requirements to meet and how our concept copes with them. We also present an implementation that provides reasonable performance.Keywords
This publication has 5 references indexed in Scilit:
- SOSACM SIGMIS Database: the DATABASE for Advances in Information Systems, 1984
- Managing the chip design databaseComputer, 1983
- A data modeling approach for office information systemsACM Transactions on Information Systems, 1983
- Programming LanguagesPublished by Springer Nature ,1983
- Exception handlingCommunications of the ACM, 1975