Processing aggregate queries on spatial OLAP data

被引：0
|
作者：
Choi, Kenneth [1 ]
Luk, Wo-Shun [1 ]
机构：
[1] Simon Fraser Univ, Sch Comp Sci, Burnaby, BC V5A 1S6, Canada
来源：
DATA WAREHOUSING AND KNOWLEDGE DISCOVERY, PROCEEDINGS | 2008年 / 5182卷
关键词：
D O I：
暂无
中图分类号：
TP18 [人工智能理论];
学科分类号：
081104 ; 0812 ; 0835 ; 1405 ;
摘要：
Spatial OLAP refers to the confluence of two technologies: spatial data management and OLAP for non-spatial data. An example query on spatial OLAP data is to find the total amount of gas sold within a period of time, of certain type of gas, to a certain type of customers, by gas stations located within a query window on a map. A framework has been established in [8], which converts this query into a set of queries for a general-purpose ROLAP system. However, there has been little done at the query optimization level, once they are submitted to the OLAP system. In this paper, we develop and implement 3 query processing strategies of very different nature on our experimental MO-LAP system. Detailed experimental performance data are presented, using a real-life spatial database with 1/3 million of spatial objects.
引用
收藏
页码：125 / 134
页数：10
相关论文
共 50 条
  • [1] The approach for data warehouse to answering spatial OLAP queries
    Li, Y
    Chen, Y
    Rao, FY
    INTELLIGENT DATA ENGINEERING AND AUTOMATED LEARNING, 2003, 2690 : 270 - 277
  • [2] Answering approximate range aggregate queries on OLAP data cubes with probabilistic guarantees
    Cuzzocrea, A
    Wang, W
    Matrangolo, U
    DATA WAREHOUSING AND KNOWLEDGE DISCOVERY, PROCEEDINGS, 2004, 3181 : 97 - 107
  • [3] Recommending Multidimensional Spatial OLAP Queries
    Layouni, Olfa
    Alahmari, Fahad
    Akaichi, Jalel
    INTELLIGENT INTERACTIVE MULTIMEDIA SYSTEMS AND SERVICES 2016, 2016, 55 : 405 - 415
  • [4] Processing OLAP queries in hierarchically clustered databases
    Theodoratos, D
    Tsois, A
    DATA & KNOWLEDGE ENGINEERING, 2003, 45 (02) : 205 - 224
  • [5] Eco-Processing of OLAP Complex Queries
    Roukh, Amine
    Bellatreche, Ladjel
    BIG DATA ANALYTICS AND KNOWLEDGE DISCOVERY, 2015, 9263 : 229 - 242
  • [6] Answering joint queries from multiple aggregate OLAP databases
    Pourabbas, E
    Shoshani, A
    DATA WAREHOUSING AND KNOWLEDGE DISCOVERY, PROCEEDINGS, 2003, 2737 : 24 - 34
  • [7] Aggregate Farthest-Neighbor Queries over Spatial Data
    Gao, Yuan
    Shou, Lidan
    Chen, Ke
    Chen, Gang
    DATABASE SYSTEMS FOR ADVANCED APPLICATIONS, PT II, 2011, 6588 : 149 - 163
  • [8] Processing aggregate queries with materialized views in data warehouse environment
    Chang, JY
    Kim, HJ
    IEICE TRANSACTIONS ON INFORMATION AND SYSTEMS, 2005, E88D (04): : 726 - 738
  • [9] Range queries in dynamic OLAP data cubes
    Liang, WF
    Wang, H
    Orlowska, ME
    DATA & KNOWLEDGE ENGINEERING, 2000, 34 (01) : 21 - 38
  • [10] Scalable OLAP queries processing towards large cluster
    Wang, Hui-Ju
    Qin, Xiong-Pai
    Wang, Shan
    Zhang, Yan-Song
    Li, Fu-Rong
    Jisuanji Xuebao/Chinese Journal of Computers, 2015, 38 (01): : 45 - 58
12345