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

Index based approach for heuristic query optimization in data warehouses

HUANG Jin-chai,YANG Ke-hua,CHEN Nan-nan College of Computer and Communication,Hunan University,Changsha 410082,China  
In large data warehouse query processing,multi-joining of fact tables is often involved.The traditional query optimization method reduces the size of middle-product as possible as it can when calculating multi-joining,but this method is unable to get the best optimal result since it is not considered massive data in data warehouse whose fact tables have indexes.To solve the above problem,this paper proposes an index based approach for heuristic query optimization.Theoretical analysis and experimental results show that the method for querying cost and executing time significantly reduces and the method is effective.
【Fund】: 广东省产学研项目No.2007A090302079~~
【CateGory Index】: TP311.13
Download(CAJ format) Download(PDF format)
CAJViewer7.0 supports all the CNKI file formats; AdobeReader only supports the PDF format.
Chinese Journal Full-text Database 4 Hits
1 Chen Changqing Cheng Ken Chen Changqing Dr.; College of Software, Huazhong Univ. of Sci. & Tech., Wuhan 430074, China .;A heuristic algorithm for finding out relatively optimal rewritten query[J];Journal of Huazhong University of Science and Technology;2005-01
2 Wen Juan~1, Xue Yongsheng~1, Weng Wei~1,2, and Lin Ziyu~1,3~1(Computer Science Department, Xiamen University, Xiamen 361005)~2(Electronic Engineering Department, Xiamen University of Technology, Xiamen 361005)~3(Department of Computer Science and Technology, Peking University, Beijing 100871);An Efficient Method for Multi-Table Joining in Data Warehouse[J];Journal of Computer Research and Development;2005-11
3 ZHAO Peiying, LI Qingzhong, WANG Haiyang ( Institute of Computer Science and Technology, Shandong University(East), Jinan 250010);A Parallel Multi-join Algorithm for Improving Query Performance in Data Warehouse[J];Computer Engineering;2002-10
4 JIANG Xu\|dong,\ ZHOU Li\|zhu(Department of Computer Science and Technology, Tsinghua University, Beijing 100084, China);A Multi-Table Join Algorithm for Data Warehouse Query Processing[J];Journal of Software;2001-02
Chinese Journal Full-text Database 10 Hits
1 LI Bo (Beijing P&T Consulting & Design Institute Co Ltd,Beijing 100035,China);A Study on Data Warehouse and OLAP Technology[J];Journal of Beijing Broadcasting Institute;2005-04
2 The Study Group, Jiangsu Branch, ICBC;Method of Innovating Marketing Model and Management of ICBC via Data Base[J];Finance Forum;2005-03
3 GUO Xiao-li ,GUO Ping,FENG Li (Information-based Teaching Centre,Northeast Dianli University,Jilin 132012);Implementation of Data Mining Technology in analysis and appraisal system of teaching quality[J];Journal of Northeast Dianli University;2006-03
4 ZHONG Qing-qi (Software College, Dongguan University of Technology, Dongguan 523808, China);Application of Data Mining in Analysis of Customer Churn in Telecom Industry[J];Journal of Dongguan University of Technology;2008-01
5 SUN Na,WU Li-zeng,YUAN Jin-sha,WANG Kun(Department of electron and communication engineering,North China Electric Power University,Hebei 071003,China);Design and development of data warehouse for power system equipment[J];Telecommunications For Electric Power System;2005-09
6 ;OLAM-A New System Construction based on the Combination of OLAP and Data Mining[J];Computer Development & Applications;2006-11
7 CUI Qing,LI Xiu-hong,ZHANG Zheng-yu,WANG Chong-guo(College of Information Science and Engineering,Xinjiang University,Urumqi,Xinjiang 830046,China);Design and Research of Beehive Customer Management System Based on UML[J];Computer and Information Technology;2008-02
8 SU Yu-e,ZHOU Xue-jun (Three Gorges University, College of Electrical Engineering and Information Technology , Yichang 443002,China);The Building of Data Warehouse Based on Marketing[J];Computer Knowledge and Technology(Academic Exchange);2007-20
9 LIU Ting-cang1,LONG Hua-biao2,SHI Li2(1.Jiangxi University of Science and Technology,Information Science and Engineering,Namchang 330013,China;2.Shenyang Ligong U-niversity,Shenyang 110168,China);The Application of Data Warehouse to Network Analysis of Mobile Company[J];Computer Knowledge and Technology;2008-36
10 DING Ding(Hangzhou Tonglu Power Supply Bureau,Hangzhou 311500,China);Application of the data warehouse base on the electrical decision information system[J];Computer Knowledge and Technology;2009-06
China Proceedings of conference Full-text Database 2 Hits
1 Deng Xiaowen Jin Yuen Technical support section,Guangzhou Branch,Guangdong Telecom;Improving Telecommunication Enterprise Competitive Ability by CRM[A];[C];2007
2 Wei Lei (China Mobile Group Liaoning Co., Ltd. 110179);The Design and Implementation of Tariff Forecasting Analysis in BASS[A];[C];2008
【Secondary Citations】
Chinese Journal Full-text Database 3 Hits
1 JIANG Xu\|dong,\ ZHOU Li\|zhu(Department of Computer Science and Technology, Tsinghua University, Beijing 100084, China);A Multi-Table Join Algorithm for Data Warehouse Query Processing[J];Journal of Software;2001-02
2 FENG Jian-Hua1+, JIANG Xu-Dong1, MENG Xian-Hu2 1(Department of Computer Science and Technology, Tsinghua University, Beijing 100084, China) 2(Department of Computer, Yuncheng Advanced Training College, Yuncheng 044000, China) + Corresponding author: Phn: 86-10-62789150, E-mail: fengjh@tsinghua.edu.cn http://www.tsinghua.edu.cn Feng JH, Jiang XD, Meng XH. An aggregation algorithm based on group numbers. Journal of Software, 2003,14(2):222~229.;An Aggregation Algorithm Based on Group Numbers[J];Journal of Software;2003-02
3 CHEN Chang qing, FENG Yu cai, YUAN Lei (Database & MultiMedia Research Institute, Huazhong University of Science & Technology , Wuhan 430074, China);Design of Data Warehousing System DM_DW[J];Mini-micro Systems;2002-05
©2006 Tsinghua Tongfang Knowledge Network Technology Co., Ltd.(Beijing)(TTKN) All rights reserved