Managing schema generation consists of configuring
and generating the database schemas.
Overview
The Schema Generator is a key component in WebSphere Business Monitor.
It is part of the WebSphere Business Monitor administrative
console. It uses the business measures model that
is produced by the Business Measures editor to
generate the appropriate artifacts for this model, based on a particular configuration.
Database DDL artifacts
You use the Schema Generator to generate the database artifacts,
scripts, and associated DDLs, to support a business measures model.
DB2 Cube Views metadata
A key benefit of using the Schema Generator is that the database
administrator (DBA) does not have to manually create the Cube Views™ schema
using the online analytical processing (OLAP) center. It automatically generates
a Cube
Views™ XML file, which contains cube models and cubes to support the business measures model.
Database replication scripts
The Schema Generator generates replication scripts that are used
to handle the replication from the State to the Runtime database and from
the Runtime to the Historical database.
Usage scenario
The Schema Generator usage scenario describes how the Schema Generator
is used to deploy a business measures model.
Configuring the Schema Generator
There are some configuration settings that pertain to the Schema
Generator. The various configuration settings are divided among three configuration
tabs.
Generating schema
After you have configured the Schema Generator component, you next
invoke the Schema Generator to generate the required artifacts of the business measures model.