scispace - formally typeset
Proceedings ArticleDOI

A generic data model and query language for spatiotemporal OLAP cube analysis

Reads0
Chats0
TLDR
This is the first proposal that allows analyzing discrete and continuous spatiotemporal data and OLAP cubes together, using just the traditional OLAP operations, thus providing a very general framework for spatiotmporal data analysis.
Abstract
Nowadays, organizations need to use OLAP (On Line Analytical Processing) tools together with geographical information. To support this, the notion of SOLAP (Spatial OLAP) arouse, aimed at exploring spatial data in the same way as OLAP operates over tables. SOLAP however, only accounts for discrete spatial data. More sophisticated GIS-based decision support systems are increasingly being needed, to handle more complex types of data, like continuous fields. Fields describe physical phenomena that change continuously in time and/or space (e.g., temperature). Although many models have been proposed for adding spatial information to OLAP tools, no one allows the user to perceive data as a cube, and analyze any type of spatial data, continuous or discrete, together with typical alphanumerical discrete OLAP data, using only the classic OLAP operators (e.g., Roll-up, Drill-down). In this paper we propose an algebra that operates over data cubes, independently of the underlying data types and physical data representation. That means, in our approach, the final user only sees the typical OLAP operators at the query level. At lower abstraction levels we provide discrete and continuous spatial data support as well as different ways of partitioning the space. We also describe a proof-of-concept implementation to illustrate the ideas presented in the paper. As far as we are aware of, this is the first proposal that allows analyzing discrete and continuous spatiotemporal data and OLAP cubes together, using just the traditional OLAP operations, thus providing a very general framework for spatiotemporal data analysis.

read more

Citations
More filters
BookDOI

Data Warehouse Systems: Design and Implementation

TL;DR: Students, practitioners and researchers alike will find this book the most comprehensive reference work on data warehouses, with key topics described in a clear and educational style.
Book ChapterDOI

Interacting with Statistical Linked Data via OLAP Operations

TL;DR: This work investigates the problem of executing OLAP queries via SPARQL on an RDF store and defines projection, slice, dice and roll-up operations on single data cubes published as Linked Data reusing the RDF Data Cube vocabulary and shows how a nested set of operations lead to an OLAP query.
Journal ArticleDOI

Scalable graph-based OLAP analytics over process execution data

TL;DR: A model for process OLAP (P-OLAP) is presented and OLAP specific abstractions in process context such as process cubes, dimensions, and cells are defined and a MapReduce-based graph processing engine is presented, to support big data analytics over process graphs.

QB4OLAP: A new vocabulary for olap cubes on the semantic web

TL;DR: This work proposes a new vocabulary, denoted QB4OLAP, which extends QB to fully support OLAP models and operators, and provides algorithms that build the structures that allow performing both kinds of analysis, and shows that compatibility between QB and QB4 OLAP can be achieved at low cost.
Journal ArticleDOI

Industrial Internet of Things-Based Collaborative Sensing Intelligence: Framework and Research Challenges.

TL;DR: This study proposes a collaborative sensing intelligence (CSI) framework, combining collaborative intelligence and industrial sensing intelligence, and facilitates the cooperativity of analytics with integrating massive spatio-temporal data from different sources and time points.
References
More filters
Book

The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling

Ralph Kimball, +1 more
TL;DR: Greatly expanded to cover both basic and advanced techniques for optimizing data warehouse design, this second edition to Ralph Kimball’s classic guide is more than sixty percent updated.

GIS : a computing perspective

TL;DR: A Brief History of Time Temporal Information Systems Spatiotemporal Information systems Indexes and Queries Appendices.
Proceedings ArticleDOI

Modeling multidimensional databases

TL;DR: A data model and a few algebraic operations that provide semantic foundation to multidimensional databases and provide an algebraic application programming interface (API) that allows the separation of the front end from the back end are proposed.
Proceedings Article

A Foundation for Multi-dimensional Databases

TL;DR: A multi-dimensional database model is presented, which is believed to serve as a conceptual model for On-Line Analytical Processing (OLAP)-based applications and it is shown that the data cube operator can be expressed easily.
Proceedings ArticleDOI

Modeling multidimensional databases, cubes and cube operations

TL;DR: This work proposes a model for multidimensional databases, based on the notion of the base cube, which is used for the calculation of the results of cube operations, and provides a mapping of the multid dimensional model to the relational model and to multiddimensional arrays.
Related Papers (5)