Can Surrogate Keys Negatively Impact Data Quality?
Summary: Exclusive use of surrogate keys can create “artificial unicity”—hidden redundancy propagated via FKs that defeats unsupervised cleaning and harms analytics. Introduces RED2Hunt, a PostgreSQL-backed human-in-the-loop web tool to elicit natural keys, detect redundancy, and guide cleaning; demoed on the Perfect Pet dataset. (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 0 of 0 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 1,325 | Detecting Data Errors: Where are we and what needs to be done? | 2016 | VLDB | 0.00011254756 |
| 9,165 | The Power of Constraints in Natural Language to SQL Translation | 2025 | VLDB | 5.371468e-05 |
| 1,887 | Information-Theoretic Tools for Mining Database Structure from Large Data Sets | 2004 | SIGMOD | 9.6342251e-05 |
| 5,405 | A Surrogate Concept For Engineering Databases | 1983 | VLDB | 6.2992646e-05 |
| 647 | Discovering Data Quality Rules | 2008 | VLDB | 0.00015507708 |
| 3,601 | Keyword Search over Relational Databases: A Metadata Approach | 2011 | SIGMOD | 7.3327274e-05 |
| 3,291 | Modeling and Querying Possible Repairs in Duplicate Detection | 2009 | VLDB | 7.615882e-05 |
| 1,499 | On Multi-Column Foreign Key Discovery | 2010 | VLDB | 0.00010653578 |
| 4,255 | Possible and Certain SQL Keys | 2015 | VLDB | 6.8673791e-05 |
| 10,822 | Mining Meaningful Keys and Foreign Keys with High Precision and Recall | 2025 | VLDB | 5.1725247e-05 |