Analysis of Dynamic Load Balancing Strategies for Parallel Shared Nothing Database Systems.
Erhard Rahm, Robert Marek:
Analysis of Dynamic Load Balancing Strategies for Parallel Shared Nothing Database Systems.
VLDB 1993: 182-193@inproceedings{DBLP:conf/vldb/RahmM93,
author = {Erhard Rahm and
Robert Marek},
editor = {Rakesh Agrawal and
Se{\'a}n Baker and
David A. Bell},
title = {Analysis of Dynamic Load Balancing Strategies for Parallel Shared
Nothing Database Systems},
booktitle = {19th International Conference on Very Large Data Bases, August
24-27, 1993, Dublin, Ireland, Proceedings},
publisher = {Morgan Kaufmann},
year = {1993},
isbn = {1-55860-152-X},
pages = {182-193},
ee = {db/conf/vldb/RahmM93.html},
crossref = {DBLP:conf/vldb/93},
bibsource = {DBLP, http://dblp.uni-trier.de}
}
Abstract
Parallel database systems have to support both inter-transaction as well as intra-transaction parallelism.
Inter-transaction parallelism (multi-user mode) is required to achieve high throughput, in particular for OLTP transactions, and sufficient cost-effectiveness. Intra-transaction parallelism is a prerequisite for reducing the response time of complex and data-intensive transactions (queries).
In order to achieve both goals dynamic strategies for load balancing and scheduling are necessary which take the current system state into account for allocating transactions and subqueries to processors and for determining the degree ofintra-transaction parallelism.
We study the load balancing problem for parallel join processing in Shared Nothing database systems.
In these systems, join processing is typically based on a dynamic redistribution of relations to join processors thus making dynamic load balancing strategiesfeasible. In particular, we study the performance of dynamic load balancing strategies for determining the number of join processors and for selection of the join processors.
In contrast to previous studies on parallel join processing, we present a multi-user performance analysis for both homogeneous and heterogeneous/mixed workloads as well as for different database allocations.
Copyright © 1993 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
Rakesh Agrawal, Seán Baker, David A. Bell (Eds.):
19th International Conference on Very Large Data Bases, August 24-27, 1993, Dublin, Ireland, Proceedings.
Morgan Kaufmann 1993, ISBN 1-55860-152-X
Contents
References
- [1]
- Paul M. Bober, Michael J. Carey:
On Mixing Queries and Transactions via Multiversion Locking.
ICDE 1992: 535-545
- [2]
- ...
- [3]
- George P. Copeland, William Alexander, Ellen E. Boughter, Tom W. Keller:
Data Placement In Bubba.
SIGMOD Conference 1988: 99-108
- [4]
- Thomas L. Casavant, Jon G. Kuhl:
A Taxonomy of Scheduling in General-Purpose Distributed Computing Systems.
IEEE Trans. Software Eng. 14(2): 141-154(1988)
- [5]
- Ming-Syan Chen, Philip S. Yu, Kun-Lung Wu:
Scheduling and Processor Allocation for Parallel Execution of Multi-Join Queries.
ICDE 1992: 58-67
- [6]
- David J. DeWitt, Jim Gray:
Parallel Database Systems: The Future of High Performance Database Systems.
Commun. ACM 35(6): 85-98(1992)
- [7]
- David J. DeWitt, Jeffrey F. Naughton, Donovan A. Schneider, S. Seshadri:
Practical Skew Handling in Parallel Joins.
VLDB 1992: 27-40
- [8]
- ...
- [9]
- Shahram Ghandeharizadeh, David J. DeWitt:
A Multiuser Performance Analysis of Alternative Declustering Strategies.
ICDE 1990: 466-475
- [10]
- ...
- [11]
- Goetz Graefe:
Encapsulation of Parallelism in the Volcano Query Processing System.
SIGMOD Conference 1990: 102-111
- [12]
- Jim Gray (Ed.):
The Benchmark Handbook for Database and Transaction Systems (1st Edition).
Morgan Kaufmann 1991
Contents - [13]
- Wei Hong:
Exploiting Inter-Operation Parallelism in XPRS.
SIGMOD Conference 1992: 19-28
- [14]
- Wei Hong, Michael Stonebraker:
Optimization of Parallel Query Execution Plans in XPRS.
PDIS 1991: 218-225
- [15]
- Yasuhiro Hirano, Tetsuji Satoh, Ushio Inoue, K. Teranaka:
Load Balancing Algorithms for Parallel Database Processing on Shared Memory Multiprocessors.
PDIS 1991: 210-217
- [16]
- Rajiv Jauhari, Michael J. Carey, Miron Livny:
Priority-Hints: An Algorithm for Priority-Based Buffer Management.
VLDB 1990: 708-721
- [17]
- ...
- [18]
- Hongjun Lu, Kian-Lee Tan:
Dynamic and Load-balanced Task-Oriented Datbase Query Processing in Parallel Systems.
EDBT 1992: 357-372
- [19]
- ...
- [20]
- C. Mohan, Bruce G. Lindsay, Ron Obermarck:
Transaction Management in the R* Distributed Database Management System.
ACM Trans. Database Syst. 11(4): 378-396(1986)
- [21]
- C. Mohan, Hamid Pirahesh, Raymond A. Lorie:
Efficient and Flexible Methods for Transient Versioning of Records to Avoid Locking by Read-Only Transactions.
SIGMOD Conference 1992: 124-133
- [22]
- Marguerite C. Murphy, Ming-Chien Shan:
Execution Plan Balancing.
ICDE 1991: 698-706
- [23]
- Hamid Pirahesh, C. Mohan, Josephine M. Cheng, T. S. Liu, Patricia G. Selinger:
Parallelism in Relational Data Base Systems: Architectural Issues and Design Approaches.
DPDS 1990: 4-29
- [24]
- ...
- [25]
- Erhard Rahm:
Parallel Query Processing in Shared Disk Database Systems.
HPTS 1993: 0-
- [26]
- 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
- [27]
- Donovan A. Schneider, David J. DeWitt:
Tradeoffs in Processing Complex Join Queries via Hashing in Multiprocessor Database Machines.
VLDB 1990: 469-480
- [28]
- ...
- [29]
- Niranjan G. Shivaratri, Phillip Krueger, Mukesh Singhal:
Load Distributing for Locally Distributed Systems.
IEEE Computer 25(12): 33-44(1992)
- [30]
- Christopher B. Walton, Alfred G. Dale, Roy M. Jenevein:
A Taxonomy and Performance Model of Data Skew Effects in Parallel Joins.
VLDB 1991: 537-548
- [31]
- Joel L. Wolf, Daniel M. Dias, Philip S. Yu, John Turek:
An Effective Algorithm for Parallelizing Hash Joins in the Presence of Data Skew.
ICDE 1991: 200-209
- [32]
- Annita N. Wilschut, Jan Flokstra, Peter M. G. Apers:
Parallelism in a Main-Memory DBMS: The Performance of PRISMA/DB.
VLDB 1992: 521-532
- [33]
- Philip S. Yu, Douglas W. Cornell, Daniel M. Dias, Balakrishna R. Iyer:
Analysis of Affinity Based Routing in Multi-System Data Sharing.
Perform. Eval. 7(2): 87-109(1987)
- [34]
- Songnian Zhou:
A Trace-Driven Simulation Study of Dynamic Load Balancing.
IEEE Trans. Software Eng. 14(9): 1327-1341(1988)
Copyright © Tue Mar 16 02:22:03 2010
by Michael Ley (ley@uni-trier.de)