A Data Warehouse Solution for Analyzing RFID-Based Baggage Tracking Data

Tanvir Ahmed, Torben Bach Pedersen, Hua Lu

Publikation: Bidrag til bog/antologi/rapportKonferencebidrag i proceedingsForskningpeer review


Today, airport baggage handling is far from perfect. Baggage goes on the wrong flights, is left behind, or gets lost, which costs a lot of money for the airlines, as well as frustration for the passengers. To remedy the situation, we present a data warehouse (DW) solution for storing and analyzing spatio-temporal Radio Frequency Identification (RFID) baggage tracking data. Analysis of this data can yield interesting results on baggage flow, the causes of baggage mishandling, and the parties responsible for the mishandling(airline, airport, handler,...), which can ultimately lead to improved baggage handling quality. The paper presents a carefully designed data warehouse (DW), with a relational schema sitting underneath a multidimensional data cube, that can handle the many complexities in the data. The paper also discusses the Extract-Transform-Load (ETL) flow that loads the data warehouse with the appropriate tracking data from the data sources. The presented concepts are generalizable to other types of multi-site indoor tracking systems based on Bluetooth and RFID. The system has been tested with large amount of real-world RFID-based baggage tracking data from a major industry initiative. The developed solution is shown to both reveal interesting insights as well as being several orders of magnitude faster than computing the results directly on the data sources.
Titel2013 IEEE 14th International Conference on Mobile Data Management, Milan, Italy, June 3-6, 2013 - Volume 1
Antal sider10
ForlagIEEE Computer Society Press
ISBN (Trykt)978-0-7685-4973-6
StatusUdgivet - 2013
Udgivet eksterntJa
Begivenhed14th IEEE International Conference on Mobile Data Management - Milano, Italien
Varighed: 3 jun. 20136 jun. 2013
Konferencens nummer: 14


Konference14th IEEE International Conference on Mobile Data Management

Citer dette