Abstract
Deriving local cost models for query optimization in a multidatabase system (MDBS) is a challenging issue due to local autonomy. It becomes even more difficult when dynamic environmental factors are taken into consideration. In this paper, we study how to evolve a cost model to capture a slowly-changing dynamic MDBS environment so that the cost model is kept up-to-date all the time. We propose a novel evolutionary technique, called the shifting method, to tackle this issue. The key idea is to adjust a cost model by adding the up-to-date performance information of a new sample query into and, in the meantime, removing the out-of-date information of the oldest sample query from consideration at each step. It is shown that this method is more efficient than the direct re-building approach. The relevant issues including derivation of recurrence update formulas, development of efficient algorithm, analysis of complexities as well as some aspects of implementation are studied. Our theoretical and experimental results demonstrate that the proposed shifting method is quite promising in deriving accurate evolutionary cost models for a slowly-changing dynamic MDBS environment.
Research supported by the US National Science Foundation under Grant # IIS- 9811980 and The University of Michigan under OVPR and UMD grants.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
S. Adali, K. S. Candan, Y. Papakonstantinou and V. S. Subrahmamian. Query caching and optimization in distributed mediator systems. In Proc. of SIGMOD, pp 137–48, 1996.
G.K. Attaluri, D.P. Bradshaw, N. Coburn, P.-Å. Larson, P. Martin, A. Silberschatz, J. Slonim and Q. Zhu. The CORDS multidatabase project. IBM Systems Journal, 34(1):39–62, 1995.
W. Du, R. Krishnamurthy and M. C. Shan. Query optimization in heterogeneous DBMS. In Proc. of VLDB, pp 277–91, 1992.
W. Du, M. C. Shan and U. Dayal. Reducing multidatabase query response time by tree balancing. In Proc. of SIGMOD, pp 293–303, 1995.
G. Gardarin, F. Sha and Z.-H. Tang. Calibrating the query optimizer cost model of IRO-DB, an object-oriented federated database system. In Proc. of VLDB, pp 378–89, 1996.
C. Lee and C.-J. Chen. Query optimization in multidatabase systems considering schema conflicts. IEEE TKDE, 9(6):941–55, 1997.
W. Litwin, L. Mark and N. Roussopoulos. Interoperability of multiple autonomous databases. ACM Comp. Surveys, 22(3):267–93, 1990.
H. Lu and M.-C. Shan. On global query optimization in multidatabase systems. In 2nd Int’l workshop on Res. Issues on Data Eng., pp 217, Arizona, 1992.
H. Naacke, G. Gardarin and A. Tomasic. Leveraging mediator cost models with heterogeneous data sources. In Proc. of ICDE, pp 351–60, 1998.
J. Neter, M. Kutner and W. Wasserman. Applied Linear Statistical Models, 3rd Ed. Richard D. Irwin, Inc., 1990.
R. Pfaffenberger and James H. Patterson. Statistical Methods for Business and Economics. Richard D. Irwin, Inc., 1987.
A. Rahal, Q. Zhu and P.-Å. Larson. Evolutionary techniques for updating cost models in a dynamic multidatabase environment. Technical Report CIS-TR-0701-02, Dept of Comp. and Inf. Sci., The Univ. of Michigan-Dearborn, July 2002.
M. T. Roth, F. Ozcan and L. M. Haas. Cost models DO matter: providing cost information for diverse data sources in a federated system. In Proc. of VLDB, pp 599–610, 1999.
A. P. Sheth and J. A. Larson. Federated database systems for managing distributed, heterogeneous, and autonomous databases. ACM Comp. Surveys, 22(3):183–236, 1990.
J. Treicher and J. Richard. Theory and Design of Adaptive Filters. Wiley and Sons, Inc, 1987.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2002 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Rahal, A., Zhu, Q., Larson, PÅ. (2002). Developing Evolutionary Cost Models for Query Optimization in a Dynamic Multidatabase Environment. In: Meersman, R., Tari, Z. (eds) On the Move to Meaningful Internet Systems 2002: CoopIS, DOA, and ODBASE. OTM 2002. Lecture Notes in Computer Science, vol 2519. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-36124-3_1
Download citation
DOI: https://doi.org/10.1007/3-540-36124-3_1
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-00106-5
Online ISBN: 978-3-540-36124-4
eBook Packages: Springer Book Archive