Simplified Integrity Checking for an Expressive Class of Denial Constraints
Open Access
- 20 February 2025
- journal article
- research article
- Published by MDPI AG in Algorithms
- Vol. 18 (3) , 123
Abstract
Data integrity is crucial for ensuring data correctness and quality and is maintained through integrity constraints that must be continuously checked, especially in data-intensive systems like OLTP. While DBMSs handle very simple cases of constraints (such as primary key and foreign key constraints) well, more complex constraints often require ad hoc solutions. Research since the 1980s has focused on automatic and simplified integrity constraint checking, leveraging the assumption that databases are consistent before updates. This paper presents program transformation operators to generate simplified integrity constraints, focusing on complex constraints expressed in denial form. In particular, we target a class of integrity constraints, called extended denials, which are more general than tuple-generating dependencies and equality-generating dependencies. One of the main contributions of this study consists in the automatic treatment of such a general class of constraints, encompassing the all the most useful and common cases of constraints adopted in practice. Another contribution is the applicability of the proposed technique with a “preventive” approach; unlike all other methods for integrity maintenance, we check whether an update will violate the constraints before executing it, so we never have to undo any work, with potentially huge savings in terms of execution overhead. These techniques can be readily applied to standard database practices and can be directly translated into SQL.Keywords
All Related Versions
This publication has 63 references indexed in Scilit:
- Flexible identity-based remote data integrity checking for cloud storage with privacy preserving propertyCluster Computing, 2021
- Dealing with trajectory streams by clustering and mathematical transformsJournal of Intelligent Information Systems, 2013
- Database Repairing and Consistent Query Answering2011
- Conjunctive Query Containment under Access Limitations2008
- Measuring inconsistency in knowledgebasesJournal of Intelligent Information Systems, 2006
- Domain-independent formulas and databasesTheoretical Computer Science, 1987
- Integrity constraint checking in stratified databasesThe Journal of Logic Programming, 1987
- Foundations of Logic Programming1987
- Making prolog more expressiveThe Journal of Logic Programming, 1984
- Logic for improving integrity checking in relational data bases?Acta Informatica, 1982