Discovery of Genuine Functional Dependencies from Relational Data with Missing Values

Summary: Defines genuineness of FDs under missing-value semantics; proposes algorithms to compute a genuineness score for discovered FDs. Extensive experiments on real and semi-synthetic data show accurate extraction of genuine FDs from large FD sets, aiding robust data cleaning and repairs. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: h87cdeecc0b77cc59
Venue: VLDB
Year: 2018
Pagerank: 9.0033119e-05
Overall Rank: 2,125 | 85.72%
DOI: 10.14778/3204028.3204032

Incoming Non-self Citations Over Time

Authors

1. Laure Berti-Équille (Aix-Marseille University; National Centre for Scientific Research)
2. Hazar Harmouch (Hasso Plattner Institute; University of Potsdam)
3. Felix Naumann (Hasso Plattner Institute; University of Potsdam)
4. Noël Novelli (Aix-Marseille University; National Centre for Scientific Research)
5. Saravanan Thirumuruganathan (Hamad Bin Khalifa University; Qatar Computing Research Institute)

BibTeX Citation

@article{bertiequille_vldb18,
        title = {{Discovery of Genuine Functional Dependencies from Relational Data with Missing Values}},
        author = {Berti-Équille, Laure and Harmouch, Hazar and Naumann, Felix and Novelli, Noël and Thirumuruganathan, Saravanan},
        journal = {PVLDB},
        series = {{VLDB} '18},
        volume = {11},
        number = {8},
        pages = {880--892},
        doi = {10.14778/3204028.3204032},
        url = {https://doi.org/10.14778/3204028.3204032},
        year = {2018}
}

Incoming Citations (Sorted by Pagerank)

Showing 17 of 17 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
1,805	Raha: A Configuration-Free Error Detection System	2019	SIGMOD	9.59842e-05
2,748	Uni-Detect: A Unified Approach to Automated Error Detection in Tables	2019	SIGMOD	8.0610697e-05
3,193	A Statistical Perspective on Discovering Functional Dependencies in Noisy Data	2020	SIGMOD	7.5505481e-05
3,441	Efficient and Effective Data Imputation with Influence Functions	2022	VLDB	7.2980777e-05
4,424	Auto-Transform: Learning-to-Transform by Patterns	2020	VLDB	6.6048065e-05
4,843	Pattern Functional Dependencies for Data Cleaning	2020	VLDB	6.3839159e-05
6,551	ORBITS: Online Recovery of Missing Values in Multiple Time Series Streams	2021	VLDB	5.750302e-05
7,287	Discovery Algorithms for Embedded Functional Dependencies	2020	SIGMOD	5.5658087e-05
7,738	Auto-Validate: Unsupervised Data Validation Using Data-Domain Patterns Inferred from Data Lakes	2021	SIGMOD	5.4623434e-05
8,003	Missing Value Imputation for Multi-attribute Sensor Data Streams via Message Propagation	2024	VLDB	5.4091136e-05
8,756	Exploratory Training: When Annotators Learn About Data	2023	SIGMOD	5.2840289e-05
9,229	Auto-Test: Learning Semantic-Domain Constraints for Unsupervised Error Detection in Tables	2025	SIGMOD	5.2056825e-05
10,181	In-Database Data Imputation	2024	SIGMOD	5.0653015e-05
11,319	How and Why False Denial Constraints are Discovered	2025	VLDB	4.9793485e-05
11,385	FDepHunter: Harnessing Negative Examples to Expose Fakes and Reveal Ghosts	2025	VLDB	4.9793485e-05
11,558	Mixed Covers of Keys and Functional Dependencies for Maintaining the Integrity of Data under Updates	2024	VLDB	4.9793485e-05
11,873	Statistical Schema Learning using Occam's Razor	2022	SIGMOD	4.9793485e-05

Outgoing Citations (Sorted by Pagerank)

Showing 6 of 6 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
727	Functional Dependency Discovery: An Experimental Evaluation of Seven Algorithms	2015	VLDB	0.00014443394
989	Towards Certain Fixes with Editing Rules and Master Data	2010	VLDB	0.0001265344
1,348	Sampling the Repairs of Functional Dependency Violations under Hard Constraints	2010	VLDB	0.0001094733
1,549	Conditioning Probabilistic Databases	2008	VLDB	0.00010288725
4,342	Possible and Certain SQL Keys	2015	VLDB	6.6510065e-05
5,278	Enriching Data Imputation with Extensive Similarity Neighbors	2015	VLDB	6.1999628e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	7,287	Discovery Algorithms for Embedded Functional Dependencies	2020	SIGMOD
2	500	Dependencies Revisited for Improving Data Quality	2008	PODS
3	11,385	FDepHunter: Harnessing Negative Examples to Expose Fakes and Reveal Ghosts	2025	VLDB
4	649	Discovering Data Quality Rules	2008	VLDB
5	12,046	Making DBMSes Dependency-Aware	2020	CIDR
6	9,958	Discovering Functional Dependencies through Hitting Set Enumeration	2024	SIGMOD
7	11,254	Efficient Discovery of Relaxed Functional Dependencies	2025	VLDB
8	603	A Hybrid Approach to Functional Dependency Discovery	2016	SIGMOD
9	727	Functional Dependency Discovery: An Experimental Evaluation of Seven Algorithms	2015	VLDB
10	3,475	Embedded Functional Dependencies and Data-completeness Tailored Database Design	2019	VLDB