Physical Modeling of Data Warehouses Using UML Component and Deployment Diagrams: Design and Implementation Issues
Por favor, use este identificador para citar o enlazar este ítem:
http://hdl.handle.net/10045/105193
Título: | Physical Modeling of Data Warehouses Using UML Component and Deployment Diagrams: Design and Implementation Issues |
---|---|
Autor/es: | Luján-Mora, Sergio | Trujillo, Juan |
Grupo/s de investigación o GITE: | Lucentia | Advanced deveLopment and empIrical research on Software (ALISoft) |
Centro, Departamento o Servicio: | Universidad de Alicante. Departamento de Lenguajes y Sistemas Informáticos |
Palabras clave: | Data warehouse | Configuration | Deployment | Component | UML | Physical design implementation |
Área/s de conocimiento: | Lenguajes y Sistemas Informáticos |
Fecha de publicación: | abr-2006 |
Editor: | IGI Global |
Cita bibliográfica: | Journal of Database Management. 2006, 17(2): 12-42. doi:10.4018/jdm.2006040102 |
Resumen: | Several approaches have been proposed to model different aspects of a Data Warehouse (DW) during recent years, such as the modeling of a DW at the conceptual and logical level, the design of the ETL (Extraction, Transformation, Loading) processes, the derivation of the DW models from the enterprise data models, and customization of a DW schema. At the end of the design, a DW has to be deployed in a database environment, requiring many decisions of a physical nature. However, few efforts have been dedicated to the modeling of the physical design of a DW from the early stages of a DW project. In this article, we argue that some physical decision can be taken from gathering main user requirements. In this paper, we present physical modeling techniques for DWs using the component diagrams and deployment diagrams of the Unified Modeling Language (UML). Our approach allows the designer to anticipate important physical design decisions that may reduce the overall development time of a DW such as replicating dimension tables, vertical and horizontal partitioning of a fact table, and the use of particular servers for certain ETL processes. Moreover, our approach allows the designer to cover all main design phases of DWs, from the conceptual modeling phase to the final implementation. To illustrate our techniques, we show a case study that is implemented on top of a commercial DW management server. |
Patrocinador/es: | This work has been partially supported by the METASIGN project (TIN2004-00779) from the Spanish Ministry of Education and Science. |
URI: | http://hdl.handle.net/10045/105193 |
ISSN: | 1063-8016 (Print) | 1533-8010 (Online) |
DOI: | 10.4018/jdm.2006040102 |
Idioma: | eng |
Tipo: | info:eu-repo/semantics/article |
Derechos: | © 2006, IGI Global |
Revisión científica: | si |
Versión del editor: | https://doi.org/10.4018/jdm.2006040102 |
Aparece en las colecciones: | INV - LUCENTIA - Artículos de Revistas INV - ALISoft - Artículos de Revistas |
Archivos en este ítem:
Archivo | Descripción | Tamaño | Formato | |
---|---|---|---|---|
Lujan-Mora_etal_2006_JDatabaseManag_preprint.pdf | Preprint (acceso abierto) | 1,09 MB | Adobe PDF | Abrir Vista previa |
Lujan-Mora_etal_2006_JDatabaseManag_final.pdf | Versión final (acceso restringido) | 2,41 MB | Adobe PDF | Abrir Solicitar una copia |
Todos los documentos en RUA están protegidos por derechos de autor. Algunos derechos reservados.