Abstract
Data warehouses are used to store large amounts of data. A data model makes possible separating data categories and establishing relations between them. In this paper we introduce for the first time the new concept of distributed spatial data warehouse based on the multidimensional data model called cascaded star schema [1]. We decided to use the idea of new aggregation tree, that indexes our model in order to fully exploit capabilities of the cascaded star. After close discussion on the cascaded star schema and aggregation tree, we introduce the new idea of distributing data warehouse based on the cascaded star schema. Using Java we implemented both system running on a single computer as well as distributed system. Then we carried out the tests which results allow us to compare the performance of both systems. The tests results show that by distribution one may improve the performance of spatial data warehouse.
This is a preview of subscription content, log in via an institution to check access.
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
Adam, N., Atluri, V., Yesha, Y., Yu, S.: Efficient Storage and Management of Environmental Information. In: IEEE Symposium on Mass Storage Systems (April 2002)
Papadias, D., Kalnis, P., Zhang, J., Tao, Y.: Efficient OLAP Operations in Spatial Data Warehouses. LNCS. Springer, Heidelberg (2001)
Bernardino, J., Madera, H.: Data Warehousing and OLAP: Improving Query Performance Using Distributed Computing. In: Conference on Advanced Information Systems Engineering, Stockholm, Sweden, June 5-6 (2000)
Märtens, H., Rahm, E., Stöhr, T.: Dynamic Query Scheduling in Parallel Data Warehouses. In: Monien, B., Feldmann, R.L. (eds.) Euro-Par 2002. LNCS, vol. 2400, p. 321. Springer, Heidelberg (2002)
Theodoratos, D., Tsois, A.: Heuristic optimization of OLAP queries in multidimensionally hierarchically clustered databases. In: DOLAP 2001 (2001)
Akal, F., Böhm, K., Schek, H.J.: OLAP Query Evaluation in a Database Cluster: a Performance Study on Intra-Query Parallelism. In: Manolopoulos, Y., Návrat, P. (eds.) ADBIS 2002. LNCS, vol. 2435, p. 218. Springer, Heidelberg (2002)
Rohm, U., Bohm, K., Schek, H.J., Schuldt, H.: FAS- a Freshness-Sensitive Coordination Middleware for a Cluster of OLAP Components. In: VLDB 2002 (2002)
Kurmann, C., Rauch, F., Stricker, T.M.: Cost/Performance Tradeoffs in Network Interconnects for Clusters of Commodity PCs. ETH Zürich (2003)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2004 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Gorawski, M., Malczok, R. (2004). Distributed Spatial Data Warehouse. In: Wyrzykowski, R., Dongarra, J., Paprzycki, M., Waśniewski, J. (eds) Parallel Processing and Applied Mathematics. PPAM 2003. Lecture Notes in Computer Science, vol 3019. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-24669-5_88
Download citation
DOI: https://doi.org/10.1007/978-3-540-24669-5_88
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-21946-0
Online ISBN: 978-3-540-24669-5
eBook Packages: Springer Book Archive