Can Surrogate Keys Negatively Impact Data Quality?
Summary: Shows that surrogate-only schemas create artificial unicity and hidden redundancy, undermining data cleaning and analytics. RED2Hunt is a human-in-the-loop PostgreSQL tool that elicits natural keys, detects redundancy, and guides database cleaning. (summarized by gpt-5.6-luna on Jul 24 2026)
Incoming Non-self Citations Over Time
No non-self incoming citations found for this paper in this database.
Authors
- 1. Mathilde Marcy (CNRS; Claude Bernard Lyon 1 University; National Institute of Applied Sciences of Lyon)
- 2. Jean-Marc Petit (CNRS; Claude Bernard Lyon 1 University; National Institute of Applied Sciences of Lyon)
- 3. Vasile-Marian Scuturici (CNRS; Claude Bernard Lyon 1 University; National Institute of Applied Sciences of Lyon)
- 4. Jocelyn Bonjour (CNRS; National Institute of Applied Sciences of Lyon)
- 5. Camille Fertel (CEMAFROID)
- 6. Gerald Cavalier (CEMAFROID)
BibTeX Citation
@article{marcy_vldb25,
title = {{Can Surrogate Keys Negatively Impact Data Quality?}},
author = {Marcy, Mathilde and Petit, Jean-Marc and Scuturici, Vasile-Marian and Bonjour, Jocelyn and Fertel, Camille and Cavalier, Gerald},
journal = {PVLDB},
series = {{VLDB} '25},
volume = {18},
number = {12},
pages = {5279--5282},
doi = {10.14778/3750601.3750651},
url = {https://doi.org/10.14778/3750601.3750651},
year = {2025}
}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 |
|---|---|---|---|---|
| 1 | 1,351 | Detecting Data Errors: Where are we and what needs to be done? | 2016 | VLDB |
| 2 | 9,305 | The Power of Constraints in Natural Language to SQL Translation | 2025 | VLDB |
| 3 | 1,913 | Information-Theoretic Tools for Mining Database Structure from Large Data Sets | 2004 | SIGMOD |
| 4 | 5,533 | A Surrogate Concept for Engineering Databases | 1983 | VLDB |
| 5 | 647 | Discovering Data Quality Rules | 2008 | VLDB |
| 6 | 3,651 | Keyword Search over Relational Databases: A Metadata Approach | 2011 | SIGMOD |
| 7 | 3,371 | Modeling and Querying Possible Repairs in Duplicate Detection | 2009 | VLDB |
| 8 | 1,521 | On Multi-Column Foreign Key Discovery | 2010 | VLDB |
| 9 | 4,303 | Possible and Certain SQL Keys | 2015 | VLDB |
| 10 | 11,044 | Mining Meaningful Keys and Foreign Keys with High Precision and Recall | 2025 | VLDB |