On the correct translation of update operations on relational views
ACM Transactions on Database Systems (TODS)
Schema Evolution in Heterogeneous Database Architectures, A Schema Transformation Approach
CAiSE '02 Proceedings of the 14th International Conference on Advanced Information Systems Engineering
Immortal DB: transaction time support for SQL server
Proceedings of the 2005 ACM SIGMOD international conference on Management of data
Semantic adaptation of schema mappings when schemas evolve
VLDB '05 Proceedings of the 31st international conference on Very large data bases
A formal characterization of PIVOT/UNPIVOT
Proceedings of the 14th ACM international conference on Information and knowledge management
Relational lenses: a language for updatable views
Proceedings of the twenty-fifth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems
An online bibliography on schema evolution
ACM SIGMOD Record
Compiling mappings to bridge applications and databases
Proceedings of the 2007 ACM SIGMOD international conference on Management of data
MeDEA: A database evolution architecture with traceability
Data & Knowledge Engineering
The recovery of a schema mapping: bringing exchanged data back
Proceedings of the twenty-seventh ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems
Data exchange with data-metadata translations
Proceedings of the VLDB Endowment
Graceful database schema evolution: the PRISM workbench
Proceedings of the VLDB Endowment
Clio: Schema Mapping Creation and Data Exchange
Conceptual Modeling: Foundations and Applications
A generic and customizable framework for the design of ETL scenarios
Information Systems - Special issue: The 15th international conference on advanced information systems engineering (CAiSE 2003)
Graphical user interfaces as updatable views
Graphical user interfaces as updatable views
What-if analysis for data warehouse evolution
DaWaK'07 Proceedings of the 9th international conference on Data Warehousing and Knowledge Discovery
Enabling revisitation of fine-grained clinical information
Proceedings of the 1st ACM International Health Informatics Symposium
Dagstuhl seminar on bidirectional transformations (BX)
ACM SIGMOD Record
ICMT'12 Proceedings of the 5th international conference on Theory and Practice of Model Transformations
Hi-index | 0.00 |
Applications typically have some local understanding of a database schema, a virtual database 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 channel transformations (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.