Electrical Engineering
      and Computer Sciences

Electrical Engineering and Computer Sciences

COLLEGE OF ENGINEERING

UC Berkeley

Decoupled Query Optimization for Federated Database Systems

Amol V. Deshpande and Joseph M. Hellerstein

EECS Department
University of California, Berkeley
Technical Report No. UCB/CSD-01-1140
April 2001

http://www.eecs.berkeley.edu/Pubs/TechRpts/2001/CSD-01-1140.pdf

We study the problem of query optimization in federated database systems. The nature of federated databases explicitly decouples many aspects of the optimization process, often making it imperative for the optimizer to consult underlying data sources while doing cost-based optimization. This not only increases the cost of optimization, but also changes the trade-offs involved in the optimization process significantly. The dominant cost in the decoupled optimization process is the "cost of costing" that traditionally has been considered insignificant. The optimizer can only afford a few rounds of messages to the underlying data sources and hence the optimization techniques in this environment must be geared toward gathering all the required cost information with minimal communication.

In this paper, we explore the design space for a query optimizer in this environment and demonstrate the need for decoupling various aspects of the optimization process. We present minimum-communication decoupled variants of various query optimization techniques, and discuss trade-offs in their performance in this scenario. We have implemented these techniques in the Cohera federated database system and our experimental results, somewhat surprisingly, indicate that a simple two-phase optimization scheme performs fairly well as long as the physical database design is known to the optimizer, though more aggressive algorithms are required otherwise.


BibTeX citation:

@techreport{Deshpande:CSD-01-1140,
    Author = {Deshpande, Amol V. and Hellerstein, Joseph M.},
    Title = {Decoupled Query Optimization for Federated Database Systems},
    Institution = {EECS Department, University of California, Berkeley},
    Year = {2001},
    Month = {Apr},
    URL = {http://www.eecs.berkeley.edu/Pubs/TechRpts/2001/5664.html},
    Number = {UCB/CSD-01-1140},
    Abstract = {We study the problem of query optimization in federated database systems. The nature of federated databases explicitly decouples many aspects of the optimization process, often making it imperative for the optimizer to consult underlying data sources while doing cost-based optimization. This not only increases the cost of optimization, but also changes the trade-offs involved in the optimization process significantly. The dominant cost in the decoupled optimization process is the "cost of costing" that traditionally has been considered insignificant. The optimizer can only afford a few rounds of messages to the underlying data sources and hence the optimization techniques in this environment must be geared toward gathering all the required cost information with minimal communication. <p>In this paper, we explore the design space for a query optimizer in this environment and demonstrate the need for decoupling various aspects of the optimization process. We present minimum-communication decoupled variants of various query optimization techniques, and discuss trade-offs in their performance in this scenario. We have implemented these techniques in the Cohera federated database system and our experimental results, somewhat surprisingly, indicate that a simple two-phase optimization scheme performs fairly well as long as the physical database design is known to the optimizer, though more aggressive algorithms are required otherwise.}
}

EndNote citation:

%0 Report
%A Deshpande, Amol V.
%A Hellerstein, Joseph M.
%T Decoupled Query Optimization for Federated Database Systems
%I EECS Department, University of California, Berkeley
%D 2001
%@ UCB/CSD-01-1140
%U http://www.eecs.berkeley.edu/Pubs/TechRpts/2001/5664.html
%F Deshpande:CSD-01-1140