Find an IT Download

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.

237 KB | 3 files | null DOC,null XLS,null PDF

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


Recent IT Downloads
Building a GRC Program: Assessing Stakeholder Needs and Readiness

This table outlines the top needs of each stakeholder group that can help guide your conversat...Read More

Recent IT Downloads
Guide to Cyber Threat Information Sharing

This publication provides guidelines for establishing and participating in cyber threat inform...Read More

Recent IT Downloads
Colocation Checklist

This checklist will help make sure you ask the important questions that will affect your coloc...Read More

Recent IT Downloads
Trustworthy Email

This document provides recommendations and guidelines for enhancing trust in email, including ...Read More