DBScholar

Back to papers

Pattern Functional Dependencies for Data Cleaning

Summary: Introduces pattern functional dependencies (PFDs), combining regex-based format constraints with FD/CFD semantics. Unlike prior integrity constraints over whole values, PFDs exploit partial, pattern-defined attribute content for finer-grained data cleaning. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID
hda059d5804fe4a8c
Venue
VLDB
Year
2020
Pagerank
6.3839159e-05
Overall Rank
4,843 | 67.44%
DOI
10.14778/3377369.3377377

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{qahtan_vldb20,
        title = {{Pattern Functional Dependencies for Data Cleaning}},
        author = {Qahtan, Abdulhakim and Tang, Nan and Ouzzani, Mourad and Cao, Yang and Stonebraker, Michael},
        journal = {PVLDB},
        series = {{VLDB} '20},
        volume = {13},
        number = {5},
        pages = {684--697},
        doi = {10.14778/3377369.3377377},
        url = {https://doi.org/10.14778/3377369.3377377},
        year = {2020}
}

Incoming Citations (Sorted by Pagerank)

Showing 13 of 13 citing papers.

Rank Citing Paper Year Venue Pagerank
1,991 RPT: Relational Pre-trained Transformer Is Almost All You Need towards Democratizing Data Preparation 2021 VLDB 9.2383849e-05
5,643 Self-supervised and Interpretable Data Cleaning with Sequence Generative Adversarial Networks 2023 VLDB 6.0538129e-05
6,921 CtxPipe: Context-aware Data Preparation Pipeline Construction for Machine Learning 2024 SIGMOD 5.6432616e-05
7,505 Conformance Constraint Discovery: Measuring Trust in Data-Driven Systems 2021 SIGMOD 5.5074181e-05
9,616 GIDCL: A Graph-Enhanced Interpretable Data Cleaning Framework with Large Language Models 2024 SIGMOD 5.1510548e-05
9,722 DataVinci: Learning Syntactic and Semantic String Repairs 2025 SIGMOD 5.1349531e-05
10,106 Efficient Differential Dependency Discovery 2024 VLDB 5.0789354e-05
10,339 Parallel Rule Discovery from Large Datasets by Sampling 2022 SIGMOD 5.0195045e-05
10,691 The Case For Language Model Approximated LIKE Predicate 2026 SIGMOD 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,590 Enriching Relations with Additional Attributes for ER 2024 VLDB 4.9793485e-05
11,603 Efficient Validation of SHACL Shapes with Reasoning 2024 VLDB 4.9793485e-05
11,738 Splitting Tuples of Mismatched Entities 2023 SIGMOD 4.9793485e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 17 of 17 cited papers.

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

Rank Cited Paper Year Venue Pagerank
189 Scorpion: Explaining Away Outliers in Aggregate Queries 2013 VLDB 0.00025840026
350 Discovering Denial Constraints 2013 VLDB 0.00020253521
530 Magellan: Toward Building Entity Matching Management Systems 2016 VLDB 0.00016855162
697 NADEEF: A Commodity Data Cleaning System 2013 SIGMOD 0.00014694048
727 Functional Dependency Discovery: An Experimental Evaluation of Seven Algorithms 2015 VLDB 0.00014443394
1,094 BlinkFill: Semi-supervised Programming By Example for Syntactic String Transformations 2016 VLDB 0.0001205355
1,344 Detecting Data Errors: Where are we and what needs to be done? 2016 VLDB 0.00010956518
1,395 Data Profiling with Metanome 2015 VLDB 0.00010794808
1,493 Synthesizing Entity Matching Rules by Examples 2018 VLDB 0.00010505174
2,125 Discovery of Genuine Functional Dependencies from Relational Data with Missing Values 2018 VLDB 9.0033119e-05
2,675 The return of JedAI: End-to-End Entity Resolution for Structured and Semi-Structured Data 2018 VLDB 8.1475005e-05
2,960 Auto-Detect: Data-Driven Error Detection in Tables 2018 SIGMOD 7.8075103e-05
2,964 Towards Dependable Data Repairing with Fixing Rules 2014 SIGMOD 7.8052551e-05
4,465 Effective and Complete Discovery of Order Dependencies via Set-based Axiomatization 2017 VLDB 6.5873563e-05
4,650 Temporal Rules Discovery for Web Data Cleaning 2016 VLDB 6.4858157e-05
5,384 ANMAT: Automatic Knowledge Discovery and Error Detection through Pattern Functional Dependencies 2019 SIGMOD 6.1524649e-05
6,187 Why Big Data Industrial Systems Need Rules and What We Can Do About It 2015 SIGMOD 5.85747e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 2,055 Combining Quantitative and Logical Data Cleaning 2016 VLDB
2 2,125 Discovery of Genuine Functional Dependencies from Relational Data with Missing Values 2018 VLDB
3 727 Functional Dependency Discovery: An Experimental Evaluation of Seven Algorithms 2015 VLDB
4 1,348 Sampling the Repairs of Functional Dependency Violations under Hard Constraints 2010 VLDB
5 11,254 Efficient Discovery of Relaxed Functional Dependencies 2025 VLDB
6 603 A Hybrid Approach to Functional Dependency Discovery 2016 SIGMOD
7 5,384 ANMAT: Automatic Knowledge Discovery and Error Detection through Pattern Functional Dependencies 2019 SIGMOD
8 1,031 On Generating Near-Optimal Tableaux for Conditional Functional Dependencies 2008 VLDB
9 649 Discovering Data Quality Rules 2008 VLDB
10 2,964 Towards Dependable Data Repairing with Fixing Rules 2014 SIGMOD