Herramienta CASE DWH-Inspector para el análisis de almacenes de datos
Fecha
2010-06-26
Autores
Gálvez Díaz, Ashley
Torres Portal, Pedro Luí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 Copo de Nieve, 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 primera versió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 automatizado 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.
The Analysis and Modeling for Data Warehouses, specifically applying the Star Model or Snowflake Model, in several occasions is complicated, since are not possessed commercial tools that generate these models appropriately for the warehouse from legacy information systems that generally exist based on the relational model. Keeping in mind this difficulty, in this work thinks about the creation of a first version of a CASE-tool for Analysis and Design of information systems for the decisions support, that facilitates the work of analysts, programmers and users, when revising automated the meta-structural of the existent Relational Databases, and to propose a optimal dimensional structure for the Warehouse. This software should be simple for using, until for the users that don't have the whole knowledge and experience required on the topic.
The Analysis and Modeling for Data Warehouses, specifically applying the Star Model or Snowflake Model, in several occasions is complicated, since are not possessed commercial tools that generate these models appropriately for the warehouse from legacy information systems that generally exist based on the relational model. Keeping in mind this difficulty, in this work thinks about the creation of a first version of a CASE-tool for Analysis and Design of information systems for the decisions support, that facilitates the work of analysts, programmers and users, when revising automated the meta-structural of the existent Relational Databases, and to propose a optimal dimensional structure for the Warehouse. This software should be simple for using, until for the users that don't have the whole knowledge and experience required on the topic.
Descripción
Palabras clave
Almacenes de Datos, Modelado Dimensional, Data Warehouse, Dimensional Model