Parallel query processing with zigzag trees

Authors:
Mikal Ziane;Mohamed Zaït;Pascale Borla-Salamet
Affiliations:
Université Paris 5, Paris, France and Institut National de Recherche en Informatique et en Automatique (INRIA), Rocquencourt, France;Projet Rodin, INRIA;Bull Research Center, Les Clayes sous Bois, France
Venue:
The VLDB Journal — The International Journal on Very Large Data Bases - Parallelism in database systems
Year:
1993

Citing 24
Cited 5

A performance evaluation of four parallel join algorithms in a shared-nothing multiprocessor environment

SIGMOD '89 Proceedings of the 1989 ACM SIGMOD international conference on Management of data
Dynamic query evaluation plans

SIGMOD '89 Proceedings of the 1989 ACM SIGMOD international conference on Management of data
Optimization of large join queries: combining heuristics and combinatorial techniques

SIGMOD '89 Proceedings of the 1989 ACM SIGMOD international conference on Management of data
Tradeoffs in processing complex join queries via hashing in multiprocessor database machines

Proceedings of the sixteenth international conference on Very large databases
Encapsulation of parallelism in the Volcano query processing system

SIGMOD '90 Proceedings of the 1990 ACM SIGMOD international conference on Management of data
Left-deep vs. bushy trees: an analysis of strategy spaces and its implications for query optimization

SIGMOD '91 Proceedings of the 1991 ACM SIGMOD international conference on Management of data
Parallel database systems: the future of database processing or a passing fad?

ACM SIGMOD Record - Directions for future database research & development
Query optimization for parallel execution

SIGMOD '92 Proceedings of the 1992 ACM SIGMOD international conference on Management of data
Exploiting inter-operation parallelism in XPRS

SIGMOD '92 Proceedings of the 1992 ACM SIGMOD international conference on Management of data
Optimization of object-oriented recursive queries using cost-controlled strategies

SIGMOD '92 Proceedings of the 1992 ACM SIGMOD international conference on Management of data
Join and Semijoin Algorithms for a Multiprocessor Database Machine

ACM Transactions on Database Systems (TODS)
Parallel query processing in DBS3

PDIS '93 Proceedings of the second international conference on Parallel and distributed information systems
Dataflow query execution in a parallel main-memory environment

PDIS '91 Proceedings of the first international conference on Parallel and distributed information systems
Optimization of parallel query execution plans in XPRS

PDIS '91 Proceedings of the first international conference on Parallel and distributed information systems
Prototyping DBS3, a shared-memory parallel database system

PDIS '91 Proceedings of the first international conference on Parallel and distributed information systems
Compiling control into database queries for parallel execution management

PDIS '91 Proceedings of the first international conference on Parallel and distributed information systems
Access path selection in a relational database management system

SIGMOD '79 Proceedings of the 1979 ACM SIGMOD international conference on Management of data
Prototyping Bubba, A Highly Parallel Database System

IEEE Transactions on Knowledge and Data Engineering
Scheduling and Processor Allocation for Parallel Execution of Multi-Join Queries

Proceedings of the Eighth International Conference on Data Engineering
ESQL2: An Object-Oriented SQL with F-Logic Semantics

Proceedings of the Eighth International Conference on Data Engineering
The Design of XPRS

VLDB '88 Proceedings of the 14th International Conference on Very Large Data Bases
Extending the Search Strategy in a Query Optimizer

VLDB '91 Proceedings of the 17th International Conference on Very Large Data Bases
Using Segmented Right-Deep Trees for the Execution of Pipelined Hash Joins

VLDB '92 Proceedings of the 18th International Conference on Very Large Data Bases
Benchmarking Database Systems A Systematic Approach

VLDB '83 Proceedings of the 9th International Conference on Very Large Data Bases

Performance evaluation of a parallel cascade semijoin algorithm for computing path expressions in object database systems

Journal of Computer Science and Technology
Benchmarking the DBS3 Parallel Query Optimizer

IEEE Parallel & Distributed Technology: Systems & Technology
Parallel Optimization of Large Join Queries with Set Operators and Aggregates in a Parallel Environment Supporting Pipeline

IEEE Transactions on Knowledge and Data Engineering
TOPAZ: a Cost-Based, Rule-Driven, Multi-Phase Parallelizer

VLDB '98 Proceedings of the 24rd International Conference on Very Large Data Bases
Revisiting pipelined parallelism in multi-join query processing

VLDB '05 Proceedings of the 31st international conference on Very large data bases

Quantified Score

Hi-index	0.00

Visualization

Abstract

In this article, we describe our approach to the compile-time optimization and parallelization of queries for execution in DBS3 or EDS. DBS3 is a shared-memory parallel database system, while the EDS system has a distributed-memory architecture. Because DBS3 implements a parallel dataflow execution model, this approach applies to both architectures. Using randomized search strategies enables the exploration of a search space large enough to include zigzag trees, which are intermediate between left-deep and right-deep trees. Zigzag trees are shown to provide better response time than right-deep trees in case of limited memory. Performance measurements obtained using the DBS3 prototype show the advantages of zigzag trees under various conditions.