Encapsulation of Parallelism in the Volcano Query Processing System.
Goetz Graefe:
Encapsulation of Parallelism in the Volcano Query Processing System.
SIGMOD Conference 1990: 102-111@inproceedings{DBLP:conf/sigmod/Graefe90,
author = {Goetz Graefe},
editor = {Hector Garcia-Molina and
H. V. Jagadish},
title = {Encapsulation of Parallelism in the Volcano Query Processing
System},
booktitle = {Proceedings of the 1990 ACM SIGMOD International Conference on
Management of Data, Atlantic City, NJ, May 23-25, 1990},
publisher = {ACM Press},
year = {1990},
pages = {102-111},
ee = {http://doi.acm.org/10.1145/93597.98720, db/conf/sigmod/Graefe90.html},
crossref = {DBLP:conf/sigmod/90},
bibsource = {DBLP, http://dblp.uni-trier.de}
}
Abstract
Volcano is a new dataflow query processing system we have developed for database systems research and education. The uniform interface between operators makes Volcano extensible by new operators. All operators are designed and coded as
if they were meant for a single-process system only. When attempting to parallelize Volcano, we had to choose between two
models of parallelization, called here the bracket and operator models. We describe the reasons for not choosing the bracket
model, introduce the novel operator model, and provide details of Volcano's exchange operator that parallelizes all other
operators. It allows intra-operator parallelism on partitioned datasets and both vertical and horizontal inter-operator parallelism. The
exchange operator encapsulates all parallelism issues and therefore makes implementation of parallel database algorithms
significantly easier and more robust. Included in this encapsulation is the translation between demand-driven dataflow within
processes and data-driven dataflow between processes. Since the interface between Volcano operators is similar to the one
used in "real," commercial systems, the techniques described here can be used to parallelize other query processing engines.
Copyright © 1990 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.
Online Version (ACM WWW Account required): Full Text in PDF Format
CDROM Version: Load the CDROM "Volume 1 Issue 2, SIGMOD '75-'92" and ...
DVD Version: Load ACM SIGMOD Anthology DVD 1" and ...
Printed Edition
Hector Garcia-Molina, H. V. Jagadish (Eds.):
Proceedings of the 1990 ACM SIGMOD International Conference on Management of Data, Atlantic City, NJ, May 23-25, 1990.
ACM Press 1990
,
SIGMOD Record 19(2), June 1990
Contents
References
- [1]
- ...
- [2]
- William Alexander, George P. Copeland:
Process And Dataflow Control In Distributed Data-Intensive Systems.
SIGMOD Conference 1988: 90-98

- [3]
- Morton M. Astrahan, Mike W. Blasgen, Donald D. Chamberlin, Kapali P. Eswaran, Jim Gray, Patricia P. Griffiths, W. Frank King III, Raymond A. Lorie, Paul R. McJones, James W. Mehl, Gianfranco R. Putzolu, Irving L. Traiger, Bradford W. Wade, Vera Watson:
System R: Relational Approach to Database Management.
ACM Trans. Database Syst. 1(2): 97-137(1976)

- [4]
- Chaitanya K. Baru, Ophir Frieder, Dilip D. Kandlur, Mark E. Segal:
Join on a Cube: Analysis, Simulation, and Implementation.
IWDM 1987: 61-74

- [5]
- Don S. Batory:
GENESIS: A Project to Develop an Extensible Database Management System.
OODBS 1986: 207-208

- [6]
- Dina Bitton, David J. DeWitt, Carolyn Turbyfill:
Benchmarking Database Systems A Systematic Approach.
VLDB 1983: 8-19

- [7]
- 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)

- [8]
- Haran Boral, David J. DeWitt:
Database Machines: An Idea Whose Time Passed? A Critique of the Future of Database Machines.
IWDM 1983: 166-187

- [9]
- Haran Boral, David J. DeWitt:
A Methodology for Database System Performance Evaluation.
SIGMOD Conference 1984: 176-185

- [10]
- Michael J. Carey, David J. DeWitt, Joel E. Richardson, Eugene J. Shekita:
Object and File Management in the EXODUS Extensible Database System.
VLDB 1986: 91-100

- [11]
- Hong-Tai Chou, David J. DeWitt, Randy H. Katz, Anthony C. Klug:
Design and Implementation of the Wisconsin Storage System.
Softw., Pract. Exper. 15(10): 943-962(1985)

- [12]
- 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

- [13]
- 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)

- [14]
- Susanne Englert, Jim Gray, Terrye Kocher, Praful Shah:
A Benchmark of NonStop SQL Release 2 Demonstrating Near-Linear Speedup and Scaleup on Large Databases.
SIGMETRICS 1990: 245-246

- [15]
- ...
- [16]
- Goetz Graefe, David Maier:
Query Optimization in Object-Oriented Database Systems: A Prospectus.
OODBS 1988: 358-363

- [17]
- Goetz Graefe:
Volcano - An Extensible and Parallel Query Evaluation System.
IEEE Trans. Knowl. Data Eng. 6(1): 120-135(1994)

- [18]
- ...
- [19]
- Goetz Graefe:
Relational Division: Four Algorithms and Their Performance.
ICDE 1989: 94-101

- [20]
- Goetz Graefe, Karen Ward:
Dynamic Query Evaluation Plans.
SIGMOD Conference 1989: 358-366

- [21]
- ...
- [22]
- ...
- [23]
- ...
- [24]
- Joel E. Richardson, Michael J. Carey:
Programming Constructs for Database System Implementation in EXODUS.
SIGMOD Conference 1987: 208-219

- [25]
- Kenneth Salem, Hector Garcia-Molina:
Disk Striping.
ICDE 1986: 336-342

- [26]
- Peter M. Schwarz, Walter Chang, Johann Christoph Freytag, Guy M. Lohman, John McPherson, C. Mohan, Hamid Pirahesh:
Extensibility in the Starburst Database System.
OODBS 1986: 85-92

- [27]
- Michael Stonebraker, Eugene Wong, Peter Kreps, Gerald Held:
The Design and Implementation of INGRES.
ACM Trans. Database Syst. 1(3): 189-222(1976)

- [28]
- Michael Stonebraker, Lawrence A. Rowe:
The Design of Postgres.
SIGMOD Conference 1986: 340-355

- [29]
- Michael Stonebraker, Randy H. Katz, David A. Patterson, John K. Ousterhout:
The Design of XPRS.
VLDB 1988: 318-330

- [30]
- Shun'ichi Torii, Keiji Kojima, Yasusi Kanada, Akiharu Sakata, Seiichi Yoshizumi, Masami Takahashi:
Accelerating Nonnumerical Processing by an Extended Vector Processor.
ICDE 1988: 194-201

- [31]
- R. Williams, Dean Daniels, Laura M. Haas, George Lapis, Bruce G. Lindsay, Pui Ng, Ron Obermarck, Patricia G. Selinger, Adrian Walker, Paul F. Wilms, Robert A. Yost:
R*: An Overview of the Architecture.
JCDKB 1982: 1-27

Referenced by
- Ron Avnur, Joseph M. Hellerstein:
Eddies: Continuously Adaptive Query Processing.
SIGMOD Conference 2000: 261-272
- Roy Goldman, Jennifer Widom:
WSQ/DSQ: A Practical Approach for Combined Querying of Databases and the Web.
SIGMOD Conference 2000: 285-296
- Arunprasad P. Marathe, Kenneth Salem:
Query Processing Techniques for Arrays.
SIGMOD Conference 1999: 323-334
- Reinhard Braumandl, Alfons Kemper, Donald Kossmann:
Database Patchwork on the Internet.
SIGMOD Conference 1999: 550-552
- Uwe Röhm, Klemens Böhm:
Working Together in Harmony - An Implementation of the CORBA Object Query Service and Its Evaluation.
ICDE 1999: 238-247
- Michael Ortega, Yong Rui, Kaushik Chakrabarti, Kriengkrai Porkaew, Sharad Mehrotra, Thomas S. Huang:
Supporting Ranked Boolean Similarity Queries in MARS.
IEEE Trans. Knowl. Data Eng. 10(6): 905-925(1998)
- Jignesh M. Patel, Jie-Bing Yu, Navin Kabra, Kristin Tufte, Biswadeep Nag, Josef Burger, Nancy E. Hall, Karthikeyan Ramasamy, Roger Lueder, Curt J. Ellmann, Jim Kupsch, Shelly Guo, David J. DeWitt, Jeffrey F. Naughton:
Building a Scaleable Geo-Spatial DBMS: Technology, Implementation, and Evaluation.
SIGMOD Conference 1997: 336-347
- Hamid Pirahesh, T. Y. Cliff Leung, Waqar Hasan:
A Rule Engine for Query Transformation in Starburst and IBM DB2 C/S DBMS.
ICDE 1997: 391-400
- Silvio Salza, Massimiliano Renzetti:
A Modeling Tool for Workload Analysis and Performance Tuning of Parallel Database Applications.
ADBIS 1997: 152-161
- Michael A. Olson, Wei Hong, Michael Ubell, Michael Stonebraker:
Query Processing in a Parallel Object-Relational Database System.
IEEE Data Eng. Bull. 19(4): 3-10(1996)
- Sunita Sarawagi, Michael Stonebraker:
Reordering Query Execution in Tertiary Memory Databases.
VLDB 1996: 156-167
- Peter A. Boncz, Wilko Quak, Martin L. Kersten:
Monet And Its Geographic Extensions: A Novel Approach to High Performance GIS Processing.
EDBT 1996: 147-166
- Uwe Herzog, Ralf Schaarschmidt:
Parallel Execution of Integrity Constraint Checks.
CIKM 1995: 82-89
- Patrick Martin, Per-Åke Larson, Vinay Deshpande:
Parallel Hash-Based Join Algorithms for a Shared-Everything.
IEEE Trans. Knowl. Data Eng. 6(5): 750-763(1994)
- Eileen Tien Lin, Edward Omiecinski, Sudhakar Yalamanchili:
Large Join Optimization on a Hypercube Multiprocessor.
IEEE Trans. Knowl. Data Eng. 6(2): 304-315(1994)
- Goetz Graefe, Ann Linville, Leonard D. Shapiro:
Sort versus Hash Revisited.
IEEE Trans. Knowl. Data Eng. 6(6): 934-944(1994)
- Goetz Graefe:
Volcano - An Extensible and Parallel Query Evaluation System.
IEEE Trans. Knowl. Data Eng. 6(1): 120-135(1994)
- Mikal Ziane, Mohamed Zaït, Pascale Borla-Salamet:
Parallel Query Processing with Zigzag Trees.
VLDB J. 2(3): 277-301(1993)
- Goetz Graefe:
Query Evaluation Techniques for Large Databases.
ACM Comput. Surv. 25(2): 73-170(1993)
- Eugene J. Shekita, Honesty C. Young, Kian-Lee Tan:
Multi-Join Optimization for Symmetric Multiprocessors.
VLDB 1993: 479-492
- Erhard Rahm, Robert Marek:
Analysis of Dynamic Load Balancing Strategies for Parallel Shared Nothing Database Systems.
VLDB 1993: 182-193
- David Maier, Bennet Vance:
A Call to Order.
PODS 1993: 1-16
- Patrick Valduriez:
Parallel Database Systems: the case for shared-something.
ICDE 1993: 460-465
- Priti Mishra, Margaret H. Eich:
Join Processing in Relational Databases.
ACM Comput. Surv. 24(1): 63-113(1992)
- David J. DeWitt, Jim Gray:
Parallel Database Systems: The Future of High Performance Database Systems.
Commun. ACM 35(6): 85-98(1992)
- Wei Hong:
Exploiting Inter-Operation Parallelism in XPRS.
SIGMOD Conference 1992: 19-28
- Wayne Davison:
Parallel Index Building in Informix OnLine 6.0.
SIGMOD Conference 1992: 103
- Thomas Keller, Goetz Graefe, David Maier:
Efficient Assembly of Complex Objects.
SIGMOD Conference 1991: 148-157
- Donovan A. Schneider, David J. DeWitt:
Tradeoffs in Processing Complex Join Queries via Hashing in Multiprocessor Database Machines.
VLDB 1990: 469-480
Last update Fri May 25 08:38:32 2012
CET by the DBLP Team —
Data released under the ODC-BY 1.0 license — See also our legal information page