Databases: History and descriptions

Follow

Databases for BPM can be installed on any of the following platforms:

  • DB2 Express
  • DB2
  • Oracle 11g R2
  • MSSQL

History:

  • Before version 7.5, there was only two databases, the Proc and Perf database now called the BPMDB and the PDWDB.  These databases contained the Runtime data and reporting data respectively.
  • With IBM BPM, there is a new database, COMMON or CMNDB, that stores much more of the component information.
  • Each database can contain component information about BPM.


Databases:

  • BPMDB - Process database or "ProcDB"
    • Component : Process Server
      • The Process Server tables are used to hold, store, and track the data for the process application repository.
      • This is where your BPD, Service, user, group, and other components exist.
  • PDWDB - Performance database or "PerfDB"
    • Component : Performance Data Warehouse
      • Stores the tracked business data historically.
  • CMNDB - Common database or "CommDB"
    • Component : Application Scheduler
      • You must create the common database before you start IBM Business Process Manager.
      • You must configure the CMNDB tables either during the startup of the deployment manager or stand-alone server or before you start the deployment manager or stand-alone server.
    • Component : Business Space
      • For stand-alone profiles, you must create the common database before you start IBM Business Process Manager. For other profiles, you must use the administrative console to configure Business Space. Configuring a Business Space database is mandatory for using Business Space powered by WebSphere® and Process Portal.Business Space powered by WebSphere provides a common interface for application users to create, manage, and integrate web interfaces across a range of IBM products.
    • Component : Enterprise service bus
      • You must configure these tables either during startup of the deployment manager or stand-alone server or before you start the deployment manager or stand-alone server
    • Component : Mediation
      • You must create the common database before you start IBM Business Process Manager. You must configure the CMNDB tables either during the startup of the deployment manager or stand-alone server or before you start the deployment manager or stand-alone server.
    • Component : Recovery
      • You must create the common database before you start IBM Business Process Manager. You must configure the CMNDB tables either during the startup of the deployment manager or stand-alone server or before you start the deployment manager or stand-alone server.
    • Component : Relationships
      • You must create the common database before you start IBM Business Process Manager. You must configure the CMNDB tables before or during the startup of the deployment manager or stand-alone server.
    • Component : Selectors and business rules
      • You must create the common database before you start IBM Business Process Manager. You must configure the CMNDB tables before or during the startup of the deployment manager or stand-alone server.
  • BPEDB
    • Component : Business Process Choreographer
      • You must create the BPEDB before you start a server or cluster with Business Process Choreographer configured.
  • OBSRVDB
    • Component : Business Process Choreographer Explorer reporting function
      • The Business Process Choreographer Explorer reporting functionality is deprecated. To monitor and report on BPEL processes, use IBM Business Monitor
  • EVENT (stores events)
    • Component : Common Event Infrastructure (CEI)
      • CEI database configuration is not supported by the Profile Management Tool or the manageprofile command-line utility.
      • Do not create this database for production environments because the performance of persisting events may be impacted.
      • The Common Base Event browser relies on the CEI database. If you want to use the Common Base Event browser to retrieve and view logging, tracing, management, and business events in your business enterprise applications, you must create the CEI database manually.
  • User Created
    • Component : SIBus
      • You must configure these tables during the startup of the messaging engine or before you start the messaging engine. You can use a file store with SIBus in a stand-alone environment during profile creation. However, you cannot use a file store with SIBus in a network deployment environment.
Have more questions? Submit a request

Comments

Powered by Zendesk