loading...
 This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
13th Euromicro Conference on Parallel, Distributed and Network-Based Processing (PDP'05)
Updating Aggregation Tree in Distributed Spatial Telemetric Data Warehouse
Lugano, Switzerland
February 09-February 12
ISBN: 0-7695-2280-7
Marcin Gorawski, Silesian University of Technology, Poland
Rafal Malczok, Silesian University of Technology, Poland
In this paper we present a Spatial Telemetric Data Warehouse (STDW) system that we use for aggregation and analysis of huge amounts of spatial data. The data is generated by utilities meters communicating via radio. In order to provide a sufficient efficiency of our system we propose data and workload distribution as well as advanced indexing techniques. As a data model we applied a cascaded star model that is a spatial development of a standard star schema. We use a dynamic indexing structure called aggregation tree. The index operation is tightly integrated with the spatial character of the data. In this paper we address a few interesting details concerning the aggregation tree: indexing structure materialization, memory managing algorithm and tree updating. The system is written in Java; as the database we use Oracle 9i. Basing on the tests results, we prove that the distributed system significantly surpasses the centralized version in terms of efficiency. We also show that a selective materialization of indexing structure fragments strongly increases system efficiency.
Citation:
Marcin Gorawski, Rafal Malczok, "Updating Aggregation Tree in Distributed Spatial Telemetric Data Warehouse," pdp, pp.329-336, 13th Euromicro Conference on Parallel, Distributed and Network-Based Processing (PDP'05), 2005
Usage of this product signifies your acceptance of the Terms of Use.