Paper Info
Title
Efficient processing of drill-across queries over geographic data warehouses
Abstract
Drill-across SOLAP queries (spatial OLAP queries) allow for strategic decision-making through the use of numeric measures from distinct fact tables that share dimensions and by the evaluation of spatial predicates. Despite the importance of these queries in geographic data warehouses (GDWs), there is a lack of research aimed at their study. In this paper, we investigate three challenging aspects related to the efficient processing of drill-across SOLAP queries over GDWs: (i) the design of a GDW schema to enable the performance evaluation of drill-across SOLAP query processing; (ii) the definition of classes of drill-across SOLAP queries to be issued over the proposed GDW schema; and (iii) the analysis of different approaches to process drill-across SOLAP queries, as follows: star-join computation, materialized views and a new proposed approach based on the SB-index, which is named DrillAcrossSB. We conclude that the DrillAcrossSB approach highly speedups the processing of drill-across SOLAP queries from 39% up to 98%.
Year
DOI
Venue
2011
10.1007/978-3-642-23544-3_12
DaWaK
Keywords
Field
DocType
drill-across solap query,gdw schema,efficient processing,drill-across solap,drill-across query,proposed gdw schema,drill-across solap query processing,geographic data warehouse,drillacrosssb approach,new proposed approach,different approach,performance evaluation
Data warehouse,Data mining,Information retrieval,Computer science,Online analytical processing,Drill,Materialized view,Schema (psychology),Database,Computation
Conference
Citations 
PageRank 
References 
6
0.42
14
Authors
5
Name
Order
Citations
PageRank
Jaqueline Joice Brito171.11
Thiago Luís Lopes Siqueira2657.42
Valéria Cesário Times318227.52
Ricardo Rodrigues Ciferri413722.24
Cristina Dutra De Aguiar Ciferri516627.92