Tradeoffs in Processing Complex Join Queries via Hashing in Multiprocessor Database Machines.
Donovan A. Schneider, David J. DeWitt:
Tradeoffs in Processing Complex Join Queries via Hashing in Multiprocessor Database Machines.
VLDB 1990: 469-480@inproceedings{DBLP:conf/vldb/SchneiderD90,
author = {Donovan A. Schneider and
David J. DeWitt},
editor = {Dennis McLeod and
Ron Sacks-Davis and
Hans-J{\"o}rg Schek},
title = {Tradeoffs in Processing Complex Join Queries via Hashing in Multiprocessor
Database Machines},
booktitle = {16th International Conference on Very Large Data Bases, August
13-16, 1990, Brisbane, Queensland, Australia, Proceedings},
publisher = {Morgan Kaufmann},
year = {1990},
isbn = {1-55860-149-X},
pages = {469-480},
ee = {db/conf/vldb/SchneiderD90.html},
crossref = {DBLP:conf/vldb/90},
bibsource = {DBLP, http://dblp.uni-trier.de}
}
Abstract
In this paper we examine the problem of processing multi-way join queries (on the order of 10 joins) through hash-based join methods in a shared-nothing database machine.
We first discuss how the choice of a format for a complex query can significantly affect performance in a multiprocessor database machine.
Several query processing algorithms are then proposed and experimental resultsobtained from a simulation study are presented to demonstrate the tradeoffs ofleft-deep and right-deep scheduling strategies for complex join query evaluation.
These results demonstrate that right-deep scheduling strategies can provide significant performance advantages in large multiprocessor database machines under many circumstances, even when memory is limited.
Copyright © 1990 by the VLDB Endowment.
Permission to copy without fee all or part of this material is granted provided that the copies are not made or
distributed for direct commercial advantage, the VLDB
copyright notice and the title of the publication and
its date appear, and notice is given that copying
is by the permission of the Very Large Data Base
Endowment. To copy otherwise, or to republish, requires
a fee and/or special permission from the Endowment.
Online Paper
CDROM Version: Load the CDROM "Volume 1 Issue 5, VLDB '89-'97" and ...
DVD Version: Load ACM SIGMOD Anthology DVD 1" and ...
Printed Edition
Dennis McLeod, Ron Sacks-Davis, Hans-Jörg Schek (Eds.):
16th International Conference on Very Large Data Bases, August 13-16, 1990, Brisbane, Queensland, Australia, Proceedings.
Morgan Kaufmann 1990, ISBN 1-55860-149-X
References
- [BARU87]
- Chaitanya K. Baru, Ophir Frieder, Dilip D. Kandlur, Mark E. Segal:
Join on a Cube: Analysis, Simulation, and Implementation.
IWDM 1987: 61-74
- [BITT83]
- Dina Bitton, David J. DeWitt, Carolyn Turbyfill:
Benchmarking Database Systems A Systematic Approach.
VLDB 1983: 8-19
- [BRAT87]
- Kjell Bratbergsengen:
Algebra Operations on a Parallel Computer - Performance Evaluation.
IWDM 1987: 415-428
- [COPE88]
- George P. Copeland, William Alexander, Ellen E. Boughter, Tom W. Keller:
Data Placement In Bubba.
SIGMOD Conference 1988: 99-108
- [DEWI84]
- David J. DeWitt, Randy H. Katz, Frank Olken, Leonard D. Shapiro, Michael Stonebraker, David A. Wood:
Implementation Techniques for Main Memory Database Systems.
SIGMOD Conference 1984: 1-8
- [DEWI85]
- David J. DeWitt, Robert H. Gerber:
Multiprocessor Hash-Based Join Algorithms.
VLDB 1985: 151-164
- [DEWI86]
- David J. DeWitt, Robert H. Gerber, Goetz Graefe, Michael L. Heytens, Krishna B. Kumar, M. Muralikrishna:
GAMMA - A High Performance Dataflow Database Machine.
VLDB 1986: 228-237
- [DEWI88]
- David J. DeWitt, Shahram Ghandeharizadeh, Donovan A. Schneider:
A Performance Analysis of the Gamma Database Machine.
SIGMOD Conference 1988: 350-360
- [DEWI90]
- David J. DeWitt, Shahram Ghandeharizadeh, Donovan A. Schneider, Allan Bricker, Hui-I Hsiao, Rick Rasmussen:
The Gamma Database Machine Project.
IEEE Trans. Knowl. Data Eng. 2(1): 44-62(1990)
- [GERB86]
- ...
- [GERB87]
- ...
- [GERB90]
- ...
- [GHAN90]
- Shahram Ghandeharizadeh, David J. DeWitt:
A Multiuser Performance Analysis of Alternative Declustering Strategies.
ICDE 1990: 466-475
- [GRAE87]
- Goetz Graefe:
Rule-Based Query Optimization in Extensible Database Systems.
Ph.D. thesis, Univ. of Wisconsin-Madison 1987
- [GRAE89]
- Goetz Graefe, Karen Ward:
Dynamic Query Evaluation Plans.
SIGMOD Conference 1989: 358-366
- [GRAE90]
- Goetz Graefe:
Encapsulation of Parallelism in the Volcano Query Processing System.
SIGMOD Conference 1990: 102-111
- [HAAS89]
- Laura M. Haas, Johann Christoph Freytag, Guy M. Lohman, Hamid Pirahesh:
Extensible Query Processing in Starburst.
SIGMOD Conference 1989: 377-388
- [INTE88]
- ...
- [KITS88]
- Masaru Kitsuregawa, Miyuki Nakano, Mikio Takagi:
Query Execution for Large Relations on Functional Disk Systems.
ICDE 1989: 159-167
- [LIPT90a]
- Richard J. Lipton, Jeffrey F. Naughton:
Query Size Estimation by Adaptive Sampling.
PODS 1990: 40-46
- [LIPT90b]
- Richard J. Lipton, Jeffrey F. Naughton, Donovan A. Schneider:
Practical Selectivity Estimation through Adaptive Sampling.
SIGMOD Conference 1990: 1-11
- [LIVN88]
- ...
- [LU85]
- Hongjun Lu, Michael J. Carey:
Some Experimental Results on Distributed Join Algorithms in a Local Network.
VLDB 1985: 292-304
- [SCHN89a]
- Donovan A. Schneider, David J. DeWitt:
A Performance Evaluation of Four Parallel Join Algorithms in a Shared-Nothing Multiprocessor Environment.
SIGMOD Conference 1989: 110-121
- [SCHN89b]
- ...
- [SHAP86]
- Leonard D. Shapiro:
Join Processing in Database Systems with Large Main Memories.
ACM Trans. Database Syst. 11(3): 239-264(1986)
- [STON89]
- ...
Copyright © Fri Mar 12 17:22:50 2010
by Michael Ley (ley@uni-trier.de)