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:
Other People Are Reading
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.
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.
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.
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.
Multiply the number of pages by "8192" to calculate the amount of space required to store the data in the database file.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for