WebSphere® Business Monitor databases
schemas are based on business
measures models.
These schemas are generated by the Schema Generator.
The business measures model is created
using Business Measures editor.
It is an annotated model, which contains the metadata of the business model.
Using the Business Measures editor, the user
can define what should be monitored: contexts, key performance indicators
(KPIs), metrics, and business situations. The business measures model produces
monitoring information through events. After the business measures model is
completed, it is exported to WebSphere Business Monitor as
an annotated XML file in zip format for use by Schema Generator.
The Schema Generator is part of the WebSphere Business Monitor administrative
console. Typically this tool will be configured and used by a database administrator
(DBA). It takes the business measures model as
an input; then generate the database artifacts.
The following are the generated artifacts:
- The database definition language (DDL) scripts suitable for creating the
database tables. For each generated DDL file (state.ddl, runtime.ddl, datamart.ddl),
a corresponding text file is created (stateMapping.txt, runtimeMapping.txt,
datamartMapping.txt). These files contain a description of the metrics and
processes that the physical database artifacts (tables, columns) represent.
- DB2® Cube
Views™ definitions, which describe the Historical database data in a star
schema format. The cube views definitions is
suitable for import into the DB2 OLAP center.
- Replication scripts that enable replication between the State, Runtime,
and Historical databases. For each of these databases, the Schema Generatorcreates a compressed file containing all the
deployment artifacts necessary to set up replication across the three databases.
Typically these artifacts will be distributed and deployed by a DBA as per
the instructions in Deploying data movement services.
The database tables in
WebSphere Business Monitor database
components consist of two types:
- There are static database tables that are created once at installation
time. These tables are shared across all business measures models and do not
depend on any single business measures model.
- There are dynamic database tables that are dependent on a business measures model that
is imported into the WebSphere Business Monitor administrative
console. The dynamic database tables schemas are unique for each business measures model. Any changes to the business measures model associated with the dynamic
tables will result in a change management scenario. For more information
about change management scenarios, refer to Change management and artifacts generation.