3 papers
cs.DB2025
RED2Hunt: an Actionable Framework for Cleaning Operational Databases with Surrogate Keys
Mathilde Marcy, Jean-Marc Petit, Vasile-Marian Scuturici +3
Surrogate keys are now extensively utilized by database designers to implement keys in SQL tables. They are straightforward, easy to understand, and enable efficient access, despit…
cs.DM2023
Functional Dependencies with Predicates: What Makes the -error Easy to Compute?
Simon Vilmin, Pierre Faure--Giovagnoli, Jean-Marc Petit +1
The notion of functional dependencies (FDs) can be used by data scientists and domain experts to confront background knowledge against data. To overcome the classical, too restrict…
cs.DB2018
SQL Query Completion for Data Exploration
Marie Le Guilly, Jean-Marc Petit, Vasile-Marian Scuturici
Within the big data tsunami, relational databases and SQL are still there and remain mandatory in most of cases for accessing data. On the one hand, SQL is easy-to-use by non speci…