Adaptive Algorithms for Join Processing in Distributed Database Systems |
| |
Authors: | Peter Scheuermann Eugene Inseok Chong |
| |
Affiliation: | 1. Department of Electrical and Computer Engineering, Northwestern University, Evanston, IL, 60208 2. New England R&D Center, Oracle Corporation, 1 Oracle Drive, Nashua, NH, 03062
|
| |
Abstract: | Distributed query processing algorithms usually perform data reduction by using a semijoin program, but the problem with these approaches is that they still require an explicit join of the reduced relations in the final phase. We introduce an efficient algorithm for join processing in distributed database systems that makes use of bipartite graphs in order to reduce data communication costs and local processing costs. The bipartite graphs represent the tuples that can be joined in two relations taking also into account the reduction state of the relations. This algorithm fully reduces the relations at each site. We then present an adaptive algorithm for response time optimization that takes into account the system configuration, i.e., the additional resources available and the data characteristics, in order to select the best strategy for response time minimization. We also report on the results of a set of experiments which show that our algorithms outperform a number of the recently proposed methods for total processing time and response time minimization. |
| |
Keywords: | |
本文献已被 SpringerLink 等数据库收录! |
|