A Modeling Tool for Workload Analysis and Performance Tuning of Parallel Database Applications.
Silvio Salza, Massimiliano Renzetti:
A Modeling Tool for Workload Analysis and Performance Tuning of Parallel Database Applications.
ADBIS 1997: 152-161@inproceedings{DBLP:conf/adbis/SalzaR97,
author = {Silvio Salza and
Massimiliano Renzetti},
title = {A Modeling Tool for Workload Analysis and Performance Tuning
of Parallel Database Applications},
booktitle = {Proceedings of the First East-European Symposium on Advances
in Databases and Information Systems (ADBIS'97), St.-Petersburg,
September 2-5, 1997. Volume 1: Regular Papers},
publisher = {Nevsky Dialect},
year = {1997},
pages = {152-161},
ee = {db/conf/adbis/SalzaR97.html},
crossref = {DBLP:conf/adbis/97},
bibsource = {DBLP, http://dblp.uni-trier.de}
}
Abstract
After about two decades of evolution parallel database architectures have
finally reached a maturity level that makes them a serious competitor to
traditional mainframe based architectures and distributed database systems.
Dealing with these innovative systems requires to change considerably the
application design process, mostly because of the sophisticated physical data
organization (e.g. relation declustering), and, in general because of the
more complex execution model. In this paper we present a methodology,
and a connected modeling tool for the performance analysis of parallel database
applications. The methodology is based on the results of previous work we
have performed on this subject for traditional sequential DBMS,
and is devised for a strict integration into the design procedure.
The modeling approach allows both to provide the designer with an early
feedback on the performance of the application, and a to produce a detailed
account of the execution cost, that helps focusing the problem and gives
a guide for the design improvement.
Copyright © 1997 by the ACM,
Inc., used by permission. Permission to make
digital or hard copies is granted provided that
copies are not made or distributed for profit or
direct commercial advantage, and that copies show
this notice on the first page or initial screen of
a display along with the full citation.
CDROM Version: Load the CDROM "Volume 2 Issue 5, SSDBM, DBPL, KRDB, ADBIS, COOPIS, SIGBDP" and ...
DVD Version: Load ACM SIGMOD Anthology DVD 1" and ...
References
- [1]
- Tilak Agerwala, Joanne L. Martin, Jamshed H. Mirza, David C. Sadler, Daniel M. Dias, Marc Snir:
SP2 System Architecture.
IBM Systems Journal 34(2): 152-184(1995)
- [2]
- Chaitanya K. Baru, Gilles Fecteau, Ambuj Goyal, Hui-I Hsiao, Anant Jhingran, Sriram Padmanabhan, George P. Copeland, Walter G. Wilson:
DB2 Parallel Edition.
IBM Systems Journal 34(2): 292-322(1995)
- [3]
- Dina Bitton, Haran Boral, David J. DeWitt, W. Kevin Wilkinson:
Parallel Algorithms for the Execution of Relational Database Operations.
ACM Trans. Database Syst. 8(3): 324-353(1983)
- [4]
- Mikal Ziane, Mohamed Zaït, Pascale Borla-Salamet:
Parallel Query Processing in DBS3.
PDIS 1993: 93-102
- [5]
- ...
- [6]
- ...
- [7]
- Ming-Ling Lo, Ming-Syan Chen, Chinya V. Ravishankar, Philip S. Yu:
On Optimal Processor Allocation to Support Pipelined Hash Joins.
SIGMOD Conference 1993: 69-78
- [8]
- Hui-I Hsiao, Ming-Syan Chen, Philip S. Yu:
On Parallel Execution of Multiple Pipelined Hash Joins.
SIGMOD Conference 1994: 185-196
- [9]
- Hong-Tai Chou, David J. DeWitt:
An Evaluation of Buffer Management Strategies for Relational Database Systems.
VLDB 1985: 127-141
- [10]
- Goetz Graefe:
Encapsulation of Parallelism in the Volcano Query Processing System.
SIGMOD Conference 1990: 102-111
- [11]
- Goetz Graefe:
Query Evaluation Techniques for Large Databases.
ACM Comput. Surv. 25(2): 73-170(1993)
- [12]
- Wei Hong, Michael Stonebraker:
Optimization of Parallel Query Execution Plans in XPRS.
Distributed and Parallel Databases 1(1): 9-32(1993)
- [13]
- Michael Stonebraker, Randy H. Katz, David A. Patterson, John K. Ousterhout:
The Design of XPRS.
VLDB 1988: 318-330
- [14]
- M. Seetha Lakshmi, Philip S. Yu:
Effectiveness of Parallel Joins.
IEEE Trans. Knowl. Data Eng. 2(4): 410-424(1990)
- [15]
- Rosana S. G. Lanzelotte, Patrick Valduriez, Mohamed Zaït:
On the Effectiveness of Optimization Search Strategies for Parallel Execution Spaces.
VLDB 1993: 493-504
- [16]
- Kian-Lee Tan, Hongjun Lu:
On Resource Scheduling of Multi-Join Queries in Parallel Database Systems.
Inf. Process. Lett. 48(4): 189-195(1993)
- [17]
- Lothar F. Mackert, Guy M. Lohman:
Index Scans Using a Finite LRU Buffer: A Validated I/O Model.
ACM Trans. Database Syst. 14(3): 401-424(1989)
- [18]
- Giovanni Maria Sacco, Mario Schkolnick:
Buffer Management in Relational Database Systems.
ACM Trans. Database Syst. 11(4): 473-498(1986)
- [19]
- Silvio Salza, Mario Terranova:
Evaluating the Size of Queries on Relational Databases with non Uniform Distribution and Stochastic Dependence.
SIGMOD Conference 1989: 8-14
- [20]
- ...
- [21]
- Michael Stonebraker:
The Case for Shared Nothing.
IEEE Database Eng. Bull. 9(1): 4-9(1986)
- [22]
- Patrick Valduriez:
Parallel Database Systems: the case for shared-something.
ICDE 1993: 460-465
Last update Mon May 21 02:19:55 2012
CET by the DBLP Team — 
Data released under the ODC-BY 1.0 license — See also our legal information page
