A Motivating Example

• Star Schema

  • Based on TPC-D(Scale Factor: 1)
  • 4 Dimension Tables
    • PART
    • SUPPLIER
    • CUSTOMER
    • TIME
  • 1 Fact Table
    • SALES

PART

PartKey 4

Name 55

Mfgr 25

Brand 10

Type 25

Size 4

Others... 41

164

200,000

CUSTOMER

CustKey 4

Name 25

Address 40

Nation 25

Region 25

Phone 15

AcctBal 8

MktSegment 10

Comment 117

269

150,000

SUPPLIER

SuppKey 4

Name 25

Address 40

Nation 25

Region 25

Phone 15

AcctBal 8

Comment 101

243

10,000

TIME

TimeKey 2

Alpha 10

Year 4

Month 4

Week 4

Day 4

28

2,557

SALES

PartKey 4

SuppKey 4

CustKey 4

Quantity 8

ExtPrice 8

Discount 8

Tax 8

RetFlag 1

Status 1

ShipDate 2

CommitDate 2

ReceiptDate 2

ShipInstruct 25

ShipMode 10

Comment 44

137

6,000,000

Previous slide

Next slide

Back to first slide

View graphic version