{"id":"https://openalex.org/W2077449561","doi":"https://doi.org/10.1145/1247480.1247532","title":"Compiling mappings to bridge applications and databases","display_name":"Compiling mappings to bridge applications and databases","publication_year":2007,"publication_date":"2007-06-11","ids":{"openalex":"https://openalex.org/W2077449561","doi":"https://doi.org/10.1145/1247480.1247532","mag":"2077449561"},"language":"en","primary_location":{"id":"doi:10.1145/1247480.1247532","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1247480.1247532","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2007 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/A5109208641","display_name":"Sergey Melnik","orcid":null},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Sergey Melnik","raw_affiliation_strings":["Microsoft Research, Redmond, WA"],"affiliations":[{"raw_affiliation_string":"Microsoft Research, Redmond, WA","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5060789723","display_name":"Atul Adya","orcid":"https://orcid.org/0000-0001-8767-6908"},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Atul Adya","raw_affiliation_strings":["Microsoft Corporation, Redmond, WA"],"affiliations":[{"raw_affiliation_string":"Microsoft Corporation, Redmond, WA","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5108676493","display_name":"Philip A. Bernstein","orcid":"https://orcid.org/0000-0001-5781-1558"},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Philip A. Bernstein","raw_affiliation_strings":["Microsoft Research, Redmond, WA"],"affiliations":[{"raw_affiliation_string":"Microsoft Research, Redmond, WA","institution_ids":["https://openalex.org/I1290206253"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5109208641"],"corresponding_institution_ids":["https://openalex.org/I1290206253"],"apc_list":null,"apc_paid":null,"fwci":13.5301,"has_fulltext":false,"cited_by_count":65,"citation_normalized_percentile":{"value":0.98936353,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"461","last_page":"472"},"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.9998000264167786,"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.9998000264167786,"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/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.9975000023841858,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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.996999979019165,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8151090741157532},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.6902047395706177},{"id":"https://openalex.org/keywords/rewriting","display_name":"Rewriting","score":0.6058151721954346},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.5851911902427673},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.563431441783905},{"id":"https://openalex.org/keywords/leverage","display_name":"Leverage (statistics)","score":0.5291894674301147},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.5183723568916321},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.4833371341228485},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.43928593397140503},{"id":"https://openalex.org/keywords/schema-evolution","display_name":"Schema evolution","score":0.4387192130088806},{"id":"https://openalex.org/keywords/data-modeling","display_name":"Data modeling","score":0.42712414264678955},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.41219621896743774},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.3836938440799713},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.32251328229904175},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.10301277041435242}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8151090741157532},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.6902047395706177},{"id":"https://openalex.org/C154690210","wikidata":"https://www.wikidata.org/wiki/Q1668499","display_name":"Rewriting","level":2,"score":0.6058151721954346},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.5851911902427673},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.563431441783905},{"id":"https://openalex.org/C153083717","wikidata":"https://www.wikidata.org/wiki/Q6535263","display_name":"Leverage (statistics)","level":2,"score":0.5291894674301147},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.5183723568916321},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.4833371341228485},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.43928593397140503},{"id":"https://openalex.org/C2780660560","wikidata":"https://www.wikidata.org/wiki/Q3951893","display_name":"Schema evolution","level":4,"score":0.4387192130088806},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.42712414264678955},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.41219621896743774},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.3836938440799713},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.32251328229904175},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.10301277041435242}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1247480.1247532","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1247480.1247532","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2007 ACM SIGMOD international conference on Management of data","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/9","score":0.4099999964237213,"display_name":"Industry, innovation and infrastructure"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":49,"referenced_works":["https://openalex.org/W30253544","https://openalex.org/W1489179195","https://openalex.org/W1500132926","https://openalex.org/W1500615737","https://openalex.org/W1505216615","https://openalex.org/W1508902783","https://openalex.org/W1556076816","https://openalex.org/W1583928555","https://openalex.org/W1802428003","https://openalex.org/W1943411325","https://openalex.org/W1985223393","https://openalex.org/W2000616678","https://openalex.org/W2005318605","https://openalex.org/W2020228538","https://openalex.org/W2024796520","https://openalex.org/W2032339126","https://openalex.org/W2045141511","https://openalex.org/W2046444514","https://openalex.org/W2074669964","https://openalex.org/W2080267935","https://openalex.org/W2088675571","https://openalex.org/W2090958287","https://openalex.org/W2095395853","https://openalex.org/W2101498152","https://openalex.org/W2113582770","https://openalex.org/W2116476518","https://openalex.org/W2120127771","https://openalex.org/W2121447816","https://openalex.org/W2125030020","https://openalex.org/W2125713144","https://openalex.org/W2140037779","https://openalex.org/W2144192824","https://openalex.org/W2144878221","https://openalex.org/W2146462464","https://openalex.org/W2152191782","https://openalex.org/W2153670461","https://openalex.org/W2155419928","https://openalex.org/W2157812994","https://openalex.org/W2158595459","https://openalex.org/W2160983447","https://openalex.org/W2167764264","https://openalex.org/W2169207323","https://openalex.org/W2997050146","https://openalex.org/W4205167958","https://openalex.org/W4249171797","https://openalex.org/W6601213961","https://openalex.org/W6630214281","https://openalex.org/W6633446409","https://openalex.org/W6683247490"],"related_works":["https://openalex.org/W1512562726","https://openalex.org/W3085968255","https://openalex.org/W2153455914","https://openalex.org/W1491042988","https://openalex.org/W279222092","https://openalex.org/W2007556552","https://openalex.org/W1998046157","https://openalex.org/W2512945146","https://openalex.org/W2460926837","https://openalex.org/W1588786827"],"abstract_inverted_index":{"Translating":[0],"data":[1,3,13,31,51],"and":[2,8,32,111,122,136],"access":[4],"operations":[5],"between":[6,28],"applications":[7],"databases":[9],"is":[10,36,43,64],"a":[11,18,39,59,95,104,108],"longstanding":[12],"management":[14],"problem.":[15],"We":[16,117],"present":[17],"novel":[19],"approach":[20,90],"to":[21,66,81,101],"this":[22],"problem,":[23],"in":[24,73,94],"which":[25,42,130],"the":[26,29,33,50,55,62,71,76,119,125],"relationship":[27],"application":[30,56,77],"persistent":[34],"storage":[35],"specified":[37],"using":[38],"declarative":[40],"mapping,":[41],"compiled":[44],"into":[45],"bidirectional":[46],"views":[47],"that":[48],"drive":[49],"transformation":[52],"engine.":[53],"Expressing":[54],"model":[57,78],"as":[58],"view":[60,83],"on":[61,124],"database":[63,72,106],"used":[65],"answer":[67],"queries,":[68],"while":[69],"viewing":[70],"terms":[74],"of":[75,127],"allows":[79],"us":[80],"leverage":[82],"maintenance":[84],"algorithms":[85],"for":[86],"update":[87],"translation.":[88],"This":[89],"has":[91],"been":[92],"implemented":[93,120],"commercial":[96],"product.":[97],"It":[98],"enables":[99],"developers":[100],"interact":[102],"with":[103],"relational":[105],"via":[107],"conceptual":[109],"schema":[110],"an":[112],"object":[113],"oriented":[114],"programming":[115],"surface.":[116],"outline":[118],"system":[121],"focus":[123],"challenges":[126],"mapping":[128],"compilation,":[129],"include":[131],"rewriting":[132],"queries":[133],"under":[134],"constraints":[135],"supporting":[137],"non-relational":[138],"constructs.":[139]},"counts_by_year":[{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":1},{"year":2016,"cited_by_count":2},{"year":2015,"cited_by_count":5},{"year":2014,"cited_by_count":2},{"year":2013,"cited_by_count":5},{"year":2012,"cited_by_count":3}],"updated_date":"2026-03-09T08:58:05.943551","created_date":"2025-10-10T00:00:00"}