Railway data warehousing system for booking data analysis

Authors:
Carlo Dell'Aquila;Ezio Lefons;Filippo Tangorra
Affiliations:
Dipartimento di Informatica, Università Bari, Bari, Italy;Dipartimento di Informatica, Università Bari, Bari, Italy;Dipartimento di Informatica, Università Bari, Bari, Italy
Venue:
ICCOMP'05 Proceedings of the 9th WSEAS International Conference on Computers
Year:
2005

Citing 3
Cited 0

Deriving initial data warehouse structures from the conceptual data models of the underlying operational information systems

Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP
Fundamentals of Data Warehouses

Fundamentals of Data Warehouses
Database Technology for Decision Support Systems

Computer

Quantified Score

Hi-index	0.00

Visualization

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.