Designing relational data warehouses through schema-transformation primitives
Resumen:
A Data Warehouse (DW) is a database that stores information oriented to satisfy decision-making request. It is a database with some particular features concerning the data it contains and its utilisation. The features od DWs cause the DW design process and strategies to be different from the ones for OLTP Systems. We address the DW design problem through a schema transformation approach. We propose a set of schema transformation primitives, which are high-level operations that transform relational sub-schemas into other relational sub-chemas. We also provide some tools that can help in DW design process: (a) the design trace, (b) a set of DW schema invariants, (c) a set of rules that specify how to correct schema-strategies dor designing the DW through application of primitives.
| 2001 | |
|
DATA WAREHOUSE DATA WAREHOUSE DESIGN SCHEMA TRANFORMATION RELATIONAL DATA WAREHOUSE DISEÑO DE DATA WAREHOUSE |
|
| Universidad de la República | |
| COLIBRI | |
| http://hdl.handle.net/20.500.12008/3433 | |
| Acceso abierto | |
| Licencia Creative Commons Atribución – No Comercial – Sin Derivadas (CC BY-NC-ND 4.0) |
Resultados similares
-
Designing relational data warehouses through schema-transformation primitives : prototype
Autor(es):: Gutiérrez, Alejandro
Fecha de publicación:: (2001) -
An overview of data warehouse design approaches and tecbniques
Autor(es):: Gutiérrez, Alejandro
Fecha de publicación:: (2001) -
Resolución de la integración en el diseño del Data Warehouse
Autor(es):: Marotta, Adriana
Fecha de publicación:: (2002) -
Implementación de herramientas CASE que asistan en el diseño de Data Warehouses
Autor(es):: Peralta Costabel, Veronika del Carmen
Fecha de publicación:: (2001) -
Diseño e implementación de una herramienta para la evolución de un DataWarehouse relacional
Autor(es):: Alcarraz, Andrés
Fecha de publicación:: (2001)