Skip to main content

A distributed algorithm for global query optimization in multidatabase systems

  • Regular Papers
  • Conference paper
  • First Online:
Advances in Databases and Information Systems (ADBIS 1998)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 1475))

  • 181 Accesses

Abstract

In multidatabase systems the heterogeneity and the autonomy of the sites preclude the applicability of the classical query optimization algorithms used in distributed database systems, and therefore new approaches have to be investigated. In this paper we propose a distributed optimization algorithm that makes very general assumptions on the cost function, and on the degree of autonomy of the federated sites. The algorithm is based on a cooperative approach where cost of a query execution plan is evaluated as the composition of the cost estimates produced by the local sites where each part of the computation has to be performed. During the optimization process larger and larger partial execution plans are considered, and the the relative cost estimates are exchanged between the sites. Duplicated and unnecessary computation is avoided by discarding as soon as possible partial plans that are dominated by an equivalent one. The paper substantially extends the results of a previous paper, where we first introduced the idea of cooperative optimization, by removing major restrictions on the query model, and by considering not only sequential execution plans but also parallel ones.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Amsaleg, L., Franklin, M. J., Tomasic, A., Urhan, T., Scrambling Query Plans to Cope With Unexpected Delays, Proc. of the 4th Int. Conf. on Parallel and Distributed Information Systems, Miami Beach (Florida), 1996, IEEE Computer Society Press, p. 208–219.

    Google Scholar 

  2. Du, W, et al., Query optimization in heterogeneous DBMS, Proc. of the 18th VLDB Conference, Vancouver, 1992, pp. 277–291

    Google Scholar 

  3. Du, W., Shan, M.-C., and Dayal, U., Reducing multidatabase query response time by tree balancing, Proc. of ACM-SIGMOD Int. Conf. On Management of Data, San Jose, USA, 1995, pp. 293–303.

    Google Scholar 

  4. Kim, W., Choi, I., Gala, S., and Scheevel, M., On resolving schematic heterogeneity in multidatabase systems, in Modern Database Systems [ed. W. Kim], Addison-Wesley Pub. Co., 1995, pp. 521–550.

    Google Scholar 

  5. Lee, C., Chen, C.-J., and Lu, H., An aspect of query optimization in multidatabase systems, SIGMOD Record, vol. 24, No. 3, 1995, pp. 28–33.

    Article  MATH  Google Scholar 

  6. Lu, W, et al., On global query optimization in multidatabase systems, Proc. of 2nd Int. Workshop on Research Issues on Data Eng., Tempe, 1992, pp. 217–227

    Google Scholar 

  7. Lu, W, et al., Multidatabase query optimization: issues and solutions, Proc. of 3rd Int. Workshop on Research Issues on Data Eng., Vienna, 1993, pp. 137–143

    Google Scholar 

  8. Meng, W., and Yu, C., Query optimization in multidatabase systems, in Modern Database Systems [ed. W. Kim], Addison-Wesley Pub. Co., 1995, pp. 551–572.

    Google Scholar 

  9. F. Ozcan, F., Nural, S., Koksal, P., Evrendilek, C., Dogac, A. Dogac, Dynamic query optimization in multidatabases, Bulletin of the TC on Data Engineering, vol. 20, No. 3, September 1997, p. 38–45

    Google Scholar 

  10. Salza, S., Barone, G., and Morzy, T., Distributed query optimization in loosely coupled multidatabase systems, Proc. of 5th Int. Conf. on Database Theory, Prague, 1995, pp. 40–53.

    Google Scholar 

  11. Sheth, A., Larson, J., Federated database systems for managing distributed, heterogeneous, and autonomous databases, ACM Computing Surveys, 22, 1990, pp. 183–236.

    Article  Google Scholar 

  12. Zhu, Q, Larson, P-A, A query sampling method for estimating local cost parameters in a multidatabase system, Proc. of 10th Int. Conf. on Data Eng., Houston, 1994, pp. 144–153.

    Google Scholar 

  13. Zhu, Q, Larson, P-A, Building Regression Cost Models for Multidatabase Systems, Proc. of the 4th Int. Conf. on Parallel and Distributed Information Systems, Miami Beach (Florida), 1996, IEEE Computer Society Press, p. 220–231.

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Witold Litwin Tadeusz Morzy Gottfried Vossen

Rights and permissions

Reprints and permissions

Copyright information

© 1998 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Salza, S., Barone, G., Morzy, T. (1998). A distributed algorithm for global query optimization in multidatabase systems. In: Litwin, W., Morzy, T., Vossen, G. (eds) Advances in Databases and Information Systems. ADBIS 1998. Lecture Notes in Computer Science, vol 1475. Springer, Berlin, Heidelberg. https://doi.org/10.1007/BFb0057720

Download citation

  • DOI: https://doi.org/10.1007/BFb0057720

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-64924-3

  • Online ISBN: 978-3-540-68309-4

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics