Systems and methods for controlling transaction participation for groups of steps in a workflow

• US 7,603,363 B2
• Filed: 01/05/2005
• Issued: 10/13/2009
• Est. Priority Date: 01/05/2005
• Status: Expired due to Fees

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Howey, James K, Haselden, J Kirk, Ivanov, Sergei
• Primary Examiner(s): Y; Truong Cam
• Assistant Examiner(s): Hwa; Shyue Jiunn
• Application Number:
  US11/030,039
• Publication Number:
  US 20060149698A1
• Time in Patent Office: 1,742 Days
• Field of Search: None
• US Class Current: N/A
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: G06Q 10/0633 Workflow analysis
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users

Abstract

Systems, methods, and computer readable media for designing and executing workflows can be equipped with a means for manipulation of workflow steps by grouping them, such as by placing them in containers. A container can be associated with a database transaction. In some embodiments, a container property can be set to indicate whether the container must participate, may participate, or may not participate in a database transaction. Further, containers may be placed in parent containers, and optionally inherit the transaction property of the parent.

Claims

1. A method for controlling transactional properties of a plurality of steps in a workflow through a Graphical User Interface (GUI) that presents graphical representations of the plurality of steps in a processor, the method comprising:

selecting, by using the processor, a plurality of workflow steps;

associating the plurality of workflow steps with a container, wherein at least one property is defined for the container;

setting the at least one property of the container to indicate a level of participation of the plurality of workflow steps of the container in an atomic transaction, wherein the atomic transaction requires that the plurality of workflow steps participating in a transaction either all commit changes to a resource or all roll back any changes to the resource, and wherein the setting the at least one property comprises saving data identifying said at least one property;

associating a first transaction object with the container, wherein a value of the first transaction object is initially set to null;

associating the container with a parent container, the parent container being associated with a superset of workflow steps including the selected plurality of workflow steps and additional work flow steps related to the selected plurality of workflow steps and being associated with a second transaction object;

assigning a value of the second transaction object to the value of the first transaction object if the at least one property is set to indicate that the container participate in the atomic transaction, the assigned value representing that the superset of workflow steps including the plurality of workflow steps of the container of the first transaction object and the additional workflow steps of the parent container of the second transaction object are to be performed as the atomic transaction;

leaving the value of the first transaction object set to null if the at least one property is set to indicate that the container is not allowed to participate in the atomic transaction, the null value representing that the plurality of workflow steps of the container of the first transaction object and the additional workflow steps of the parent container of the second transaction object are to be performed as separate transactions;

storing the first transaction object with a first value thereof as assigned or as left null in a computer-readable storage medium;

retrieving the stored first transaction object with the first value thereof as assigned or as left null from the computer-readable storage medium;

employing the value of the retrieved first transaction object to determine whether the plurality of workflow steps of the container of the first transaction object and the additional workflow steps of the parent container of the second transaction object are to be performed as the atomic transaction or as separate transactions;

verifying that a connection object that communicates with one or more of the plurality of workflow steps and the container during execution of the workflow can support the atomic transaction; and

assigning the value of the second transaction object to the value of the first transaction object if the at least one property is set to indicate that the container must participate in the atomic transaction and the value of the second transaction object is not null.

2. The method of claim 1 wherein the at least one property is set to indicate that the container may participate in the atomic transaction.

3. The method of claim 2, further comprising assigning the atomic transaction to the container.

4. The method of claim 1 wherein the at least one property is set to indicate that the container must participate in the atomic transaction.

5. The method of claim 4, further comprising assigning the atomic transaction to the container.

6. The method of claim 1, further comprising assigning a new transaction object to the container if (1) the at least one property is set to indicate that the container must participate in the atomic transaction and (2) the value of the second transaction object is null.

7. A system comprising a processor, and a Graphical User Interface (GUI) for defining relationships between a plurality of steps in a workflow and a workflow execution engine for executing the workflow, said system comprising:

memory containing instructions for use in execution by the processor to perform operations including;

selecting a plurality of workflow steps;

associating the plurality of workflow steps with a container, wherein at least one property is defined for the container;

setting the at least one property of the container to indicate a level of participation of the plurality of workflow steps of the container in an atomic transaction, wherein the atomic transaction requires that the plurality of workflow steps participating in a transaction either all commit changes to a resource or all roll back any changes to the resource, and wherein the setting the at least one property comprises saving data identifying said at least one property;

associating a first transaction object with the container, wherein a value of the first transaction object is initially set to null;

associating the container with a parent container, the parent container being associated with a superset of workflow steps including the selected plurality of workflow steps and additional work flow steps related to the selected plurality of workflow steps and being associated with a second transaction object;

assigning a value of the second transaction object to the value of the first transaction object if the at least one property is set to indicate that the container participate in the atomic transaction, the assigned value representing that the superset of workflow steps including the plurality of workflow steps of the container of the first transaction object and the additional workflow steps of the parent container of the second transaction object are to be performed as the atomic transaction;

leaving the value of the first transaction object set to null if the at least one property is set to indicate that the container is not allowed to participate in the atomic transaction, the null value representing that the plurality of workflow steps of the container of the first transaction object and the additional workflow steps of the parent container of the second transaction object are to be performed as separate transactions;

storing the first transaction object with a first value thereof as assigned or as left null in the computer-readable storage medium;

retrieving the stored first transaction object with the first value thereof as assigned or as left null from the computer-readable storage medium;

employing the value of the retrieved first transaction object to determine whether the plurality of workflow steps of the container of the first transaction object and the additional workflow steps of the parent container of the second transaction object are to be performed as the atomic transaction or as separate transactions;

verifying that a connection object that communicates with one or more of the plurality of workflow steps and the container during execution of the workflow can support the atomic transaction; and

assigning the value of the second transaction object to the value of the first transaction object if the at least one property is set to indicate that the container must participate in the atomic transaction and the value of the second transaction object is not null.

8. The system of claim 7 wherein the at least one property is set to indicate that the container must participate in the atomic transaction.

9. The system of claim 8, further comprising means for assigning the atomic transaction to the container.

10. The system of claim 9 wherein the atomic transaction that is assigned to the container is a newly created atomic transaction.

11. The system of claim 8, further comprising means for verifying that at least one connection object that one or more of the plurality of workflow steps and the container communicate with during execution of the workflow can support the atomic transaction.

12. The system of claim 7 wherein the at least one property is set to indicate that the container may not participate in the atomic transaction.

13. The system of claim 7, further comprising means for passing an identifier for the atomic transaction to at least one connection object that one or more of the plurality of workflow steps and the container communicate with during execution of the workflow.

14. The system of claim 7, further comprising means for assigning the value of the second transaction object to the value of the first transaction object if (1) the at least one property is set to indicate that the container must participate in the atomic transaction and (2) the value of the second transaction object is not null.

15. The system of claim 7, further comprising means for assigning a new transaction object to the container if (1) the at least one property is set to indicate that the container must participate in the atomic transaction and (2) the value of the second transaction object is null.

16. A computer readable storage medium bearing instructions for controlling the transactional properties of a plurality of steps in a workflow, wherein the instructions perform:

selecting a plurality of workflow steps;

associating the plurality of workflow steps with a container, wherein at least one property is defined for the container;

setting the at least one property of the container to indicate a level of participation of the plurality of workflow steps of the container in an atomic transaction, wherein the atomic transaction requires that the plurality of workflow steps participating in a transaction either all commit changes to a resource or all roll back any changes to the resource, and wherein the setting the at least one property comprises saving data identifying said at least one property;

associating a first transaction object with the container, wherein a value of the first transaction object is initially set to null;

associating the container with a parent container, the parent container being associated with a superset of workflow steps including the selected plurality of workflow steps and additional work flow steps related to the selected plurality of workflow steps and being associated with a second transaction object;

assigning a value of the second transaction object to the value of the first transaction object if the at least one property is set to indicate that the container participate in the atomic transaction, the assigned value representing that the superset of workflow steps including the plurality of workflow steps of the container of the first transaction object and the additional workflow steps of the parent container of the second transaction object are to be performed as the atomic transaction;

leaving the value of the first transaction object set to null if the at least one property is set to indicate that the container is not allowed to participate in the atomic transaction, the null value representing that the plurality of workflow steps of the container of the first transaction object and the additional workflow steps of the parent container of the second transaction object are to be performed as separate transactions;

storing the first transaction object with a first value thereof as assigned or as left null in a computer-readable storage medium;

retrieving the stored first transaction object with the first value thereof as assigned or as left null from the computer-readable storage memory;

employing the value of the retrieved first transaction object to determine whether the plurality of workflow steps of the container of the first transaction object and the additional workflow steps of the parent container of the second transaction object are to be performed as the atomic transaction or as separate transactions;

verifying that a connection object that communicates with one or more of the plurality of workflow steps and the container during execution of the workflow can support the atomic transaction; and

assigning the value of the second transaction object to the value of the first transaction object if the at least one property is set to indicate that the container must participate in the atomic transaction and the value of the second transaction object is not null.

17. The computer readable storage medium of claim 16, further comprising instructions for verifying that at least one connection object that one or more of the plurality of workflow steps and the container communicate with during execution of the workflow can support the atomic transaction.

18. The computer readable storage medium of claim 16 wherein the transaction option property is set to indicate that the container must participate in the atomic transaction.

19. The computer readable storage medium of claim 18, further comprising instructions for assigning the atomic transaction to the container.

20. The computer readable storage medium of claim 16, further comprising instructions for assigning the value of the second transaction object to the value of the first transaction object if (1) the at least one property is set to indicate that the container must participate in the atomic transaction and (2) the value of the second transaction object is not null.