Sciweavers

Share
CAISE
2003
Springer

Towards the Automation of Data Warehouse Logical Design: a Rule-Based Approach

9 years 3 months ago
Towards the Automation of Data Warehouse Logical Design: a Rule-Based Approach
Data Warehouse logical design involves the definition of structures that enable an efficient access to information. The designer builds relational or multidimensional structures taking into account a conceptual schema representing the information requirements, the source databases, and non-functional requirements. Existing work in this area has mainly focused on aspects like data models, data structures specifically designed for DWs, and criteria for defining table partitions and indexes. This paper proposes a step forward to the automation of DW relational design through a rule-based mechanism, which automatically generates the DW schema by applying existing DW design knowledge. The proposed rules embed design strategies which are triggered by conditions on requirements and source databases, and perform the schema generation through the application of predefined DW design oriented transformations. Keywords. Data Warehouse Design, Rule based design.
Verónika Peralta, Alvaro Illarze, Raul Rugg
Added 06 Jul 2010
Updated 06 Jul 2010
Type Conference
Year 2003
Where CAISE
Authors Verónika Peralta, Alvaro Illarze, Raul Ruggia
Comments (0)
books