Database Software enables business intelligence analytics.

Press Release Summary:



DB2® Data Warehouse Editions offer flexible features for real-time insight and decision making to achieve e-business on demand(TM). Data Warehouse Edition is built on warehousing and analytics engine of DB2. With built-in analytics, software provides statistical and linear regression functions, data mining features, sliding windows functions, and support for ad hoc and other queries. Scalable software uses SQL and shared-nothing architecture.



Original Press Release:



IBM DB2 Universal Database Data Warehouse Editions V8.1.2 Simplify Install Process



At a glance

New DB2 Data Warehouse Editions offer powerful and flexible BI features for real-time insight and decision making to achieve e-business on demand(TM). DWE builds on the strong warehousing and analytics engine of DB2.

o High-function analytics built in

o Advanced statistical functions: Correlation, co-variance, and standard deviation

o Complete family of linear regression functions

o Industry-leading data mining features

o Sliding windows functions; smooth-moving average and equi-height histogram

o Industry-leading support for ad hoc queries

o Materialized query tables (MQTs) cache prejoined aggregates for fast reuse by common queries

o Patented multidimensional clustering index and table structure speeds queries

o Star Join optimizer algorithms enable faster star schema queries

o Aggregate-aware cost-based optimizer with adjustable optimization levels

o Single, consolidated system view for querying multiple databases

o Uses SQL

o Proven scalability

o Near-linear scalability of DB2 enabled by shared-nothing architecture

o DB2 published 10 TB TPC-H benchmark

For ordering, contact:

Your IBM representative or the Americas Call Centers at 800-IBM-CALL (Reference: VE001).

Overview

DB2 Universal Database® (UDB) is the world's leading database platform for business intelligence (BI) solution deployments. DB2® Data Warehouse Edition (DWE) embodies IBM's vision for BI as a cornerstone of information on demand:

o Build BI function into the database

o Make it accessible solely through open, standard interfaces, as part of an integrated BI platform

o Collaborate with partners for other layers of architecture

DB2 has been steadily progressing toward supporting BI functions inside the database. The latest release of DB2 DWE enables customers and partners to perform mining, Online Analytic Processing (OLAP), Extract, Transform and Load (ETL), and advanced analytics with a single unified engine operating on common data structures within a consolidated data warehouse. It combines a carefully selected set of IBM BI products to provide the essential infrastructure needed to extend the enterprise data warehouse as a platform for BI.

DB2 delivers the core strengths of scaling, platform portability, flexibility, extensibility, availability, and manageability. It also brings all the benefits of IBM's services, support, and customer partnership capabilities.

DB2 DWE leverages the full portfolio of partner tools, applications, and services, as well as IBM's own software portfolio (including Rational®, Tivoli®, Lotus®, and WebSphere®), to deliver full-function BI platforms for customer and partner solution development.

What's new?

Version 8.1.2 includes an Integrated Install feature that simplifies and streamlines the install process with a single GUI for installing products included with it. The Integrated Install feature offers support for:

o Silent installation of DWE Enterprise Edition or DWE Standard Edition

o Installation on Windows(TM), AIX®, Solaris, and Linux (Intel(TM)) platforms

o Both server and client environments

Planned availability dates

October 14, 2003 (electronic software delivery)

October 17, 2003 (media)

Trademarks

Intelligent Miner and e-business on demand are trademarks of International Business Machines Corporation in the United States or other countries or both.

DB2 Universal Database, DB2, Rational, Tivoli, Lotus, WebSphere, and AIX are registered trademarks of International Business Machines Corporation in the United States or other countries or both.

Intel is a trademark of Intel Corporation.

Windows and Microsoft are trademarks of Microsoft Corporation.

Other company, product, and service names may be trademarks or service marks of others.

All Topics