Optimize 10.5 | webMethods Optimize Documentation | Administering webMethods Optimize | For Database Administrators | Configuring Optimize Database Pools | Concepts
 
Concepts
 
Multiple Analytic Engines
Optimize has six components or activities that access the Optimize database component sets:
*analysis.engine Analytic Engine
*process.history Analytic Engine
*process.model Analytic Engine
*process.work Analytic Engine
*common.directory Analytic Engine
A typical Optimize configuration of database connection pools involves four connections:
*analysis.engine Analytic Engine through a pool to the Analysis database component set
*process.history Analytic Engine and process.work Analytic Engine through a single pool to the Process Tracker database component set
*process.model Analytic Engine through a pool to the Process Audit Log database component set
*common.directory Analytic Engine through a pool to the My webMethods Server database component set
See the following figure.
Figure 10. Connecting Optimize database activities to Optimize database component sets: typical configuration
Connecting Optimize database activities to Optimize database component sets
In high-volume situations, you may be able to improve performance by assigning separate database connection pools to:
*The process.history Analytic Engine and process.work Analytic Engine Optimize database activities; both connect to the Process Tracker database component set.
*The analysis.engine Analytic Engine Optimize database activities; connects to the Analysis database component set.
See the following figure.
Figure 11. Connecting Optimize database activities to Optimize database component sets: high-volume configuration
Connecting Optimize database activities to Optimize database component sets for high volume configuration
Note:
You must define a minimum of one database connection pool per database schema. In an Optimize configuration with four database schemas as shown in the figures above, you must define a minimum of four database connection pools.