Adaptive Algorithms for Join Processing in Distributed Database Systems

Peter Scheuermann*, Eugene Inseok Chong

*Corresponding author for this work

Research output: Contribution to journalArticlepeer-review

3 Scopus citations

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.

Original languageEnglish (US)
Pages (from-to)233-269
Number of pages37
JournalDistributed and Parallel Databases
Volume5
Issue number3
DOIs
StatePublished - 1997

Funding

⁄The work of this author was partially supported by NSF grant IRI-9303583 and NASA-Ames grant NAG2-846. †The work of this author was performed while he was with Northwestern University.

Keywords

  • Adaptive algorithms
  • Bipartite graphs
  • Distributed query processing
  • Join algorithms

ASJC Scopus subject areas

  • Software
  • Information Systems
  • Hardware and Architecture
  • Information Systems and Management

Fingerprint

Dive into the research topics of 'Adaptive Algorithms for Join Processing in Distributed Database Systems'. Together they form a unique fingerprint.

Cite this