DSpace DSpace UPC
 Català   Castellano   English  

E-prints UPC >
Altres >
Enviament des de DRAC >

Empreu aquest identificador per citar o enllaçar aquest ítem: http://hdl.handle.net/2117/9991

Arxiu Descripció MidaFormat
Romero.pdf791.58 kBAdobe PDFThumbnail

Títol: GEM: requirement-driven generation of ETL and multidimensional conceptual designs
Autor: Romero Moral, Óscar Veure Producció científica UPC; Simitsis, Alkis; Abelló Gamazo, Alberto Veure Producció científica UPC
Data: 21-oct-2010
Tipus de document: External research report
Citació: ESSI-TR-10-7
Resum: At the early stages of a data warehouse design project, the main objective is to collect the business requirements and needs, and translate them into an appropriate conceptual, multidimensional design. Typically, this task is performed manually, through a series of interviews involving two different parties: the business analysts and technical designers. Producing an appropriate conceptual design is an errorprone task that undergoes several rounds of reconciliation and redesigning, until the business needs are satisfied. It is of great importance for the business of an enterprise to facilitate and automate such a process. The goal of our research is to provide designers with a semi-automatic means for producing conceptual multidimensional designs and also, conceptual representation of the extract-transform-load (ETL)processes that orchestrate the data flow from the operational sources to the data warehouse constructs. In particular, we describe a method that combines information about the data sources along with the business requirements, for validating and completing –if necessary– these requirements, producing a multidimensional design, and identifying the ETL operations needed. We present our method in terms of the TPC-DS benchmark and show its applicability and usefulness.
Descripció: Technical Report
URI: http://hdl.handle.net/2117/9991
Apareix a les col·leccions:MPI - Modelització i processament d´informació. Reports de recerca
Departament d'Enginyeria de Serveis i Sistemes d'Informació. Reports de recerca
Altres. Enviament des de DRAC

Stats Mostra les estadístiques d'aquest ítem

SFX Query

Aquest ítem (excepte textos i imatges no creats per l'autor) està subjecte a una llicència de Creative Commons Llicència Creative Commons
Creative Commons


Valid XHTML 1.0! Programari DSpace Copyright © 2002-2004 MIT and Hewlett-Packard Comentaris
Universitat Politècnica de Catalunya. Servei de Biblioteques, Publicacions i Arxius