Properties of Inconsistency Measures for Databases
Ester Livshits, Rina Kochirgan, Segev Tsur, Ihab F. Ilyas, Benny Kimelfeld, Sudeepa Roy
Abstract
How should we quantify the inconsistency of a database that violates integrity constraints? Proper measures are important for various tasks, such as progress indication and action prioritization in cleaning systems, and reliability estimation for new datasets. To choose an appropriate inconsistency measure, it is important to identify the desired properties in the application and understand which of these is guaranteed or at least expected in practice. For example, in some use cases, the inconsistency should reduce if constraints are eliminated; in others, it should be stable and avoid jitters and jumps in reaction to small changes in the database. We embark on a systematic investigation of properties for database inconsistency measures. We investigate a collection of basic measures that have been proposed in the past in both the Knowledge Representation and Database communities, analyze their theoretical properties, and empirically observe their behavior in an experimental study. We also demonstrate how the framework can lead to new inconsistency measures by introducing a new measure that, in contrast to the rest, satisfies all of the properties we consider and can be computed in polynomial time.
Ask about this paper
Your agent reads all of it.
Lune indexed this paper to the last equation, along with the top-tier papers that cite it. Ask a question and the answer quotes them.
Your agent calls
Luneget_paper_fulltext
Free to start. No credit card required.
Terminal
Install the CLIlune papers fulltext 696afda5-19a4-4de0-8303-57b66693467cCited by top-tier papers8
- Fast Algorithms for Denial Constraint DiscoveryEduardo H. M. Pena, Fábio Porto, Felix NaumannVLDB 2023 · 23 citations
- The Cost of Representation by Subset RepairsYuxi Liu, Fangzhu Shen, Kushagra Ghosh, Amir Gilad et al.VLDB 2025 · 4 citations
- Computing Inconsistency Measures Under Differential PrivacyShubhankar Mohapatra, Amir Gilad, Xi He, Benny KimelfeldSIGMOD 2025 · 3 citations
- Analyzing Deviations from Monotonic Trends through Database RepairShunit Agmon, Jonathan Gal, Amir Gilad, Ester Livshits et al.SIGMOD 2026 · 1 citation
- Evaluating Continuous Queries with Inconsistency AnnotationsSamuele Langhi, Angela Bonifati, Riccardo TommasiniVLDB 2025 · 1 citation
Builds on2
Related papers
- Evaluating Top-k Queries with Inconsistency DegreesOusmane Issa, Angela Bonifati, Farouk ToumaniVLDB 2020 · 20 citations
- Germane Conflicts: Desirable Properties for Localising InconsistencyGlauber De Bona, Anthony HunterAAAI 2025
- Consistent Answers of Aggregation Queries via SATAkhil A. Dixit, Phokion G. KolaitisICDE 2022 · 2 citations
- Learning Over Dirty Data Without CleaningJose Picado, John Davis, Arash Termehchy, Ga Young LeeSIGMOD 2020 · 13 citations
- User-Centric Property Graph RepairsAmedeo Pachera, Angela Bonifati, Andrea MauriSIGMOD 2025 · 4 citations
