Database Software features inline analytics.

Press Release Summary:



DB2 Universal Database® Data Warehouse Edition v8.2.1 integrates Web-based analytics and reporting of DB2 Alphablox into existing data mining, online analytical processing, extract, transform, and load capabilities. Using DB2 as back-end server, software can deliver multidimensional OLAP-style cube viewing, navigation, and analytics. In addition, analytics, reporting, and query are customizable to each user's role and context.



Original Press Release:



IBM DB2 UDB Data Warehouse Edition, V8.2.1 Introduces Inline Analytics by Including DB2 Alphablox



Overview

The latest release of DB2 Universal Database® (UDB) Data Warehouse Edition (DWE) further empowers you by adding world-class Web-based analytics and reporting to the existing end-to-end platform. With DB2® Alphablox, DB2 DWE rounds out the carefully selected set of IBM Business Intelligence (BI) products to provide the essential infrastructure needed to extend the enterprise data warehouse as a platform for BI. DB2 Alphablox also can be deployed in operational applications to provide inline or embedded analytics, extending the DWE value-add beyond the data warehouse environment.

What's new?

DB2 Alphablox extends DWE with an industry-leading platform for the rapid assembly and broad deployment of integrated analytics and report visualization embedded within applications. DB2 Alphablox has an open, extensible architecture based on Java(TM) 2 Platform, Enterprise Edition (J2EE) standards, an industry standard for developing Web-based enterprise applications. DB2 Alphablox simplifies and speeds deployment of analytical applications by automatically handling many details of application behavior without the need for complex programming.

DB2 Alphablox provides various Blox components, which are modular, reusable components, as well as an application framework, a powerful programming model, and a variety of development tools for assembling analytic applications. For its run-time environment, DB2 Alphablox in DWE runs on WebSphere® Application Server and accesses data in the DB2 data warehouse.

As delivered in both Enterprise and Standard DWE editions, DB2 Alphablox includes the DB2 Cube Views metadata bridge. The synergistic combination of these technologies in DWE means DB2 Alphablox applications, using the relational cubing engine, can connect directly to the DB2 warehouse and still enjoy a significant range of multidimensional analytics and navigation, along with the performance acceleration of DB2 Cube Views. DB2 Alphablox in DWE also includes the standard relational reporting component, adding value in environments where SQL is important for reporting applications.

Because DB2 Alphablox is intended to access data solely through the DB2 data warehouse (including remote heterogeneous data sources via optional II federation), this version of DB2 Alphablox in DWE does not include multidimensional connectors for accessing non-relational MOLAP-style cube servers, nor does it include relational connectors for other IBM or non-IBM databases. These connectors are available via separate licensing.

Planned availability dates

· February 1, 2005: Electronic software delivery

· February 15, 2005: Media

At a glance

IBM DB2 Universal Database (UDB) Data Warehouse Edition (DWE), V8.2.1 integrates the Web-based analytics and reporting of DB2 Alphablox with the data mining, online analytical processing (OLAP), and extract, transform, and load (ETL) already available. The addition of DB2 Alphablox to DWE provides a truly comprehensive BI platform operating on common data structures within the data warehouse.

The inline analytics approach of DB2 Alphablox in DWE allows you to:

· Develop and deploy end-user solutions leveraging the warehouse via zero-client Web-based applications and portals

· Integrate analytics, reporting, and query in quick-to-deploy applications that are customized to each user's role and context

· Deliver multidimensional OLAP-style cube viewing, navigation, and analytics using DB2 as the back-end data server

For ordering, contact:
Your IBM representative, an IBM Business Partner, or the Americas Call Centers at 800-IBM-CALL Reference: VE001

All Topics