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 条
  • [1] Optimization research of the OLAP query technology based on P2P
    Wang, Chunfeng, 1600, Universitas Ahmad Dahlan (12):
  • [2] A Query Optimization Strategy Based on Domain Ontology
    Xu Jian-liang
    Xiong Jing
    Liu Yong
    FIRST IITA INTERNATIONAL JOINT CONFERENCE ON ARTIFICIAL INTELLIGENCE, PROCEEDINGS, 2009, : 510 - 513
  • [3] Achieving Query Optimization Using Sparsity Management in OLAP System
    Kumar, Arvind
    Singh, Deepti
    Sharma, Vineet
    PROCEEDINGS OF THE 2014 INTERNATIONAL CONFERENCE ON ISSUES AND CHALLENGES IN INTELLIGENT COMPUTING TECHNIQUES (ICICT), 2014, : 797 - 801
  • [4] Join strategy optimization in column storage based query
    Sun, L. (sli@dhu.edu.cn), 1647, Science Press (50):
  • [5] Mobile query optimization based on agent-technology for distributed data warehouse and OLAP applications
    Hameurlain, A
    Morvan, F
    Tomsich, P
    Bruckner, R
    Kosch, H
    Brezany, P
    13TH INTERNATIONAL WORKSHOP ON DATABASE AND EXPERT SYSTEMS APPLICATIONS, PROCEEDINGS, 2002, : 795 - 799
  • [6] CQPM based OLAP query log mining and recommendation
    Chen, L. (lingchen@cs.zju.edu.cn), 1600, Zhejiang University (46):
  • [7] Predicate simplification based query optimization strategy for semantic caching
    Li, Dong
    Chen, Rui
    Xu, Yang
    Tien Tzu Hsueh Pao/Acta Electronica Sinica, 2013, 41 (10): : 2021 - 2028
  • [8] Algorithm optimization of sentence similarity based on sematic disambiguation
    Jun, Yuan
    INFORMATION SCIENCE AND MANAGEMENT ENGINEERING, VOLS 1-3, 2014, 46 : 135 - 140
  • [9] Usability-based caching of query results in OLAP systems
    Park, CS
    Kim, MH
    Lee, YJ
    JOURNAL OF SYSTEMS AND SOFTWARE, 2003, 68 (02) : 103 - 119
  • [10] SUPRA: A sampling-query optimization method for large-scale OLAP
    Ushijima, K
    Fujiwara, S
    Nishizawa, I
    Sagawa, N
    NINTH INTERNATIONAL WORKSHOP ON DATABASE AND EXPERT SYSTEMS APPLICATIONS, PROCEEDINGS, 1998, : 232 - 237
12345