João Mendes Moreira
INEGI – Instituto de Engenharia Mecânica e Gestão Industrial e Faculdade de Engenharia da Universidade do Porto

Jorge Freire de Sousa
INEGI – Instituto de Engenharia Mecânica e Gestão Industrial e Faculdade de Engenharia da Universidade do Porto

Abstract: This paper describes the methodology used in the construction of a Data Warehousing project to support planning and control on mass transit companies. The data sources used were the ones from the GIST98/EUROBUS system - a computer application for supporting operational planning in public transport companies. Firstly, the main Data Warehousing concepts and definitions are introduced. After the problem description and a brief analysis of different Data Warehousing methodologies, the analysis and development phases of the Data Warehousing project are presented. Finally, in the conclusions, the main advantages to implement such a system in the situation described are emphasized.

Keywords: Data Warehousing, OLAP, Mass Transit, Transportation Management.