Technical Requirements to the Database Schema

The following tables are to support database administrators during the definition of the relevant configuration parameters and the creation of the Infinity Process Platform audit trail database schema. The tables provide size information as well as scalability factors and update behaviors which should help the administrator with the optimization of the database performance.

Overview of Technical Requirements

Table No. of Records Scales to Record size
ACT_INST_HISTORY ~ a * p * 4 p 13 * n
ACT_INST_PROPERTY M * P * A * ae * ap - 6 * n + 428 * c
ACTIVITY M * P * A - 3 * n + 4150 * c
ACTIVITY_INST_LOG ~ a * p * 4 p 7 * n
ACTIVITY_INSTANCE a * p p 11 * n
ACTIVITY_INSTANCE_LCK p 1 * n
CLOB_DATA ~ p * S * s p 2 * n + (s+32) * c
DAEMON_LOG 2 * d - 5 * n + 100 * c
DATA M * D - 2 * n + 4150 * c
DATA_VALUE D * r p 6 * n + 128 * c
DATA_VALUE_HISTORY D * r * a * p a * p 9 * n + 128 * c
DATA_VALUE_HISTORY_LCK p 1 * n
DATA_VALUE_LCK p 1 * n
DEPARTMENT M * SR * dp - 4 * n + 4200 * c
DEPARTMENT_HIERARCHY M * SR * dp 2 * n
DOMAIN PA - 3 * n + 4050 * c
DOMAIN_HIERARCHY PA - 2 * n
EVENT_BINDING   - 8 * n
EVENT_HANDLER - 4 * n + 150 * c
LOG_ENTRY l l 8 * n + 300 * c
LINK_TYPE
MODEL M - 8 * n + 950 * c
MODEL_DEP
MODEL_DEP_LCK p 1 * n
MODEL_REF
PARTICIPANT M * R - 4 * n + 4150 * c
PARTITION PA - 1 * n + 4050 * c
PROC_INST_PROPERTY M * P * pe * pp - 6 * n + 428 * c
PROCINST_LINK
PROCESS_DEFINITION M * P - 2 * n + 4150 * c
PREFERENCES
PROCESS_INSTANCE p p 13 * n
PROCESS_INSTANCE_LCK p 1 * n
PROCESS_TRIGGER TR - 3 * n + 150 * c
PROCINST_HIERARCHY p 2 * n
PROCINST_SCOPE p p 3 * n
PROPERTY < 100 - 3 * n + 1100 * c
RUNTIME_ARTIFACT
SIGNAL_MESSAGE
SIGNAL_MESSAGE_LOOKUP
STRING_DATA ~ p * E * (e / 1000) p 2 * n + 4032 * c
STRUCTURED_DATA M * SD * SDX - 3 * n + 200 * c
STRUCTURED_DATA_VALUE SD * SDX * r p 6 * n + 178 * c
STRUCTURED_DATA_VALUE_LCK p 1 * n
TIMER_LOG TTR - 4 * n
TRANS_INST ~ a * p p 6 * n
TRANS_TOKEN t - 7 * n
TRANS_TOKEN_LCK p 1 * n
TRANSITION T * M - 5 * n + 250 * c
USER_PARTICIPANT u * ur u 5 * n
USER_PROPERTY u * up u 5 * n + 428 * c
USER_USERGROUP u * ug u 3 * n
USERGROUP ug ug 4 * n + 500 * n
USERGROUP_PROPERTY ug * ugp ug 6 * n + 428 * c
WFUSER_DOMAIN 0 - 5 * n
WFUSER_REALM re - 2 * n + 4150 * c
WFUSER_SESSION - u 5 * n + 300 * n
WORKFLOWUSER u u 7 * n + 1100 * n
WORKITEM wa * p p 13 * n

No. of records legend:

Scales to legend:

Record size legend:

Table Update behavior Updates Inserts Deletes
ACT_INST_HISTORY sa - Workflow step -
ACT_INST_PROPERTY v Event handling Event binding Event handling
ACTIVITY - Model overwrite Model deployment Model overwrite
ACTIVITY_INST_LOG sa - Workflow step -
ACTIVITY_INSTANCE a Workflow step Workflow step -
CLOB_DATA a Workflow step Workflow step -
DAEMON_LOG v Daemon execution Bootstrapping -
DATA - Model overwrite Model deployment Model overwrite
DATA_VALUE a Workflow step Workflow step -
DEPARTMENT v Department change/sync Department change/sync, Login -
DEPARTMENT_HIERARCHY v Department change/sync Department change/sync, Login -
DOMAIN sa - Partition creation Partition deletion
DOMAIN_HIERARCHY sa - Partition creation Partition deletion
EVENT_BINDING v Event handling Event binding Event handling
EVENT_HANDLER - Model overwrite Model deployment Model overwrite
LINK_TYPE
LOG_ENTRY sa - Log event -
MODEL - Model overwrite Model deployment -
MODEL_DEP
MODEL_REF
PARTICIPANT - Model overwrite Model deployment Model overwrite
PARTITION sa - Partition creation Partition deletion
PREFERENCES
PROC_INST_PROPERTY v Event handling Event binding Event handling
PROCINST_LINK
PROCESS_DEFINITION - Model overwrite Model deployment Model overwrite
PROCESS_INSTANCE a Workflow step Process start -
PROCESS_TRIGGER - Model overwrite Model deployment Model overwrite
PROCINST_HIERARCHY sa - Process start -
PROCINST_SCOPE sa - Process start -
PROPERTY v Administrative operations Administrative operations -
RUNTIME_ARTIFACT
SIGNAL_MESSAGE
SIGNAL_MESSAGE_LOOKUP
STRING_DATA a Workflow step / Model overwrite Workflow step / Model deployment -
STRUCTURED_DATA - Model overwrite Model deployment Model overwrite
STRUCTURED_DATA_VALUE a Workflow step Workflow step -
TIMER_LOG v Timer Based Trigger Execution Bootstrapping -
TRANS_INST a - Workflow step -
TRANS_TOKEN v Workflow step Workflow step Workflow step
TRANSITION - Model overwrite Model deployment Model overwrite
USER_PARTICIPANT v User change/sync User change/sync, Model deployment User change/sync
USER_PROPERTY v User change/sync User change/sync User change/sync
USER_USERGROUP v User group change/sync User group change/sync, Model deployment User group change/sync
USERGROUP v User group change/sync User group change/sync, Login -
USERGROUP_PROPERTY v User group change/sync User group change/sync User group change/sync
WFUSER_DOMAIN never never never
WFUSER_REALM a User change / synch User change / synch User change / synch
WFUSER_SESSION a Service calls First service call -
WORKFLOWUSER v User change/sync User change/sync, Login -
WORKITEM v Activity instance suspend / delegation / activation Activity instance suspend / delegation / activation Activity instance completion / hibernation / abortion

Update behavior legend: