An Advanced Data Warehouse for Integrating Large Sets of GPS Data

Ove Andersen, Benjamin Bjerre Krogh, Christian Thomsen, Kristian Torp

Research output: Contribution to book/anthology/report/conference proceedingArticle in proceedingResearchpeer-review

2 Citations (Scopus)


GPS data recorded from driving vehicles is available from many sources and is a very good data foundation for answering traffic related queries. However, most approaches so far have not considered combining GPS data from many sources into a single data warehouse. Further, the integration of GPS data with fuel consumption data (from the so-called CAN bus in the vehicles) and weather data has not been done. In this paper, we propose a data warehouse design for handling GPS data, fuel consumption data, and weather data. The design is fully implemented in a running system using the PostgreSQL DBMS. The system has been in production since March 2011 and the main fact table contains today approximately 3.4 billion rows from 16 different data sources. We show that the system can be used for a number of novel traffic related analyses such as relating the fuel consumption of vehicles with the road network and road congestion.
Original languageEnglish
Title of host publicationProceedings of the 17th International Workshop on Data Warehousing and OLAP
Number of pages10
PublisherAssociation for Computing Machinery
Publication date7 Nov 2014
ISBN (Print)978-1-4503-0999-8
Publication statusPublished - 7 Nov 2014
EventInternational Workshop on Data Warehousing and OLAP - , Hong Kong
Duration: 7 Nov 20147 Nov 2014
Conference number: 17


WorkshopInternational Workshop on Data Warehousing and OLAP
CountryHong Kong


  • data warehousing
  • GPS-data
  • integration

Fingerprint Dive into the research topics of 'An Advanced Data Warehouse for Integrating Large Sets of GPS Data'. Together they form a unique fingerprint.

Cite this