Part I: Fundamentals


Chapter List

Chapter 1: Basic Components
Chapter 2: Dimension History
Chapter 3: Measure Additivity
Chapter 4: Dimensional Queries

Part Overview

You implement a dimensional data warehouse using a relational database. Two types of relational tables, the fact table and the dimension table, make up the basic components and form the schema of a data warehouse. You will build these basic components in a MySQL database in the first part of this book.

More specifically, Part I covers the following five primary topics:

  • The star schema

  • Surrogate keys

  • Dimension history

  • Fact table measure additivity

  • Dimensional queries



Dimensional Data Warehousing with MySQL. A Tutorial
Dimensional Data Warehousing with MySQL: A Tutorial
ISBN: 0975212826
EAN: 2147483647
Year: 2004
Pages: 149

Similar book on Amazon
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (Second Edition)
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (Second Edition)
The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleanin
The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleanin
Successful Business Intelligence: Secrets to Making BI a Killer App
Successful Business Intelligence: Secrets to Making BI a Killer App

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net