DBScholar

Back to papers

Foofah: Transforming Data By Example

Summary: Data wrangling is automated by example. Foofah synthesizes transformation programs from a small input-output example by efficiently searching the space of operations, outperforming Wrangler with about 60% less user effort. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
5472
Venue
SIGMOD
Year
2017
Pagerank
0.00011860616
Overall Rank
1,165 | 92.01%
DOI
10.1145/3035918.3064034

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{jin_sigmod17,
        title = {{Foofah: Transforming Data By Example}},
        author = {Jin, Zhongjun and Anderson, Michael R. and Cafarella, Michael and Jagadish, H. V.},
        series = {{SIGMOD} '17},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3035918.3064034},
        url = {https://dl.acm.org/doi/10.1145/3035918.3064034},
        year = {2017}
}

Incoming Citations (Sorted by Pagerank)

Showing 27 of 27 citing papers.

Rank Citing Paper Year Venue Pagerank
2,744 Auto-Suggest: Learning-to-Recommend Data Preparation Steps Using Data Science Notebooks 2020 SIGMOD 8.1781662e-05
2,978 Transform-Data-by-Example (TDE): An Extensible Search Engine for Data Transformations 2018 VLDB 7.9030989e-05
2,980 Auto-Join: Joining Tables by Leveraging Transformations 2017 VLDB 7.8975073e-05
3,894 Navigating the Data Lake with DATAMARAN: Automatically Extracting Structure from Log Datasets 2018 SIGMOD 7.0417782e-05
4,412 Auto-Transform: Learning-to-Transform by Patterns 2020 VLDB 6.7168614e-05
4,875 Auto-Pipeline: Synthesizing Complex Data Pipelines By-Target Using Reinforcement Learning and Search 2021 VLDB 6.4689177e-05
4,904 Mining Precision Interfaces From Query Logs 2019 SIGMOD 6.4503063e-05
4,990 Explaining Dataset Changes for Semantic Data Versioning with Explain-Da-V 2023 VLDB 6.4105738e-05
5,403 Auto-Tables: Synthesizing Multi-Step Transformations to Relationalize Tables without Using Examples 2023 VLDB 6.2306083e-05
6,545 DTT: An Example-Driven Tabular Transformer for Joinability by Leveraging Large Language Models 2024 SIGMOD 5.8454882e-05
7,078 Transform-Data-by-Example (TDE): Extensible Data Transformation in Excel 2018 SIGMOD 5.7095504e-05
7,552 Trinity: An Extensible Synthesis Framework for Data Science 2019 VLDB 5.6005243e-05
7,869 Foofah: A Programming-By-Example System for Synthesizing Data Transformation Programs 2017 SIGMOD 5.5273054e-05
8,000 PIDS: Attribute Decomposition for Improved Compression and Query Performance in Columnar Storage 2020 VLDB 5.5092344e-05
8,217 Automated Migration of Hierarchical Data to Relational Tables using Programming-by-Example 2018 VLDB 5.4644927e-05
8,797 Auto-Formula: Recommend Formulas in Spreadsheets using Contrastive Learning for Table Representations 2024 SIGMOD 5.3702298e-05
9,020 Data-Driven Insight Synthesis for Multi-Dimensional Data 2024 VLDB 5.3306775e-05
9,380 Auto-Prep: Holistic Prediction of Data Preparation Steps for Self-Service Business Intelligence 2025 VLDB 5.2755515e-05
9,505 TabulaX: Leveraging Large Language Models for Multi-Class Table Transformations 2025 VLDB 5.258497e-05
9,930 Data Augmentation for ML-driven Data Preparation and Integration 2021 VLDB 5.1955087e-05
10,042 Scalable and Usable Relational Learning With Automatic Language Bias 2021 SIGMOD 5.1708123e-05
10,202 BAT: Target-Instance-Free Data Preparation Synthesis via LLM-Driven Tree Search 2026 SIGMOD 5.093636e-05
10,317 Guardrail: Automated Integrity Constraint Synthesis From Noisy Data 2026 SIGMOD 5.093636e-05
10,867 Weak-to-Strong Prompts with Lightweight-to-Powerful LLMs for High-Accuracy, Low-Cost, and Explainable Data Transformation 2025 VLDB 5.093636e-05
11,496 DataRinse: Semantic Transforms for Data preparation based on Code Mining 2023 VLDB 5.093636e-05
11,541 SPINE: Scaling up Programming-by-Negative-Example for String Filtering and Transformation 2022 SIGMOD 5.093636e-05
11,960 Constraint-based Explanation and Repair of Filter-based Transformations 2018 VLDB 5.093636e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 8 of 8 cited papers.

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

Rank Cited Paper Year Venue Pagerank
91 WebTables: Exploring the Power of Tables on the Web 2008 VLDB 0.00034838835
94 Potter's Wheel: An Interactive Data Cleaning System 2001 VLDB 0.00034616103
179 Constructing an Interactive Natural Language Interface for Relational Databases 2015 VLDB 0.00026838277
516 Data Curation at Scale: The Data Tamer System 2013 CIDR 0.00017171198
1,160 BlinkFill: Semi-supervised Programming By Example for Syntactic String Transformations 2016 VLDB 0.00011883163
2,215 Characterizing Schema Mappings via Data Examples 2010 PODS 8.93781e-05
3,547 Learning Semantic String Transformations from Examples 2012 VLDB 7.3225973e-05
7,618 Senbazuru: A Prototype Spreadsheet Database Management System 2013 VLDB 5.5811128e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 7,078 Transform-Data-by-Example (TDE): Extensible Data Transformation in Excel 2018 SIGMOD
2 13,887 Efficient development of data migration transformations 2004 SIGMOD
3 4,412 Auto-Transform: Learning-to-Transform by Patterns 2020 VLDB
4 1,030 Data-Driven Understanding and Refinement of Schema Mappings 2001 SIGMOD
5 12,088 Synthesizing Data Programs 2015 CIDR
6 6,092 DataXFormer: Leveraging the Web for Semantic Transformations 2015 CIDR
7 2,978 Transform-Data-by-Example (TDE): An Extensible Search Engine for Data Transformations 2018 VLDB
8 2,077 Generating Example Data for Dataflow Programs 2009 SIGMOD
9 4,546 DataXFormer: An Interactive Data Transformation Tool 2015 SIGMOD
10 7,869 Foofah: A Programming-By-Example System for Synthesizing Data Transformation Programs 2017 SIGMOD