Sustaining software interoperability via shared, evolving object repositories: system optimization and evaluation

Powerful interoperability-enabling solutions for software application integration must allow applications to evolve and data requirements to change, while minimizing such changes on other integrated applications. Thus, we have developed the transparent schema evolution (TSE) system that accomplishes evolution by generating a new object-oriented view schema to capture the changes desired by the user, while preserving existing view schemas for old applications. This generation of a potentially large number of schema versions over time results in an excessive build-up of classes and underlying object instances - some of which may no longer be in use. The presence of no-longer-utilized view schemas will result in storage overhead costs and a degradation of system performance due to the update propagation of our materialized view foundation. In this paper, we address this problem using consistent schema removal techniques. Our solution is based on a formal model of capturing all dependencies between classes as logic clauses and of manipulating them to make decisions on class deletions and nondeletions while guaranteeing the consistency of the schema. Based on this formal model, we have developed and proven consistent a dependency graph (DG) representation and associated set of rules for DG generation, reduction, and transformation. The later has been successfully implemented in our TSE optimizer tool. To address the problem that view schema removal is sensitive to the order in which individual classes are processed, we present a cost model for evaluating alternative removal patterns on DG. We also report our preliminary experimental studies that validate our approach and demonstrate its impact on the performance of the TSE system.

[1]  Elke A. Rundensteiner,et al.  A transparent object-oriented schema change approach using view evolution , 1995, Proceedings of the Eleventh International Conference on Data Engineering.

[2]  Markus Tresch,et al.  Updatable Views in Object-Oriented Databases , 1991, DOOD.

[3]  Elke A. Rundensteiner Multiview: A Methodology for Supporting Multiple Views in Object-Oriented Databases , 1992, VLDB.

[4]  Elke A. Rundensteiner,et al.  A Transparent Schema-Evolution System Based on Object-Oriented View Technology , 1997, IEEE Trans. Knowl. Data Eng..

[5]  Won Kim,et al.  Versions of Schema for Object-Oriented Databases , 1988, VLDB.

[6]  Won Kim,et al.  Introduction to Object-Oriented Databases , 1991, Computer systems.

[7]  David J. DeWitt,et al.  The 007 Benchmark , 1993, SIGMOD '93.

[8]  Craig W. Thompson,et al.  Special report: the 1988 Object-oriented database workshop , 1989, SGMD.

[9]  Elisa Bertino,et al.  Integration of heterogeneous data repositories by using object-oriented views , 1991, [1991] Proceedings. First International Workshop on Interoperability in Multidatabase Systems.

[10]  Elke A. Rundensteiner,et al.  Using object-oriented principles to optimize update propagation to materialized views , 1996, Proceedings of the Twelfth International Conference on Data Engineering.

[11]  Svein Erik Bratsberg Unified Class Evolution by Object-Oriented Views , 1992, ER.

[12]  David J. DeWitt,et al.  The oo7 Benchmark , 1993, SIGMOD Conference.

[13]  Elke A. Rundensteiner,et al.  The MultiView OODB View System: Design and Implementation , 1996, Theory Pract. Object Syst..

[14]  Elisa Bertino,et al.  A formal model of views for object-oriented database systems , 1997 .

[15]  Elke A. Rundensteiner,et al.  Consistent view removal in transparent schema evolution systems , 1996, Proceedings RIDE '96. Sixth International Workshop on Research Issues in Data Engineering.

[16]  Elke A. Rundensteiner,et al.  The MultiView project: object-oriented view technology and applications , 1996, SIGMOD '96.

[17]  Serge Abiteboul,et al.  Virtual Schemas and Bases , 1994, EDBT.

[18]  Serge Abiteboul,et al.  Objects and views , 1991, SIGMOD '91.