Thats a unique idea.You should consider the following idea to enhance your idea so that it would impact uniquely: Dynamic load balancing issues in multiway join operations is discussed. In particular, four multiway join query optimizers have been implemented and a simulator developed to investigate the effect of sked tuple distribution on these techniques. Dynamic load balancing is found to very critical to the performance of shared-nothing (SN) systems, particularly when the system is large. Since load balancing becomes more difficult for larger systems, one should exploit interjoin parallelism in order to limit the number of processing nodes used for each join operation. The skew issue must be considered during query optimization to achieve the best performance. The load balancing techniques proposed can easily be extended to support interquery parallelism in a multiuser environment. >
['Kien A. Hua', 'Yu-lung Lo', 'Honesty C. Young']
I am writing a research paper on a idea Including the load balancing issue in the optimization of multi-way join queries for shared-nothing database computers
[{"from": "human", "value": "I am writing a research paper on a idea Including the load balancing issue in the optimization of multi-way join queries for shared-nothing database computers"}, {"from": "gpt", "value": "Thats a unique idea.You should consider the following idea to enhance your idea so that it would impact uniquely: Dynamic load balancing issues in multiway join operations is discussed. In particular, four multiway join query optimizers have been implemented and a simulator developed to investigate the effect of sked tuple distribution on these techniques. Dynamic load balancing is found to very critical to the performance of shared-nothing (SN) systems, particularly when the system is large. Since load balancing becomes more difficult for larger systems, one should exploit interjoin parallelism in order to limit the number of processing nodes used for each join operation. The skew issue must be considered during query optimization to achieve the best performance. The load balancing techniques proposed can easily be extended to support interquery parallelism in a multiuser environment. >"}]