InfoSphere Warehouse 10.1 components, by edition

Preventive Service Planning

Abstract

InfoSphere Warehouse V10.1 offers different features depending on the edition that you purchase.

Content

Descriptions of key InfoSphere Warehouse components

The key components of InfoSphere Warehouse are described as follows.

InfoSphere Warehouse Design Studio

The Design Studio provides a common design environment for creating physical data models, OLAP cubes, SQL data flows and control flows, and BloxÂ® Builder analytic applications. The Design Studio is built on the Eclipse Workbench, which is a development environment that you can customize.

InfoSphere Warehouse Administration Console

The InfoSphere Warehouse Administration Console is a Web application from which you can deploy and manage applications, control flows, database resources, and system resources. You can do the following types of tasks in the Administration Console:

Common configuration

Create and manage database and system resources, including driver definitions, log files, and notifications.

SQL warehousing

Run and monitor data warehousing applications and view deployment histories and execution statistics.

Cubing Services

Manage cube servers, import and export cube models, explore cubes and cube models, and run the OLAP Metadata Optimization Advisor. Cubing Services works with business intelligence tools to provide OLAP access to data directly from InfoSphere Warehouse. Cubing Services includes tooling for multidimensional modeling to design OLAP metadata (cubes), an optimization advisor for recommending materialized query tables (MQTs) in DB2, and a cube server for providing multidimensional access to the data. Each of these Cubing Services components is integrated with the InfoSphere Warehouse user interfaces for design (Design Studio) and administration and maintenance (Administration Console).

Intelligent Miner

InfoSphere Warehouse includes the following mining features:

Intelligent Miner Easy Mining

Intelligent Miner Modeling

Intelligent Miner Scoring

Intelligent Miner Visualization

Text Analysis

These features provide rapid enablement of data mining analysis in Data Warehousing, eCommerce, or traditional Online Transaction Processing (OLTP) application programs. While previously available as separately priced products, they are now available as an integrated part of InfoSphere Warehouse.

Text Analysis

With InfoSphere Warehouse, you can create business insight from unstructured information. You can extract information from text columns in your data warehouse then use the extracted information in reports, multidimensional analysis, or as input for data mining.

Components of InfoSphere Warehouse, by edition

InfoSphere Warehouse offers different features depending on the edition that you purchase. The following table summarizes the components and features of each edition.

Component

Advanced Enterprise Edition

Enterprise Edition²

Enterprise Base Edition ¹

Advanced Departmental Edition

Departmental Edition

Departmental Base Edition

Developer Edition

Table 1. Components of InfoSphere Warehouse, by edition

DB2 10.1 Enterprise Server Edition

Included

Included

Included

Included

Included

Included

Included

DB2 Database Partitioning

Included

Included

Included

Included

Included

Included

Included

Cubing Services

Included

Included

Included

Included

Included

Included

Included

SQL Warehousing (SQW) Tool

Included

Included

Included

Included

Included

Included

Included

InfoSphere Federation Server Relational Wrappers

Included

Included

Included

Included

Included

Included

Included

Design Studio

Included

Included

Included

Included

Included

Included

Included

IBM Data Studio Client

Included

Included

Included

Included

Included

Included

Included

IBM Data Studio Administration Client

Included

Included

Included

Included

Included

Included

Included

IBM Data Studio Web Console

Included

Included

Included

Included

Included

Included

Included

Warehouse Administration Console

Included

Included

Included

Included

Included

Included

Included

WebSphere Application Server

Included

Included

Included

Included

Included

Included

Included

Cognos 10 Business Intelligence For Reporting

Included

Included

Not applicable

Included

Included

Not applicable

Included

InfoSphere Replication Server

Included

Included

Included

Included

Included

Included

Included

DB2 Workload Management

Included

Included

Performance Optimization Feature

Included

Included

Not applicable

Included

Optim Performance Manager

Extended Edition included

Extended Edition included

Performance Optimization Feature

Included

Included

Not applicable

Extended Edition included

DB2 Query Patroller

Included

Included

Performance Optimization Feature

Not applicable

Not applicable

Not applicable

Included

DB2 Deep Compression

Included

Included

Storage Optimization Feature

Included

Included

Not applicable

Included

Label Based Access Control (LBAC)

Included

Included

Advanced Access Control Feature

Not applicable

Not applicable

Not applicable

Included

Intelligent Miner

Included

Included

Not applicable

Included

Included

Not applicable

Included

Text Analytics

Included

Included

Not applicable

Included

Included

Not applicable

Included

Mashup Center

Included

Included

Not applicable

Not applicable

Not applicable

Not applicable

Included

InfoSphere Data Architect

10 user license

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

InfoSphere Optim Query Workload Tuner

Included

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Optim High Performance Unload

Included

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

DB2 Recovery Expert

Included

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

DB2 Merge Backup

Included

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Warehouse Pack: Market and Campaign Insight

Included

Not applicable

Not applicable

Included

Not applicable

Not applicable

Not applicable

Warehouse Pack: Customer Insight

Included

Not applicable

Not applicable

Included

Not applicable

Not applicable

Not applicable

Warehouse Pack: Supply Chain Insight

Included

Not applicable

Not applicable

Included

Not applicable

Not applicable

Not applicable

Maximum DB2 Database Size

Unrestricted

Unrestricted

Unrestricted

Unrestricted

Unrestricted

Unrestricted

Unrestricted

Maximum DB2 instance memory

Unrestricted

Unrestricted

Unrestricted

32 GB, or 64 GB

32 GB, or 64 GB

32 GB, or 64 GB

Unrestricted

Maximum process cores used by DB2

Unrestricted

Unrestricted

Unrestricted

16

16

16

Unrestricted

Maximum terabytes of user data

Unrestricted

Unrestricted

Not applicable

15

15

Not applicable

Not applicable

Environments

Unrestricted

Unrestricted

Unrestricted

Unrestricted

Unrestricted

Unrestricted

Non-production only

¹ Applies to customers with the Base Warehousing Feature for DB2.

² Applies to customers with the Enterprise Warehousing Feature for DB2.

The following table lists the separately purchasable features that are available for each edition of InfoSphere Warehouse.