Integrity Constraints and Versions
نویسندگان
چکیده
In this paper, the extension of integrity constraint mechanisms in order to maintain consistency in multiversion databases is studied. Unlike monoversion databases, a multiversion database represents several states of the modeled universe. Thus, both the notion of consistency and the means to maintain it have to be extended. This goal requires studying new integrity constraints induced by versioning. Constraints are characterized according to several criteria, and a general framework for optimizing their veriication in the context of ACID transactions is given. The database versions model CJ90] is used as it ooers a sound basis for the deenition of consistency.
منابع مشابه
Versions of integrity constraints in multiversiondatabasesAnne
In earlier work, we proposed an integrity constraint mechanism intended to maintain consistency in multiversion databases 6, 5]. However, we did not consider versions of integrity constraints. This paper analyses the extension of this integrity mechanism, in order to express and manage versions of constraints. To make this extension possible, we address two issues. First, we inventory the prope...
متن کاملIntegrity Constraint Management for Design Object Versions in a Concurrent Engineering Design Environment
Concurrent Engineering (CE) is a product development approach which requires collaborative multidisciplinary team environment with efective communication. Due to the evolutionary nature of the engineering design process it is necessary to provide support for version management. The version model should be provided with an integrity checking mechanism to assure the consistency of object versions...
متن کاملUpdate Rewriting and Integrity Constraint Maintenance in a Schema Evolution Support System: PRISM++
Supporting legacy applications when the database schema evolves represents a long-standing challenge of practical and theoretical importance. Recent work has produced algorithms and systems that automate the process of data migration and query adaptation; however, the problems of evolving integrity constraints and supporting legacy updates under schema and integrity constraints evolution are si...
متن کاملTemporal Dependencies
Static integrity constraints involve only the current database state. Temporal integrity constraints involve current, past, and future database states; they can be expressed by essentially unrestricted sentences in temporal logic. Certain syntactically restricted classes of temporal constraints have been studied in their own right for considerations of feasibility or practicality; they are usua...
متن کاملExpression and Enforcement of Dynamic Integrity Constraints
The interest in consistency enforcement in the field of database and in expert systems is nowadays widespread. Special attention has been given in the literature to the subtopic of static integrity constraints. This paper centers instead on the automatic enforcement of dynamic consistency constraints, i.e. those integrity constraints that cannot be checked by solely inspecting the most recent s...
متن کامل