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)
Incoming Non-self Citations Over Time
Authors
- 1. Ziheng Wei (University of Auckland)
- 2. Uwe Leck (University of Flensburg)
- 3. Sebastian Link (University of Auckland)
BibTeX Citation
@article{wei_vldb19,
title = {{Discovery and Ranking of Embedded Uniqueness Constraints}},
author = {Wei, Ziheng and Leck, Uwe and Link, Sebastian},
journal = {PVLDB},
series = {{VLDB} '19},
volume = {12},
number = {13},
pages = {2339--2352},
doi = {10.14778/3358701.3358703},
url = {https://doi.org/10.14778/3358701.3358703},
year = {2019}
}Incoming Citations (Sorted by Pagerank)
Showing 4 of 4 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 5,690 | Normalizing Property Graphs | 2023 | VLDB | 6.1205402e-05 |
| 7,187 | Discovery Algorithms for Embedded Functional Dependencies | 2020 | SIGMOD | 5.6776392e-05 |
| 8,844 | Hitting Set Enumeration with Partial Information for Unique Column Combination Discovery | 2020 | VLDB | 5.3588479e-05 |
| 9,923 | Efficient Differential Dependency Discovery | 2024 | VLDB | 5.1955087e-05 |
Previous
Page 1 / 1
Next
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 |
|---|---|---|---|---|
| 618 | A Hybrid Approach to Functional Dependency Discovery | 2016 | SIGMOD | 0.00015711835 |
| 729 | Functional Dependency Discovery: An Experimental Evaluation of Seven Algorithms | 2015 | VLDB | 0.00014539421 |
| 1,500 | Efficient Discovery of Approximate Dependencies | 2018 | VLDB | 0.00010561098 |
| 2,269 | GORDIAN: Efficient and Scalable Discovery of Composite Keys | 2006 | VLDB | 8.8328424e-05 |
| 3,609 | Embedded Functional Dependencies and Data-completeness Tailored Database Design | 2019 | VLDB | 7.2602055e-05 |
| 4,183 | Scalable Discovery of Unique Column Combinations | 2014 | VLDB | 6.8467773e-05 |
| 4,303 | Possible and Certain SQL Keys | 2015 | VLDB | 6.7711902e-05 |
| 8,399 | DataProf: Semantic Profiling for Iterative Data Cleansing and Business Rule Acquisition | 2018 | SIGMOD | 5.4333402e-05 |
| 12,055 | SQL Schema Design: Foundations, Normal Forms, and Normalization | 2016 | SIGMOD | 5.093636e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 1,262 | Discovering Queries based on Example Tuples | 2014 | SIGMOD |
| 2 | 6,403 | Parallel Discrepancy Detection and Incremental Detection | 2021 | VLDB |
| 3 | 10,812 | Discovering Approximate Inclusion Dependencies | 2025 | VLDB |
| 4 | 1,707 | The Data Complexity of Consistent Query Answering for Self-Join-Free Conjunctive Queries Under Primary Key Constraints | 2015 | PODS |
| 5 | 4,454 | Effective and Complete Discovery of Order Dependencies via Set-based Axiomatization | 2017 | VLDB |
| 6 | 12,386 | Efficient Rank Join with Aggregation Constraints | 2011 | VLDB |
| 7 | 2,745 | Optimal Algorithms for Ranked Enumeration of Answers to Full Conjunctive Queries | 2020 | VLDB |
| 8 | 8,844 | Hitting Set Enumeration with Partial Information for Unique Column Combination Discovery | 2020 | VLDB |
| 9 | 4,183 | Scalable Discovery of Unique Column Combinations | 2014 | VLDB |
| 10 | 7,187 | Discovery Algorithms for Embedded Functional Dependencies | 2020 | SIGMOD |