Special section on “Spatial data warehouses and SOLAP”
- 1.1k Downloads
Data Warehouses (DW) and OnLine Analytical Processing (OLAP) tools are used in Business Intelligence (BI) applications in order to support decision-making processes. DWs are a specific type of database used to integrate, accumulate and analyze data from various sources. OLAP tools provide means to query and to analyze the warehoused information and produce online statistical summaries (indicators) at different levels of details. These indicators are computed using aggregate functions (e.g. Sum, Avg, Min, Max, etc.). Users can explore DWs by performing OLAP operations (e.g., Roll-up, Drill-down, etc.). Data mining algorithms can also be used in DWs, aiming towards improving data analysis; these techniques help to discern automatically the correlations and causal links between data.
The increasing availability of geo-referenced data has made necessary the need to enrich OLAP with spatial analysis tools. OLAP systems were successfully adapted to solve problems in different areas of application and new kinds of decision support systems, named Spatial Data Warehouses (SDW) and Spatial OLAP (SOLAP) tools have been made available. SDWs are a collection of geographical information supporting spatial analysis. SOLAP tools allow users to perform spatio-temporal exploration of data: these tools combine OLAP analysis with cartographic visualization capabilities of GIS systems. The relevance of SOLAP technology has been widely recognized in several application domains (e.g., marketing, agriculture, environmental risk management, etc.).
There are a number of reasons to believe that the new technology of spatial DW will play a major role in the field of Geo-Business Intelligence. Today, SDW-related topics concern a large international research community that has been the source of commercial or open source software development. There are still many theoretical and practical research issues to be addressed in order to improve the technology of SDW such as query optimization, spatial data visualization, conceptual modeling, complex spatial data processing, etc., to name a few.
Quite a few of scientific laboratories and a large research community are working on SDW-related areas, but no workshop or special journal issue has focused on the topic of SDW. Thus, the large interest on the SDW-related areas and the scientific relevance of this topic has motivated us to propose a specific Geoinformatica special section dealing with these issues. Four papers have been accepted for publication in this special section. Mobility and uncertain data processing are the two main topics found in these papers.
The paper “A General Framework for Trajectory Data Warehousing and Visual OLAP” present a method for modeling a Trajectory Data Warehouse (TDW). The data warehouse model is sufficiently flexible to deal with different types of mobile objects. The authors cope with issues related to the efficient calculation of aggregate measures. The proposed TDW is provided with an interface to visualize objects inside a given area as well as the movements of objects between different areas. Measures can be aggregated at different level of granularity.
Traditional spatial data warehouses do not support spatial vagueness. In the paper ‘Modeling Vague Spatial Data Warehouses using the VSCube Conceptual Model”, the authors propose a conceptual model named VSCube to store and query shape vagueness in data warehouses. The VSCube conceptual model constitutes an expressive method to represent vague spatial data and spatial aggregation/predicates in SOLAP queries. An application to pest control in agriculture is presented in the paper.
The paper “A probabilistic data model and algebra for location-based data warehouses and their implementation” introduces a probabilistic data model and algebra to represent and query uncertain data in SOLAP. The model allows for using probability distributions in facts/dimensions and an algebra defines how to aggregate uncertain data over uncertain hierarchies. These methods are applied to location-based services. Data warehouses for location-based services often combine complex spatial hierarchies with static and dynamic content, both containing uncertain data. The paper also provides a complexity analysis of the algebra, and reports on an empirical, experimental evaluation of the implementation.
The paper “Context-based mobile GeoBI: Enhancing business analysis with contextual metrics/statistics and context-based reasoning” highlights: the requirement for context-based reasoning in mobile GeoBI; the need for contextual metrics/statistics to help mobile business professionals discover their local context; the need for crossing business performance metrics with contextual metrics to help mobile business professionals in discovering the context hidden behind business performance figures, and proposes convenient solutions to tackle these needs.