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
12454
Venue
VLDB
Year
2020
Pagerank
6.5220005e-05
Overall Rank
4,757 | 67.37%
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
2,019 RPT: Relational Pre-trained Transformer Is Almost All You Need towards Democratizing Data Preparation 2021 VLDB 9.2983994e-05
5,518 Self-supervised and Interpretable Data Cleaning with Sequence Generative Adversarial Networks 2023 VLDB 6.1885722e-05
7,397 Conformance Constraint Discovery: Measuring Trust in Data-Driven Systems 2021 SIGMOD 5.6256632e-05
8,914 CtxPipe: Context-aware Data Preparation Pipeline Construction for Machine Learning 2024 SIGMOD 5.3483178e-05
9,437 GIDCL: A Graph-Enhanced Interpretable Data Cleaning Framework with Large Language Models 2024 SIGMOD 5.2687567e-05
9,539 DataVinci: Learning Syntactic and Semantic String Repairs 2025 SIGMOD 5.2528121e-05
9,923 Efficient Differential Dependency Discovery 2024 VLDB 5.1955087e-05
10,111 Parallel Rule Discovery from Large Datasets by Sampling 2022 SIGMOD 5.1347137e-05
10,505 The Case For Language Model Approximated LIKE Predicate 2026 SIGMOD 5.093636e-05
11,221 Mixed Covers of Keys and Functional Dependencies for Maintaining the Integrity of Data under Updates 2024 VLDB 5.093636e-05
11,262 Enriching Relations with Additional Attributes for ER 2024 VLDB 5.093636e-05
11,276 Efficient Validation of SHACL Shapes with Reasoning 2024 VLDB 5.093636e-05
11,424 Splitting Tuples of Mismatched Entities 2023 SIGMOD 5.093636e-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
191 Scorpion: Explaining Away Outliers in Aggregate Queries 2013 VLDB 0.00026096009
376 Discovering Denial Constraints 2013 VLDB 0.00019677674
529 Magellan: Toward Building Entity Matching Management Systems 2016 VLDB 0.00017096361
725 NADEEF: A Commodity Data Cleaning System 2013 SIGMOD 0.00014617251
729 Functional Dependency Discovery: An Experimental Evaluation of Seven Algorithms 2015 VLDB 0.00014539421
1,160 BlinkFill: Semi-supervised Programming By Example for Syntactic String Transformations 2016 VLDB 0.00011883163
1,351 Detecting Data Errors: Where are we and what needs to be done? 2016 VLDB 0.00011064851
1,374 Data Profiling with Metanome 2015 VLDB 0.00010986078
1,465 Synthesizing Entity Matching Rules by Examples 2018 VLDB 0.00010689571
2,123 Discovery of Genuine Functional Dependencies from Relational Data with Missing Values 2018 VLDB 9.1372798e-05
2,623 The return of JedAI: End-to-End Entity Resolution for Structured and Semi-Structured Data 2018 VLDB 8.3327284e-05
2,981 Towards Dependable Data Repairing with Fixing Rules 2014 SIGMOD 7.8960114e-05
3,147 Auto-Detect: Data-Driven Error Detection in Tables 2018 SIGMOD 7.7077175e-05
4,454 Effective and Complete Discovery of Order Dependencies via Set-based Axiomatization 2017 VLDB 6.6929626e-05
4,598 Temporal Rules Discovery for Web Data Cleaning 2016 VLDB 6.6127851e-05
5,268 ANMAT: Automatic Knowledge Discovery and Error Detection through Pattern Functional Dependencies 2019 SIGMOD 6.2923403e-05
6,068 Why Big Data Industrial Systems Need Rules and What We Can Do About It 2015 SIGMOD 5.9887211e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

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