Query optimization in multidatabase systems

Subramanian, DK and Subramanian, K (1998) Query optimization in multidatabase systems. In: Distributed and Parallel Databases, 06 (02). pp. 183-210.

PDF Query_Optimization.pdf - Published Version Restricted to Registered users only Download (307kB) | Request a copy

Abstract

Global query execution in a multidatabase system can be done parallelly, as all the local databases are independent. In this paper, a cost model that considers parallel execution of subqueries for a global query is developed. in order to obtain maximum parallelism in query execution, it is required to find a query execution plan that is represented in the form of a bushy tree and this query tree should be balanced to the maximal possible extent with respect to execution time. A new bottom up approach called Agglomerative Approach (AA) is proposed to construct balanced bushy trees with respect to execution time. By the deterministic nature of this approach, it generates local optimal solutions. This local minima problem will be severe in the case of graph queries, i.e., queries that are represented with a graph structure. A Simulated annealing Approach (SA) is employed to obtain a (near) optimal solution. These approaches (AA and SA) are suitable for handling on-line and off-line queries respectively. A Hybrid Approach (HA), that is an integration of AA and SA, is proposed to optimize queries for which the estimated time to be spent on optimization is known a priori. Results obtained with AA and SA on both tree and graph structured queries are presented.

Item Type:	Journal Article
Publication:	Distributed and Parallel Databases
Publisher:	Springer
Additional Information:	Copyright of this article belongs to Springer.
Keywords:	database;multidatabase;Query Optimization;Simulated Annealing;heuristics and combinatorial optimization.
Department/Centre:	Division of Electrical Sciences > Computer Science & Automation
Date Deposited:	24 Dec 2009 10:04
Last Modified:	02 May 2011 07:21
URI:	http://eprints.iisc.ac.in/id/eprint/19108

Actions (login required)

View Item