Chapter 2. Business Service Management concepts 33
central data warehouse (CDW) is the database that contains all
enterprise-wide historical data (with hour as the lowest granularity). This data
store is optimized for the efficient storage of large amounts of data and has a
documented format that makes the data accessible to many analysis solutions.
The database is organized in a very flexible way, which lets you store data from
new applications without adding or changing tables.
data mart ETL extracts a subset of historical data from the central data
warehouse that contains data tailored to and optimized for a specific reporting or
analysis task. This subset of data is used to create data marts. The data mart
ETL is also known as
target ETL or ETL2.
data mart is a subset of the historical data that satisfies the needs of a specific
department, team, or customer. A data mart is optimized for interactive reporting
and data analysis. The format of a data mart is specific to the reporting or
analysis tool you plan to use. Each application that provides a data mart ETL
creates its data marts in the appropriate format.
Tivoli Data Warehouse provides a
Report Interface (RI) that creates static
two-dimensional reports of your data using the data marts. The RI is a role-based
Web interface that can be accessed with a simple Web browser without any
additional software installed on the client. You can also use other tools to perform
OLAP analysis, business intelligence reporting, or data mining.
Control server is the system that contains the control database which itself
contains metadata for Tivoli Data Warehouse and from which you manage your
data warehouse. The Control server controls communication between the
Control server, the central data warehouse, the data marts, and the Report
The Control server uses the Data Warehouse Center to define the ETL
processes and the star schemas used by the data marts. You use the Data
Warehouse Center to schedule, maintain, and monitor these processes.
2.4.3 Tivoli Data Warehouse components
A distributed installation is recommended for most production systems and for
customers who already run their database servers on UNIX® systems. Each of
the aforementioned components of Tivoli Data Warehouse can exist on a
separate machine. Such a configuration is illustrated in Figure 2-6 on page 34.
34 Business Service Management Best Practices
Figure 2-6 A distributed Tivoli Data Warehouse configuration
We will provide further information about the four components, including
prerequisites such as DB2 installations and supported operational systems.
However, always first thoroughly review Tivoli Data Warehouse Release Notes,
GI11-0857, before planning your installation.
The Control server is the system that contains the control database for Tivoli
Data Warehouse and from which you manage your data warehouse. Supported
operating systems are Windows NT® and Windows 2000.
Before you install the Tivoli Data Warehouse component on the Control server,
you have to install IBM DB2 Universal Database™ Enterprise Edition on this
machine first. The Control server uses the DB2 Server, the Data Warehouse
Center, and the warehouse agent.