Available under a Creative Commons Attribution Non-Commercial Share Alike 4.0 International Licence
Most urban bus operators collect detailed data on their respective transportation networks using electronic fare collection systems. However, contrary to the opinion of other service industries that this data is a valuable resource, many bus operators have tended not to fully utilise these resources. International experience suggests using innovative technologies and methodologies such as data warehousing, Online Analytical Processing (OLAP), and data mining, to derive the maximum benefit from this data. Still bus operators tend not to keep the full range of data in a form, which is easy to access or utilise, and therefore, are not able to apply these technologies. The aim of the research project on which this paper reports is to describe the initial data structure of an electronic fare collection system (installed by a public transport operator in Ireland), the storage and enrichment of that data in a relational database, and finally, the representation of the public transport data in a data warehouse. This data warehouse forms the basis of all future data analysis. A 4-phase framework describes the import process leading to a relational database storing the transactional data. The paper concludes with the development of a data warehouse using the star schema.
Hofmann, Markus; Tierney, Brendan; and O'Mahony, Margaret M., "A Framework to Utilise Urban Bus Data for Advanced Data Analysis" (2003). Conference papers. 294.