Designing relational data warehouses through schema-transformation primitives : prototype

The logical design of a Data Warehouse (DW) is a task that requires the application of techniques and strategies that are specific of DW context. In [Mar00] we present a mechanism for designing DWs. Based in this mechanism we developed a prototype of a DW design tool. This tool offers, a graphical u...

Descripción completa

Detalles Bibliográficos
Autores: Gutiérrez, Alejandro, Marotta, Adriana
Tipo de recurso: informe técnico
Estado:Versión publicada
Fecha de publicación:2001
País:Uruguay
Institución:Universidad de la República
Repositorio:COLIBRI
OAI Identifier:oai:colibri.udelar.edu.uy:20.500.12008/3557
Acceso en línea:http://hdl.handle.net/20.500.12008/3557
Access Level:acceso abierto
Palabra clave:DATA WAREHOUSE
DATA WAREHOUSE DESIGN
SCHEMA TRANFORMATION
RELATIONAL DATA WAREHOUSE
DISEÑO DE DATA WAREHOUSE
Descripción
Sumario:The logical design of a Data Warehouse (DW) is a task that requires the application of techniques and strategies that are specific of DW context. In [Mar00] we present a mechanism for designing DWs. Based in this mechanism we developed a prototype of a DW design tool. This tool offers, a graphical user interface that allows the designer to apply transformation primitives to a source schema constructing a DW schema, visualise the generated transformation trace, check DW schema invariants and apply consistency rules.