Data Warehouse Schema DesignA data warehouse is an integrated database primarily used in organizational decision making. Although the deployment of data warehouses is current practise in the modern information technology landscapes, the methodical schema design for such databases has only been studied cursorily." |
Contents
Introduction | 1 |
1 | 51 |
Conceptual Data Warehouse Design | 109 |
Logical Data Warehouse Design | 141 |
Summary and Further Remarks | 203 |
Index 217 | 210 |
Common terms and phrases
1MNF 3MNF Account AccountID aggregation attr(R autonomously computable auxiliary views Balance BalanceClass Band base relation complementary views conceptual schema Consistency Check contains context dependency context of validity cube CustomerID CustomerType d₁ d₂ data model data warehouse design data warehouse schema data warehousing database schema defined Definition denote derivation design process dimension schema discriminating level domain example expression fact schema foreign key functional dependencies GMNF implies independence ISBN l₁ lattice Lemma logical logical schema mandatory measures monotonic complement Moreover multidimensional data model multidimensional database multidimensional normal forms NFDs null values OLAP operational databases optional dimension levels OrgID property attributes queries R₁ recall relation schemata requirement analysis respect scenario schema F self-maintainability set of views sources specification sub-classes Subsection Table terminal dimension levels Theorem third normal form tuple Universität update update-independent V₁ V₂ view instance view inverse warehouse attributes