Institutional Repository
Institutional Repository Institutional Repository Login  Institutional Repository  
  • UOC Library |
  •  |
  •  |

Home >
Academics >
IT, Multimedia and Telecommunications >
Computer Science >
Bachelor thesis, research projects, etc. >

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
Authors: Aixut Cavero, Teresa
Director: Martín Carballo, José Ángel
Other: Universitat Oberta de Catalunya
Keywords: Data Warehouse
ETL
Oracle
Discoverer
Formula 1
Issue Date: 13-Jun-2010
Publisher: Universitat Oberta de Catalunya
Type: Bachelor Thesis
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.


Add This:

RefWorks:

Ratings:
  0 (0 valuations)


Files in This Item:

File Description SizeFormat
memoria.pdfmemoria1.18 MBAdobe PDFPreview  Download
presentacio.flvpresentacio50.15 MBflvPreview  Download

Author names in Twitter


Author names in FriendFeed



Recommend this item

SFX Query

This item is licensed under a Creative Commons License
Creative Commons

Items in Repository e are protected by copyright, with all rights reserved, unless otherwise indicated.

 

The library replies
A product of the Universitat Oberta de Catalunya Virtual Library