Pocket Guide to Data Warehousing

Price: $19.95

BI expert and SQL Server Magazine author Michelle Poolet covers a myriad of topics in this downloadable guide. You’ll learn about the characteristics and benefits of implementing a star schema in your organization. Plus, you’ll discover the differences between dimensional and entity relationship data warehouse models, and how to design and use essential data warehouse components, including fact tables and dimensions. More advanced topics are covered as well, including dimensions (e.g., slowly changing, rapidly changing, junk, degenerate), the benefits of using dimensional role-playing in a star schema, and how to horizontally partition a fact table. You’ll also uncover how to determine which type of data warehouse you have and which workloads it uses.

Table of Contents:

  • Discover the Star Schema
  • Measuring the Facts
  • Dimension Basics
  • The Data Warehouse Bus Architecture
  • Dimensional Role-Playing
  • Slowly Changing Dimensions
  • Rapidly Changing Monster Dimensions
  • Junk Dimensions
  • Degenerate Dimensions
  • Many-to-Many Relationships in the Data Warehouse
  • Indexing the Data Warehouse: Data Warehouse Workloads and Use Cases
Your Shopping Cart

Sponsored Introduction Continue on to (or wait seconds) ×