Next Article in Journal
Enhanced Drone Navigation in GNSS Denied Environment Using VDM and Hall Effect Sensor
Previous Article in Journal
A Mesh-Based Typification Method for Building Groups with Grid Patterns
Previous Article in Special Issue
Mr4Soil: A MapReduce-Based Framework Integrated with GIS for Soil Erosion Modelling
Article Menu
Issue 4 (April) cover image

Export Article

Open AccessArticle

Mobility Data Warehouses

Department of Information Engineering, Instituto Tecnológico de Buenos Aires, Lavardén 315, C1437FBG Ciudad Autónoma de Buenos Aires, Argentina
Department of Computer & Decision Engineering (CoDE), CP 165/15 Université Libre de Bruxelles, Avenue F. D. Roosevelt 50, B-1050 Brussels, Belgium
Author to whom correspondence should be addressed.
ISPRS Int. J. Geo-Inf. 2019, 8(4), 170;
Received: 9 January 2019 / Revised: 12 March 2019 / Accepted: 29 March 2019 / Published: 2 April 2019
(This article belongs to the Special Issue Distributed and Parallel Architectures for Spatial Data)
PDF [452 KB, uploaded 17 April 2019]


The interest in mobility data analysis has grown dramatically with the wide availability of devices that track the position of moving objects. Mobility analysis can be applied, for example, to analyze traffic flows. To support mobility analysis, trajectory data warehousing techniques can be used. Trajectory data warehouses typically include, as measures, segments of trajectories, linked to spatial and non-spatial contextual dimensions. This paper goes beyond this concept, by including, as measures, the trajectories of moving objects at any point in time. In this way, online analytical processing (OLAP) queries, typically including aggregation, can be combined with moving object queries, to express queries like “List the total number of trucks running at less than 2 km from each other more than 50% of its route in the province of Antwerp” in a concise and elegant way. Existing proposals for trajectory data warehouses do not support queries like this, since they are based on either the segmentation of the trajectories, or a pre-aggregation of measures. The solution presented here is implemented using MobilityDB, a moving object database that extends the PostgresSQL database with temporal data types, allowing seamless integration with relational spatial and non-spatial data. This integration leads to the concept of mobility data warehouses. This paper discusses modeling and querying mobility data warehouses, providing a comprehensive collection of queries implemented using PostgresSQL and PostGIS as database backend, extended with the libraries provided by MobilityDB. View Full-Text
Keywords: mobility; data warehouses; spatiotemporal OLAP; mobility analytics mobility; data warehouses; spatiotemporal OLAP; mobility analytics

Figure 1

This is an open access article distributed under the Creative Commons Attribution License which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited (CC BY 4.0).

Share & Cite This Article

MDPI and ACS Style

Vaisman, A.; Zimányi, E. Mobility Data Warehouses. ISPRS Int. J. Geo-Inf. 2019, 8, 170.

Show more citation formats Show less citations formats

Note that from the first issue of 2016, MDPI journals use article numbers instead of page numbers. See further details here.

Related Articles

Article Metrics

Article Access Statistics



[Return to top]
ISPRS Int. J. Geo-Inf. EISSN 2220-9964 Published by MDPI AG, Basel, Switzerland RSS E-Mail Table of Contents Alert
Back to Top