2.3.5 Estimating database table capacity

You must estimate database table capacity in advance in order to manage execution history and to set the execution environment. Setting is not necessary if the database is not used.

Organization of this subsection

(1) Estimating table capacity related to execution history management of process instances
(2) Estimating table capacity related to execution environment settings

(1) Estimating table capacity related to execution history management of process instances

The following table describes the list of database tables related to execution history management of process instances:

Table 2‒10: List of database tables related to execution history management of process instances
Classification	Table name	Description
Basic information table	CSCBP_<Cluster name>_PROCESS	Store process instance status.
	CSCBP_<Cluster name>_ACTIVITY	Store activity instance status.
	CSCBP_<Cluster name>_LINK	Store link status.
	CSCBP_<Cluster name>_CORRELATIONSET	Store correlation set value.
Variable information table	CSCBP_<Cluster name>_STR_VARIABLE	Store string type variable value.
	CSCBP_<Cluster name>_NUM_VARIABLE	Store numeric type variable value.
	CSCBP_<Cluster name>_BOOL_VARIABLE	Store boolean type variable value.
	CSCBP_<Cluster name>_MSG_VARIABLE	Store message type variable value (XML, non-XML, any).
Message history correlated information table	CSCBP_<Cluster name>_MSG_RELATION	Store correlated information of message ID and process instance identifier or activity instance identification number.

While designing a database, see all types of database manuals and estimate contents on the basis of the following information:

(a) Table and index definitions

For details on table and index definitions, see "Appendix C.1 Table information about process instance execution log management".

(b) Estimation methods of number of records

Calculate estimation of the number of records for each table as follows:

CSCBP_<Cluster name>_PROCESS table
CSCBP_<Cluster name>_ACTIVITY table
Number of activities={Number of activity definitions in business process definition

+Number of activity definitions in repeat activities

x (Repeat activity loop frequency-1)}

x Number of processes
CSCBP_<Cluster name>_LINK table
Number of links={Number of link definitions in business process definition

+Number of link definitions in repeat activities

x (Repeat activity loop frequency-1)}

x Number of processes
CSCBP_<Cluster name>_CORRELATION-SET table
CSCBP_<Cluster name>_STR_VARIABLE table
CSCBP_<Cluster name>_NUM_VARIABLE table
CSCBP_<Cluster name>_BOOL_VARIABLE table
CSCBP_<Cluster name>_MSG_VARIABLE table
CSCBP_<Cluster name>_MSG_RELATION table
Number of messages sent and received=Number of reception activity definitions

+ Number of invoke service activity definitions

(c) All types of index estimation methods

All types of index estimation methods are derived from index definitions and the number of records. For estimation methods, see the used database manual.

To Page Top

(2) Estimating table capacity related to execution environment settings

The following table describes the list of database tables related to execution environment settings:

Table 2‒11: List of database tables related to execution environment settings
Classification	Table name	Description
Basic HCSC information table	CSCMSG_S<HCSC server name>_CSC_PERSIST	HCSC server status persists.
HCSC linkage directory information table	CSCMSG_C<Cluster name>_CSC_CONNECT	This table is not used.
Location directory information table	CSCMSG_S<HCSC server name>_LC_DIRECTORY	Store location information of service adapter, business process and service group.
Location directory information table	CSCMSG_S<HCSC server name>_LC_BPFORMAT	Store business process format information.
Routing rules directory information table	CSCMSG_S<HCSC server name>_RT_RULE	Store rule information for service routing.
Directory information table for data transformation definition	CSCMSG_S<HCSC server name>_CV_MAPPING	Store data transformation definition information.
	CSCMSG_S<HCSC server name>_CV_FORMAT	Store message format definition information for data transformation.
Basic cluster information table	CSCMSG_C<Cluster name>_CLUSTER	Store set up HCSC server name.
Management table of asynchronous adapter service ID	CSCMSG_C<Cluster name>_HA_ASYNC_ADP	Store deployed asynchronous adapter service ID.