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

fYear

2013

fDate

7-11 Oct. 2013

Firstpage

1

Lastpage

12

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;

fLanguage

English

Publisher

ieee

Conference_Titel

Computing Conference (CLEI), 2013 XXXIX Latin American

Conference_Location

Naiguata

Print_ISBN

978-1-4799-2957-3

Type

conf

DOI

10.1109/CLEI.2013.6670652

Filename

6670652