Applying data warehousing technology to support planning and control on mass transit companies

João Mendes Moreira* and Jorge Freire de Sousa*

*INEGI – Instituto de Engenharia Mecânica e Gestão Industrial

Rua Dr. Roberto Frias s/n; 4200-465 Porto – Portugal

FEUP – Faculdade de Engenharia da Universidade do Porto

Email: jmoreira@fe.up.pt and jfsousa@fe.up.pt,

Tel.:+351-225081639, Fax: +351-225081797

 

 

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

 

Texto completo apenas disponível em PDF.

Full text only in PDF.

 

 

References

[1] Sid Adelman, Joe Oates, Data Warehouse Project Management, Data Management Review, May 1998        [ Links ]

[2] João Falcão e Cunha, Jorge Pinho de Sousa, Teresa Galvão, José Luis Borges., A Decision Support System for the Operational Planning at Mass Transport Companies, presented at the 6^th International Workshop on Computer-Aided Scheduling of Public Transport, July 1993, Lisbon, Portugal.

[3] C. J. Date, An Introduction to Database Systems (6th Edition), Addison-Wesley, 1995

[4] Stephen R. Gardner, Building the Data Warehouse, Communications of the ACM, September 1998

[5] Hadden Company, http://www.hadden-kelly.com, 1999

[6] Inmon W.H., Building the Data Warehouse, Wiley, 1996, pp.33

[7] Ralph Kimball, Laura Reeves, Margy Ross, Warren Thornthwaite, The Data Warehouse Lifecycle Toolkit, Wiley, 1998, pp. 137-314

[8] OLAP Council, http://www.olapcouncil.org/research/glossaryly.htm, 1997

[9] John Onder, Todd Nash, Building a business-driven Data Warehouse, Data Management Review, October 1998

[10] Nigel Pendse, Richard Creeth, The OLAP Report, http://www.olapreport.com, red in October 2000

[11] Neil Raden, Data Modeling – Star Schema 101, http://www.archerdecision.com, 1995/96

[12] João Ranito, seminar presentation at Faculdade de Engenharia da Universidade do Porto, 1999.

[13] Jorge Pinho de Sousa, Jorge Freire de Sousa and Rui Campos Guimarães, Un système informatique d'aide à la génération d'horaires de bus et de chauffeurs, in: Gestion de l'économie et de l'entreprise - l'approche quantitative, Editions CORE, Série Balises, De Boeck, Brussels, 1988, pp. 477-492 (in French).

[14] The Data Warehousing Institute, 1998 Data Warehousing Buyer’s Guide, http://www.institute.com/buyersguide/, 1998

[15] Erik Thomsen, OLAP Solutions, Wiley, 1997, pp. 229-264

[16] Karen Watterson, Attention, Data-Mart shoppers, BYTE Magazine - July 1997

[17] J. D. Welch, http://www.datawing.com/BOOKS_F.HTM, 1998