File Library

Scaling to Infinity: Making Star Transformations Sing
Topic: The Database
Owner: Tim Gorman
Date: 2013-06-05
Subtopic: Best Practices

Dimensional data models (a.k.a. star schemas) are a crucial component of the presentation layer of data warehouses and data marts, because that is the format in which business-intelligence analysts expect to find their data. Yet, so many decision-support environments based on Oracle attempt to live with star schemas without using star transformations. The reasons vary from lack of understanding to practical impediments related to ETL processing. This presentation will explain the justification for the star transformation mechanism, including comparisons to other execution plans, how to implement, how to optimize, and how to troubleshoot.

Three Things Attendees will learn:

1. Why dimensional data models are crucial in data warehousing
2. Using star-joins and star-transformation joins in a dimensional data model
3. How to improve on star-transformation joins using bitmap-join indexes

Download File   TGorman KScope2013 StarTransform 20130625.pdf
Download File   Waterbury Session 09.mp4

Become a member of ODTUG to gain access to more than 12,500 files in our technical database.

  • Not a member? Click through to the topic of interest to browse a list of available presentations.
  • Already a member? Log-in here to access the full database

Click here to see the Full Techincal Resource Database