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 条
  • [31] A Holistic Approach for Query Evaluation and Result Vocalization in Voice-Based OLAP
    Trummer, Immanuel
    Wang, Yicheng
    Mahankali, Saketh
    SIGMOD '19: PROCEEDINGS OF THE 2019 INTERNATIONAL CONFERENCE ON MANAGEMENT OF DATA, 2019, : 936 - 953
  • [32] A Graph-based Database Partitioning Method for Parallel OLAP Query Processing
    Nam, Yoon-Min
    Kim, Min-Soo
    Han, Donghyoung
    2018 IEEE 34TH INTERNATIONAL CONFERENCE ON DATA ENGINEERING (ICDE), 2018, : 1025 - 1036
  • [33] Hypergraph Based Query Optimization
    Sen, Sangeeta
    Ghosh, Moumita
    Dutta, Animesh
    Dutta, Biswanath
    2015 INTERNATIONAL CONFERENCE ON COMPUTER COMMUNICATION AND INFORMATICS (ICCCI), 2015,
  • [34] A Query Optimization Method Based on Hadoop-HANA Hybrid Data Management Strategy
    Wang, Jie
    Pan, Qiao
    Zhang, Yuan
    Wang, Mei
    3RD INTERNATIONAL SYMPOSIUM ON MECHATRONICS AND INDUSTRIAL INFORMATICS, (ISMII 2017), 2017, : 157 - 166
  • [35] Efficient OLAP query processing in distributed data warehouses
    Akinde, M
    Böhlen, M
    Johnson, T
    Lakshmanan, LVS
    Srivastava, D
    18TH INTERNATIONAL CONFERENCE ON DATA ENGINEERING, PROCEEDINGS, 2002, : 262 - 262
  • [36] SkyCube-Tree Based Group-by Query Processing in OLAP Skyline Cubes
    Sato, Hideki
    Usami, Takayuki
    INTELLIGENT INTERACTIVE MULTIMEDIA SYSTEMS AND SERVICES 2016, 2016, 55 : 297 - 308
  • [37] OLAP query routing and physical design in a database cluster
    Röhm, U
    Böhm, K
    Schek, HJ
    ADVANCES IN DATABASE TECHNOLOGY-DEBT 2000, PROCEEDINGS, 2000, 1777 : 254 - 268
  • [38] Analytical synopses for approximate query answering in OLAP environments
    Cuzzocrea, A
    Matrangolo, U
    DATABASE AND EXPERT SYSTEMS APPLICATIONS, PROCEEDINGS, 2004, 3180 : 359 - 370
  • [39] Efficient OLAP query processing in distributed data warehouses
    Akinde, MO
    Böhlen, MH
    Johnson, T
    Lakshmanan, LVS
    Srivastava, D
    ADVANCES IN DATABASE TECHNOLOGY - EDBT 2002, 2002, 2287 : 336 - 353
  • [40] Efficient OLAP query processing in distributed data warehouses
    Akinde, MO
    Böhlen, MH
    Johnson, T
    Lakshmanan, LVS
    Srivastava, D
    INFORMATION SYSTEMS, 2003, 28 (1-2) : 111 - 135
12345