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 taking into account a conceptual schema representing information requirements, source databases, and non-functional requirements. Existing work in this area has mainly focused on aspects like data models, specifically designed for DWs, criteria defining table partitions indexes. This paper proposes step forward automation DW through rule-based mechanism, which automatically generates by applying existing knowledge. proposed rules embed strategies are triggered conditions requirements perform generation application predefined oriented transformations.