Chapter 1: Basic Components


Overview

There are two topics you learn in this chapter, the star schema and the surrogate key. The star schema is the database structure of a dimensional data warehouse. A surrogate key is a column you add to a data warehouse table that acts as the primary key for that table.

In this chapter you begin a long journey building a real-world data warehouse. Here are the tasks you will perform in this chapter.

  • Creating a database user

  • Creating a relational database for the data warehouse and another one for the source database

  • Creating database tables for the data warehouse

  • Generating surrogate keys.

You need to create a source database because you don’t have a source for your data warehouse yet. In the real world, this is not necessary because your data warehouse is based on an existing source. You will start using the source database in Part II of this book.



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