Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition

20 Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition

defined functions and stored procedures, tune SQL queries, create and edit

physical data models, and provide multisystem deployment features. As of

DB2 10.1, IBM Data Studio replaces DB2 Control Center, and is available at no

cost as a download from the IBM website.

2.1.9 Optim Database Administrator

Originally provided as a stand-alone tool for the management of databases, and

to enable database changes to be applied without disruption, Optim Database

Administrator and its functionality have now been incorporated within Data

Studio.

2.1.10 Optim Development Studio

Also originally provided as a separate tool for the design, development, and

deployment of SQL scripts, stored procedures, and data-related web and Java

applications, Optim Development Studio has now been incorporated within Data

Studio.

2.1.11 InfoSphere Warehouse Client - IBM Design Studio and the wh

command

IBM Design Studio is an integrated development environment, based on the

original IBM Rational Data Architect product, that brings to InfoSphere

Warehouse a set of rich development tools needed in the creation of BI

solutions. Design Studio integrates the tasks required in the development of

solutions into a single graphical user interface, based on the popular Eclipse

Workbench. The tool provides the following functionality within a common,

easy-to-use interface:

򐂰 Physical data modelling

򐂰 ETL flow development and testing

򐂰 OLAP cube modelling and services

򐂰 Data mining modelling

򐂰 Text analytics

By utilizing Design Studio, developers can connect to multiple databases as

either source or targets in support of their operations, work with physical data

models, created as new, or by reverse-engineering from a DDL file or an actual

database. From within the same tool, they can develop and test ETL flows, data

mining flows, develop OLAP cubes, and prepare warehouse applications ready

for deployment to the runtime elements of the InfoSphere Warehouse.