A Real-Time Data Warehouse Solution for Analysis on Indoor Tracking Data
Student thesis: Master Thesis and 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.
Language | English |
---|---|
Publication date | 2009 |
Number of pages | 66 |
Publishing institution | Aalborg Universitet |