A Survey of Current Methods for Integrity Constraint Maintenance and View Updating

During the process of updating a database, two interrelated problems could arise. On one hand, when an update is applied to the database, integrity constraints could become violated, thus falsifying database consistency. In this case, the integrity constraint maintenance approach tries to obtain additional updates to be applied to re-establish database consistency. On the other hand, when an update request consist on updating some derived predicate, a view updating mechanism must be applied to translate the update request into correct updates on the underlying base facts. In this paper, we propose a general framework to compare and classify current methods in the field of view updating and integrity constraint maintenance. In this sense, we classify them considering how they tackle with both problems and, we also state the main drawbacks these methods have.

• Type: Conference
• Year: 1999
• Where: ER
• Authors: Enric Mayol, Ernest Teniente
• Keywords: Database, Database Consistency, ER 1999, Integrity Constraint, Integrity Constraint Maintenance