Title :
Study of query of distributed database based on relation semi join
Author :
Li, Xiaofeng ; Li, Dong ; Gao, Hong Zhi ; Yao, Lu
Author_Institution :
Dept. of Comput. Appl. Technol., Harbin Inst. of Technol., Harbin, China
Abstract :
Query processing and optimization of distributed database are the key factors to affect the performance,service efficiency and reliability of system. On the basis of the study of some common optimization algorithm of distributed query, query optimization algorithm based on multi-relation semi join is put forward to apply to this situation that takes buffer zone of distributed database system as the final assembly station of intermediate result of query. The experiment proves that query optimization algorithm based on multi-relation semi join obviously reduces the data volume of intermediate result and effectively decreases the overall cost of network communications. Comparing with common multi-relation semi join algorithm, the optimization benefit of the algorithm in this article is higher.
Keywords :
distributed databases; query processing; distributed database system; distributed query processing; multirelation semi join algorithm; network communication; query optimization algorithm; service efficiency; Assembly systems; Computer networks; Cost function; Database systems; Design optimization; Distributed computing; Distributed databases; Medical services; Memory management; Query processing; distributed database; multi-relation semi join; query optimization;
Conference_Titel :
Computer Design and Applications (ICCDA), 2010 International Conference on
Conference_Location :
Qinhuangdao
Print_ISBN :
978-1-4244-7164-5
Electronic_ISBN :
978-1-4244-7164-5
DOI :
10.1109/ICCDA.2010.5541153