Please use this identifier to cite or link to this item:

http://hdl.handle.net/10609/2342
Title: Construcció i explotació d'un magatzem de dades per a l'anàlisi estadístic dels resultats del Campionat de Fórmula 1
Author: Aixut Cavero, Teresa
Director: Martín Carballo, José Ángel
Others: Universitat Oberta de Catalunya
Keywords: Magatzem de dades;Almacén de datos;Data Warehouse;ETL;Oracle;Discoverer;Fórmula 1;ETL;Oracle;Discoverer;Fórmula 1;ETL;Oracle;Discoverer;Formula 1
Issue Date: 13-Jun-2010
Publisher: Universitat Oberta de Catalunya
Abstract: In recent years organizations have become aware of the importance of managing their information. Data Warehousing intends to help by organizing data in a coherent and efficient way to ease its analysis. The project "Construction and operation of a data warehouse for statistical analysis of the results of the Championship of Formula 1" is set within this context and aims to design a data warehouse to meet the needs of the Institut Català d'Esports Motor (ICEM) in the management of data relating to Formula 1. The different steps for the creation of a new data warehouse have been executed. First, the analysis of requirements and available data has been conducted. In the second step the data store has been designed and it's been implemented physically. Then it has been proceeded with the extraction, transformation and loading of the original data (ETL). Finally, series of reports have been created. As a result the users of ICEM have at their disposal a group of reports ready to be consulted. These reports will simplify the analysis of data making the whole process more agile. It has also been implemented an automatic update system data for maintaining the information up to date in the data store. The implementation of data warehouse has been done on an Oracle Database 10g Express Edition and reports have been designed with Oracle Discoverer tool. For the data updating system it has been used visual basic script and the loading tool SQL * Loader.
Language: Catalan
URI: http://hdl.handle.net/10609/2342
Appears in Collections:Bachelor thesis, research projects, etc.

Share:
Export:
Files in This Item:
File Description SizeFormat 
memoria.pdfmemoria1.18 MBAdobe PDFView/Open
presentacio.flvpresentacio50.15 MBflvView/Open

This item is licensed under a Creative Commons License Creative Commons