Peter McBrien, Alexandra Poulovassilis. Automatic Migration and Wrapping of Database Applications - A Schema Transformation Approach. In Jacky Akoka, Mokrane Bouzeghoub, Isabelle Comyn-Wattiau, Elisabeth Métais, editors, Conceptual Modeling - ER 99, 18th International Conference on Conceptual Modeling, Paris, France, November, 15-18, 1999, Proceedings. Volume 1728 of Lecture Notes in Computer Science, pages 96-113, Springer, 1999.
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 hypergraphbased 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 lowerlevel 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.