Data Warehouse Sizing Calculator

Data Warehouse Sizing Calculator

Since Data Warehouses are optimized for quick and simple reporting, picking the right size for the warehouse is a key component of making the project pay off. This simple calculator will help with that task.

A data warehouse is a specialized database that is optimized for analysis, reporting
and decision support at both the tactical and strategic levels. Data warehouses make
sense because the data in production systems — such as ERP systems —
is stored and managed in ways that make analysis difficult.
Creating new reports is therefore a time-consuming process that requires highly trained
programmers who know how and where to access the required data. In contrast, with a
data warehouse the process of creating new reports is relatively quick and easy, and
can be done by department-level users with no need to involve the IT department.
Sometimes the content of a data warehouse is partitioned by function into
department-specific databases, often referred to as “data marts.”

This Data Warehouse Sizing Calculator helps you estimate the memory size required
for a data warehousing project involving data from as many as 5 business units, each
with as many as 5 relevant DBs, and each DB with as many as 10 relevant fields.

The process for using this calculator is as follows:

Step 1: Determine which business units will be contributing
data.

Step 2: Identify which DBs controlled by that business unit have
relevant data.

Step 3: Within each DB, identify the relevant rows.

Step 4: Determine the average length (number of characters) in each
of these rows.

Step 5: Enter the data.

The attached Zip file includes:

• Intro Page.doc
• Cover Sheet and Terms.pdf
• Data Warehouse Sizing Calculator.xls