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.
- 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
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.
Component | Advanced Enterprise Edition ² | Enterprise Edition ² | Enterprise Base Edition ¹ | Advanced Departmental Edition | Departmental Edition | Departmental Base Edition | Developer Edition |
Table 2. Separately purchasable features forInfoSphere Warehouse, by edition | |||||||
DB2 Advanced Access Control Feature | Included | Included | Available | Not applicable | Not applicable | Not applicable | Included |
DB2 Geodetic Data Management Feature | Available | Available | Available | Not applicable | Not applicable | Not applicable | Included |
Homogenous Replication Feature for DB2 | Restricted use | Restricted use | Restricted use | Restricted use | Restricted use | Restricted use | Included |
Performance Optimization Feature for DB2 | Included | Included | Available | Not applicable | Not applicable | Not applicable | Included |
Storage Optimization Feature for DB2 | Included | Included | Available | Included | Included | Not applicable | Included |
- ¹ Applies to customers with the Base Warehousing Feature for DB2.
- ² Applies to customers with the Enterprise Warehousing Feature for DB2.
InfoSphere Warehouse with Optim Data Retention software is a bundled solution that includes IBM InfoSphere Warehouse Enterprise Edition and IBM Optim Data Growth Solution. This combination of products provides a complete end-to-end data growth solution for IBM enterprise data warehouse customers.
The separately purchasable IBM Base Warehouse Feature for DB2 and IBM Enterprise Warehouse Feature for DB2 provide an upgrade path for existing DB2 for Linux, UNIX, and Windows customers. With these features, you can extend your DB2 Enterprise Server investment by adding the superior scalability and comprehensive tooling of InfoSphere Warehouse. IBM Base Warehouse Feature for DB2 adds the capabilities of InfoSphere Warehouse Enterprise Base Edition to an existing DB2 Enterprise Server deployment. Similarly, the IBM Enterprise Warehouse Feature for DB2 adds the capabilities of InfoSphere Warehouse Enterprise Edition to an existing DB2 Enterprise Server deployment.
All editions of InfoSphere Warehouse allow the use of Q replication in DB2, but the use is restricted to a single DB2 source and target.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21585911