60 Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition
In the last section, we touch on the “black box” solutions currently supplied by
IBM as a complete system that includes both a hardware component and a
software component.
2.3.1 Scenarios for implementing InfoSphere Warehouse core
products
The components that make up a core InfoSphere Warehouse implementation
can be divided into four Installation categories as follows:
???? Data Server component
This category covers the main DB2 platform, which is supported on AIX,
HP-UX, Solaris, various Linux implementations, and Windows. For a
warehouse implementation, consider only the 64-bit versions of DB2.
???? Application server component
This category covers the IBM WebSphere Application server, an integral part
of the warehouse product set. This component also includes the InfoSphere
Warehouse server application that is installed within an instance of the IBM
WebSphere Application Server.
???? Clients
This category covers all of the command line and GUI-based platforms that
are normally installed on a user’s personal computer or notebook. Because
the management, configuration, and use of many of the server applications
and tools is through a web browser, count this as a client tool.
However, because all modern operating systems now include a web browser
by default, no web browser is shipped with the product. Clients supported can
either be 32-bit or 64-bit, and Windows-based or Linux-based.
???? Documentation
This category includes both the online and PDF versions of the product set
documentation.
Chapter 2. Overview of InfoSphere Warehouse Advanced Edition 61
The InfoSphere Warehouse components covered in the categories listed can be
installed onto a hardware platform in a range of topologies. The three most
common topologies are listed here:
???? One tier - Often utilized as a development, test, and education environment,
all the major components, including the clients, are installed on a single
hardware platform. In this case, the platform can only be a server installed
with either a Windows or a Linux operating system.
A virtual machine image can be used in this type of environment, meaning a
Linux VMware image such as that supplied as part of an IBM 5070 Smart
Analytics Solution.
???? Two tier - Although also primarily used in a development and test
environment, this topology can be utilized, with the proper server and storage,
for a smaller warehouse implementation.
In this topology, the client components are often installed on a single client
Intel-based hardware platform running either Windows or Linux. The server
components are then all installed on a second platform. In this topology, the
clients and servers may be on completely different operating systems, and
even on different hardware-based platforms. For example, the clients might
be on Linux on an Intel-based platform, while the servers are on AIX on a
Power-based platform. In such a case, the server components include the
DB2 database engine and a single instance of the WebSphere Application
Server, loaded with the InfoSphere Warehouse application.
???? Three tier - In this topology, the client components are installed on a single
client hardware platform, the DB2 components are installed on a second
hardware platform, and the WebSphere Application Server components are
installed on the third hardware platform. For ease of administration, it is
advisable to have the operating system and hardware platform of the DB2
Installation considerations: For InfoSphere Warehouse 9.7.3 and below,
IBM WebSphere Application Server is installed as part of the installation
process if an already installed version of IBM WebSphere Application Server
was not selected to be used by the user.
With InfoSphere Warehouse 10, however, the installer requires an already
installed copy of IBM WebSphere Application Server. Thus, before running the
installer for InfoSphere Warehouse 10, a user must have installed a copy of
IBM WebSphere Application Server by using the IBM Installation Manager
application.
62 Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition
and WebSphere servers be identical, although the DB2 server will host a
larger number of disks.
It might also be advisable for performance reasons to install a local copy of
DB2 on the WebSphere Application Server to host the runtime metadata
databases of the InfoSphere Warehouse application, leaving the main DB2
engine for simply the production database.
Figure 2-24 on page 63 illustrates the three most common topologies.
Figure 2-23 The three common topologies of InfoSphere Warehouse architecture
What is not shown in this figure is what can be called a “multi-tier”
implementation. This is because, although there would be multiple hardware
platforms, in principle it is still only three software elements to the
implementation, and thus from a software view point, it would still be a three-tier
implantation. The additional hardware platforms introduced in this extended
three- or multi-tier implementation will all be installed and running additonal DB2
relational database engines to create a partitioned database.
For completeness, a partitioned DB2 database can also be configured to execute
on a single hardware platform that contains multiple central processor units. The
DB2 database engine hides the complexity of a partitioned database from the
Database
Server
(DB2)
Application
Server
(Admin
Console)
Client
(Design
Studio)
Single Tier Architecture Three Tier Architecture
*For Development only *Heavy Workloads
and Multiple Clients
Database
Server
(DB2)
Application
Server
(Admin
Console)
Two Tier Architecture
*Multiple Clients and Small
Workloads
Database
Server
(DB2)
Application
Server
(Admin
Console)
Client(s)
(Design
Studio)
Client(s)
(Design
Studio)
Chapter 2. Overview of InfoSphere Warehouse Advanced Edition 63
user and presents the user with what looks to be a single database. Because
DB2 has no reasonable limit to the number of physical servers that a partitioned
database can be installed on, this provides an InfoSphere Warehouse with both
performance and scalability growth options.
Figure 2-24 demonstrates the three-tier implementation on multiple physical
hardware platforms. Notice in this figure that the database server has an
administration database node and multiple data nodes. It is the administration
server that a user connects to and sends SQL and DB2 commands.
Figure 2-24 A three-tier solution on multiple tier physical servers
IBM Cognos BI is not installed by using the InfoSphere Warehouse install
manager, but by using its own install process. Nevertheless, it is an important
part of the data warehouse environment and is included with all versions of the
IBM InfoSphere Warehouse product range. A standard installation of IBM
Cognos BI includes a number of components that implement Cognos services.
Included within these components are copies of the open source Apache Tomcat
application server. It is possible, through a manual process, to replace the
Apache Tomcat application server and host these Cognos elements within a
WebSphere Application Server.
1. InfoSphere Warehouse Database Server
On Linux,UNIX, or Windows
DB2 Enterprise Server Edition 10
z Intelligent Miner
z InfoSphere Federation Server Relational Wrappers
Administration Nodes
Provides DB2 catalog and
coordinator function
d
es DB2 catalog and
d
inator
f
unction
partition 0
Data Nodes
Stores Warehouse data across
multiple database partitions
Stores Warehouse
mu
l
t
i
p
l
e
d
a
t
partition 1
e data across
part
i
t
i
on
s
r
e
h
ous
e
t
a
b
ase
o
ss
...
partition 2 partition n
2. InfoSphere Warehouse Application Server
On Linux,UNIX, or Windows
z Administration Console
z SQL Warehousing (SQW) administration
z Cubing Services administration
z Intelligent Mining administration
z Unstructured Text Analysis
z
Administration Console Command Line Client
z DB2 Client 10
z WebSphere Application Server
z Cubing Services
3. InfoSphere Warehouse Client
On Linux or Windows
z Design Studio
z SQL Warehousing (SQW) Tool
z Cubing Services modeling
z Intelligent Mining tools
z Unstructured Text Analysis tools
z
DB2 Client 10
z Intelligent Miner Visualization
z Cubing Services client
z Administration Console Command Line client
dLi li
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.