A comparative analysis of methodologies for database schema integration
ACM Computing Surveys (CSUR)
View updates in relational databases with an independent scheme
ACM Transactions on Database Systems (TODS)
Federated database systems for managing distributed, heterogeneous, and autonomous databases
ACM Computing Surveys (CSUR) - Special issue on heterogeneous databases
Managing semantic heterogeneity in databases: a theoretical prospective
PODS '97 Proceedings of the sixteenth ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems
A formalisation of semantic schema integration
Information Systems
A general formal framework for schema transformation
Data & Knowledge Engineering - Special issue on ER '97
InterViso: dealing with the complexity of federated database access
The VLDB Journal — The International Journal on Very Large Data Bases
Don't Scrap It, Wrap It! A Wrapper Architecture for Legacy Data Sources
VLDB '97 Proceedings of the 23rd International Conference on Very Large Data Bases
Optimizing Queries Across Diverse Data Sources
VLDB '97 Proceedings of the 23rd International Conference on Very Large Data Bases
A Uniform Approach to Inter-model Transformations
CAiSE '99 Proceedings of the 11th International Conference on Advanced Information Systems Engineering
A Meta-Wrapper for Scaling up to Multiple Autonomous Distributed Information Sources
COOPIS '98 Proceedings of the 3rd IFCIS International Conference on Cooperative Information Systems
A Formal Framework for ER Schema Transformation
ER '97 Proceedings of the 16th International Conference on Conceptual Modeling
On the updatability of relational views
VLDB '78 Proceedings of the fourth international conference on Very Large Data Bases - Volume 4
The AutoMed Schema Integration Repository
BNCOD 19 Proceedings of the 19th British National Conference on Databases: Advances in Databases
A Semantic Approach to Integrating XML and Structured Data Sources
CAiSE '01 Proceedings of the 13th International Conference on Advanced Information Systems Engineering
Schema Evolution in Heterogeneous Database Architectures, A Schema Transformation Approach
CAiSE '02 Proceedings of the 14th International Conference on Advanced Information Systems Engineering
Tracing Data Lineage Using Automed Schema Transformation Pathways
BNCOD 19 Proceedings of the 19th British National Conference on Databases: Advances in Databases
Global Query Processing in the AutoMed Heterogeneous Database Environment
BNCOD 19 Proceedings of the 19th British National Conference on Databases: Advances in Databases
Metadata management in a multiversion data warehouse
OTM'05 Proceedings of the 2005 OTM Confederated international conference on On the Move to Meaningful Internet Systems: CoopIS, COA, and ODBASE - Volume Part II
Change management in large-scale enterprise information systems
EDBT'06 Proceedings of the 2006 international conference on Current Trends in Database Technology
| Hi-index | 0.00 |
Integration of heterogeneous databases requires that semantic differences between schemas are resolved by a process of schema transformation. Previously, we have developed a general framework to support the schema transformation process, consisting of a hypergraph-based common data model and a set of primitive schema transformations defined for this model. Higher-level common data models and primitive schema transformations for them can be defined in terms of this lower-level model. In this paper, we show that a key feature of our framework is that both primitive and composite schema transformations are automatically reversible. We show how these transformations can be used to automatically migrate or wrap data, queries and updates between semantically equivalent schemas.We also show how to handle transformations between non-equivalent but overlapping schemas.We describe a prototype schema integration tool that supports this functionality. Finally, we briefly discuss how our approach can be extended to more sophisticated application logic such as constraints, deductive rules, and active rules.