Please use this identifier to cite or link to this item:
|Title:||Processing multi-join query in parallel systems|
|Authors:||Tan, Kian-Lee |
|Citation:||Tan, Kian-Lee,Lu, Hongjun (1992). Processing multi-join query in parallel systems. Applied Computing: Technological Challenges of the 1990's : 283-292. ScholarBank@NUS Repository.|
|Abstract:||In parallel systems, a number of joins from one or more queries can be executed either serially or in parallel. While serial execution assigns all processors to execute each join one after another, the parallel execution distributes the joins to clusters formed by certain number of processors and executes them concurrently. Both approaches employ parallelism to improve system performance. However, data skew may result in load imbalance among processors executing the same join and some clusters may be overloaded with time-consuming joins. As a result, the completion time will be much longer than what is expected. In this paper, we propose an algorithm to further minimize the completion time of concurrently executed multiple joins. For this algorithm, all the joins to be executed concurrently are decomposed into a set of tasks that are ordered according to decreasing task size. These tasks are dynamically allocated to available processors during execution. Our performance study shows that the proposed algorithm outperforms the previously proposed approaches, especially when number of processors increases, high skewness is present in the relations to be joined and relation sizes are large.|
|Source Title:||Applied Computing: Technological Challenges of the 1990's|
|Appears in Collections:||Staff Publications|
Show full item record
Files in This Item:
There are no files associated with this item.
checked on Dec 7, 2018
Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.