Abstract
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 MOLAP system. Detailed experimental performance data are presented, using a real-life spatial database with 1/3 million of spatial objects.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Kheops Technologies Inc., JMAP Spatial OLAP, http://www.kheops-tech.com/en/jmap/solap.jsp
Kifer, M., Bernstein, A., Lewis, P.: Database Systems, 2nd edn. Addison Wesley, Reading (2006)
Luk, W.: A B-tree Based Scheme for OLAP Aggregation and Query Processing (submitted for publication)
Mamoulis, N., Badiras, S., Kalnis, P.: Evaluation of Top-k OLAP Queries Using Aggregate R-Trees. In: Bauzer Medeiros, C., Egenhofer, M.J., Bertino, E. (eds.) SSTD 2005. LNCS, vol. 3633. Springer, Heidelberg (2005)
Papadias, D., Kalnis, P., Zhang, J., Tao, Y.: Efficient OLAP Operations in Spatial Data Warehouses. In: Jensen, C.S., Schneider, M., Seeger, B., Tsotras, V.J. (eds.) SSTD 2001. LNCS, vol. 2121. Springer, Heidelberg (2001)
Pestana, G., Silval, M.: Multidimensional Modeling based on Spatial, Temporal and Spatio-Temporal Stereotypes. In: ESRI International User Conference, San Diego, Calif (2005)
Rao, F., Zhang, L., Yu, X., Li, Y., Chen, Y.: Spatial Hierarchy and OLAP-Favored Search in Spatial Data Warehouse. In: DOLAP 2003, New Orleans, Louisiana (2003)
Zhang, L., Li, Y., Rao, F., Yu, X., Chen, Y., Liu, D.: An Approach to Enabling Spatial OLAP by Aggregating on Spatial Hierarchy. In: Kambayashi, Y., Mohania, M., Wöß, W. (eds.) DaWaK 2003. LNCS, vol. 2737. Springer, Heidelberg (2003)
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 2008 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Choi, K., Luk, WS. (2008). Processing Aggregate Queries on Spatial OLAP Data. In: Song, IY., Eder, J., Nguyen, T.M. (eds) Data Warehousing and Knowledge Discovery. DaWaK 2008. Lecture Notes in Computer Science, vol 5182. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-85836-2_12
Download citation
DOI: https://doi.org/10.1007/978-3-540-85836-2_12
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-85835-5
Online ISBN: 978-3-540-85836-2
eBook Packages: Computer ScienceComputer Science (R0)