Abstract
More than ever before schema transformation is a prevalent problem that needs to be addressed to accomplish for example the mi- gration of legacy systems to the newer OODB systems, the generation of structured web pages from data in database systems, or the integration of systems with different native data models. Such schema transformations are typically composed of a sequence of schema evolution operations. The execution of such sequences can be very time-intensive, possibly requi- ring many hours or even days and thus effectively making the database unavailable for unacceptable time spans. While researchers have looked at the deferred execution approach for schema evolution in an effort to improve availability of the system, to the best of our knowledge ours is the first effort to provide a direct optimization strategy for a sequence of changes. In this paper, we propose heuristics for the iterative elimination and cancellation of schema evolution primitives as well as for the merging of database modifications of primitives such that they can be performed in one efficient transformation pass over the database. In addition we show the correctness of our optimization approach, thus guaranteeing that the initial input and the optimized output schema evolution se- quence produce the same final schema and data state. We provide proof of the algorithm’s optimality by establishing the confluence property of our problem search space, i.e., we show that the iterative application of our heuristics always terminates and converges to a unique minimal sequence. Moreover, we have conducted experimental studies that de- monstrate the performance gains achieved by our proposed optimization technique over previous solutions.
This work was supported in part by the NSF NYI grant #IRI 94-57609. We would also like to thank our industrial sponsors, in particular, IBM for the IBM partnership award and Informix for software contribution. Kajal T. Claypool would like to thank GE for the GE Corporate Fellowship. Special thanks also goes to the PSE Team specically, Gordon Landis, Sam Haradhvala, Pat O’Brien and Breman Thuraising at Object Design Inc. for not only software contributions but also for providing us with a customized patch of the PSE Pro2.0 system that exposed schema-related APIs needed to develop our tool.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
J. Banerjee, W. Kim, H. J. Kim, and H. F. Korth. Semantics and Implementation of Schema Evolution in Object-Oriented Databases. SIGMOD, pages 311–322, 1987.
P. Bréche. Advanced Primitives for Changing Schemas of Object Databases. In Conference on Advanced Information Systems Engineering, pages 476–495, 1996.
R. Bretl, D. Maier, A. Otis, J. Penney, B. Schuchardt, J. Stein, E. H. Williams, and M. Williams. The GemStone Data Management System. In Object-Oriented Concepts, Databases and Applications, pages 283–308. ACM Press, 1989.
Cattell, R.G.G and et al. The Object Database Standard: ODMG 2.0. Morgan Kaufmann Publishers, Inc., 1997.
K.T. Claypool, J. Jin, and E.A. Rundensteiner. SERF: Schema Evolution through an Extensible, Re-usable and Flexible Framework. In Int. Conf. on Information and Knowledge Management, pages 314–321, November 1998.
K.T. Claypool, C. Natarajan, and E.A. Rundensteiner. Optimizing the Performance of Schema Evolution Sequences. Technical Report WPI-CS-TR-99-06, Worcester Polytechnic Institute, February 1999.
C. Faloutsos, R.T. Snodgrass, V.S. Subrahmanian, S. Zaniolo, C. Ceri, and R. Zicari. Advanced Database Systems. Morgan Kaufmann, 1997.
F. Ferrandina, T. Meyer, and R. Zicari. Correctness of Lazy Database Updates for an Object Database System. In Proc. of the 6th Int’l Workshop on Persistent Object Systems, 1994.
F. Ferrandina, T. Meyer, and R. Zicari. Implementing Lazy Database Updates for an Object Database System. In Proc. of the 20th Int’l Conf. on Very Large Databases, pages 261–272, 1994.
Itasca Systems Inc. Itasca Systems Technical Report. Technical Report TM-92-001, OODBMS Feature Checklist. Rev 1.1, Itasca Systems, Inc., December 1993.
Bo KÄhler and Oddvar Risnes. Extending logging for database snapshot refresh. In Peter M. Stocker, William Kent, and Peter Hammersley, editors, VLDB’87, Proceedings of 13th International Conference on Very Large Data Bases, September 1-4, 1987, Brighton, England, pages 389–398. Morgan Kaufmann, 1987.
B.S. Lerner. A Model for Compound Type Changes Encountered in Schema Evolution. Technical Report UM-CS-96-044, University of Massachusetts, Amherst, Computer Science Department, 1996.
S. Marche. Measuring the Stability of Data Models. European Journal of Information Systems, 2(1):37–47, 1993.
Object Design Inc. ObjectStore-User Guide: DML. ObjectStore Release 3.0 for UNIX Systems. Object Design Inc., December 1993.
E.A. Rundensteiner, K.T. Claypool, M. Li, L. Chen, X. Zhang, C. Natarajan, J. Jin, S. De Lima, and S. Weiner. SERF: ODMG-Based Generic Re-structuring Facility. In Demo Session Proceedings of SIGMOD’99, pages 568–570, 1999.
A. Segev and J. Park. Updating Distributed Materialized Views. IEEE Transactions on Knowledge and Data Engineering, 1:173–184, 1989.
D. Sjoberg. Quantifying Schema Evolution. Information and Software Technology, 35(1):35–54, January 1993.
O2 Technology. O 2 Reference Manual, Version 4.5, Release November 1994. O2 Technology, Versailles, France, November 1994.
Z. Zicari. Primitives for Schema Updates in an Object-Oriented Database System: A Proposal. In Computer Standards & Interfaces, pages 271–283, 1991.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2001 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Claypool, K.T., Natarajan, C., Rundensteiner, E.A. (2001). Optimizing Performance of Schema Evolution Sequences. In: Dittrich, K., Guerrini, G., Merlo, I., Oliva, M., Rodriguez, M. (eds) Objects and Databases. SODB 2000. Lecture Notes in Computer Science, vol 1944. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-44677-X_8
Download citation
DOI: https://doi.org/10.1007/3-540-44677-X_8
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-41664-7
Online ISBN: 978-3-540-44677-4
eBook Packages: Springer Book Archive