Abstract
In this paper a methodology for representing and evaluating the execution of relational queries by a multiprocessor data base machine (DBM) is presented. The starting points are the parallel algorithms implementing the relational operators in the DBM in question and the query to be executed. A structure, called query execution graph, is obtained by the analysis of this information. A query execution graph is the detailed description of the operations the DBM must carry out in order to execute the query. A procedure for computing the execution cost of the query is given. This procedure operates on the query execution graph and also takes into account the strategy used to allocate processors to the subqueries which can be executed in parallel.
This is a preview of subscription content, log in via an institution to check access.
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
D. Bitton, H. Boral, D.J. DeWitt and W.K. Wilkinson: Parallel Algorithms for the Execution of Relational Database Operations, ACM TODS, Vol. 8, n.3, Sept. 1983.
H. Boral, D.J. DeWitt: Processor Allocation Strategies for Multiprocessor Data Base Machine, ACM TODS, Vol. 6, n.2, June 1981.
F. Cesarini, D. De Luca and G. Soda: An Assessment of the Query-Processing Capability of DBMAC, in "Advanced Database Machine Architecture", D.K. Hsiao Ed., Prentice-Hall, 1983.
D.J. DeWitt, P.B. Hawthorn: A Performance Evaluation of Data Base Machine Architectures, Proc. 7th Int. Conf. on VLDB, Cannes, 1981.
E.A. Ozkarahan, S.A. Schuster and K.C. Sevick: Performance Evaluation of a Relational Associative Processor, ACM TODS, Vol.2, n.2, June 1977.
R.K. Shultz, R.J. Zingg: Response Time Analysis of Multiprocessor Computers for Database Support, ACM TODS, Vol. 9, n.1, March 1984.
G. Schiffner, P. Scheuermann, S. Seehusen, H. Weber: On a Specification and Performance Evaluation Model for Multicomputer Database Machines, Proc. of 3rd Int. Workshop on Database Machines, Munich, Sept. 1983.
S. Salza, M. Terranova and P. Velardi: Performance Modeling of the DBMAC Architecture, Proc. of 3rd Int. Workshop on Database Machines, Munich, Sept. 1983 (also reprinted in this volume as chapter 7).
J.D. Ullman: Principles of Database Systems, Computer Science Press, Maryland, 1980.
P. Valduriez, G. Gardarin: Join and Semijoin Algorithms for a Multiprocessor Database Machine, ACM TODS, vol. 9, n.1, March 1984.
Editor information
Rights and permissions
Copyright information
© 1987 Springer-Verlag Berlin Heidelberg
About this chapter
Cite this chapter
Cesarini, F., Pippolini, F., Soda, G. (1987). Chapter 9 A technique for analyzing query execution in a multiprocessor database machine. In: Cesarini, F., Salza, S. (eds) Database Machine Performance: Modeling Methodologies and Evaluation Strategies. Lecture Notes in Computer Science, vol 257. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-17942-9_19
Download citation
DOI: https://doi.org/10.1007/3-540-17942-9_19
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-17942-9
Online ISBN: 978-3-540-47140-0
eBook Packages: Springer Book Archive