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 6th 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
]]>