How do you size a data warehouse?

Question

The data warehouse size = the sum of the table sizes. However, most people include all of the rest of the database objects — indexes, logs, mirrored volumes, etc — in their “size” calculations, making their data warehouse “size” much larger than their data population.

What is the average size of a data warehouse?

Today, the average size of a modern data warehouse is pushing 100 terabytes — enough to contain all warehouses on the planet in 1990. (The first 1 terabyte data warehouse was achieved in 1991 by Wal-mart.)

How do you estimate data size?

We can roughly estimate the size of a small/medium/large dimension based on the KB per row, like this:1Small: 1 KB/row x 1000 rows = 1 MB.2Medium: 5 KB/row x 100k rows = 500 MB.3Large: 10 KB/row x 1m rows = 10 GB.

How many dimensions are there in data warehouse?

In data warehousing there are 6 types of dimension: Normal dimension. Junk dimension. Split dimension.

What are the dimensions of warehousing?

In a data warehouse, dimensions provide structured labeling information to otherwise unordered numeric measures. The dimension is a data set composed of individual, non-overlapping data elements. The primary functions of dimensions are threefold: to provide filtering, grouping and labelling.

Expert · Answer