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: 8.9990594e-05
Overall Rank: 2,127 | 85.71%
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.5938877e-05
2,748	Uni-Detect: A Unified Approach to Automated Error Detection in Tables	2019	SIGMOD	8.0572603e-05
3,194	A Statistical Perspective on Discovering Functional Dependencies in Noisy Data	2020	SIGMOD	7.5469742e-05
3,441	Efficient and Effective Data Imputation with Influence Functions	2022	VLDB	7.2946229e-05
4,426	Auto-Transform: Learning-to-Transform by Patterns	2020	VLDB	6.601896e-05
4,845	Pattern Functional Dependencies for Data Cleaning	2020	VLDB	6.3808938e-05
6,553	ORBITS: Online Recovery of Missing Values in Multiple Time Series Streams	2021	VLDB	5.7475799e-05
7,289	Discovery Algorithms for Embedded Functional Dependencies	2020	SIGMOD	5.5631739e-05
7,742	Auto-Validate: Unsupervised Data Validation Using Data-Domain Patterns Inferred from Data Lakes	2021	SIGMOD	5.4599258e-05
8,008	Missing Value Imputation for Multi-attribute Sensor Data Streams via Message Propagation	2024	VLDB	5.406553e-05
8,764	Exploratory Training: When Annotators Learn About Data	2023	SIGMOD	5.2815275e-05
9,239	Auto-Test: Learning Semantic-Domain Constraints for Unsupervised Error Detection in Tables	2025	SIGMOD	5.2032182e-05
10,185	In-Database Data Imputation	2024	SIGMOD	5.0629036e-05
11,327	How and Why False Denial Constraints are Discovered	2025	VLDB	4.9769913e-05
11,391	FDepHunter: Harnessing Negative Examples to Expose Fakes and Reveal Ghosts	2025	VLDB	4.9769913e-05
11,564	Mixed Covers of Keys and Functional Dependencies for Maintaining the Integrity of Data under Updates	2024	VLDB	4.9769913e-05
11,879	Statistical Schema Learning using Occam's Razor	2022	SIGMOD	4.9769913e-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
728	Functional Dependency Discovery: An Experimental Evaluation of Seven Algorithms	2015	VLDB	0.00014436728
989	Towards Certain Fixes with Editing Rules and Master Data	2010	VLDB	0.00012647631
1,348	Sampling the Repairs of Functional Dependency Violations under Hard Constraints	2010	VLDB	0.00010942213
1,548	Conditioning Probabilistic Databases	2008	VLDB	0.00010288842
4,342	Possible and Certain SQL Keys	2015	VLDB	6.6478954e-05
5,281	Enriching Data Imputation with Extensive Similarity Neighbors	2015	VLDB	6.1970284e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	7,289	Discovery Algorithms for Embedded Functional Dependencies	2020	SIGMOD
2	501	Dependencies Revisited for Improving Data Quality	2008	PODS
3	11,391	FDepHunter: Harnessing Negative Examples to Expose Fakes and Reveal Ghosts	2025	VLDB
4	650	Discovering Data Quality Rules	2008	VLDB
5	12,052	Making DBMSes Dependency-Aware	2020	CIDR
6	9,964	Discovering Functional Dependencies through Hitting Set Enumeration	2024	SIGMOD
7	11,262	Efficient Discovery of Relaxed Functional Dependencies	2025	VLDB
8	603	A Hybrid Approach to Functional Dependency Discovery	2016	SIGMOD
9	728	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