Data Volume

• Estimate the total size of the database.

  • Current.
  • Future growth.
  • Guide for hardware and software purchases.

• For each table.

  • Use data types to estimate the number of bytes used for each row.
  • Multiply by the estimated number of rows.

• Add the value for each table to get the total size.

• For concatenated keys (and similar tables).

  • OrderItems(O#, Item#, Qty)
  • Hard to “know” the total number of items ordered.
    • Start with the total number of orders.
    • Multiply by the average number of items on a typical order.

• Need to know time frame or how long to keep data.

  • Do we store all customer data forever?
  • Do we keep all orders in the active database, or do we migrate older ones?

前一張投影片

下一張投影片

回到第一張投影片

檢視圖形版本