{"id":"https://openalex.org/W2077397644","doi":"https://doi.org/10.1145/2043652.2043656","title":"Characterizing schema mappings via data examples","display_name":"Characterizing schema mappings via data examples","publication_year":2011,"publication_date":"2011-12-01","ids":{"openalex":"https://openalex.org/W2077397644","doi":"https://doi.org/10.1145/2043652.2043656","mag":"2077397644"},"language":"en","primary_location":{"id":"doi:10.1145/2043652.2043656","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2043652.2043656","pdf_url":null,"source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Transactions on Database Systems","raw_type":"journal-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/A5045881151","display_name":"Bogdan Alexe","orcid":"https://orcid.org/0009-0004-9732-8770"},"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"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Bogdan Alexe","raw_affiliation_strings":["IBM Research - Almaden, San Jose, CA","IBM Research -- Almaden, San Jose, CA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Research - Almaden, San Jose, CA","institution_ids":["https://openalex.org/I4210085935"]},{"raw_affiliation_string":"IBM Research -- Almaden, San Jose, CA","institution_ids":["https://openalex.org/I4210085935"]}]},{"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":["University of California, Santa Cruz, Santa Cruz, CA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of California, Santa Cruz, Santa Cruz, CA","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":["University of California, Santa Cruz CA and IBM Research - Almaden, San Jose, CA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of California, Santa Cruz CA and IBM Research - Almaden, San Jose, CA","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/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 University of California, Santa Cruz, San Jose, CA and Santa Cruz, CA","IBM Research - Almaden and University of California, Santa Cruz, San Jose, CA and Santa Cruz, CA#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Research - Almaden and University of California, Santa Cruz, San Jose, CA and Santa Cruz, CA","institution_ids":["https://openalex.org/I185103710","https://openalex.org/I4210085935"]},{"raw_affiliation_string":"IBM Research - Almaden and University of California, Santa Cruz, San Jose, CA and Santa Cruz, CA#TAB#","institution_ids":["https://openalex.org/I185103710"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":6.8136,"has_fulltext":false,"cited_by_count":50,"citation_normalized_percentile":{"value":0.96458877,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":"36","issue":"4","first_page":"1","last_page":"48"},"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.9994000196456909,"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.9994000196456909,"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.998199999332428,"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/T11719","display_name":"Data Quality and Management","score":0.9961000084877014,"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/computer-science","display_name":"Computer science","score":0.8011364936828613},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.6595897674560547},{"id":"https://openalex.org/keywords/star-schema","display_name":"Star schema","score":0.6214953660964966},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.6163045763969421},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.5857223868370056},{"id":"https://openalex.org/keywords/semi-structured-model","display_name":"Semi-structured model","score":0.5600214600563049},{"id":"https://openalex.org/keywords/data-exchange","display_name":"Data exchange","score":0.5005786418914795},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.4830939769744873},{"id":"https://openalex.org/keywords/conceptual-schema","display_name":"Conceptual schema","score":0.48025014996528625},{"id":"https://openalex.org/keywords/data-integration","display_name":"Data integration","score":0.43284469842910767},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3583611845970154},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.2880828380584717},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.22660058736801147},{"id":"https://openalex.org/keywords/discrete-mathematics","display_name":"Discrete mathematics","score":0.150128573179245},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.1394328773021698},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.1210756003856659}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8011364936828613},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.6595897674560547},{"id":"https://openalex.org/C190703929","wikidata":"https://www.wikidata.org/wiki/Q1331138","display_name":"Star schema","level":4,"score":0.6214953660964966},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.6163045763969421},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.5857223868370056},{"id":"https://openalex.org/C56310702","wikidata":"https://www.wikidata.org/wiki/Q2269281","display_name":"Semi-structured model","level":4,"score":0.5600214600563049},{"id":"https://openalex.org/C15845906","wikidata":"https://www.wikidata.org/wiki/Q1172338","display_name":"Data exchange","level":2,"score":0.5005786418914795},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4830939769744873},{"id":"https://openalex.org/C29275276","wikidata":"https://www.wikidata.org/wiki/Q2268965","display_name":"Conceptual schema","level":3,"score":0.48025014996528625},{"id":"https://openalex.org/C72634772","wikidata":"https://www.wikidata.org/wiki/Q386824","display_name":"Data integration","level":2,"score":0.43284469842910767},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3583611845970154},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.2880828380584717},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.22660058736801147},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.150128573179245},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.1394328773021698},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.1210756003856659},{"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},{"id":"https://openalex.org/C138496976","wikidata":"https://www.wikidata.org/wiki/Q175002","display_name":"Developmental psychology","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/2043652.2043656","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2043652.2043656","pdf_url":null,"source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Transactions on Database Systems","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.5099999904632568,"id":"https://metadata.un.org/sdg/12","display_name":"Responsible consumption and production"}],"awards":[{"id":"https://openalex.org/G310994580","display_name":null,"funder_award_id":"IIS-0905276","funder_id":"https://openalex.org/F4320337389","funder_display_name":"Division of Information and Intelligent Systems"},{"id":"https://openalex.org/G3568257621","display_name":null,"funder_award_id":"IIS-0347065","funder_id":"https://openalex.org/F4320337389","funder_display_name":"Division of Information and Intelligent Systems"}],"funders":[{"id":"https://openalex.org/F4320337389","display_name":"Division of Information and Intelligent Systems","ror":"https://ror.org/053a2cp42"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":39,"referenced_works":["https://openalex.org/W43035074","https://openalex.org/W655258421","https://openalex.org/W1520252399","https://openalex.org/W1556189547","https://openalex.org/W1558832481","https://openalex.org/W1565438236","https://openalex.org/W1968823468","https://openalex.org/W1969053136","https://openalex.org/W1971847909","https://openalex.org/W1992673035","https://openalex.org/W1997887309","https://openalex.org/W2001521450","https://openalex.org/W2006214331","https://openalex.org/W2039470646","https://openalex.org/W2057069578","https://openalex.org/W2065521247","https://openalex.org/W2073279331","https://openalex.org/W2077296695","https://openalex.org/W2101827111","https://openalex.org/W2102729564","https://openalex.org/W2106039833","https://openalex.org/W2107115563","https://openalex.org/W2111203646","https://openalex.org/W2119681685","https://openalex.org/W2126354234","https://openalex.org/W2127753549","https://openalex.org/W2137208394","https://openalex.org/W2147298415","https://openalex.org/W2151604269","https://openalex.org/W2153719564","https://openalex.org/W2156859522","https://openalex.org/W2161439427","https://openalex.org/W2166162093","https://openalex.org/W2171094216","https://openalex.org/W2561675875","https://openalex.org/W2591031484","https://openalex.org/W4229970255","https://openalex.org/W4256119157","https://openalex.org/W6633343697"],"related_works":["https://openalex.org/W2137208394","https://openalex.org/W2006214331","https://openalex.org/W2101827111","https://openalex.org/W2013205276","https://openalex.org/W1976957990","https://openalex.org/W2043942427","https://openalex.org/W2189294255","https://openalex.org/W2351507151","https://openalex.org/W2613904075","https://openalex.org/W2077397644"],"abstract_inverted_index":{"Schema":[0],"mappings":[1,42,118,310],"are":[2,14,161,175,311,332],"high-level":[3],"specifications":[4],"that":[5,74,173,209,215,246,306],"describe":[6],"the":[7,18,31,76,86,100,103,129,163,228,236,268,280,296,324,372],"relationship":[8],"between":[9],"two":[10],"database":[11],"schemas;":[12],"they":[13,174],"considered":[15],"to":[16,50,65,69,179,227,267,279,323,371],"be":[17,44,138],"essential":[19],"building":[20],"blocks":[21],"in":[22,38,108,222],"data":[23,26,72,90,106,146,168],"exchange":[24],"and":[25,28,53,58,92,102,110,127,157,204,347],"integration,":[27],"have":[29],"been":[30],"object":[32],"of":[33,89,96,105,134,145,155,167,189,200,230,235,239,262,270,284,299,318,326,366,374],"extensive":[34],"research":[35],"investigations.":[36],"Since":[37],"real-life":[39],"applications":[40],"schema":[41,60,77,112,117,248,287,301,309,357],"can":[43,137],"quite":[45],"complex,":[46],"it":[47],"is":[48,68,196,255,359],"important":[49],"develop":[51,82],"methods":[52],"tools":[54],"for":[55,85,208,350],"understanding,":[56],"explaining,":[57],"refining":[59],"mappings.":[61,113,302],"A":[62],"promising":[63],"approach":[64],"this":[66,275],"effect":[67],"use":[70],"\u201cgood\u201d":[71],"examples":[73,91,107,220,264,320,368],"illustrate":[75],"mapping":[78,249,358],"at":[79],"hand.":[80],"We":[81,114,184,212],"a":[83,94,142,193,197,201,205,223,259,290,315,336,355,363],"foundation":[84],"systematic":[87],"investigation":[88,149],"obtain":[93],"number":[95],"results":[97],"on":[98,116],"both":[99],"capabilities":[101],"limitations":[104],"explaining":[109],"understanding":[111],"focus":[115],"specified":[119,250],"by":[120,141,151,251,258,314,362],"source-to-target":[121],"tuple":[122],"generating":[123],"dependencies":[124],"(s-t":[125],"tgds)":[126],"investigate":[128],"following":[130],"problem:":[131],"which":[132,160],"classes":[133,283],"s-t":[135,253,272,328,376],"tgds":[136,254],"\u201cuniquely":[139],"characterized\u201d":[140],"finite":[143,153,187,260,316,364],"set":[144,261,317,365],"examples?":[147],"Our":[148],"begins":[150],"considering":[152],"sets":[154,188],"positive":[156,276,291],"negative":[158],"examples,":[159,191],"arguably":[162],"most":[164],"natural":[165],"choice":[166],"examples.":[169],"However,":[170],"we":[171,244,294,342],"show":[172,214,245],"not":[176,354],"powerful":[177],"enough":[178],"yield":[180],"interesting":[181],"unique":[182,216,297],"characterizations.":[183],"then":[185],"consider":[186],"universal":[190,194,206,219,263,319,367],"where":[192],"example":[195],"pair":[198],"consisting":[199],"source":[202,210],"instance":[203],"solution":[207],"instance.":[211],"first":[213],"characterizations":[217],"via":[218],"is,":[221],"precise":[224],"sense,":[225],"equivalent":[226],"existence":[229],"Armstrong":[231,240],"bases":[232],"(a":[233],"relaxation":[234],"classical":[237],"notion":[238],"databases).":[241],"After":[242],"this,":[243],"every":[247],"LAV":[252,271],"uniquely":[256,312,360],"characterized":[257],"with":[265,321,339,369],"respect":[266,322,370],"class":[269,325,373],"tgds.":[273,377],"Moreover,":[274],"result":[277],"extends":[278],"much":[281],"broader":[282],"n":[285,289],"-modular":[286],"mappings,":[288],"integer.":[292],"Finally,":[293],"study":[295],"characterizability":[298],"GAV":[300,308,327,356,375],"It":[303],"turns":[304],"out":[305],"some":[307],"characterizable":[313,361],"tgds,":[329],"while":[330],"others":[331],"not.":[333],"By":[334],"unveiling":[335],"tight":[337],"connection":[338],"homomorphism":[340],"dualities,":[341],"establish":[343],"an":[344],"effective,":[345],"sound,":[346],"complete":[348],"criterion":[349],"determining":[351],"whether":[352],"or":[353]},"counts_by_year":[{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":3},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":3},{"year":2020,"cited_by_count":3},{"year":2019,"cited_by_count":7},{"year":2018,"cited_by_count":4},{"year":2017,"cited_by_count":5},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":2},{"year":2014,"cited_by_count":3},{"year":2013,"cited_by_count":9},{"year":2012,"cited_by_count":2}],"updated_date":"2026-07-22T07:51:19.307946","created_date":"2025-10-10T00:00:00"}