Active Data Warehouse

Product Focus

Design DataWarehousing applications real-time, with out-of-the-box functionality in regard to Star Schemas, Data mapping, and Warehouse Performance.

Product Description

ActiveDataWarehouse provides a means of creating DataWarehouse functionality for new or existing database applications, out-of-the-box.

Product Architecture

The solution architecture is highly scalable. It can support hundreds of users and thousands of devices. It has multiple options to support active-active or active-passive architectures.

  • Database Compatibility:

    Oracle

    SQL Server

    DB2

  • Operating System Compatibility:

    Windows95/98/ME

    WindowsNT/2000 client connecting to ANY Database on the corporate network

  • Technical Requirements:

    Pentium 100MHz or higher

    10MB hard disk space

    64 MB RAM (128 MB recommended).

Benefits

  • Creating data mapping strategies quickly
  • Ability to build a list of candidate Star Schemas for any existing database application.
  • Real-time designer allows the designer o test the DataWarehouse design in terms of sizing, stress and performance
  • Integrate the custom DataWarehouse with other corporate applications to build a true enterprise-wide DataWarehouse

Application Area

  • Iterative DataWarehouse designs for rapid implementation
  • Enterprise with a large IT infrastructure with several applications and databases with integrated Warehousing requirement
  • Improved DataWarehouse query optimization via real-time Warehouse building and testing techniques.