Herramienta case “asistente-dw’’ para el análisis y diseño de almacenes de datos
Fecha
2012-06-26
Autores
Alvarez Alfonso, Jesús
Título de la revista
ISSN de la revista
Título del volumen
Editor
Universidad Central “Marta Abreu” de Las Villas
Resumen
El trabajo de Análisis y Modelado para Almacenes de Datos, específicamente
aplicando el Modelo Estrella o el de Constelación de estrellas, en varias ocasiones se torna complicado, puesto que no se poseen herramientas comerciales que generen estos modelos adecuadamente para el almacén a partir de sistemas de información legados, que generalmente existen en base al modelo relacional. Teniendo en cuenta esta dificultad se plantea en este trabajo la creación de una herramienta CASE de Análisis y Diseño de sistemas de información para la toma de decisiones, que facilite el trabajo de analistas, implementadores y usuarios, al revisar de forma automática los metadatos estructurales de las Bases de Datos relacionales existentes, y proponer una estructura dimensional óptima para el Almacén. Este software debe ser simple de usar hasta para los usuarios que no tengan todo el conocimiento y experiencia requerido sobre el tema.
Work Analysis and Modeling for Data Warehouses, specifically applying the Model Star or the constellation of stars, repeatedly becomes complicated, since it does not have marketing tools that generate these models adequately for the store from systems information bequests, which are generally, based on the relational model. Given this difficulty arises in this work the creation of a CASE tool for analysis and design of information systems for decision-making, to facilitate the work of analysts, implementers and users to review automated structural metadata Bases existing relational data, and propose an optimal dimensional structure for the Vault. This software should be simple to use even for users who do not have all the knowledge and experience required on the subject.
Work Analysis and Modeling for Data Warehouses, specifically applying the Model Star or the constellation of stars, repeatedly becomes complicated, since it does not have marketing tools that generate these models adequately for the store from systems information bequests, which are generally, based on the relational model. Given this difficulty arises in this work the creation of a CASE tool for analysis and design of information systems for decision-making, to facilitate the work of analysts, implementers and users to review automated structural metadata Bases existing relational data, and propose an optimal dimensional structure for the Vault. This software should be simple to use even for users who do not have all the knowledge and experience required on the subject.
Descripción
Palabras clave
Almacenes de Datos, Modelado Dimensional, Data Warehouse, Dimensional Model