Railway Data Warehousing System for Booking Data Analysis

Abstract: - The analysis, design, and implementation of the data warehouse system for the decisional process based on the Italian train booking data are presented. Trenitalia, the Italian main train service company, is the customer, and TSF (railway telesystems company) the IT solution provider. In particular, the feasibility requirements, functionality, technical architecture, and product technology are described. Moreover, the guidelines about operational environments interfacing with the data warehouse for data acquisition and elaboration, and related problems are dealt with. With our contribution and the aim of software reuse, the provider has released the prototype system, and, in order to satisfy all the customer’s requests, the entire warehouse’s data marts concerning the project will be completely re-engineered