Data Volume Example

Customer(C#, Name, Address, City, State, Zip)

Order(O#, C#, Odate)

OrderItem(O#, P#, Quantity, SalePrice)

Row: 4 + 15 + 25 + 20 + 2 + 10 = 76

Row: 4 + 4 + 8 = 16

Row: 4 + 4 + 4 + 8 = 20

• Business rules

  • Three year retention.
  • 1000 customers.
  • Average 10 orders per customer per year.
  • Average 5 items per order.

• Customer 76 * 1000 76,000

• Order 16 * 30,000 480,000

• OrderItem 20 * 150,000 3,000,000

• Total 3,556,000

前一張投影片

回到第一張投影片

檢視圖形版本