How and Why False Denial Constraints are Discovered
Albert Martin, Eduardo C. de Almeida, Oscar Romero, Anna Queralt
Abstract
Denial Constraints (DCs) are a flexible formalism to express many types of data rules, making them a widely adopted tool for many applications. This flexibility led to the development of numerous algorithms to automatically discover DCs directly from data. However, few studies have been conducted on the quality of the discovered DCs. We experimentally quantify the lack of quality in the results obtained by state-of-the-art algorithms, showing how the proportion of discovered DCs that are false is rarely below 95%. We hypothesize that the common source of these erroneous DCs stems from the adoption of the current DC validity definition. We use a statistical approach to explain the mechanism leading to these results, and propose a redefinition of DC validity properties to avoid the acceptance of false DCs. We validate this redefinition experimentally, showing that it exclusively accepts true constraints of the data, and is reliable enough to discover DCs missed by domain experts. Additionally, we provide curated sets of golden DCs for each dataset used in our study, those generated by domain experts and those discovered using our approach.
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 e7e0d01c-7722-422e-8c73-e439c6460792Cited by top-tier papers2
- Discovering Approximate Denial Constraints in Large DatabasesAlbert Martin, Eduardo C. de Almeida, Oscar Romero, Anna QueraltVLDB 2026 · 2 citations
- Discovery of Denial Constraints with Hardware AccelerationSergio Luiz Marques Filho, Eduardo Cunha de Almeida, Marco Antonio Zanata AlvesSIGMOD 2026 · 1 citation
Builds on6
- Discovery of Approximate (and Exact) Denial ConstraintsEduardo H. M. Pena, Eduardo C. de Almeida, Felix NaumannVLDB 2020 · 79 citations
- Approximate Denial ConstraintsEster Livshits, Alireza Heidari, Ihab F. Ilyas, Benny KimelfeldVLDB 2020 · 60 citations
- Hitting Set Enumeration with Partial Information for Unique Column Combination DiscoveryJohann Birnick, Thomas Bläsius, Tobias Friedrich, Felix Naumann et al.VLDB 2020 · 35 citations
- Fast Algorithms for Denial Constraint DiscoveryEduardo H. M. Pena, Fábio Porto, Felix NaumannVLDB 2023 · 23 citations
- Fast Approximate Denial Constraint DiscoveryRenjie Xiao, Zijing Tan, Haojin Wang, Shuai MaVLDB 2023 · 19 citations
Related papers
- Discovering Denial Constraints in Dynamic DatasetsEduardo H. M. Pena, Fábio Porto, Felix NaumannICDE 2024 · 2 citations
- DCDiscover: Mining Threshold Denial Constraints from Time Series DataXiaoou Ding, Muyun Zhou, Yida Liu, Zekai Qian et al.ICDE 2025 · 1 citation
- Incremental Detection of Denial Constraint ViolationsYouri Kaminsky, Eduardo H. M. Pena, Felix NaumannVLDB 2025 · 1 citation
- Rapidash: Efficient Detection of Constraint ViolationsZifan Liu, Shaleen Deep, Anna Fariha, Fotis Psallidas et al.VLDB 2024 · 1 citation
- Auto-Test: Learning Semantic-Domain Constraints for Unsupervised Error Detection in TablesQixu Chen, Yeye He, Raymond Chi-Wing Wong, Weiwei Cui et al.SIGMOD 2025 · 4 citations
