Home | Previous Page | Next Page Dimensional Databases >

Implementing a Dimensional Database (XPS)

In This Chapter

Implementing the sales_demo Dimensional Database

Using CREATE DATABASE

Using CREATE TABLE for the Dimension and Fact Tables

Mapping Data from Data Sources to the Database

Loading Data into the Dimensional Database

Creating the sales_demo Database

Testing the Dimensional Database

Logging and Nonlogging Tables in Extended Parallel Server

Choosing Table Types

Scratch and Temp Temporary Tables

Raw Permanent Tables

Static Permanent Tables

Operational Permanent Tables

Standard Permanent Tables

Switching Between Table Types

Indexes for Data-Warehousing Environments

Using GK Indexes in a Data-Warehousing Environment

Defining a GK Index on a Selection

Defining a GK Index on an Expression

Defining a GK Index on Joined Tables

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]