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.
This is a preview of subscription content, log in via an institution to check access.
Preview
Unable to display preview. Download preview PDF.
References
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.
Du, W, et al., Query optimization in heterogeneous DBMS, Proc. of the 18th VLDB Conference, Vancouver, 1992, pp. 277–291
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.
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.
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
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
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
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.
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.
Proc. of Int. Workshop on Multidatabase and Semantic Interoperability, Tulsa, UK, 1990.
Proc. of Int. Workshop on Interoperability in Multidatabase Systems — RIDE, Kyoto, Japan, 1991.
Proc. of Int. Workshop on Interoperability in Multidatabase Systems — RIDE, Vienna, Austria, 1993.
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).
A. Sheth, J. Larson, Federated database systems for managing distributed, heterogeneous, and autonomous databases, ACM Computing Surveys, 22:183–236, 1990.
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.
Author information
Authors and Affiliations
Editor information
Rights 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