A master thesis from Aalborg University
A Real-Time Data Warehouse Solution for Analysis on Indoor Tracking Data
Author(s)
Term
4. term
Education
Publication year
2009
Submitted on
2009-07-30
Pages
66 pages
Abstract
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.
Keywords
Documents
Colophon: This page is part of the AAU Student Projects portal, which is run by Aalborg University. Here, you can find and download publicly available bachelor's theses and master's projects from across the university dating from 2008 onwards. Student projects from before 2008 are available in printed form at Aalborg University Library.
If you have any questions about AAU Student Projects or the research registration, dissemination and analysis at Aalborg University, please feel free to contact the VBN team. You can also find more information in the AAU Student Projects FAQs.