On Multi-Column Foreign Key Discovery
Summary: Proposes a robust method for discovering single- and multi-column foreign keys in relational data. Introduces a general Randomness rule unifying prior heuristics and two-pass approximate algorithms to evaluate it, validated on real and synthetic data. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Meihui Zhang (National University of Singapore)
- 2. Marios Hadjieleftheriou (AT&T)
- 3. Beng Chin Ooi (National University of Singapore)
- 4. Cecilia M. Procopiuc (AT&T)
- 5. Divesh Srivastava (AT&T)
BibTeX Citation
@article{zhang_vldb10,
title = {{On Multi-Column Foreign Key Discovery}},
author = {Zhang, Meihui and Hadjieleftheriou, Marios and Ooi, Beng Chin and Procopiuc, Cecilia M. and Srivastava, Divesh},
journal = {PVLDB},
series = {{VLDB} '10},
volume = {3},
number = {1},
pages = {805--816},
doi = {10.14778/1920841.1920942},
url = {https://doi.org/10.14778/1920841.1920942},
year = {2010}
}Incoming Citations (Sorted by Pagerank)
Showing 21 of 21 citing papers.
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 7 of 7 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 83 | Space-Efficient Online Computation of Quantile Summaries | 2001 | SIGMOD | 0.00035962466 |
| 159 | Inclusion dependencies and their interaction with functional dependencies (Extended abstract) | 1982 | PODS | 0.00027945388 |
| 435 | Mining Database Structure; Or, How to Build a Data Quality Browser | 2002 | SIGMOD | 0.0001831946 |
| 707 | On Synopses for Distinct-Value Estimation Under Multiset Operations | 2007 | SIGMOD | 0.00014633741 |
| 822 | On Schema Matching with Opaque Column Names and Data Values | 2003 | SIGMOD | 0.00013645125 |
| 2,294 | GORDIAN: Efficient and Scalable Discovery of Composite Keys | 2006 | VLDB | 8.6831732e-05 |
| 3,679 | Detecting Change in Data Streams | 2004 | VLDB | 7.1016619e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 8,269 | Discovery and Ranking of Embedded Uniqueness Constraints | 2019 | VLDB |
| 2 | 1,737 | The Data Complexity of Consistent Query Answering for Self-Join-Free Conjunctive Queries Under Primary Key Constraints | 2015 | PODS |
| 3 | 689 | Query Optimization in the Presence of Foreign Functions | 1993 | VLDB |
| 4 | 8,980 | A Fast Randomized Algorithm for Multi-Objective Query Optimization | 2016 | SIGMOD |
| 5 | 3,288 | Comprehensive Approach to the Design of Relational Database Schemes | 1984 | VLDB |
| 6 | 3,306 | Multi-column Substring Matching for Database Schema Translation | 2006 | VLDB |
| 7 | 7,275 | An Algorithm For Servicing Multi-Relational Queries | 1977 | SIGMOD |
| 8 | 7,970 | A New Characterization of Independence | 1983 | SIGMOD |
| 9 | 11,414 | Mining Meaningful Keys and Foreign Keys with High Precision and Recall | 2025 | VLDB |
| 10 | 3,470 | Automatic Discovery of Attributes in Relational Databases | 2011 | SIGMOD |