Evaluation Results of Multi-Way Joins in Shared-Nothing Database Environment : The Case for Left-Deep and Right-Deep Execution Query Trees

スポンサーリンク

概要

• 論文の詳細を見る

• In this paper we introduce a performance modeling of multi-way joins represented in the left and right-deep tree structures, in a shared-nothing environment. The structure of the query execution tree and the balance of the utilization of the system resources are important factors in the efficient parallel processing of multi-way joins. In the following we present our analytical model to determine their elapsed time, showing the effects of resource utilization(amount of main memory, disk and interconnection network bandwidth),and identifying resources bottlenecks that limit their performance.

• 一般社団法人情報処理学会の論文
• 1992-09-28

著者

• Harada Lilian

  Fujitsu Laboratories

• Akaboshi Naoki

  Fujitsu Laboratories

関連論文

• On Parallel Hash-Join Processing with Skewed Data
• An Efficient Query Execution Plan for Multi-Way Joins in Shared-Nothing Database Environment
• Evaluation Results of Multi-Way Joins in Shared-Nothing Database Environment : The Case for Left-Deep and Right-Deep Execution Query Trees

スポンサーリンク