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,627 | Data Profiling with Metanome | 2015 | VLDB | 0.0001108421 |
| 4,432 | Sampling Dirty Data for Matching Attributes | 2010 | SIGMOD | 6.1858589e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 6,622 | Exploratory Mining via Constrained Frequent Set Queries | 1999 | SIGMOD | 4.9846111e-05 |
| 4,502 | Possible and Certain SQL Keys | 2015 | VLDB | 6.1322784e-05 |
| 1,530 | Example-driven Design of Efficient Record Matching Queries | 2007 | VLDB | 0.00011483613 |
| 10,388 | Entity/Relationship Graphs: Principled Design, Modeling, and Data Integrity Management of Graph Databases | 2025 | SIGMOD | 4.1905499e-05 |
| 2,551 | GORDIAN: Efficient and Scalable Discovery of Composite Keys | 2006 | VLDB | 8.5553153e-05 |
| 9,724 | On Concise Set of Relative Candidate Keys | 2014 | VLDB | 4.2903967e-05 |
| 4,101 | Online Entity Resolution Using an Oracle | 2016 | VLDB | 6.4462498e-05 |
| 3,826 | Automatic Discovery of Attributes in Relational Databases | 2011 | SIGMOD | 6.7204879e-05 |
| 481 | Mining Database Structure; Or, How to Build a Data Quality Browser | 2002 | SIGMOD | 0.000221538 |
| 1,661 | On Multi-Column Foreign Key Discovery | 2010 | VLDB | 0.00010967185 |