The TPC-DS schema is a snowflake schema. It consists of multiple dimension and fact tables. Each dimension has a single column surrogate key. The fact tables join with dimensions using each dimension table's surrogate key.
The schema includes seven fact tables:
Type | Name | Abbreviation |
---|---|---|
Fact | Store Sales | SS |
Fact | Store Returns | SR |
Fact | Catalog Sales | CS |
Fact | Catalog Returns | CR |
Fact | Web Sales | WS |
Fact | Web Returns | WR |
Fact | Inventory | INV |
In addition, the schema includes 17 dimension tables that are associated with all sales channels. The following clauses specify the logical design of each table:
Type | Name | Abbreviation |
---|---|---|
Dimension | Store | S |
Dimension | Call Center | CC |
Dimension | Catalog Page | CP |
Dimension | Web Site | WEB |
Dimension | Web Page | WP |
Dimension | Warehouse | W |
Dimension | Customer | C |
Dimension | Customer Address | CA |
Dimension | Customer Demographics | CD |
Dimension | Date Dim | D |
Dimension | Household Demographics | D |
Dimension | Item | I |
Dimension | Income Band | IB |
Dimension | Promotion | P |
Dimension | Reason | R |
Dimension | Ship Mode | SM |
Dimension | Time Dim | T |
Dimension | dsdgen_version | NA |