{"id":"https://openalex.org/W2106039833","doi":"https://doi.org/10.1145/1066157.1066252","title":"Clio grows up","display_name":"Clio grows up","publication_year":2005,"publication_date":"2005-06-14","ids":{"openalex":"https://openalex.org/W2106039833","doi":"https://doi.org/10.1145/1066157.1066252","mag":"2106039833"},"language":"en","primary_location":{"id":"doi:10.1145/1066157.1066252","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1066157.1066252","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2005 ACM SIGMOD international conference on Management of data","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5086612708","display_name":"Laura M. Haas","orcid":null},"institutions":[{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]},{"id":"https://openalex.org/I4210148712","display_name":"Silicon Valley University","ror":"https://ror.org/04jk6hn97","country_code":"US","type":"education","lineage":["https://openalex.org/I4210148712"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Laura M. Haas","raw_affiliation_strings":["IBM Silicon Valley Labs","IBM Silicon Valley Lab.#TAB#"],"affiliations":[{"raw_affiliation_string":"IBM Silicon Valley Labs","institution_ids":["https://openalex.org/I4210148712"]},{"raw_affiliation_string":"IBM Silicon Valley Lab.#TAB#","institution_ids":["https://openalex.org/I1341412227"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5110264798","display_name":"Mauricio A. Hern\u00e1ndez","orcid":null},"institutions":[{"id":"https://openalex.org/I4210085935","display_name":"IBM Research - Almaden","ror":"https://ror.org/005w8dd04","country_code":"US","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210085935","https://openalex.org/I4210114115"]},{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Mauricio A. Hern\u00e1ndez","raw_affiliation_strings":["IBM Almaden Research Center","IBM Almaden Research Center,#TAB#"],"affiliations":[{"raw_affiliation_string":"IBM Almaden Research Center","institution_ids":["https://openalex.org/I4210085935"]},{"raw_affiliation_string":"IBM Almaden Research Center,#TAB#","institution_ids":["https://openalex.org/I1341412227"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5004469222","display_name":"Howard Ho","orcid":null},"institutions":[{"id":"https://openalex.org/I4210085935","display_name":"IBM Research - Almaden","ror":"https://ror.org/005w8dd04","country_code":"US","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210085935","https://openalex.org/I4210114115"]},{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Howard Ho","raw_affiliation_strings":["IBM Almaden Research Center","IBM Almaden Research Center,#TAB#"],"affiliations":[{"raw_affiliation_string":"IBM Almaden Research Center","institution_ids":["https://openalex.org/I4210085935"]},{"raw_affiliation_string":"IBM Almaden Research Center,#TAB#","institution_ids":["https://openalex.org/I1341412227"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5105463891","display_name":"Lucian Popa","orcid":null},"institutions":[{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]},{"id":"https://openalex.org/I4210085935","display_name":"IBM Research - Almaden","ror":"https://ror.org/005w8dd04","country_code":"US","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210085935","https://openalex.org/I4210114115"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Lucian Popa","raw_affiliation_strings":["IBM Almaden Research Center","IBM Almaden Research Center,#TAB#"],"affiliations":[{"raw_affiliation_string":"IBM Almaden Research Center","institution_ids":["https://openalex.org/I4210085935"]},{"raw_affiliation_string":"IBM Almaden Research Center,#TAB#","institution_ids":["https://openalex.org/I1341412227"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5110032944","display_name":"Mary T. Roth","orcid":null},"institutions":[{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]},{"id":"https://openalex.org/I4210148712","display_name":"Silicon Valley University","ror":"https://ror.org/04jk6hn97","country_code":"US","type":"education","lineage":["https://openalex.org/I4210148712"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Mary Roth","raw_affiliation_strings":["IBM Silicon Valley Labs","IBM Silicon Valley Lab.#TAB#"],"affiliations":[{"raw_affiliation_string":"IBM Silicon Valley Labs","institution_ids":["https://openalex.org/I4210148712"]},{"raw_affiliation_string":"IBM Silicon Valley Lab.#TAB#","institution_ids":["https://openalex.org/I1341412227"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5086612708"],"corresponding_institution_ids":["https://openalex.org/I1341412227","https://openalex.org/I4210148712"],"apc_list":null,"apc_paid":null,"fwci":18.6133,"has_fulltext":false,"cited_by_count":252,"citation_normalized_percentile":{"value":0.99301825,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":100},"biblio":{"volume":null,"issue":null,"first_page":"805","last_page":"810"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9991000294685364,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9991000294685364,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9983000159263611,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9703999757766724,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/xquery","display_name":"XQuery","score":0.8519202470779419},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8505053520202637},{"id":"https://openalex.org/keywords/xslt","display_name":"XSLT","score":0.8204330801963806},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.6623932719230652},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5681923627853394},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.5677622556686401},{"id":"https://openalex.org/keywords/xml","display_name":"XML","score":0.5637091398239136},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.5182009339332581},{"id":"https://openalex.org/keywords/graph-rewriting","display_name":"Graph rewriting","score":0.47377610206604004},{"id":"https://openalex.org/keywords/ibm","display_name":"IBM","score":0.45336276292800903},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.4149268567562103},{"id":"https://openalex.org/keywords/graph","display_name":"Graph","score":0.3898398280143738},{"id":"https://openalex.org/keywords/xml-schema-editor","display_name":"XML Schema Editor","score":0.3111363649368286},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.29016226530075073},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.283833384513855},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.27562928199768066},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.2127658724784851}],"concepts":[{"id":"https://openalex.org/C2780512708","wikidata":"https://www.wikidata.org/wiki/Q850661","display_name":"XQuery","level":4,"score":0.8519202470779419},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8505053520202637},{"id":"https://openalex.org/C150569060","wikidata":"https://www.wikidata.org/wiki/Q32110","display_name":"XSLT","level":3,"score":0.8204330801963806},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.6623932719230652},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5681923627853394},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.5677622556686401},{"id":"https://openalex.org/C8797682","wikidata":"https://www.wikidata.org/wiki/Q2115","display_name":"XML","level":2,"score":0.5637091398239136},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.5182009339332581},{"id":"https://openalex.org/C558772884","wikidata":"https://www.wikidata.org/wiki/Q1508564","display_name":"Graph rewriting","level":3,"score":0.47377610206604004},{"id":"https://openalex.org/C70388272","wikidata":"https://www.wikidata.org/wiki/Q5968558","display_name":"IBM","level":2,"score":0.45336276292800903},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.4149268567562103},{"id":"https://openalex.org/C132525143","wikidata":"https://www.wikidata.org/wiki/Q141488","display_name":"Graph","level":2,"score":0.3898398280143738},{"id":"https://openalex.org/C34716815","wikidata":"https://www.wikidata.org/wiki/Q8042322","display_name":"XML Schema Editor","level":3,"score":0.3111363649368286},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.29016226530075073},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.283833384513855},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.27562928199768066},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.2127658724784851},{"id":"https://openalex.org/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"score":0.0},{"id":"https://openalex.org/C171250308","wikidata":"https://www.wikidata.org/wiki/Q11468","display_name":"Nanotechnology","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1066157.1066252","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1066157.1066252","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2005 ACM SIGMOD international conference on Management of data","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":10,"referenced_works":["https://openalex.org/W1556076816","https://openalex.org/W1966294080","https://openalex.org/W1992673035","https://openalex.org/W2008896880","https://openalex.org/W2020228538","https://openalex.org/W2102729564","https://openalex.org/W2125822162","https://openalex.org/W2155758146","https://openalex.org/W2159793945","https://openalex.org/W6633446409"],"related_works":["https://openalex.org/W2788136784","https://openalex.org/W1525368680","https://openalex.org/W2061340446","https://openalex.org/W1491583426","https://openalex.org/W1637463641","https://openalex.org/W202738805","https://openalex.org/W2396850421","https://openalex.org/W2031597260","https://openalex.org/W2583066568","https://openalex.org/W2106039833"],"abstract_inverted_index":{"Clio,":[0],"the":[1,13,58,62,77,85,101,122],"IBM":[2],"Research":[3],"system":[4],"for":[5,115],"expressing":[6],"declarative":[7,35],"schema":[8,39],"mappings,":[9],"has":[10],"progressed":[11],"in":[12,84,121],"past":[14],"few":[15],"years":[16],"from":[17],"a":[18,22,34],"research":[19],"prototype":[20],"into":[21,50,71],"technology":[23],"that":[24,56],"is":[25],"behind":[26,105],"some":[27,110],"of":[28,37,61,79],"IBM's":[29],"mapping":[30],"technology.":[31],"Clio":[32,87],"provides":[33],"way":[36],"specifying":[38],"mappings":[40],"between":[41],"either":[42],"XML":[43],"or":[44],"relational":[45],"schemas.":[46],"Mappings":[47],"are":[48],"compiled":[49],"an":[51,126],"abstract":[52],"query":[53,65,73],"graph":[54,66],"representation":[55],"captures":[57],"transformation":[59],"semantics":[60],"mappings.":[63],"The":[64],"can":[67],"then":[68,108],"be":[69],"serialized":[70],"different":[72],"languages,":[74],"depending":[75],"on":[76],"kind":[78],"schemas":[80],"and":[81,93,103,117],"systems":[82],"involved":[83],"mapping.":[86],"currently":[88],"produces":[89],"XQuery,":[90],"XSLT,":[91],"SQL,":[92],"SQL/XML":[94],"queries.":[95],"In":[96],"this":[97],"paper,":[98],"we":[99],"revisit":[100],"architecture":[102],"algorithms":[104],"Clio.":[106],"We":[107],"discuss":[109],"implementation":[111],"issues,":[112],"optimizations":[113],"needed":[114],"scalability,":[116],"general":[118],"lessons":[119],"learned":[120],"road":[123],"towards":[124],"creating":[125],"industrial-strength":[127],"tool.":[128]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":3},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2019,"cited_by_count":4},{"year":2018,"cited_by_count":5},{"year":2017,"cited_by_count":12},{"year":2016,"cited_by_count":16},{"year":2015,"cited_by_count":12},{"year":2014,"cited_by_count":15},{"year":2013,"cited_by_count":12},{"year":2012,"cited_by_count":17}],"updated_date":"2026-04-14T08:04:32.555800","created_date":"2016-06-24T00:00:00"}