Automated Migration of Hierarchical Data to Relational Tables using Programming-by-Example

Summary: Mitra synthesizes XML/JSON-to-relational transformations from small input–output examples. Its key novelty is decomposing synthesis into column and row construction to discover hidden node relationships, achieving 94% benchmark and all real-dataset successes. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID: h4446c6fb6fd9fc66
Venue: VLDB
Year: 2018
Pagerank: 5.3428083e-05
Overall Rank: 8,381 | 43.66%
DOI: 10.1145/3177732.3177735

Incoming Non-self Citations Over Time

Authors

1. Navid Yaghmazadeh (University of Texas)
2. Xinyu Wang (University of Texas)
3. Isil Dillig (University of Texas)

BibTeX Citation

@article{yaghmazadeh_vldb18,
        title = {{Automated Migration of Hierarchical Data to Relational Tables using Programming-by-Example}},
        author = {Yaghmazadeh, Navid and Wang, Xinyu and Dillig, Isil},
        journal = {PVLDB},
        series = {{VLDB} '18},
        volume = {11},
        number = {5},
        pages = {580--593},
        doi = {10.1145/3177732.3177735},
        url = {https://doi.org/10.1145/3177732.3177735},
        year = {2018}
}

Incoming Citations (Sorted by Pagerank)

Showing 5 of 5 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
5,520	PATSQL: Efficient Synthesis of SQL Queries from Example Tables with Quick Inference of Projected Columns	2021	VLDB	6.0964774e-05
6,657	Data Migration using Datalog Program Synthesis	2020	VLDB	5.7187028e-05
7,695	Trinity: An Extensible Synthesis Framework for Data Science	2019	VLDB	5.4756857e-05
9,192	Data-Driven Insight Synthesis for Multi-Dimensional Data	2024	VLDB	5.2110714e-05
9,549	GIO: Generating Efficient Matrix and Frame Readers for Custom Data Formats by Example	2023	SIGMOD	5.1599622e-05

Outgoing Citations (Sorted by Pagerank)

Showing 18 of 18 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
141	Relational Databases for Querying XML Documents: Limitations and Opportunities	1999	VLDB	0.00029294114
182	Schema Mapping as Query Discovery	2000	VLDB	0.00026277842
296	Generic Schema Matching with Cupid	2001	VLDB	0.00021867512
374	Storing and Querying Ordered XML Using a Relational Database System	2002	SIGMOD	0.00019707844
392	Data Exchange: Getting to the Core	2003	PODS	0.0001922472
407	COMA - A system for flexible combination of schema matching approaches	2002	VLDB	0.00019026291
426	Translating Web Data	2002	VLDB	0.00018483901
517	Schema Mappings, Data Exchange, and Metadata Management	2005	PODS	0.00016948466
822	On Schema Matching with Opaque Column Names and Data Values	2003	SIGMOD	0.00013651306
1,050	Data-Driven Understanding and Refinement of Schema Mappings	2001	SIGMOD	0.00012298141
1,094	BlinkFill: Semi-supervised Programming By Example for Syntactic String Transformations	2016	VLDB	0.0001205355
1,115	Foofah: Transforming Data By Example	2017	SIGMOD	0.00011964111
1,776	Sample-Driven Schema Mapping	2012	SIGMOD	9.6674087e-05
2,244	Characterizing Schema Mappings via Data Examples	2010	PODS	8.7653687e-05
3,397	Designing and Refining Schema Mappings via Data Examples	2011	SIGMOD	7.3366398e-05
5,398	EIRENE: Interactive Design and Refinement of Schema Mappings via Data Examples	2011	VLDB	6.1481166e-05
5,498	HAMSTER: Using Search Clicklogs for Schema and Taxonomy Matching	2009	VLDB	6.1035636e-05
9,894	Data Integration and Data Exchange: It’s Really About Time	2013	CIDR	5.1129187e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	8,877	Efficient XML-to-SQL Query Translation: Where to Add the Intelligence?	2004	VLDB
2	6,391	From XML view updates to relational view updates: old solutions to a new problem	2004	VLDB
3	544	Efficiently Publishing Relational Data as XML Documents	2000	VLDB
4	10,190	MEET DB2: Automated Database Migration Evaluation	2010	VLDB
5	12,845	Relational-Style XML Query	2008	SIGMOD
6	12,073	JSON Schema Matching: Empirical Observations	2020	SIGMOD
7	14,600	Providing Database Migration Tools: A Practitioner's View	1995	VLDB
8	4,088	Automatic Generation of Normalized Relational Schemas from Nested Key-Value Data	2016	SIGMOD
9	6,657	Data Migration using Datalog Program Synthesis	2020	VLDB
10	5,167	Auto-Tables: Synthesizing Multi-Step Transformations to Relationalize Tables without Using Examples	2023	VLDB