Abstract
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.
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.
Originalsprog | Engelsk |
---|---|
Titel | IEEE 14th International Conference on Mobile Data Management |
Antal sider | 10 |
Vol/bind | 1 |
Forlag | IEEE Computer Society Press |
Publikationsdato | jun. 2013 |
Sider | 283-292 |
ISBN (Trykt) | 978-1-4673-6068-5 |
ISBN (Elektronisk) | 978-0-7695-4973-6 |
DOI | |
Status | Udgivet - jun. 2013 |
Begivenhed | 14th IEEE International Conference on Mobile Data Management - Milan, Italien Varighed: 3 jun. 2013 → 6 jun. 2013 Konferencens nummer: 14 |
Konference
Konference | 14th IEEE International Conference on Mobile Data Management |
---|---|
Nummer | 14 |
Land/Område | Italien |
By | Milan |
Periode | 03/06/2013 → 06/06/2013 |