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.