Optimize 10.11 | webMethods Optimize Documentation | Administering webMethods Optimize | Optimize Schema
 
Optimize Schema
 
Table Naming and Versioning
Fact Tables (BAM_FACT_<Event Map Name>_V1)
Dimension Tables (BAM_DIM_<Dimension Name>_V1)
Optimize stores system and customer data in the “analysis” database within the applicable customer database product (Oracle, SQL Server, etc.). This data forms the schema that defines the structure of a particular database. As delivered, Optimize has a core schema that provides a basis for adding customer-specific metadata and runtime data. As a user creates event maps, facts, and dimensions to work with their specific business operations, Optimize creates the appropriate database tables automatically based on the implemented event maps. These tables form the customer-specific schema that is unique to each Optimize installation.
Because Optimize table names are derived from user-created data structures, it is impossible to provide an accurate, detailed schema diagram for any given user. However, Optimize follows a consistent taxonomy for naming and relating tables, which can be represented by a star diagram. Below is a graphical representation of a basic Optimize star schema:
Taxonomy for Naming and Relating Tables