A Comprehensive Method for Data Warehouse Design
Por favor, use este identificador para citar o enlazar este ítem:
http://hdl.handle.net/10045/77428
Título: | A Comprehensive Method for Data Warehouse Design |
---|---|
Autor/es: | Luján-Mora, Sergio | Trujillo, Juan |
Grupo/s de investigación o GITE: | Advanced deveLopment and empIrical research on Software (ALISoft) | Lucentia |
Centro, Departamento o Servicio: | Universidad de Alicante. Departamento de Lenguajes y Sistemas Informáticos |
Palabras clave: | Data warehouse | Multidimensional modeling | Design methods | UML |
Área/s de conocimiento: | Lenguajes y Sistemas Informáticos |
Fecha de publicación: | 8-sep-2003 |
Editor: | RWTH Aachen University |
Cita bibliográfica: | Lujan-Mora, Sergio; Trujillo, Juan. “A Comprehensive Method for Data Warehouse Design”. En: Lenz, Hans-J., et al. (Eds.). Design and Management of Data Warehouses 2003: Proceedings of the 5th Intl. Workshop DMDW'2003, Berlin, Germany, September 8, 2003. (CEUR Workshop Proceedings; 77) |
Resumen: | A data warehouse (DW) is a complex information system primarily used in the decision making process by means of On-Line Analytical Processing (OLAP) applications. Although various methods and approaches have been presented for designing different parts of DWs, such as the conceptual and logical schemas or the Extraction-Transformation-Loading (ETL) processes, no general and standard method exists to date for dealing with the whole design of a DW. In this paper, we fill this gap by presenting a method based on the Unified Modeling Language (UML) that allows the user to tackle all DW design phases and steps, from the operational data sources to the final implementation and including the definition of the ETL processes. The main advantages of our proposal are: the use of a standard modeling notation (UML) in the models accomplished in the different design phases, the integration of different design phases in a single and coherent framework and the use of a grouping mechanism (UML packages) that allows the designer to layer the models according to different levels of detail. Finally, we also provide a set of steps that guide the DW design. |
Patrocinador/es: | This paper has been supported by a grant from the State Secretary of Education and Universities (Spanish Ministry of Education, Culture and Sport). |
URI: | http://hdl.handle.net/10045/77428 |
ISSN: | 1613-0073 |
Idioma: | eng |
Tipo: | info:eu-repo/semantics/conferenceObject |
Derechos: | © 2003 for the individual papers by the papers' authors. Copying permitted for private and scientific purposes. Re-publication of material on this page requires permission by the copyright owners. |
Revisión científica: | si |
Versión del editor: | http://ceur-ws.org/Vol-77/ |
Aparece en las colecciones: | INV - LUCENTIA - Comunicaciones a Congresos, Conferencias, etc. INV - ALISoft - Comunicaciones a Congresos, Conferencias, etc. |
Archivos en este ítem:
Archivo | Descripción | Tamaño | Formato | |
---|---|---|---|---|
comprehensive-method-data-warehouse-design.pdf | 322,1 kB | Adobe PDF | Abrir Vista previa | |
Todos los documentos en RUA están protegidos por derechos de autor. Algunos derechos reservados.