A Real-Time Data Warehouse Solution for Analysis on Indoor Tracking Data

Student thesis: Master thesis (including HD thesis)

  • Jonas Hansen
  • Stig Jørgensen
4. term, Software, Master (Master Programme)
This project concerns the design and implementation of a real-time data warehouse for analysis on tracking data collected at Copenhagen Airports A/S. The project is done in cooperation with BLIP Systems A/S, who has a Bluetooth based tracking system installed in Copenhagen Airports A/S. First, we describe how BLIP Systems A/S stores the collected tracking data and propose a data warehouse design that enables answering some business intelligence related questions. As a part of the capture, transform, and flow, some data cleansing has been performed on the source data. Additionally, we introduce two case-specific algorithms, ValidMoves and BounceDetection, which normalizes the tracking data. By utilizing custom applications and Microsoft Analysis Server, we address some of the questions presented and provide answers through views and GUIS. We conclude on the project and suggests directions for further work. Last, the report contains a summary in Appendix C.
LanguageEnglish
Publication date2009
Number of pages66
Publishing institutionAalborg Universitet
ID: 17989172