Fast Approximate Denial Constraint Discovery

Summary: Two‑phase approach: build a condensed, cache‑friendly 'clue set' (parallelizable) then transform to evidence sets to discover approximate denial constraints tolerant of exceptions in dirty data. Extends evidence‑inversion for approximate DCs, yielding ~7–8× avg speedups and up to orders‑of‑magnitude gains over prior parallel methods. (summarized by gpt-5-mini on Feb 09 2026)

Paper ID: 13302
Venue: VLDB
Year: 2023
Pagerank: 5.5138609e-05
Overall Rank: 7,982 | 45.24%
DOI: 10.14778/3565816.3565828

Incoming Non-self Citations Over Time

Authors

1. Renjie Xiao (Fudan University)
2. Zijing Tan (Fudan University)
3. Haojin Wang (Fudan University)
4. Shuai Ma (Beihang University)

BibTeX Citation

@article{xiao_vldb23,
        title = {{Fast Approximate Denial Constraint Discovery}},
        author = {Xiao, Renjie and Tan, Zijing and Wang, Haojin and Ma, Shuai},
        journal = {PVLDB},
        series = {{VLDB} '23},
        volume = {16},
        number = {2},
        pages = {269--281},
        doi = {10.14778/3565816.3565828},
        url = {https://doi.org/10.14778/3565816.3565828},
        year = {2023}
}

Incoming Citations (Sorted by Pagerank)

Showing 6 of 6 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
9,923	Efficient Differential Dependency Discovery	2024	VLDB	5.1955087e-05
10,223	Discovery of Denial Constraints with Hardware Acceleration	2026	SIGMOD	5.093636e-05
10,322	Minimum Change ≠ Best Cleaning: Parallel and Incremental Error Detection under Integrity Constraints	2026	SIGMOD	5.093636e-05
10,812	Discovering Approximate Inclusion Dependencies	2025	VLDB	5.093636e-05
10,848	Efficient Discovery of Relaxed Functional Dependencies	2025	VLDB	5.093636e-05
10,928	How and Why False Denial Constraints are Discovered	2025	VLDB	5.093636e-05

Outgoing Citations (Sorted by Pagerank)

Showing 25 of 25 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
112	HoloClean: Holistic Data Repairs with Probabilistic Inference	2017	VLDB	0.00032801121
376	Discovering Denial Constraints	2013	VLDB	0.00019677674
618	A Hybrid Approach to Functional Dependency Discovery	2016	SIGMOD	0.00015711835
725	NADEEF: A Commodity Data Cleaning System	2013	SIGMOD	0.00014617251
744	Fundamental Techniques for Order Optimization	1996	SIGMOD	0.00014411295
1,500	Efficient Discovery of Approximate Dependencies	2018	VLDB	0.00010561098
1,741	Efficient Denial Constraint Discovery with Hydra	2018	VLDB	9.8755846e-05
1,955	Discovery of Approximate (and Exact) Denial Constraints	2020	VLDB	9.4166032e-05
2,398	BigDansing: A System for Big Data Cleansing	2015	SIGMOD	8.631172e-05
2,685	Approximate Denial Constraints	2020	VLDB	8.2594662e-05
3,295	Lightning Fast and Space Efficient Inequality Joins	2015	VLDB	7.5477715e-05
3,361	Cleaning Denial Constraint Violations through Relaxation	2020	SIGMOD	7.4872032e-05
3,387	Data Profiling – A Tutorial	2017	SIGMOD	7.4534663e-05
3,928	Implementation of Two Semantic Query Optimization Techniques in DB2 Universal Database	1999	VLDB	7.0115196e-05
4,183	Scalable Discovery of Unique Column Combinations	2014	VLDB	6.8467773e-05
4,454	Effective and Complete Discovery of Order Dependencies via Set-based Axiomatization	2017	VLDB	6.6929626e-05
5,052	Distributed implementations of dependency discovery algorithms	2019	VLDB	6.3846183e-05
6,114	Fundamentals of Order Dependencies	2012	VLDB	5.9713126e-05
6,664	On Multiple Semantics for Declarative Database Repairs	2020	SIGMOD	5.8090585e-05
6,720	Fast Incremental Discovery of Pointwise Order Dependencies	2020	VLDB	5.794237e-05
6,930	Expressiveness and Complexity of Order Dependencies	2013	VLDB	5.7367175e-05
7,187	Discovery Algorithms for Embedded Functional Dependencies	2020	SIGMOD	5.6776392e-05
7,396	Fast Detection of Denial Constraint Violations	2022	VLDB	5.6257228e-05
8,399	DataProf: Semantic Profiling for Iterative Data Cleansing and Business Rule Acquisition	2018	SIGMOD	5.4333402e-05
8,844	Hitting Set Enumeration with Partial Information for Unique Column Combination Discovery	2020	VLDB	5.3588479e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	9,923	Efficient Differential Dependency Discovery	2024	VLDB
2	10,812	Discovering Approximate Inclusion Dependencies	2025	VLDB
3	376	Discovering Denial Constraints	2013	VLDB
4	1,741	Efficient Denial Constraint Discovery with Hydra	2018	VLDB
5	10,928	How and Why False Denial Constraints are Discovered	2025	VLDB
6	7,396	Fast Detection of Denial Constraint Violations	2022	VLDB
7	10,223	Discovery of Denial Constraints with Hardware Acceleration	2026	SIGMOD
8	2,685	Approximate Denial Constraints	2020	VLDB
9	1,955	Discovery of Approximate (and Exact) Denial Constraints	2020	VLDB
10	5,611	Fast Algorithms for Denial Constraint Discovery	2023	VLDB