O'Reilly logo

Microsoft SQL Server 2014 Unleashed by Paul Bertucci, Alex T. Silverstein, Chris Gallelli, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Data on a PDW

Taking a closer look at how data is stored on the PDW, you’ll better understand how this architecture yields the data access speeds it delivers. Looking at Figure 51.3, we will define a typical star schema sales database that contains sales facts (measures) such as Sales Units (A), Sales Amounts (B), and Sales Returns (C). In addition, this star schema has three dimensions: a Product hierarchical dimension, a Geography hierarchical dimension, and a Time dimension. Each fact in the fact tables is identified by all three of these dimensions.

Image

FIGURE 51.3 Sales data facts (measures) and dimensions on the PDW.

Now, as you can also ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required