Software provides building blocks for on-demand e-business.
Press Release Summary:
DB2 UDB Data Warehouse Enterprise Edition and Standard Edition v8.1 deliver real-time insight and decision making users need to achieve e-business on demand(TM). Built-in analytics include correlation, co-variance, and standard deviation statistical functions; linear regression functions; data mining; and sliding windows functions. Software supports ad hoc queries and includes scalable database. Near-linear scalability of DB2 is enabled by shared-nothing architecture.
Original Press Release:
IBM DB2 UDB Data Warehouse Enterprise Edition and Standard Edition V8.1 Combine the Building Blocks for Your On Demand e-business
At a Glance
Powerful new and existing data management applications are combined to deliver the real-time insight and decision making you need to achieve e-business on demand(TM).
High-Function Analytics Built In
o Advanced statistical functions include correlation, co-variance, standard deviation
o Complete family of linear regression functions
o Industry-leading data mining
o Sliding windows functions: smooth moving average and equi-height histogram
Industry-Leading Support for Ad Hoc Queries
o Materialized Query Tables cache prejoined aggregates for fast reuse by common queries
o Patented Multi-Dimensional Clustering index and table structure that speeds queries
o Star Join optimizer algorithms that enable faster star schema queries
o Aggregate-aware cost-based optimizer with adjustable optimization levels for optimal query performance
o Single, consolidated system view for querying multiple database instances
o It's SQL
World's Most Scalable Database
o The near-linear scalability of DB2 is enabled by shared-nothing architecture
o Proven scalability: First database with a published 10 TB TPC-H benchmark
For ordering, contact:
Your IBM representative or the Americas Call Centers at 800-IBM-CALL (Reference: VE001).
Overview
IBM is a leader in business intelligence (BI), with technology built into the DB2 Universal Database® (UDB) Data Warehouse Editions, enabling real-time information integration, insight, and decision making. These new editions combine the strength of DB2® UDB with essential IBM BI infrastructure.
DB2 UDB Data Warehouse Enterprise Edition provides a comprehensive BI platform with everything needed by customers to deploy and partners to build next-generation BI solutions. This powerful BI platform includes DB2, federated data access, data partitioning, integrated OLAP, advanced data mining, enhanced ETL, and workload management, and provides light BI for the desktop.
o DB2 UDB Enterprise Server Edition V8.1
o DB2 UDB Database Partitioning Feature V8.1
o DB2 Cube Views V8.1
o DB2 Intelligent Miner(TM) Modeling, Visualization, and Scoring V8.1
o DB2 Office Connect Enterprise Web Edition V4.0
o DB2 Query Patroller V8.1
o DB2 Warehouse Manager Standard Edition V8.1
o DB2 Information Integrator Standard Edition V8.1 (Restricted use; available at a later date)
DB2 UDB Data Warehouse Standard Edition is a complete data mart infrastructure product that includes DB2; integrated OLAP; advanced data mining; and extract, transform, and load (ETL); and provides light BI for the desktop.
o DB2 UDB Workgroup Server Unlimited Edition V8.1
o DB2 Cube Views V8.1
o DB2 Intelligent Miner Modeling, Visualization, and Scoring V8.1
o DB2 Office Connect Professional Web Edition V4.0
What's New?
DB2 Data Warehouse Edition makes it easier for customers to purchase the comprehensive DB2 BI platform.
o With the brand new DB2 Cube Views V8.1, BI users can decrease the development time required to define common objects across multiple tools. DB2 Cube Views improves the ability of DB2 to perform OLAP processing. Users can store and manipulate OLAP metadata in the DB2 catalogs. Metadata captures the structure of OLAP cubes, enabling the Optimization Advisor to recommend materialized query tables for improve query performance.
o DB2 Warehouse Manager Standard Edition V8.1 now supports the Red Brick(TM) Warehouse database server and the Computer Associates AllFusion ERwin Data Modeler.
o DB2 Query Patroller V8.1 has been completely re-engineered as a DB2-based workload and analysis management tool suite.
o DB2 Office Connect Analytics is a new Microsoft(TM) Excel plug-in that connects to DB2 and turns the spreadsheet into an OLAP cube viewer.
For new product and feature details and existing product recaps, refer to the Description and Additional Information sections.
Key Prerequisites
Refer to the Hardware Requirements and Software Requirements sections.
Planned Availability Dates
o June 27, 2003 (electronic software delivery)
o July 25, 2003 (media and documentation)
