WebSphere Business Monitor databases
schemas are based on Business Measures-Modelle.
These schemas are generated by the Schema Generator.
The Business Measures-Modell 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-Modell produces
monitoring information through events. After the Business Measures-Modell 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-Modell 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 ../../tasks/dbServices/Depreplicartifacts.html#Depreplicartifacts.
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-Modell.
- There are dynamic database tables that are dependent on a Business Measures-Modell that
is imported into the WebSphere Business Monitor administrative
console. The dynamic database tables schemas are unique for each Business Measures-Modell. Any changes to the Business Measures-Modell associated with the dynamic
tables will result in a change management scenario. For more information
about change management scenarios, refer to Änderungsmanagement und Artefaktgenerierung.