Create process instances and calculate measures

Copy EPC phase

In this step, the imported fragments are exported from the EPK_IMPORT_TBL table and written to the EPK_TBL table. The calculated values of all process-related keys (process, shared fragment, hierarchy keys) are saved with foreign key relation to the corresponding fragment in certain tables. Exactly to which tables they are saved depends on the state of the database, for example, if process instances already exist in the database. Subsequently, the fragment is deleted from the EPK_IMPORT_TBL.

Merger phase

Fragments with identical process key are combined in one process instance. Two fragments are processed for this, i.e., all objects and connections of the fragment with the older import time stamp are copied to the fragment with the more recent import time stamp. This process is repeated until only unique process keys exist in the database.

Hierarchies phase

The sequence of calculation of hierarchically dependent process instances is specified and the state of the references is updated.

Measure calculation phase

In this phase, process instances are typified and calculated. Fragments and keys no longer needed in the database are deleted and the calculated process instances are written back into the EPK_TBL.

Consolidating fragments into process instances requires the process keys of all imported fragments to be held in the main memory so that they can be processed simultaneously. If you import a large number of fragments in one import process, the main memory size might not be sufficient. Use the READ_RATE_EPC key of the EpkImport_settings.properties configuration file to set the maximum number of fragment instances to be imported in one process step. Default value = 100000.