Skip to main content

Distributed query optimization in loosely coupled multidatabase systems

Contributed Papers

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

Abstract

A multidatabase system (MDBS) is a database system which integrates pre-existing databases, called component local database systems (LDBSs), to support global applications accessing data at more than one LDBS. An important research issue in MDBS is query optimization. The query optimization problem in MDBS is quite different from the case of distributed database system (DDBS) since, due to schema heterogeneity and local autonomy of component LDBSs, is not possible to assume that the query optimizer has a complete information on the execution cost and database statistics. In this paper we present a distributed query optimization algorithm that works under very general assumptions for MDBSs with relational global data model. The algorithm is based on the idea of delegating the evaluation of the execution cost of the elementary steps in a query execution plan to the LDBS where the computation is performed. The optimization process is organized as a sequence of steps, in which at each step all LDBSs work in parallel to evaluate the cost of execution plans for partial queries of increasing size, and send their cost estimates to the other LDBS that need them for the next step. The computation is totally distributed, and organized in order to perform no duplicate computation, and to discard as soon as possible the execution plans that may not lead to an optimal solution.

Keywords

  • Execution Model
  • Execution Plan
  • Query Optimization
  • Query Execution
  • Execution Cost

These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

This is a preview of subscription content, access via your institution.

Buying options

Chapter
USD   29.95
Price excludes VAT (USA)
  • DOI: 10.1007/3-540-58907-4_5
  • Chapter length: 14 pages
  • Instant PDF download
  • Readable on all devices
  • Own it forever
  • Exclusive offer for individuals only
  • Tax calculation will be finalised during checkout
eBook
USD   99.00
Price excludes VAT (USA)
  • ISBN: 978-3-540-49136-1
  • Instant PDF download
  • Readable on all devices
  • Own it forever
  • Exclusive offer for individuals only
  • Tax calculation will be finalised during checkout
Softcover Book
USD   129.00
Price excludes VAT (USA)

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. W. Du, A. K. Elmagarmid, Quasi serializability: a correctness criterion for global concurrency control in InterBase, Proc. of 15th Int. Conf. VLDB, 1989, pp. 347–355.

    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. A. K. Elmagarmid, W. Du, A paradigm for concurrency control in heterogeneous distributed database systems, Proc. of 6th Int. Conf. on Data Engineering, 1990, pp. 37–46.

    Google Scholar 

  4. D. Georgakopolous, M. Rusinkiewicz, A. Sheth, On serializability of multidatabase transactions through forced local conflicts, Proc. 7th Int. Conf. on Data Engineering, 1991, pp. 314–323.

    Google Scholar 

  5. Y. E. Ioannidis and Y.C. Kang, Left-Deep vs. Bushy Trees: An Analysis of Strategy Spaces and its Implications for Query Optimization, Proc. of ACM-SIGMOD Conf. on Management of Data, Denver, USA, 1991, pp.168–177

    Google Scholar 

  6. W. Lu, 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. W. Lu, 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. S. Mehrotra, R. Rastogi, Y. Breitbart, H. F. Korth, A. Silberschatz, The concurrency control problem in multidatabases: characteristics and solutions, Proc. of ACM SIGMOD Conf., 1992, pp. 288–296.

    Google Scholar 

  9. P. Muth, W. Klas, E. J. Neuhold, How to handle global transactions in heterogeneous database systems, Proc. 8th Int. Conf. on Data Engineering, 1992, pp. 192–198.

    Google Scholar 

  10. Proc. of Int. Workshop on Multidatabase and Semantic Interoperability, Tulsa, UK, 1990.

    Google Scholar 

  11. Proc. of Int. Workshop on Interoperability in Multidatabase Systems — RIDE, Kyoto, Japan, 1991.

    Google Scholar 

  12. Proc. of Int. Workshop on Interoperability in Multidatabase Systems — RIDE, Vienna, Austria, 1993.

    Google Scholar 

  13. S. Salza, T. Morzy, M. Matysiak, Tabu Search optimization of large join queries, Proc. of 4th Int. Conf. EDBT'94, Cambridge (UK), 1994, pp. 151–161 (Lecture Notes on Computer Science).

    Google Scholar 

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

    Google Scholar 

  15. 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 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and Permissions

Copyright information

© 1995 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Salza, S., Barone, G., Morzy, T. (1995). Distributed query optimization in loosely coupled multidatabase systems. In: Gottlob, G., Vardi, M.Y. (eds) Database Theory — ICDT '95. ICDT 1995. Lecture Notes in Computer Science, vol 893. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-58907-4_5

Download citation

  • DOI: https://doi.org/10.1007/3-540-58907-4_5

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-58907-5

  • Online ISBN: 978-3-540-49136-1

  • eBook Packages: Springer Book Archive