{"id":"https://openalex.org/W1976957990","doi":"https://doi.org/10.1145/2452376.2452479","title":"Schema mappings and data examples","display_name":"Schema mappings and data examples","publication_year":2013,"publication_date":"2013-03-18","ids":{"openalex":"https://openalex.org/W1976957990","doi":"https://doi.org/10.1145/2452376.2452479","mag":"1976957990"},"language":"en","primary_location":{"id":"doi:10.1145/2452376.2452479","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2452376.2452479","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 16th International Conference on Extending Database Technology","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/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","[UC Santa Cruz.]"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"UC Santa Cruz","institution_ids":["https://openalex.org/I185103710"]},{"raw_affiliation_string":"[UC Santa Cruz.]","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"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"UC Santa Cruz and IBM Research - Almaden","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"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Wang-Chiew Tan","raw_affiliation_strings":["UC Santa Cruz","[UC Santa Cruz.]"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"UC Santa Cruz","institution_ids":["https://openalex.org/I185103710"]},{"raw_affiliation_string":"[UC Santa Cruz.]","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":null,"has_fulltext":false,"cited_by_count":14,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"777","last_page":"780"},"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.9988999962806702,"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.9988999962806702,"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.9984999895095825,"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.9868999719619751,"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.7616776823997498},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.72523033618927},{"id":"https://openalex.org/keywords/conceptual-schema","display_name":"Conceptual schema","score":0.7118176221847534},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.7081311345100403},{"id":"https://openalex.org/keywords/information-schema","display_name":"Information schema","score":0.6475546956062317},{"id":"https://openalex.org/keywords/semi-structured-model","display_name":"Semi-structured model","score":0.6238594651222229},{"id":"https://openalex.org/keywords/star-schema","display_name":"Star schema","score":0.6035738587379456},{"id":"https://openalex.org/keywords/schema-migration","display_name":"Schema migration","score":0.5455685257911682},{"id":"https://openalex.org/keywords/data-exchange","display_name":"Data exchange","score":0.5384440422058105},{"id":"https://openalex.org/keywords/data-integration","display_name":"Data integration","score":0.5082475543022156},{"id":"https://openalex.org/keywords/data-modeling","display_name":"Data modeling","score":0.452612966299057},{"id":"https://openalex.org/keywords/schema-matching","display_name":"Schema matching","score":0.4386865496635437},{"id":"https://openalex.org/keywords/schema-evolution","display_name":"Schema evolution","score":0.42702963948249817},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3945651650428772},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3516826033592224},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.24407732486724854},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.23518693447113037},{"id":"https://openalex.org/keywords/gender-schema-theory","display_name":"Gender schema theory","score":0.11989754438400269}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7616776823997498},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.72523033618927},{"id":"https://openalex.org/C29275276","wikidata":"https://www.wikidata.org/wiki/Q2268965","display_name":"Conceptual schema","level":3,"score":0.7118176221847534},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.7081311345100403},{"id":"https://openalex.org/C150012506","wikidata":"https://www.wikidata.org/wiki/Q6031185","display_name":"Information schema","level":5,"score":0.6475546956062317},{"id":"https://openalex.org/C56310702","wikidata":"https://www.wikidata.org/wiki/Q2269281","display_name":"Semi-structured model","level":4,"score":0.6238594651222229},{"id":"https://openalex.org/C190703929","wikidata":"https://www.wikidata.org/wiki/Q1331138","display_name":"Star schema","level":4,"score":0.6035738587379456},{"id":"https://openalex.org/C153440673","wikidata":"https://www.wikidata.org/wiki/Q7431119","display_name":"Schema migration","level":5,"score":0.5455685257911682},{"id":"https://openalex.org/C15845906","wikidata":"https://www.wikidata.org/wiki/Q1172338","display_name":"Data exchange","level":2,"score":0.5384440422058105},{"id":"https://openalex.org/C72634772","wikidata":"https://www.wikidata.org/wiki/Q386824","display_name":"Data integration","level":2,"score":0.5082475543022156},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.452612966299057},{"id":"https://openalex.org/C2777327318","wikidata":"https://www.wikidata.org/wiki/Q1408390","display_name":"Schema matching","level":3,"score":0.4386865496635437},{"id":"https://openalex.org/C2780660560","wikidata":"https://www.wikidata.org/wiki/Q3951893","display_name":"Schema evolution","level":4,"score":0.42702963948249817},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3945651650428772},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3516826033592224},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.24407732486724854},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.23518693447113037},{"id":"https://openalex.org/C165611974","wikidata":"https://www.wikidata.org/wiki/Q5531015","display_name":"Gender schema theory","level":2,"score":0.11989754438400269},{"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":2,"locations":[{"id":"doi:10.1145/2452376.2452479","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2452376.2452479","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 16th International Conference on Extending Database Technology","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.309.1219","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.309.1219","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.edbt.org/Proceedings/2013-Genova/papers/edbt/a81-cate.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G5177825213","display_name":null,"funder_award_id":"IIS-0905276, IIS-1217869","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":18,"referenced_works":["https://openalex.org/W1969053136","https://openalex.org/W1981951557","https://openalex.org/W1992673035","https://openalex.org/W2023878327","https://openalex.org/W2068680051","https://openalex.org/W2077296695","https://openalex.org/W2077397644","https://openalex.org/W2078047958","https://openalex.org/W2101827111","https://openalex.org/W2106039833","https://openalex.org/W2109171159","https://openalex.org/W2147298415","https://openalex.org/W2151604269","https://openalex.org/W2153719564","https://openalex.org/W2155419928","https://openalex.org/W2167866332","https://openalex.org/W2401502514","https://openalex.org/W4235498869"],"related_works":["https://openalex.org/W166845585","https://openalex.org/W2103472145","https://openalex.org/W945629821","https://openalex.org/W1513459549","https://openalex.org/W2584207435","https://openalex.org/W1499427961","https://openalex.org/W1971380397","https://openalex.org/W2351507151","https://openalex.org/W896179304","https://openalex.org/W2512111375"],"abstract_inverted_index":{"A":[0],"fundamental":[1],"task":[2],"in":[3],"data":[4,7,101],"integration":[5],"and":[6,30,85,106],"exchange":[8],"is":[9,46,94],"the":[10,21,61,75,97],"design":[11],"of":[12,20,43,100],"schema":[13,51,87,108],"mappings,":[14],"that":[15,47],"is,":[16],"high-level":[17],"declarative":[18],"specifications":[19],"relationship":[22],"between":[23],"two":[24],"database":[25],"schemas.":[26],"Several":[27],"research":[28],"prototypes":[29],"commercial":[31],"systems":[32,45],"have":[33],"been":[34],"developed":[35],"to":[36,83,103],"facilitate":[37],"schema-mapping":[38],"design;":[39],"a":[40,50,64,79],"common":[41],"characteristic":[42],"these":[44],"they":[48],"produce":[49],"mapping":[52],"based":[53,95],"on":[54,96],"attribute":[55],"correspondences":[56],"across":[57],"schemas":[58],"solicited":[59],"from":[60,71],"user":[62],"via":[63],"visual":[65],"interface.":[66],"This":[67,91],"methodology,":[68],"however,":[69],"suffers":[70],"certain":[72],"shortcomings.":[73],"In":[74],"past":[76],"few":[77],"years,":[78],"fundamentally":[80],"different":[81],"methodology":[82,93],"designing":[84],"understanding":[86],"mappings":[88],"has":[89],"emerged.":[90],"new":[92],"systematic":[98],"use":[99],"examples":[102],"derive,":[104],"illustrate,":[105],"refine":[107],"mappings.":[109]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":3},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":1},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":2}],"updated_date":"2026-07-22T07:51:19.307946","created_date":"2025-10-10T00:00:00"}