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

Cost model of query plan database system

HE Xin Department of Information Management,Institute of Petro-Chemical Technology,Beijing 102617,China  
A new cost model of distributed database query based on the study of availability semi-joins is put forward in this paper,which can describe the cost of distributed database query precisely by including selection of relation copies,query order of multi-join,determination of performance sites,transaction of data and cost of local computation.Then the cost model is analyzed,designed in detail and realized.
【Fund】: 北京市教委2006人文社会科学研究资助项目(Beijing Municipal Education Commission 2006 Funded Projects No.SM200610017002)
【CateGory Index】: TP311.13
Download(CAJ format) Download(PDF format)
CAJViewer7.0 supports all the CNKI file formats; AdobeReader only supports the PDF format.
【Citations】
Chinese Journal Full-text Database 2 Hits
1 YUHong~(1,2),WANGXiu-kun~(*1)( 1.School of Electr. and Inf. Eng., Dalian Univ. of Technol., Dalian 116024, China;2.School of Inf. Eng., Dalian Fisheries Univ., Dalian 116023, China );Value-based query optimization algorithm[J];Journal of Dalian University of Technology;2005-03
2 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
【Co-citations】
Chinese Journal Full-text Database 5 Hits
1 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
2 Yang Haixia(Business College of Shanxi University,Tai-yuan 030031,China);Heterogeneous Database Optimization Mining Technology Based on the Improved Data Filtering Algorithm[J];Bulletin of Science and Technology;2013-06
3 HE Shu-luan;PANG Yin;Chongqing University;Hainan College of Economics and Business;;Database query optimization strategy algorithm based on two phase[J];Laser Journal;2015-04
4 ;Cost Model of Query Plan in Distribute DataBase System[J];Computer Systems Applications;2007-10
5 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 YU Xiuxia~(1,2) ZHAO Jianping~2 (1.Network information Center,Changchun University,Changchun 1300222.Changchun University of Science and Technology,Changchun 130022));Study on Optimized Algorithm for Distributed Database Direct-join Query[J];Journal of Changchun Institute of Optics and Fine Mechanics;2005-03
2 YUHong~(1,2),WANGXiu-kun~(*1)( 1.School of Electr. and Inf. Eng., Dalian Univ. of Technol., Dalian 116024, China;2.School of Inf. Eng., Dalian Fisheries Univ., Dalian 116023, China );Value-based query optimization algorithm[J];Journal of Dalian University of Technology;2005-03
3 GU Guo-dong (Nanjing Institute Huawei Technologies Co., LTD, Nanjing 210001, China);Research and Analyze of the MMDB Correlation Technology[J];Computer Knowledge and Technology(Academic Exchange);2007-19
4 WANG Zheng1,WANG Ya-ping2(1.Zhengzhou Railway Vocational Technology College,Zhengzhou 450052,China;2.Xi’an International University,Xi’an 710077,China);Research on relational algebra and SQL query optimization[J];Electronic Design Engineering;2009-08
5 YIN Wei-hong , LIU Ya-cheng ( Shanghai University of Electric Power, Shanghai 200090, China; Anhui Provincial Energy Group Co. , Ltd. , Hefei 230061 , China);Design and implementation of real-time databases for grid monitoring systems[J];East China Electric Power;2006-12
6 Li Guohui Yang Jincai Li Guohui Assoc. Prof.; College of Computer Sci. & Tech., Huazhong Univ. of Sci. & Tech., Wuhan 430074, China.;Query optimization in main memory database system[J];Journal of Huazhong University of Science and Technology;2003-04
7 Hu Feng1 Tao Shiqun2 1(Dept.of computer,Qinghai Normal University,Xining 810008) 2(Dept.of computer science,Shanxi University,Taiyuan 030006);A Optimization Algorithm and Improved for Multi-join Queries of Distributed Database[J];Computer Engineering and Applications;2001-16
8 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
9 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
10 CHEN Shu-sheng,LIU Wei-dong(Dept.of Computer Science & Technology,Tsinghua University,Beijing 100084);Graph-based Adaptive Multi-join Query Optimization Algorithm[J];Computer Engineering;2009-10
【Secondary References】
Chinese Journal Full-text Database 1 Hits
1 CHU Long-xian,SHEN Yuan(Software School,Pingdingshan University,Pingdingshan 467000,China);A Query Optimization Algorithm Based on Multiple Join Attribute[J];Computer and Modernization;2012-05
【Secondary Citations】
Chinese Journal Full-text Database 4 Hits
1 Hu Feng1 Tao Shiqun2 1(Dept.of computer,Qinghai Normal University,Xining 810008) 2(Dept.of computer science,Shanxi University,Taiyuan 030006);A Optimization Algorithm and Improved for Multi-join Queries of Distributed Database[J];Computer Engineering and Applications;2001-16
2 YANG Bo,\ HONG Xiao\|guang,\ WANG Hai\|yang(Department of Computer Science, Shandong University, Ji'nan 250100, China);Optimization of Multiple User-Defined Functions in a Query Using Interval Constraints[J];Journal of Software;2001-09
3 CAO Yang, FANG Qiang, WANG Guo-ren, YU Ge (School of Information Science and Engineering, Northeastern University, Shenyang 110004, China) E-mail: {wanggr,yuge}@mail.neu.edu.cn http://www.neu.edu.cn;Parallel Query Optimization Techniques for Multi-Join Expressions Based onGenetic Algorithm[J];Journal of Software;2002-02
4 YU Hong, WANG Xiu-kun (Deptartment Of Computer Science & Engineering Dalian University of Technology, Dalian 116023,China);Model for Index Selection Based on SQL Server[J];Mini-micro Systems;2003-02
©2006 Tsinghua Tongfang Knowledge Network Technology Co., Ltd.(Beijing)(TTKN) All rights reserved