Mining Meaningful Keys and Foreign Keys with High Precision and Recall
Summary: E/R Profiler that mines a strict hierarchy of key variants (candidate keys → SQL uniqueness) with algorithms for approximate-key discovery under arity, completeness, dirtiness and orthogonality thresholds. Novel orthogonality metric separates accidental from meaningful keys, enabling high-precision/-recall key and FK discovery to reveal entity and referential constraints. (summarized by gpt-5-mini on Feb 09 2026)
Incoming Non-self Citations Over Time
No non-self incoming citations found for this paper in this database.
Authors
Incoming Citations (Sorted by Pagerank)
Showing 0 of 0 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 2 of 2 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 1,625 | Data Profiling with Metanome | 2015 | VLDB | 0.00011094926 |
| 4,435 | Sampling Dirty Data for Matching Attributes | 2010 | SIGMOD | 6.1918164e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 6,623 | Exploratory Mining via Constrained Frequent Set Queries | 1999 | SIGMOD | 4.989399e-05 |
| 4,499 | Possible and Certain SQL Keys | 2015 | VLDB | 6.1385333e-05 |
| 1,533 | Example-driven Design of Efficient Record Matching Queries | 2007 | VLDB | 0.00011471971 |
| 10,376 | Entity/Relationship Graphs: Principled Design, Modeling, and Data Integrity Management of Graph Databases | 2025 | SIGMOD | 4.1945683e-05 |
| 2,549 | GORDIAN: Efficient and Scalable Discovery of Composite Keys | 2006 | VLDB | 8.5641554e-05 |
| 9,725 | On Concise Set of Relative Candidate Keys | 2014 | VLDB | 4.2945121e-05 |
| 4,104 | Online Entity Resolution Using an Oracle | 2016 | VLDB | 6.4493809e-05 |
| 3,823 | Automatic Discovery of Attributes in Relational Databases | 2011 | SIGMOD | 6.7261168e-05 |
| 475 | Mining Database Structure; Or, How to Build a Data Quality Browser | 2002 | SIGMOD | 0.00022303253 |
| 1,664 | On Multi-Column Foreign Key Discovery | 2010 | VLDB | 0.00010976887 |