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 条
  • [41] Compressed data cube for approximate OLAP query processing
    Yu Feng
    Shan Wang
    Journal of Computer Science and Technology, 2002, 17 : 625 - 635
  • [42] Query Recommendations for OLAP Discovery-Driven Analysis
    Giacometti, Arnaud
    Marcel, Patrick
    Negre, Elsa
    Soulet, Arnaud
    INTERNATIONAL JOURNAL OF DATA WAREHOUSING AND MINING, 2011, 7 (02) : 1 - 25
  • [43] Privacy Preserving Aggregate Query of OLAP for Accurate Answers
    Zhu, Youwen
    Huang, Liusheng
    Yang, Wei
    Dong, Fan
    JOURNAL OF COMPUTERS, 2010, 5 (11) : 1678 - 1685
  • [44] A temporal query language for OLAP: Implementation and a case study
    Vaisman, AA
    Mendelzon, AO
    DATABASE PROGRAMMING LANGUAGES, 2002, 2397 : 78 - 96
  • [45] Compressed data cube for approximate OLAP query processing
    Feng, Y
    Wang, S
    JOURNAL OF COMPUTER SCIENCE AND TECHNOLOGY, 2002, 17 (05) : 625 - 635
  • [46] GPU adaptive hybrid OLAP query processing model
    Zhang Y.
    Zhang Y.-S.
    Chen H.
    Wang S.
    Zhang, Yan-Song (zhangys_ruc@hotmail.com), 1600, Chinese Academy of Sciences (27): : 1246 - 1265
  • [47] MDX2SPARQL: Semantic query mapping of OLAP query language to SPARQL
    Boumhidi, Haytem
    Nfaoui, El Habib
    Oubenaalla, Younes
    2018 INTERNATIONAL CONFERENCE ON INTELLIGENT SYSTEMS AND COMPUTER VISION (ISCV2018), 2018,
  • [48] Relevance feedback based query optimization
    Chen, Chen
    Zhao, Tiejun
    Qi, Haoliang
    Yang, Muyun
    Li, Sheng
    Journal of Information and Computational Science, 2009, 6 (03): : 1461 - 1468
  • [49] Query Optimization Based on Data Provenance
    Huang Li
    Cheng Hongbing
    NEW TRENDS AND APPLICATIONS OF COMPUTER-AIDED MATERIAL AND ENGINEERING, 2011, 186 : 586 - 590
  • [50] Query optimization based on users profile
    Loubna, Cherrat
    Mostafa, Ezziyyani
    Omar, Kassara
    Mohammed, Essaaidi
    2012 INTERNATIONAL CONFERENCE ON MULTIMEDIA COMPUTING AND SYSTEMS (ICMCS), 2012, : 706 - 712
12345