How to Estimate the Size of a Database With Volumetrics

Written by alexander gokhfeld
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Estimate the Size of a Database With Volumetrics
Database storage needs must be estimated in advance. (database on paper image by .shock from Fotolia.com)

Database designers need to estimate the size of a future database to allow sufficient disk space to store data. Volumetric data help to predict the size of a database, based on the current business activity and forecast of future growth. They are used to make decisions about necessary hardware and database storage design. Volumetric information, stored in a database, can show the expected rate of storage expansion.

Skill level:
Easy

Other People Are Reading

Instructions

  1. 1

    Multiply the total number of fixed-length columns by their byte size to calculate the space that is required for storage of fixed-length columns.

  2. 2

    Multiply the total number of variable-length columns by maximum total byte size of all variable-length columns to calculate the space that is required for storage of variable-length columns.

  3. 3

    Add the total byte size required for storage of variable-length columns and the number of variable-length columns multiplied by 2 to calculate the variable-length data size. Add total byte size required for storage of fixed-length columns and total byte size required for storage of variable-length columns to calculate the total row size.

  4. 4

    Divide "8096" by the total row size to calculate the number of rows per page. Divide the number of rows by the number of rows per page to calculate the number of pages required to store all the rows.

  5. 5

    Multiply the number of pages by "8192" to calculate the amount of space required to store the data in the database file.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.