{"id":"https://openalex.org/W2101827111","doi":"https://doi.org/10.1145/1989323.1989338","title":"Designing and refining schema mappings via data examples","display_name":"Designing and refining schema mappings via data examples","publication_year":2011,"publication_date":"2011-06-12","ids":{"openalex":"https://openalex.org/W2101827111","doi":"https://doi.org/10.1145/1989323.1989338","mag":"2101827111"},"language":"en","primary_location":{"id":"doi:10.1145/1989323.1989338","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1989323.1989338","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2011 ACM SIGMOD International Conference on Management of data","raw_type":"proceedings-article"},"type":"conference-paper","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/A5045881151","display_name":"Bogdan Alexe","orcid":"https://orcid.org/0009-0004-9732-8770"},"institutions":[{"id":"https://openalex.org/I185103710","display_name":"University of California, Santa Cruz","ror":"https://ror.org/03s65by71","country_code":"US","type":"education","lineage":["https://openalex.org/I185103710"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Bogdan Alexe","raw_affiliation_strings":["UC Santa Cruz, Santa Cruz, CA, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"UC Santa Cruz, Santa Cruz, CA, USA","institution_ids":["https://openalex.org/I185103710"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5080220262","display_name":"Balder ten Cate","orcid":"https://orcid.org/0000-0002-2538-5846"},"institutions":[{"id":"https://openalex.org/I185103710","display_name":"University of California, Santa Cruz","ror":"https://ror.org/03s65by71","country_code":"US","type":"education","lineage":["https://openalex.org/I185103710"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Balder ten Cate","raw_affiliation_strings":["UC Santa Cruz, Santa Cruz, CA, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"UC Santa Cruz, Santa Cruz, CA, USA","institution_ids":["https://openalex.org/I185103710"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5041825861","display_name":"Phokion G. Kolaitis","orcid":"https://orcid.org/0000-0002-8407-8563"},"institutions":[{"id":"https://openalex.org/I185103710","display_name":"University of California, Santa Cruz","ror":"https://ror.org/03s65by71","country_code":"US","type":"education","lineage":["https://openalex.org/I185103710"]},{"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":"Phokion G. Kolaitis","raw_affiliation_strings":["UC Santa Cruz and IBM Research - Almaden, Santa Cruz, San Jose, CA, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"UC Santa Cruz and IBM Research - Almaden, Santa Cruz, San Jose, CA, USA","institution_ids":["https://openalex.org/I185103710","https://openalex.org/I4210085935"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5026007789","display_name":"Wang-Chiew Tan","orcid":"https://orcid.org/0009-0008-4174-7545"},"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/I185103710","display_name":"University of California, Santa Cruz","ror":"https://ror.org/03s65by71","country_code":"US","type":"education","lineage":["https://openalex.org/I185103710"]},{"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":"Wang-Chiew Tan","raw_affiliation_strings":["IBM Research - Almaden and UC Santa Cruz, San Jose, Santa Cruz, CA, USA","IBM Research - Almaden and UC Santa Cruz, San Jose, Santa Cruz, CA, USA#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Research - Almaden and UC Santa Cruz, San Jose, Santa Cruz, CA, USA","institution_ids":["https://openalex.org/I185103710","https://openalex.org/I4210085935"]},{"raw_affiliation_string":"IBM Research - Almaden and UC Santa Cruz, San Jose, Santa Cruz, CA, USA#TAB#","institution_ids":["https://openalex.org/I1341412227"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":78,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"133","last_page":"144"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9994999766349792,"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"}},"topics":[{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9994999766349792,"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/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/T11719","display_name":"Data Quality and Management","score":0.9706000089645386,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/star-schema","display_name":"Star schema","score":0.8021211624145508},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7459380626678467},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.6806362867355347},{"id":"https://openalex.org/keywords/semi-structured-model","display_name":"Semi-structured model","score":0.6784513592720032},{"id":"https://openalex.org/keywords/conceptual-schema","display_name":"Conceptual schema","score":0.6751681566238403},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.6264779567718506},{"id":"https://openalex.org/keywords/information-schema","display_name":"Information schema","score":0.6252703070640564},{"id":"https://openalex.org/keywords/data-exchange","display_name":"Data exchange","score":0.5837867259979248},{"id":"https://openalex.org/keywords/schema-migration","display_name":"Schema migration","score":0.4966633915901184},{"id":"https://openalex.org/keywords/schema-evolution","display_name":"Schema evolution","score":0.469635933637619},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.44400084018707275},{"id":"https://openalex.org/keywords/data-integration","display_name":"Data integration","score":0.42890602350234985},{"id":"https://openalex.org/keywords/document-structure-description","display_name":"Document Structure Description","score":0.42695358395576477},{"id":"https://openalex.org/keywords/data-modeling","display_name":"Data modeling","score":0.41805899143218994},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.36551129817962646},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.35024404525756836},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.28983062505722046},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.18497762084007263},{"id":"https://openalex.org/keywords/xml","display_name":"XML","score":0.11334803700447083},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.0981731116771698}],"concepts":[{"id":"https://openalex.org/C190703929","wikidata":"https://www.wikidata.org/wiki/Q1331138","display_name":"Star schema","level":4,"score":0.8021211624145508},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7459380626678467},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.6806362867355347},{"id":"https://openalex.org/C56310702","wikidata":"https://www.wikidata.org/wiki/Q2269281","display_name":"Semi-structured model","level":4,"score":0.6784513592720032},{"id":"https://openalex.org/C29275276","wikidata":"https://www.wikidata.org/wiki/Q2268965","display_name":"Conceptual schema","level":3,"score":0.6751681566238403},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.6264779567718506},{"id":"https://openalex.org/C150012506","wikidata":"https://www.wikidata.org/wiki/Q6031185","display_name":"Information schema","level":5,"score":0.6252703070640564},{"id":"https://openalex.org/C15845906","wikidata":"https://www.wikidata.org/wiki/Q1172338","display_name":"Data exchange","level":2,"score":0.5837867259979248},{"id":"https://openalex.org/C153440673","wikidata":"https://www.wikidata.org/wiki/Q7431119","display_name":"Schema migration","level":5,"score":0.4966633915901184},{"id":"https://openalex.org/C2780660560","wikidata":"https://www.wikidata.org/wiki/Q3951893","display_name":"Schema evolution","level":4,"score":0.469635933637619},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.44400084018707275},{"id":"https://openalex.org/C72634772","wikidata":"https://www.wikidata.org/wiki/Q386824","display_name":"Data integration","level":2,"score":0.42890602350234985},{"id":"https://openalex.org/C68699486","wikidata":"https://www.wikidata.org/wiki/Q265904","display_name":"Document Structure Description","level":3,"score":0.42695358395576477},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.41805899143218994},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.36551129817962646},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.35024404525756836},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.28983062505722046},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.18497762084007263},{"id":"https://openalex.org/C8797682","wikidata":"https://www.wikidata.org/wiki/Q2115","display_name":"XML","level":2,"score":0.11334803700447083},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.0981731116771698},{"id":"https://openalex.org/C138496976","wikidata":"https://www.wikidata.org/wiki/Q175002","display_name":"Developmental psychology","level":1,"score":0.0},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"id":"https://openalex.org/C165611974","wikidata":"https://www.wikidata.org/wiki/Q5531015","display_name":"Gender schema theory","level":2,"score":0.0},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/1989323.1989338","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1989323.1989338","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2011 ACM SIGMOD International Conference on Management of data","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.232.8513","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.232.8513","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cs.ucsc.edu/%7Ewctan/papers/2011/eirene-sigmod.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.6200000047683716,"id":"https://metadata.un.org/sdg/16","display_name":"Peace, Justice and strong institutions"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":28,"referenced_works":["https://openalex.org/W1558832481","https://openalex.org/W1565438236","https://openalex.org/W1634111961","https://openalex.org/W1969053136","https://openalex.org/W1971847909","https://openalex.org/W1979514837","https://openalex.org/W1992673035","https://openalex.org/W2006214331","https://openalex.org/W2023878327","https://openalex.org/W2077296695","https://openalex.org/W2078047958","https://openalex.org/W2102729564","https://openalex.org/W2106039833","https://openalex.org/W2109171159","https://openalex.org/W2126354234","https://openalex.org/W2137208394","https://openalex.org/W2147298415","https://openalex.org/W2151604269","https://openalex.org/W2153719564","https://openalex.org/W2155419928","https://openalex.org/W2159686758","https://openalex.org/W2167866332","https://openalex.org/W4206031975","https://openalex.org/W4234400829","https://openalex.org/W4235498869","https://openalex.org/W6633513001","https://openalex.org/W6922274083","https://openalex.org/W6990023262"],"related_works":["https://openalex.org/W166845585","https://openalex.org/W2103472145","https://openalex.org/W1513459549","https://openalex.org/W2105315220","https://openalex.org/W2137027610","https://openalex.org/W2153512431","https://openalex.org/W1591654213","https://openalex.org/W1512552654","https://openalex.org/W2801323518","https://openalex.org/W2148067883"],"abstract_inverted_index":{"A":[0],"schema":[1,12,35,51,69,95,113,143,147,163,193,246],"mapping":[2,36,70,144,148,164],"is":[3,207],"a":[4,10,14,38,68,72,83,88,104,122,129,141,146,160,176,190,196,219],"specification":[5,74,106],"of":[6,46,75,94,107,110,118,132,181,189,198,213,235,243],"the":[7,33,42,76,91,108,111,116,170,182,187,210,214,241],"relationship":[8,77],"between":[9,78],"source":[11],"and":[13,26,86,124],"target":[15],"schema.":[16],"Schema":[17],"mappings":[18,52,96,247],"are":[19],"fundamental":[20],"building":[21],"blocks":[22],"in":[23,218,263],"data":[24,27,98,101,133,156,199,249],"integration":[25,43],"exchange":[28,45],"and,":[29],"as":[30],"such,":[31],"obtaining":[32],"right":[34],"constitutes":[37],"major":[39],"step":[40],"towards":[41],"or":[44,58,137],"data.":[47],"Up":[48],"to":[49],"now,":[50],"have":[53,59],"typically":[54],"been":[55,60],"specified":[56,149],"manually":[57],"derived":[61],"using":[62,248],"mapping-design":[63],"systems":[64],"that":[65,153,204,239,256],"automatically":[66],"generate":[67],"from":[71],"visual":[73],"two":[79],"schemas.":[80],"We":[81,174],"present":[82],"novel":[84],"paradigm":[85],"develop":[87],"system":[89,120,168,258],"for":[90,209],"interactive":[92],"design":[93],"via":[97],"examples.":[99,157,200,250],"Each":[100],"example":[102],"represents":[103],"partial":[105],"semantics":[109],"desired":[112],"mapping.":[114],"At":[115],"core":[117],"our":[119,167,236,253,257],"lies":[121],"sound":[123],"complete":[125,208],"algorithm":[126],"that,":[127],"given":[128,195],"finite":[130],"set":[131,197],"examples,":[134],"decides":[135],"whether":[136],"not":[138],"there":[139],"exists":[140],"GLAV":[142,162,192],"(i.e.,":[145],"by":[150],"Global-and-Local-As-View":[151],"constraints)":[152],"\"fits\"":[154],"these":[155],"If":[158],"such":[159],"fitting":[161,191],"exists,":[165],"then":[166],"constructs":[169],"\"most":[171],"general\"":[172],"one.":[173],"give":[175],"rigorous":[177],"computational":[178],"complexity":[179,227],"analysis":[180,228],"underlying":[183],"decision":[184],"problem":[185,206],"concerning":[186],"existence":[188],"mapping,":[194],"Specifically,":[201],"we":[202,230],"prove":[203],"this":[205],"second":[211],"level":[212],"polynomial":[215],"hierarchy,":[216],"hence,":[217],"precise":[220],"sense,":[221],"harder":[222],"than":[223],"NP-complete.":[224],"This":[225],"worst-case":[226],"notwithstanding,":[229],"conduct":[231],"an":[232],"experimental":[233],"evaluation":[234],"prototype":[237],"implementation":[238],"demonstrates":[240],"feasibility":[242],"interactively":[244],"designing":[245],"In":[251],"particular,":[252],"experiments":[254],"show":[255],"achieves":[259],"very":[260],"good":[261],"performance":[262],"real-life":[264],"scenarios.":[265]},"counts_by_year":[{"year":2023,"cited_by_count":3},{"year":2021,"cited_by_count":3},{"year":2020,"cited_by_count":3},{"year":2019,"cited_by_count":12},{"year":2018,"cited_by_count":7},{"year":2017,"cited_by_count":7},{"year":2016,"cited_by_count":4},{"year":2015,"cited_by_count":6},{"year":2014,"cited_by_count":5},{"year":2013,"cited_by_count":18},{"year":2012,"cited_by_count":6}],"updated_date":"2026-07-22T07:51:19.307946","created_date":"2025-10-10T00:00:00"}