Comparison of parallel algorithms for path expression query in object database systems

Proposes a new parallel algorithm for computing path expressions, named the "parallel cascade semi-join" (PCSJ) algorithm. Moreover, a new scheduling strategy called the "right-deep zigzag tree" is designed to further improve the performance of the PCSJ algorithm. The experiments have been implemented in a distributed and parallel NOW (network of workstations) environment. The results show that the PCSJ algorithm outperforms two other parallel algorithms [the parallel forward pointer chasing (PFPC) algorithm and the index-splitting parallel algorithm (IndexSplit)] when computing path expressions with restrictive predicates, and that the right-deep zigzag tree scheduling strategy has a better performance than the right-deep tree scheduling strategy.

[1]  David J. DeWitt,et al.  Tradeoffs in Processing Complex Join Queries via Hashing in Multiprocessor Database Machines , 1990, VLDB.

[2]  S.Y.W. Su,et al.  Algorithms for Asynchronous Parallel Processing of Object-Oriented Databases , 1995, IEEE Trans. Knowl. Data Eng..

[3]  Patrick Valduriez,et al.  On the Effectiveness of Optimization Search Strategies for Parallel Execution Spaces , 1993, VLDB.

[4]  Donovan A. Schneider,et al.  The Gamma Database Machine Project , 1990, IEEE Trans. Knowl. Data Eng..

[5]  David J. DeWitt,et al.  Parallel pointer-based join techniques for object-oriented databases , 1993, [1993] Proceedings of the Second International Conference on Parallel and Distributed Information Systems.

[6]  Masaru Kitsuregawa,et al.  Parallel GRACE hash join on shared-everything multiprocessor: implementation and performance evaluation on symmetry S81 , 1992, [1992] Eighth International Conference on Data Engineering.

[7]  Kyung-Chang Kim Parallelism in object-oriented query processing , 1990, [1990] Proceedings. Sixth International Conference on Data Engineering.

[8]  Philip S. Yu,et al.  Using Segmented Right-Deep Trees for the Execution of Pipelined Hash Joins , 1992, VLDB.

[9]  Peter M. G. Apers,et al.  Parallel evaluation of multi-join queries , 1995, SIGMOD '95.