Chapter 2. Overview of InfoSphere Warehouse Advanced Edition 53
queue. However, in this method the data is placed on the queue as either
XML or comma-separated values (CVS).
At the target end, the MQ reading process is normally a user-developed
application that uses this data. Figure 2-21 shows the Event Publishing
replication method.
Figure 2-21 Event Publishing replication method
For more detailed information, refer to the Replication and Event Publishing
section of the Information Center:
http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp
2.2.5 InfoSphere Warehouse Advanced Edition client applications
InfoSphere Warehouse includes a rich set of development tools, and with the
exception of the Cognos BI tools, they are all based on the universal Eclipse
Workbench Platform. Eclipse is an open source development platform comprised
of extensible frameworks, tools, and runtimes for building, deploying, and
managing software across the software lifecycle. A number of companies,
Source Server
Q Capture
program
Q Capture
control tables
DB2 process
Source
table
Log
Send queue
Publishing
queue map
Message
Publication
User
application
54 Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition
including IBM, have adopted the Eclipse Platform as the base for a wide range of
their development tools. Generally, for ease of installation, IBM ships each of
these IDE Eclipse-based tools as a complete self-contained development
environment, when in reality, they are extensions to the standard Eclipse
Platform that have been developed by IBM.
The Cognos BI client tools, Query Studio, Analysis Studio, Report Studio, and
Event Studio, are all web-based. The Cognos Frameworks is a separate
Windows application.
Each of these tools, included in InfoSphere Warehouse Advanced Edition, is
focused on a different role within the complete lifecycle of building a data
warehouse environment. The roles and their respective clients are listed here:
???? Data Architect - Aimed at the role of data architecting and the need to capture
and model the business requirements, this tool can be used to develop both
logical and dimensional logical models. These models themselves can
become the basis for the physical models used in the creation of the
warehouse data schema.
???? Design Studio - Aimed at developers who must create the SQW applications
that perform the ETL processes and cubing and mining services.
???? Data Studio - Aimed at both end users and DBAs.
???? Cognos BI - This Cognos tool group includes the Cognos Framework
Manager and the Cognos Studio web tool set, and is aimed at BI users who
must create reports and develop dashboards.
Data Architect
Data Architect is made available under the umbrella of the Advanced Edition
licence, although it can be purchased from IBM as an independent product. This
product was originally known as Rational Data Architect.
Design Studio
Design Studio is not an individual product but rather the main component of the
InfoSphere Warehouse Client product, and it is listed under this name within the
IBM software portfolio. It is made available as a standard element with all types
of the InfoSphere Warehouse Server solution. It has been developed as an
advanced, integrated development tool to handle the majority of the main tasks
required to implement a data warehouse.
Following the principles of the Eclipse Workbench, Design Studio encompasses
a number of different tools within one development environment, with each tool
Chapter 2. Overview of InfoSphere Warehouse Advanced Edition 55
aimed at performing an element of the total warehouse solution. Design Studio
can thus perform the following tasks:
???? Physical data model development
This tool within Design Studio is based on the original Rational Data Architect
product, and allows the modeling of DB2 databases. Both the physical and
logical database models can be created from scratch or captured from either
a DDL or a real database.
Included within this modelling element is a method that enables you to
graphically view the tables and their interrelationships. The model can be
edited, meaning that new tables can be created and existing tables can be
altered. This allows these alterations to be retrospectively applied back to the
execution database within the IDE, or saved as a DDL file. The physical data
model is also used within the other sections of Design Studio to provide
metadata about the execution or remote databases.
???? SQL warehousing tool for ETL development, testing and deployment
Commonly known as SQW, this tool allows for the development of data flows
and control flows. These flows can be tested and debugged within the IDE,
with connections to the execution database and remote data sources.
After development has completed, these flows are packaged into a
warehouse application with the required generated Java and SQL code and
the required resources for deploying the DIS. The SQW IDE also includes
integration points with the IBM Data Stage product.
???? OLAP Cubing models development
This component of Design Studio handles the implementation of cubing
services. The tool can be used to add OLAP features to a physical model,
which in turn then represents an OLAP cube model.
Additionally, this tool can be used to verify the cubing model and implement
an execution instance of the cube service within the Design Studio Client.
This model can then be transferred to the metadata database, and through an
XML file be deployed within the InfoSphere administration console for
execution as a cube service on the server.
???? Data Mining models and flows development:
This function enables you to develop data mining models and flows without
the need for in-depth data mining knowledge. The graphical interface of
Design Studio allows for the easy conversion of business rules into mining
flows, which can then either be shared with other mining tools such as SPSS
and SAS, or deployed to the mining runtime server.
56 Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition
Data Studio
Before the release of DB2 10, both the client and server components of DB2
contained Java GUI applications to assist with both the management and access
of DB2 databases and servers. However, these Java tools have now been
deprecated and replaced with the more advanced tool, Data Studio.
Available from IBM at no cost as a web download, Data Studio tool has been
developed to work with a greater range of relational database, including DB2 for
IBM z/OS®, DB2 for i, Informix, and other non-IBM databases. The tool is
available in three installation formats:
???? The Data Studio full client provides an integrated development environment
for database administration, and routine and Java application development,
that can be installed with other IBM software products so that they can share
a common environment.
???? The Data Studio administration client is an alternative to the full client that
provides a small footprint, stand-alone integrated development environment
for database administration and non-Java routine development.
???? The Data Studio web console provides health and availability monitoring
features and job creation and management tools for your databases.
Data Studio includes the functionality originally shipped as Optim Development
Studio, Optim Database Administrator, and Data Studio Health Monitor within
one single offering.
Additional information can be obtained from the eBook: Getting Started with IBM
Data Studio for DB2, which is available at the following website:
http://www.ibm.com/developerworks/wikis/display/db2oncampus/FREE+ebook+-+Gettin
g+started+with+IBM+Data+Studio+for+DB2
IBM Cognos BI: Cognos Framework Manager and Cognos
web-based tools
The included Cognos BI server comes with its own complete range of
developments tools, all of which have to be accessed on a Microsoft
Windows-based client system. All but one of the Cognos tools are web-based
and come contained as integral part of the main Cognos BI server. They are
accessible from the main Cognos menu as shown in Figure 2-22 on page 58.
Note: Data Studio is available at no cost as a download from the following
website:
http://www.ibm.com/software/data/optim/data-studio/
Chapter 2. Overview of InfoSphere Warehouse Advanced Edition 57
These tools only function correctly when accessed from within an Internet
Explorer browser, due to the need to use Microsoft Windows technology. The
exception to the Cognos web-based tools is Cognos Frameworks, which is a
separate Windows-only executable.
A complete list of the tools included as part of Cognos BI are:
???? IBM Cognos Business Insight
This tool can create sophisticated interactive dashboards using IBM Cognos
content and external data sources such as Cubing Services. Users can view
dashboards and reports, open dashboards to manipulate the content, and
email these dashboards.
???? IBM Cognos Query Studio
With this tool, users with little or no training can quickly design, create, and
save reports to meet reporting needs that are not covered by the standard,
professional reports created in IBM Cognos Report Studio.
???? IBM Cognos Analysis Studio
With this tool, users can explore and analyze data from different dimensions
of their business. Users can also compare data to spot trends or anomalies in
performance. IBM Cognos Analysis Studio provides access to dimensional,
online analytical processing (OLAP), and dimensionally modeled relational
data sources. Analyses created in IBM Cognos Analysis Studio can be
opened in IBM Cognos Report Studio and used to build professional reports.
???? IBM Cognos Report Studio
This is a robust report design and authoring tool. Using IBM Cognos Report
Studio, report authors can create, edit, and distribute a wide range of
professional reports. They can also define corporate standard report
templates for use in IBM Cognos Query Studio, and edit and modify reports
created in IBM Cognos Query Studio or IBM Cognos Analysis Studio.
???? IBM Cognos Event Studio
You can use IBM Cognos Event Studio to set up agents to monitor data and
perform tasks when business events or exceptional conditions occur with that
data. When an event occurs, people can be alerted to take action, agents can
publish details to a portal, deliver alerts by email, run and distribute reports,
and continue to monitor the status of events.
???? IBM Cognos Administration
This tool provides a central management interface that contains the
administrative tasks for IBM Cognos BI. It provides easy access to the overall
management of the IBM Cognos environment and is accessible through IBM
Cognos Connection.
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.