Title :
On the performance and use of spatial OLAP tools
Author :
Bianchi, Renata Germano ; Yuki Hatano, Guilherme ; Lopes Siqueira, Thiago Luis
Author_Institution :
Inst. Fed. de Educ., Cienc. e Tecnol. de Sao Paulo, IFSP, Sao Carlos, Brazil
Abstract :
Spatial data warehouses provide a means of carrying out spatial analysis together with agile and flexible multidimensional analytical queries performed by SOLAP tools. However, queries are processed with slow query response times and functionalities of these tools are still insufficient, such as the support for a variety of spatial data warehouse schemas. In this paper, we conduct an experimental evaluation of existing open source software as SOLAP tool and database management system, to analyze its functionalities and query processing performance. Furthermore, we describe and evaluate our novel SOLAP tool called MapQuery that reuses efficient indices to boost query processing performance. Results derived from our performance evaluation indicated that MapQuery shortened the response time of queries from at least 63% up to 92% if compared to existing solutions.
Keywords :
data mining; data warehouses; public domain software; query processing; software performance evaluation; visual databases; MapQuery; SOLAP tool; agile multidimensional analytical queries; database management system; flexible multidimensional analytical queries; online analytical processing; open source software; query processing performance; spatial OLAP tools performance; spatial analysis; spatial data warehouse schemas; Cities and towns; Data warehouses; Geometry; Indexes; Query processing; Spatial databases; Time factors; SB-index; SOLAP; drill-down; roll-up; slice-and-dice; spatial data warehouse;
Conference_Titel :
Computing Conference (CLEI), 2013 XXXIX Latin American
Conference_Location :
Naiguata
Print_ISBN :
978-1-4799-2957-3
DOI :
10.1109/CLEI.2013.6670652
