More

    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

    Latest Articles