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,612 | Detecting Data Errors: Where are we and what needs to be done? | 2016 | VLDB | 0.00011142794 |
| 9,151 | The Power of Constraints in Natural Language to SQL Translation | 2025 | VLDB | 4.3849295e-05 |
| 1,908 | Information-Theoretic Tools for Mining Database Structure from Large Data Sets | 2004 | SIGMOD | 0.00010126101 |
| 5,348 | A Surrogate Concept For Engineering Databases | 1983 | VLDB | 5.5558592e-05 |
| 732 | Discovering Data Quality Rules | 2008 | VLDB | 0.00017465093 |
| 3,758 | Keyword Search over Relational Databases: A Metadata Approach | 2011 | SIGMOD | 6.7824746e-05 |
| 3,360 | Modeling and Querying Possible Repairs in Duplicate Detection | 2009 | VLDB | 7.1742067e-05 |
| 1,664 | On Multi-Column Foreign Key Discovery | 2010 | VLDB | 0.00010976887 |
| 4,499 | Possible and Certain SQL Keys | 2015 | VLDB | 6.1385333e-05 |
| 10,817 | Mining Meaningful Keys and Foreign Keys with High Precision and Recall | 2025 | VLDB | 4.1945683e-05 |