Designing relational data warehouses through schema-transformation primitives : prototype

Abstract

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.