{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2022,12,29]],"date-time":"2022-12-29T18:25:57Z","timestamp":1672338357027},"reference-count":20,"publisher":"Association for Computing Machinery (ACM)","issue":"1-2","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2010,9]]},"abstract":"<jats:p>\n            Applications typically have some local understanding of a database schema, a\n            <jats:italic>virtual database<\/jats:italic>\n            that may differ significantly from the actual schema of the data where it is stored. Application engineers often support a virtual database using custom-built middleware because the available solutions, including updatable views, are unable to express necessary capabilities. We propose an alternative means of mapping a virtual database to a physical database that guarantees they remain synchronized under data or schema updates against the virtual schema. One constructs a mapping by composing\n            <jats:italic>channel transformations<\/jats:italic>\n            (CTs) that encapsulate atomic transformations --- including complex transformations such as pivoting --- with known updatability properties. Applications, query interfaces, and any other services can behave as if the virtual database is the implemented schema. We describe how CTs translate queries, DML, and DDL, and the properties that are necessary for such translation to be correct. We describe two example CTs in detail, and evaluate an implementation of channels for completeness and performance.\n          <\/jats:p>","DOI":"10.14778\/1920841.1920883","type":"journal-article","created":{"date-parts":[[2014,6,24]],"date-time":"2014-06-24T12:17:57Z","timestamp":1403612277000},"page":"309-319","source":"Crossref","is-referenced-by-count":3,"title":["Updatable and evolvable transforms for virtual databases"],"prefix":"10.14778","volume":"3","author":[{"given":"James F.","family":"Terwilliger","sequence":"first","affiliation":[{"name":"Microsoft Corporation"}]},{"given":"Lois M. L.","family":"Delcambre","sequence":"additional","affiliation":[{"name":"Portland State University"}]},{"given":"David","family":"Maier","sequence":"additional","affiliation":[{"name":"Portland State University"}]},{"given":"Jeremy","family":"Steinhauer","sequence":"additional","affiliation":[{"name":"Portland State University"}]},{"given":"Scott","family":"Britell","sequence":"additional","affiliation":[{"name":"Portland State University"}]}],"member":"320","published-online":{"date-parts":[[2010,9]]},"reference":[{"key":"e_1_2_1_1_1","doi-asserted-by":"publisher","DOI":"10.1145\/1376916.1376920"},{"key":"e_1_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.1145\/1142351.1142399"},{"key":"e_1_2_1_3_1","first-page":"761","volume":"2008","author":"Curino C.","journal-title":"Graceful Database Schema Evolution: the PRISM Workbench. VLDB"},{"key":"e_1_2_1_4_1","doi-asserted-by":"publisher","DOI":"10.1145\/319732.319740"},{"key":"e_1_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.1016\/j.datak.2007.12.001"},{"key":"e_1_2_1_6_1","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-642-02463-4_12"},{"issue":"2","key":"e_1_2_1_7_1","first-page":"3","volume":"18","author":"Gupta A.","year":"1995","journal-title":"Maintenance of Materialized Views: Problems, Techniques, and Applications. IEEE Data Engineering Bulletin"},{"key":"e_1_2_1_8_1","first-page":"260","volume":"2008","author":"Hern\u00e1ndez M.","journal-title":"Data Exchange with Data-Metadata Translations. VLDB"},{"key":"e_1_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.1145\/1066157.1066295"},{"key":"e_1_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2003.1260795"},{"key":"e_1_2_1_11_1","volume-title":"CAiSE '02","author":"McBrien P."},{"key":"e_1_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.1145\/1247480.1247532"},{"key":"e_1_2_1_13_1","unstructured":"Microsoft SQL Server 2005. http:\/\/www.microsoft.com\/sql\/default.mspx.  Microsoft SQL Server 2005. http:\/\/www.microsoft.com\/sql\/default.mspx."},{"key":"e_1_2_1_14_1","first-page":"23","volume":"2007","author":"Papastefanatos G.","journal-title":"DaWaK"},{"key":"e_1_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.1145\/1228268.1228273"},{"key":"e_1_2_1_16_1","volume-title":"Portland State University","author":"Terwilliger J. F.","year":"2009"},{"key":"e_1_2_1_17_1","volume-title":"Va.","author":"Tsichritzis D.","year":"1977"},{"key":"e_1_2_1_18_1","doi-asserted-by":"publisher","DOI":"10.1016\/j.is.2004.11.002"},{"key":"e_1_2_1_19_1","doi-asserted-by":"publisher","DOI":"10.1145\/1099554.1099709"},{"key":"e_1_2_1_20_1","first-page":"1006","volume":"2005","journal-title":"C. Yu and L. Popa. Semantic Adaptation of Schema Mappings When Schemas Evolve. VLDB"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/1920841.1920883","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T11:53:49Z","timestamp":1672228429000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/1920841.1920883"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2010,9]]},"references-count":20,"journal-issue":{"issue":"1-2","published-print":{"date-parts":[[2010,9]]}},"alternative-id":["10.14778\/1920841.1920883"],"URL":"https:\/\/doi.org\/10.14778\/1920841.1920883","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2010,9]]}}}