An optimization strategy of OLAP query based on sematic

被引：0
|
作者：
Yang, Ke-Hua [1 ]
Liu, Sheng-Gang [1 ,2 ]
机构：
[1] School of Computer and Communication, Hunan Univ., Changsha, Hunan 410082, China
[2] Department of Computer Science and Information Engineering, Hunan Institute of Science and Technology, Yueyang, Hunan 414000, China
来源：
Hunan Daxue Xuebao/Journal of Hunan University Natural Sciences | 2009年 / 36卷 / 06期
关键词：
Semantics - Heuristic algorithms;
D O I：
暂无
中图分类号：
学科分类号：
摘要：
This paper first studied the optimization strategy of single OLAP query set based on the hierarchy and semantic of cells in Data Cube, and then expanded the strategy to multi OLAP query sets. For the given multi OLAP Query sets, we discerned public query and carried on global optimization according to the relationship between the queries, and then produced a global optimum execute plan by using dynamic heuristic algorithm. The optimization can avoid redundant disk access and improve the efficiency of the OLAP queries.
引用
收藏
页码：63 / 66
相关论文
共 50 条
  • [21] XML-based OLAP query processing in a federated data warehouses
    Mangisengi, O
    Essmayr, W
    Huber, J
    Weippl, E
    ENTERPRISE INFORMATION SYSTEMS V, 2004, : 93 - 100
  • [22] Research and application of OLAP system based on object-oriented query
    Wang, Chengliang
    Zhang, Jian
    He, Juan
    Jisuanji Gongcheng/Computer Engineering, 2006, 32 (01): : 84 - 86
  • [23] HIERARCHICAL OPTIMIZATION STRATEGY FOR QUERY EVALUATION.
    Hiyoshi, Shigeki
    Mizuma, Masayuki
    Watanabe, Masanobu
    NEC Research and Development, 1984, (72): : 48 - 55
  • [24] HIERARCHICAL-OPTIMIZATION STRATEGY FOR QUERY EVALUATION
    HIYOSHI, S
    MIZUMA, M
    WATANABE, M
    NEC RESEARCH & DEVELOPMENT, 1984, (72): : 48 - 55
  • [25] Semantic Cache Replacement Strategy for XML Algebra-Based Query Optimization
    XU Fangfang
    LI Yaoyao
    GU Jinguang
    Wuhan University Journal of Natural Sciences, 2015, 20 (02) : 165 - 172
  • [26] OLAP Optimization Techniques Based on GPU Database
    Zhang Y.-S.
    Liu Z.
    Han R.-C.
    Zhang Y.
    Wang S.
    Ruan Jian Xue Bao/Journal of Software, 2023, 34 (11): : 5205 - 5229
  • [27] Overcoming limitations of approximate query answering in OLAP
    Cuzzocrea, A
    9TH INTERNATIONAL DATABASE ENGINEERING & APPLICATION SYMPOSIUM, PROCEEDINGS, 2005, : 200 - 209
  • [28] An Efficient OLAP Query Algorithm Based on Dimension Hierarchical Encoding Storage and Shark
    Yao, Shengqiang
    He, Jieyue
    ADVANCES IN SWARM INTELLIGENCE, ICSI 2014, PT II, 2014, 8795 : 180 - 187
  • [29] From a procedural to a visual query language for OLAP
    Cabibbo, L
    Torlone, R
    TENTH INTERNATIONAL CONFERENCE ON SCIENTIFIC AND STATISTICAL DATABASE MANAGEMENT - PROCEEDINGS, 1998, : 74 - 83
  • [30] OLAP query processing for XML data in RDBMS
    Kit, Chantola
    Amagasa, Toshiyuki
    Kitagawa, Hiroyuki
    2007 IEEE INTERNATIONAL WORKSHOP ON DATABASES FOR NEXT GENERATION RESEARCHERS, 2007, : 7 - +
12345