System and method for performing consistent workflow process execution in a workflow management system

A computer-implemented method for allowing consistent executing of a workflow process in a workflow management system, comprising

• (A) allowing each of a plurality of interconnected nodes of the workflow process to read and write data items to and from a workflow process database in carrying out workflow actions associated with the respective nodes of the workflow process, wherein the workflow actions include multiple workflow actions including at least one set of parallel actions;
• (B) maintaining the execution consistency among the workflow actions when the nodes access the workflow process database to read and write the data items in carrying out the workflow actions while maintaining execution concurrency among the workflow actions, wherein the step (B) further comprises the steps of
• (I) locking a data item in the database when the data item is to be read or updated by a node of the nodes before the read or update operation is commenced;
• (II) releasing the lock after the node has performed the read or update operation regarding the data item;
• (III) causing the node to update the workflow process database with the data item if the data item was either not previously updated or previously updated by another node executing another action which has accessed the same action database of the workflow management system with a smaller serialization order.

A computer-implemented method for allowing consistent executing of a workflow process in a workflow management system, comprising

• (A) allowing each of a plurality of interconnected nodes of the workflow process to read and write data items to and from a workflow process database in carrying out workflow actions associated with the respective nodes of the workflow process, wherein the workflow actions include multiple workflow actions including at least one set of parallel actions;
• (B) maintaining the execution consistency among the workflow actions when the nodes access the workflow process database to read and write the data items in carrying out the workflow actions while maintaining execution concurrency among the workflow actions, wherein the step (B) further comprising the steps of
• (a) performing an atomic read operation to read all data items from the workflow process database for an associated action, wherein the data items are locked when being read and released from being locked after being read;
• (b) causing the associated action to be executed;
• (c) performing an atomic update operation to update the data items in the workflow process database, wherein the data items are locked when being updated and released from being locked after being updated, wherein the step (c) further comprises the step of not updating the data item if the data item was previously updated by another node executing another action which has accessed the same action database of the workflow management system with a greater serialization order.