Full-Text Search:
Home|Journal Papers|About CNKI|User Service|FAQ|Contact Us|中文
《Computer Engineering and Applications》 2001-16
Add to Favorite Get Latest Update

A Optimization Algorithm and Improved for Multi-join Queries of Distributed Database

Hu Feng1 Tao Shiqun2 1(Dept.of computer,Qinghai Normal University,Xining 810008) 2(Dept.of computer science,Shanxi University,Taiyuan 030006)  
: This paper presents a new optimization algorithm for multi-join queries of distributed database.The algorithm has global optimization property in the course of determining join sequences.In the telnet,We use the algorithm of minimum spanning tree,and minimize the total cost.,In the local network,we get parallel join sequences at most by using improved algorithm,utilizing most concurrency reduce response time.
【CateGory Index】: TP311.131
Download(CAJ format) Download(PDF format)
CAJViewer7.0 supports all the CNKI file formats; AdobeReader only supports the PDF format.
【References】
Chinese Journal Full-text Database 10 Hits
1 YU Xiuxia,SONG Yajuan(School of Computer Science,Changchun University,Changchun 130022);A Study of Optimized Algorithm for Distributed Database Half-join Query[J];;2006-04
2 CHEN Ke-hua(Ning De Teacher College,Computer Department,Ningde 352100,china);A Query Optimization Method Based on Quantum Genetic Algorithm in Distributed Heterogeneous Database[J];Computer Knowledge and Technology;2009-08
3 XIE Rui-bing(Guangsha College of Applied Construction Technology,Dongyang 322100,China);Optimized Query Process in the System of Distributed Database[J];Computer Knowledge and Technology;2009-11
4 LIANG Ke-bing YAN Yan(1.Department of Computer Science,Sichuan University of Science & Engineering,Zigong Sichuan 643000,China;2.Head Office of Logistics,Sichuan University of Science & Engineering,Zigong Sichuan 643000,China);An Improved Research on Query Optimized Algorithm of Distributed Database Based on Multi-Relation Semi Join[J];Journal of Guiyang University(Natural Sciences);2008-04
5 CAO Qu-jiang,LIU Gang(College of Computer and Electrical Engineering,University of Shanghai for Science and Technology,Shanghai 200093,China);Research on the improved query optimization strategy of distributed database and its implementation[J];Journal of University of Shanghai for Science and Technology;2008-04
6 WANG Shu-jing,LIU Ren-yi,LIU Nan,TENG Long-mei(Department of Earth Sciences,Zhejiang University,Hangzhou 310028,China);Research on WebGIS in marine remote sensing field for distributed heterogeneous databases.[J];Journal of Zhejiang University(Science Edition);2006-06
7 LIU Guo-qiang1 LIU Wei-guo1 HE Xiao-dong2 1(School of Information Science and Engineering,Central South University,Changsha 410083) 2(Department of Computer,Hunan College of Economic Manager,Changsha 410004);A New Path Choice of the Mobile Query[J];Computer Engineering and Applications;2006-27
8 Lu Jinshi Li Hongxing La Xiao (Dept. of Inf.Eng. , Dalian Inst. of Light Ind. , Dalian 116034) (Xinjiang Institute of Physics, CAS, Wulumuqi 830011);METHODS OF QUERY OPTIMIZATION OF DISTRIBUTED HETEROGENEOUS DATABASE BASED ON GENETIC ALGORITHM[J];Computer Applications and Software;2003-11
9 HE Yuan, DAI Xiao-peng,ZHANG Lin-feng(College of Computer and Information Engineering , HNAU, Changsha410128,China);Overview of Data Query Optimization Algorithms[J];Computer and Modernization;2005-04
10 LI Hai,LI Chun-lai(College of Mathematics & Computer Science,Jishou University,Jishou,Hu'nan 416000,China);An Improved Database-query Algorithm for Multi-relation Semi Joins[J];Journal of Neijiang Normal University;2009-08
【Citations】
Chinese Journal Full-text Database 2 Hits
1 ZHONG Wu; HU Shouren(Department of Computer Science, National University of Defense Technology, Changsha 410073);AN ALGORITHM FOR OPTIMIZATION OF DISTRIBUTED QUERIES[J];Chinese Journal of Computers;1997-11
2 ZHONG Wu HU Shou ren (Department of Computer Science\ Changsha Institute of Technology Changsha 410073);An Improved Optimizing Method for Multi join Queries[J];JOURNAL OF SOFTWARE;1998-02
【Co-citations】
Chinese Journal Full-text Database 9 Hits
1 Yang Yi1,2 Li Yandong1 Li Xiangshu11(College of Computer Engeneering and Science,Chongqing University,Chongqing 400044)2(College of Computer Science and Information Engineering,ChongqingTechnology & Business University,Chongqing 400067);Application of Multi-join Query Based on Simulated Annealing and Genetic Algorithm[J];Computer Engineering and Applications;2004-34
2 LIU Guo-qiang1 LIU Wei-guo1 HE Xiao-dong2 1(School of Information Science and Engineering,Central South University,Changsha 410083) 2(Department of Computer,Hunan College of Economic Manager,Changsha 410004);A New Path Choice of the Mobile Query[J];Computer Engineering and Applications;2006-27
3 WANG Guo, XU Renzuo (State Key Laboratory of Software Engineering, Wuhan University,Wuhan 430072);An Improved Optimizing Algorithm for Large Join Queries Combined with Hash Filters[J];Computer Engineering;2004-07
4 HE Yuan, DAI Xiao-peng,ZHANG Lin-feng(College of Computer and Information Engineering , HNAU, Changsha410128,China);Overview of Data Query Optimization Algorithms[J];Computer and Modernization;2005-04
5 Wu Zhiqiang (Departmen of Information Management,Sun Yat-Sen University,Guangzhou510275);On the Construction and Analysis of Distributed Documentary Databases Query System[J];Information Science;2004-10
6 Zhou Li-li(Computer Information Engineering Department, Shandong Finance Institute, Jinan 250014,China);A Distributed Query Optimization Algorithm on Distributed Information System[J];Shandong Metallurgy;2004-05
7 XU Xun-ming, XUE Yong-sheng, WANG Jin-bo, LV Xiao-hua (Department of Computer Science, Xiamen University, Xiamen 361005, China);Optimization of Join Queries of Distributed Database System[J];Journal of Xiamen University(Natural Science);2004-02
8 PENG Jian_ping 1,WANG Bian_qin 2 (1.School of Management,Zhongshan University, Guangzhou 510275,China; 2.School of Information and Technology,Zhongshan University, Guangzhou 510275,China);A Research on Optimization of Multi-join Queries[J];Acta Scientiarum Naturalium Universitatis Sunyatseni;2001-02
9 SHUAI Xun-bo1,MA Shu-nan2,ZHOU Xiang-guang1,GONG An31(Institute of Geophysics and Information,LangFang Branch of Research Institute of Petroleum Exploration and Development,PetroChina,Langfang 065007,China)2(College of Computer Science & Technology,Beijing University of Technology,Beijing 100022,China)3(Department of Computer Science and Engineering,University of Petroleum,Dongying 257061,China);Research of Query Optimization Based on Genetic Algorithm in Distributed Database[J];Journal of Chinese Computer Systems;2009-08
【Co-references】
Chinese Journal Full-text Database 10 Hits
1 LIN Qi-dong (Wenzhou University, ZheJiang Wenzhou, China 325035);The Research of Optimal Design Project for ORACLE Database[J];Journal of Anyang Institute of Technology;2006-03
2 ;大型关系型数据库优化探讨[J];;2007-02
3 LIU Shu-xin , LI Zheng-fan (School of Information Engineering of East China Jiaotong University, Nanchang330013, China );An Optimized Algorithm Inguiry in Distributed Database System[J];Journal of Beijing Union University;2005-01
4 Zhang Shibo Zhou Shujie Min Yan (Department of Computer Science ,Beijing Institute of Petro-chemical Technology, Beijing 102617);Design of MVC Framework Based on Java[J];Journal of Beijing Institute of Petro-Chemical Technology;2006-01
5 WT4”BX]LIU Wei [WT5BZ]Computer Engineering Department,Changchun University,Changchun 130022[WT5”BZ] [WT5”HZ];Distributed database and its implement techniques[J];JOURNAL OF CHANGCHUN UNIVERSITY;2000-01
6 ZHANG Xia,LI De ren,ZHU Xin yan;A Study of Building WebGIS Based on GML[J];Bulletin of Surveying and Mapping;2003-10
7 CHEN Jing, GONG Jian-ya,ZHU Xin-yan,LI Qing-quan;Web-based Implementation and Publication of Massive Image Data[J];Bulletin of Surveying and Mapping;2004-01
8 HUANG Qin-zhen~1,QIN Xiao-xiao~2 (1.School of Electrical and Information Engineering, Southwest University for Nationalities, Chengdu 610041,China;2.Chengdu Yinhu Technology Company,Chengdu 610041,China);Application of Middleware in Information Query Optimizing System[J];Telecommunication Engineering;2004-03
9 JING Zheng-shu,ZI Hua Liang,LU Dong-fang (Department of Infonmation Engineering,Northeast China Institute of Electric Power Engineering,Jilin City 132012);The Inquiry Optimization in The Distributed Data Base System[J];Journal of Northeast China Institute of Electric Power Engineering(Natural Science Edition);2003-04
10 WANG Ji-zhou1,2, LI Cheng-ming2, FU Jun-e3(1.School of Remote Sensing and Information Engineering, Wuhan University,Wuhan 430079; 2.Institute of GIS, Chinese Academy of Surveying and Mapping,Beijing 100039;3.Remote Sensing Center, China Institute of Water Resources and Hydropower Research,Beijing 100038,China);Research on Connection Pool Service for Distributed Heterogeneous Databases in WebGIS[J];Geography and Geo-Information Science;2003-03
【Secondary References】
Chinese Journal Full-text Database 10 Hits
1 XU Jie1,2,XU Yong-chang,YU Ya-lou2,JIN wei-dong 1.College of GeoExploration Science and Technology,Jilin University,Changchun 130026,China 2.Well Logging Company,Daqing Petroleum Administration Bureau,Daging,Heilongjiang 163412,China 3.Daqing Oil Laying Branch,Pipeline Company,PetroChina,Daqing,Heilongjiang 163818,China;Application of Database Technique to Log Data Analysis[J];Journal of Jilin University(Earth Science Edition);2007-S1
2 XU Chunfeng,SHAO Zhen,LI Weichun(School of computer science and technology,Changchun University of Science and Technology,Changchun 130022);Design and Realization of Query Processing in Data Stream Management System[J];Journal of Changchun University of Science and Technology(Natural Science Edition);2007-04
3 ZHOU Yi-wen1,SHI Shi-long1,WEI Fang2(1.School of Telecommunication Engineering,Beijing University of Post and Telecommunications,Beijing 100876,China;2.School of Information Engineering,Beijing University of Post and Telecommunications,Beijing 100876,China);Design and Implementation of Administrative System for Ocean Map Services Based on ArcGIS Server[J];Geomatics & Spatial Information Technology;2009-01
4 FENG Zhi-qiang,YANG Zong-xiao,CHENG Chuan-ye,ZHANG Zu-jun,GAO Yan-ping, YUAN Xiao-bo,ZHANG Zhi-wen,ZHENG Yan-yi (School of Systems Science and Engineering,Henan University of Science and Technology,Luoyang 471003,Henan Province,China);Security Assessment Management Information System for Power Plants Based on Browser/Server Mode[J];Power System Technology;2007-21
5 Pan Delu,Bai Yan(State Key Laboratory of Satellite Ocean Environment Dynamic,Second Institute of Oceanography,State Oceanic Administration,Hangzhou 310012,China);Advances on the application of ocean color remote sensing engineering in China[J];Engineering Sciences;2008-09
6 LIANG Ke-bing YAN Yan(1.Department of Computer Science,Sichuan University of Science & Engineering,Zigong Sichuan 643000,China;2.Head Office of Logistics,Sichuan University of Science & Engineering,Zigong Sichuan 643000,China);An Improved Research on Query Optimized Algorithm of Distributed Database Based on Multi-Relation Semi Join[J];Journal of Guiyang University(Natural Sciences);2008-04
7 HE Xin Department of Information Management,Institute of Petro-Chemical Technology,Beijing 102617,China;Cost model of query plan database system[J];Computer Engineering and Applications;2008-13
8 XU Xin-hua1,HU Shi-gang1,TANG Sheng-qun2,LIU Hua-dong11.Hubei Vocational-Technical College,Xiaogan,Hubei 432000,China 2.State Key Laboratory of Software Engineering,Wuhan University,Wuhan 430072,China;History,current situation and future of database query optimization[J];Computer Engineering and Applications;2009-18
9 Lu Jinshi Li Hongxing(Dept.of Inf.Eng.,Dalian Inst.of Light Ind.,Dalian 116034) Li Xiao(Xinjiang Institute of Physics,CAS,Wulumuqi 830011);GENETIC QUERY OPTIMIZATION OF DISTRIBUTED HETEROGENEOUS DATABASE[J];Computer Applications and Software;2004-07
10 ZHENG Wei QI Yong-an LI Lin-bo;The integrated design research of resource environmental data oriented network service[J];Shanxi Architecture;2008-17
©2006 Tsinghua Tongfang Knowledge Network Technology Co., Ltd.(Beijing)(TTKN) All rights reserved