Discovery and Ranking of Embedded Uniqueness Constraints

Summary: First study of embedded uniqueness constraints (eUCs): unique column combinations embedded in complete fragments of incomplete data, realized as filtered indexes for integrity and query optimization. Shows NP-complete decision variant, W[2]-complete, max-size bounds, scalable column/row algorithms with a hybrid approach, and ranking to identify relevant eUCs. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 11955
Venue: VLDB
Year: 2019
Pagerank: 4.5902231e-05
Overall Rank: 8,085 | 43.76%
DOI: 10.14778/3358701.3358703

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 4 of 4 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
5,910	Normalizing Property Graphs	2023	VLDB	5.2768691e-05
7,366	Discovery Algorithms for Embedded Functional Dependencies	2020	SIGMOD	4.7515248e-05
8,850	Hitting Set Enumeration with Partial Information for Unique Column Combination Discovery	2020	VLDB	4.4364648e-05
9,749	Efficient Differential Dependency Discovery	2024	VLDB	4.2897489e-05

Outgoing Citations (Sorted by Pagerank)

Showing 9 of 9 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
894	A Hybrid Approach to Functional Dependency Discovery	2016	SIGMOD	0.00015556428
1,047	Functional Dependency Discovery: An Experimental Evaluation of Seven Algorithms	2015	VLDB	0.00014459715
2,077	Efficient Discovery of Approximate Dependencies	2018	VLDB	9.6001836e-05
2,549	GORDIAN: Efficient and Scalable Discovery of Composite Keys	2006	VLDB	8.5641554e-05
3,818	Embedded Functional Dependencies and Data-completeness Tailored Database Design	2019	VLDB	6.7300958e-05
4,499	Possible and Certain SQL Keys	2015	VLDB	6.1385333e-05
4,682	Scalable Discovery of Unique Column Combinations	2014	VLDB	6.0022412e-05
8,475	DataProf: Semantic Profiling for Iterative Data Cleansing and Business Rule Acquisition	2018	SIGMOD	4.5028904e-05
11,854	SQL Schema Design: Foundations, Normal Forms, and Normalization	2016	SIGMOD	4.1945683e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
1,509	Discovering Queries based on Example Tuples	2014	SIGMOD	0.00011612727
6,690	Parallel Discrepancy Detection and Incremental Detection	2021	VLDB	4.9621556e-05
10,540	Discovering Approximate Inclusion Dependencies	2025	VLDB	4.1945683e-05
2,243	The Data Complexity of Consistent Query Answering for Self-Join-Free Conjunctive Queries Under Primary Key Constraints	2015	PODS	9.2166927e-05
4,744	Effective and Complete Discovery of Order Dependencies via Set-based Axiomatization	2017	VLDB	5.957936e-05
12,191	Efficient Rank Join with Aggregation Constraints	2011	VLDB	4.1945683e-05
3,715	Optimal Algorithms for Ranked Enumeration of Answers to Full Conjunctive Queries	2020	VLDB	6.8220943e-05
8,850	Hitting Set Enumeration with Partial Information for Unique Column Combination Discovery	2020	VLDB	4.4364648e-05
4,682	Scalable Discovery of Unique Column Combinations	2014	VLDB	6.0022412e-05
7,366	Discovery Algorithms for Embedded Functional Dependencies	2020	SIGMOD	4.7515248e-05