Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition

Chapter 2. Overview of InfoSphere Warehouse Advanced Edition 21

IBM Design Studio is provided as one component of InfoSphere Warehouse

Client. The warehouse command line tool wh

provides an alternative interface to

the runtime elements of InfoSphere Warehouse, to that of a web browser.

This alternative interface provides developers and administrators with a fast and

efficient method of configuring, scheduling, and running tasks within the

InfoSphere warehouse runtime, from the command line of the native operating

system.

2.1.12 InfoSphere Data Architect

InfoSphere Data Architect is a collaborative integrated data design environment

that is aimed at the higher role of the solution architect who is required to

discover and model the warehouse solution while taking into account its

relationship within the wider corporate environment.

This tool provides architects with the functions needed to create and visualize a

logical model that addresses the BI requirements. Simultaneously, it provides the

facilities needed to transform this model into a physical data model and from

there to a DDL script that can be easily and rapidly deployed.

The tool can also be used to leverage standard deployment models, develop

collaboration between architects, developers, and administrators, and maintain

data lifecycle polices. Data models developed within the tool can be exchanged

with other IBM development tools and applications such as Cognos

Frameworks.They can also published into an HTML format for hosting on a

website in support of audit and collaboration purposes.

The physical data models developed within InfoSphere Data Architect have a

common format that is shared between Data Studio and Design Studio, as are

the interfaces within these IDEs. This helps developers by providing a consistent

look and feel, and can accelerate the development process.

When used in conjunction with the InfoSphere Warehouse Packs, InfoSphere

Data Architect allows designers to enhance the standard included models to

develop and deploy custom models tailored to their specific industry or business

environment.

For your awareness: InfoSphere Data Architect was formerly known as IBM

Rational Data Architect.