Optimizing chain queries in a distributed database system
Author(s)
Author(s)
Bernstein, P. A.
Ho, Y.-C.
Date Issued
1984
Publisher
Society for Industrial and Applied Mathematics
Journal
SIAM Journal on Computing
Volume
13
Issue
1
Start page
116
End page
134
Abstract
This paper studies the problem of query optimization in a distributed database. Assuming a linear additive cost function (in volume of data moved), we present a fast algorithm for finding the optimal program that answers a class of common queries, called chain queries. The key to the problem formulation and to the derivation of an efficient algorithm is an elegant parameterization of the database state against which the query is to be answered. This parameterization then enables us to characterize the set of potentially optimal programs, which in turn leads to a fast dynamic programming algorithm. Since in practice the needed parameters may not be available to the database system, we also discuss how to deal with partial parameterizations of the database state.
SFU Affiliated Publication
No
Availability at SFU Library
No database links found.