Clio: A Semi-Automatic Tool For Schema Mapping

Summary: Clio is a semi-automatic tool for generating schema mappings from legacy sources to a fixed target schema. It uses a mapping-by-example paradigm with value correspondences that show how target values derive from source attributes, enabling semi-automatic mapping discovery for data integration. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: hf59747c182356712
Venue: SIGMOD
Year: 2001
Pagerank: 9.2222424e-05
Overall Rank: 1,993 | 86.61%
DOI: 10.1145/375663.375767

Incoming Non-self Citations Over Time

Authors

1. Mauricio A. Hernández (IBM)
2. Renée J. Miller (University of Toronto)
3. Laura M. Haas (IBM)
4. Lingling Yan
5. C. T. Howard Ho (IBM)
6. Xuqing Tian (University of California Berkeley)

BibTeX Citation

@inproceedings{hernandez_sigmod01,
        title = {{Clio: A Semi-Automatic Tool For Schema Mapping}},
        author = {Hernández, Mauricio A. and Miller, Renée J. and Haas, Laura M. and Yan, Lingling and Ho, C. T. Howard and Tian, Xuqing},
        series = {{SIGMOD} '01},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/375663.375767},
        url = {https://dl.acm.org/doi/10.1145/375663.375767},
        year = {2001}
}

Incoming Citations (Sorted by Pagerank)

Showing 10 of 10 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
822	On Schema Matching with Opaque Column Names and Data Values	2003	SIGMOD	0.00013651306
1,871	Predictive Interaction for Data Transformation	2015	CIDR	9.464979e-05
2,049	Merging Models Based on Given Correspondences	2003	VLDB	9.1214548e-05
3,699	Canonical Abstraction for Outerjoin Optimization	2004	SIGMOD	7.0865558e-05
4,656	Update Rewriting and Integrity Constraint Maintenance in a Schema Evolution Support System: PRISM++	2011	VLDB	6.4827966e-05
7,047	Light-weight Domain-based Form Assistant: Querying Web Databases On the Fly	2005	VLDB	5.6137121e-05
7,158	Just-in-time Data Integration in Action	2010	VLDB	5.5967949e-05
7,455	AgreementMaker: Efficient Matching for Large Real-World Schemas and Ontologies	2009	VLDB	5.5227353e-05
9,549	GIO: Generating Efficient Matrix and Frame Readers for Custom Data Formats by Example	2023	SIGMOD	5.1599622e-05
12,947	GeRoMeSuite: A System for Holistic Generic Model Management	2007	VLDB	4.9793485e-05

Outgoing Citations (Sorted by Pagerank)

Showing 2 of 2 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
182	Schema Mapping as Query Discovery	2000	VLDB	0.00026277842
1,050	Data-Driven Understanding and Refinement of Schema Mappings	2001	SIGMOD	0.00012298141

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	1,776	Sample-Driven Schema Mapping	2012	SIGMOD
2	3,397	Designing and Refining Schema Mappings via Data Examples	2011	SIGMOD
3	6,235	MapMerge: Correlating Independent Schema Mappings	2010	VLDB
4	1,050	Data-Driven Understanding and Refinement of Schema Mappings	2001	SIGMOD
5	13,029	SMART: A Tool for Semantic-Driven Creation of Complex XML Mappings	2005	SIGMOD
6	8,184	Muse: A System for Understanding and Designing Mappings	2008	SIGMOD
7	426	Translating Web Data	2002	VLDB
8	480	Clio Grows Up: From Research Prototype to Industrial Tool	2005	SIGMOD
9	4,297	Semi-Automatic Schema Integration in Clio	2007	VLDB
10	182	Schema Mapping as Query Discovery	2000	VLDB