TPC-D Schema

Customer

SF*150K

LineItem

SF*6000K

Order

SF*1500K

Supplier

SF*10K

Nation

25

Region

5

PartSupp

SF*800K

Part

SF*200K

Time

2557

Legend:

• Arrows point in the direction of one-to-many relationships.

• The value below each table name is its cardinality. SF is the Scale Factor.

• The Time table is optional. So far, not used by anyone.

Previous slide

Next slide

Back to first slide

View graphic version