[1]张银玲,武彤.常用OLAP查询优化方法性能分析[J].计算机技术与发展,2014,24(01):39-42.
　ZHANG Yin-ling,WU Tong.Performance Analysis of Several OLAP Query Optimization Methods[J].,2014,24(01):39-42.
点击复制

常用OLAP查询优化方法性能分析()
分享到：

《计算机技术与发展》[ISSN:1006-6977/CN:61-1281/TN]

卷:
24
期数:
2014年01期
页码:
39-42
栏目:
智能、算法、系统工程
出版日期:
2014-01-31

文章信息/Info

Title:
Performance Analysis of Several OLAP Query Optimization Methods
文章编号:
1673-629X（2014）01-0039-04
作者:
张银玲; 武彤
贵州大学 计算机科学与信息学院
Author(s):
ZHANG Yin-ling; WU Tong
关键词:
OLAP; 存储过程; 索引技术; 物化视图
Keywords:
OLAP; stored procedure; index technique; materialized view
分类号:
TP311
文献标志码:
A
摘要:
OLAP( Online Analytical Processing)查询常常涉及到不同的维表和事实表，要得到查询结果通常需要进行多张表的连接操作。连接操作是一种非常耗时的操作，因此，如何提高OLAP查询效率成为数据仓库应用中的关键问题。文中对存储过程、索引技术、物化视图等几种常用的OLAP查询优化方法进行性能分析，针对特定应用通过反复实验比较得出物化视图的优越性。而就物化视图而言，其本身有优越性的同时也存在一些缺陷。因此，针对物化视图更新问题提出了几种更新方案
Abstract:
OLAP query often involves different dimension tables and fact tables,to get the query result usually requires more table join op-erations. The connection operation is very time-consuming,consequently how to improve the efficiency of OLAP queries becomes the key problem in data warehouse. Analyze several OLAP query optimization techniques like stored procedure,index technique,and materi-alized view,take the superiority of materialized view by doing experiments in application-specific system. And in terms of materialized views,it has the superiority,also has some defects. So,the several methods to solve the update problem of materialized view are pro-posed.

相似文献/References:

[1]葛华 李香云.基于SQL Server存储过程公共机房管理系统设计[J].计算机技术与发展,2009,(09):190.
　GE Hua,LI Xiang-yun.Design of Public Computer Room＇s Management System by SQL Server Stored Procedure[J].,2009,(01):190.
[2]黄光芳.基于.NET的数据访问基类的构建[J].计算机技术与发展,2008,(03):148.
　HUANG Guang-fang.Construction of Data Access Base Class Based on. NET[J].,2008,(01):148.
[3]何健 王家华.树型层次结构数据中遍历子树结点的方法[J].计算机技术与发展,2008,(04):95.
　HE Jian,WANG Jia-hua.Method of Traversing Subtree Nodes in Data of Tree-Level Structure[J].,2008,(01):95.
[4]夏义全.数据库应用系统优化方法的研究[J].计算机技术与发展,2008,(07):149.
　XIA Yi-quan.Research on Optimization Method of Database Application System[J].,2008,(01):149.
[5]陈荣鑫 陈维斌 黄杰圣.基于Analysis Services的教学评估分析系统的设计[J].计算机技术与发展,2007,(08):233.
　CHEN Rong-xin,CHEN Wei-bin,HUANG Jie-sheng.Design of Teaching Evaluation Analysis System Based on Analysis Services[J].,2007,(01):233.
[6]马帅 刘利军 黄青松.基于动态交叉表的Web多维分析系统设计与实现[J].计算机技术与发展,2007,(09):113.
　MA Shuai,LIU Li-jun,HUANG Oing-song.Design and Implementation of Multidimensional Analysis System of Web Based on Dynamic Crosstab[J].,2007,(01):113.
[7]杨锦园 李艳灵.基于桥梁健康监测的数据库系统设计研究[J].计算机技术与发展,2007,(12):213.
　YANG Jin-yuan,LI Yan-ling.Research and Design of Database System for Bridge Healthy Monitoring System[J].,2007,(01):213.
[8]曲美霞 弭希庆.企业自动审批流程管理系统的实现[J].计算机技术与发展,2006,(02):67.
　QU Mei-xia,MI Xi-qing.Implementation of Automatic Approval Flow Management System in Company[J].,2006,(01):67.
[9]高筱芸 严洪森 路致远.基于模型重构的生产计划优化系统设计与开发[J].计算机技术与发展,2006,(03):167.
　GAO Xiao-yun,YAN Hong-sen,LU Zhi-yuan.Design and Development of Optimal Production Planning System Based on Production Model Reengineering[J].,2006,(01):167.
[10]金鑫 张毅.基于图形组件的数据分析决策系统研究[J].计算机技术与发展,2006,(05):157.
　JIN Xin,ZHANG-Yi.Study of Data Analysis and Decision System Based on Graphic Module Technology[J].,2006,(01):157.

更新日期/Last Update: 1900-01-01