Access to Line-of-Business Databases in Declarative Workflow

• US 20100250487A1
• Filed: 03/31/2009
• Published: 09/30/2010
• Est. Priority Date: 03/31/2009
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Stevenson, Bradley C., Campbell, Jonathan T., Phair, Mark E., Stanciu, Constantin, Gabriel, Sean K., Malek, Alexander, Chou, Eray
• Granted Patent: US 8,442,937 B2
• Time in Patent Office: Days
• US Class Current: 707/608
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling

Abstract

A first database and a second database have different schemas. An activity in a workflow accesses a data item in a list by invoking a method in an interface of a list object. The list comprises a collection of data items. Each data item in the list comprises an item key field specifying an item key. No two data items in the data item collection have item key fields specifying a shared item key. In addition, each data item in the list comprises a set of additional fields. Each field in the set of additional fields has a value derived from the first database or each field in the set of additional fields has a value derived from the second database. In this way, the activity can be implemented without knowledge of the different schemas of the first database and the second database.

Claims

1. A method for performing an automated business process, the method comprising:

storing a first database at a data storage system;

storing a second database at the data storage system, the first database having a different schema than the second database;

initializing, at a server computing system, a workflow instance, the workflow instance being an instance of a workflow that facilitates performance by an enterprise of a business process, the business process being a structured set of tasks routinely performed by the enterprise to accomplish a specific business goal, the workflow instance comprising a plurality of activities, each activity in the plurality of activities comprising a set of computer-executable code that when executed facilitates performance of a task in the business process;

initializing, at the server computing system, a list object, the list object being a software object enabling access to a list, the list comprising a data item collection, each data item in the data item collection comprising an item key field specifying an item key, no two data items in the data item collection having item key fields specifying a shared item key, each data item in the data item collection comprising a set of additional fields, each field in the set of additional fields having a value derived from the first database or each field in the set of additional fields having a value derived from the second database, the list object implementing an interface, the interface being the same regardless of whether fields in the set of additional fields have values derived from the first database or the second database, the item keys specified by the item key fields being of a same data type regardless of whether fields in the set of additional fields have values derived from the first database or the second database;

initiating, at the server computing system, after initializing the workflow instance and the list object, execution of the workflow instance;

accessing, at the server computing system, during execution of the workflow instance in response to executing one of the activities in the workflow instance, a data item in the list by invoking an access method of the list object, the access method being a member of the interface; and

completing, at the server computing system, execution of the workflow instance, thereby completing a cycle of the business process.

2. The method of claim 1,

wherein the access method is a delete method;

and

wherein accessing the data item comprises invoking the delete method, the server computing system providing an item key of the data item as a parameter to the delete method.

3. The method of claim 1, wherein accessing the data item comprises modifying the data item.

4. The method of claim 1, wherein accessing the data item comprises adding the data item to the list.

5. The method of claim 1 further comprising:

during execution of the workflow instance prior to accessing the data item, initiating, by the server computing system, invoking a query method of the list object, wherein the server computing system initiates the query in response to executing the activity; and

during execution of the workflow instance, receiving, by the server computing system, the item key of the data item, wherein the server computing system receives the data item collection in response to executing the query method of the list object.

6. The method of claim 5, wherein the query is a Collaborative Application Markup Language (CAML) query.

7. The method of claim 1 further comprising:

prior to initializing the workflow instance, displaying, by a design computing system, a workflow design user interface containing a catalog of available activities, the catalog of available activities including names of activities available to be included in the workflow;

displaying, by the design computing system, a catalog of available lists in the workflow design user interface, the available lists including the list;

receiving, at the design computing system, list selection input from the user via the workflow design user interface, the list selection input indicating a selected list, the selected list being one of the available lists;

receiving, at the design computing system, activity selection input from a user via the workflow design user interface, the activity selection input indicating a selected activity selected by the user from the catalog of available activity,

displaying, by the design computing system in response to receiving the activity selection input, a natural language sentence in the workflow design user interface, the natural language sentence describing a task of the business process facilitated by the selected activity, the natural language sentence including an input feature, the input feature enabling the user to bind data to an input property of the selected activity;

receiving, at the design computing system, target field selection input from the user via the workflow design user interface, the target field selection input indicating a target field of the selected list;

receiving, at the design computing system, criterion field selection input from the user via the workflow design user interface, the criterion field selection input indicating a criterion field of the selected list;

receiving, at the design computing system, criterion value selection input from the user via the workflow design user interface, the criterion value selection input indicating a criterion value;

after receiving the list selection input, the target field selection input, the criterion field selection input, and the criterion value selection input, updating, by the design computing system, a workflow file to include an activity element, the workflow file defining the workflow, the activity element indicating the selected activity, the activity element having an attribute associated with the input property of the selected activity, the attribute specifying the selected list, the target field, the criterion field, and the criterion value; and

after updating the workflow file, storing the workflow file at the data storage system.

8. The method of claim 7, wherein initializing the workflow instance comprises instantiating each activity specified by activity elements in the workflow file.

9. The method of claim 7 further comprising:

during execution of the workflow instance, invoking, at the server computing system, a query method of the list object, the query method being a member of the interface, wherein the server computing system invokes the query method in response to executing the selected activity;

during execution of the workflow instance, receiving, at the server computing system, a target value, the server computing system receiving the target value in response to executing the query method, the target value being the value of the target field of a first data item in the selected list, the criterion field of the first data item specifying the criterion value; and

during execution of the workflow instance, use the target value in response to executing the selected activity.

10. The method of claim 7, wherein the workflow file is an extensible markup language (XML) file.

11. The method of claim 7, wherein the selected list is a external list.

12. The method of claim 11, wherein external lists and actual lists are presented in the catalog of available lists such that the user cannot distinguish which lists in the catalog of available lists are external lists and which lists in the catalog of available lists are actual lists.

13. The method of claim 1, wherein the list is drawn from a table in the first database that does not include a unique key for each table row.

14. The method of claim 1, wherein the first database is a line-of-business database.

15. An electronic computing system comprising:

a processing unit; and

a data storage system, the data storage system storing;

a first database;

a second database, the first database having a different schema than the second database; and

a set of computer-executable instructions, the computer-executable instructions, when executed by the processing unit, cause the electronic computing system to;

initialize a workflow instance, the workflow instance being an instance of a workflow that facilitates performance by an enterprise of a business process, the business process being a structured set of tasks routinely performed by the enterprise to accomplish a specific business goal, the workflow instance comprising a plurality of activities, each activity in the plurality of activities comprising a set of computer-executable code that when executed facilitates performance of a task in the business process;

initialize a list object, the list object being a software object enabling access to a list, each data item in the list comprising an item key field specifying an item key, no two data items in the list having item key fields specifying a shared item key, each data item in the list comprising a set of additional fields, each field in the set of additional fields having a value derived from the first database or each field in the set of additional fields having a value derived from the second database, the list object implementing an interface, the interface being the same regardless of whether fields in the set of additional fields have values derived from the first database or the second database, the item keys being of a same data type regardless of whether fields in the set of additional fields have values derived from the first database or the second database;

initiate, after initializing the workflow instance and the list object, execution of the workflow instance;

access, during execution of the workflow instance in response to executing one of the activities in the workflow instance, a data item in the list by invoking an access method of the list object, the access method being a member of the interface; and

complete execution of the workflow instance, thereby completing a cycle of the business process.

16. The electronic computing system of claim 15, wherein the electronic computing system provides an item key as a parameter of the access method.

17. The electronic computing system of claim 15, the computer-executable instructions further causing the electronic computing system to:

initiate a query during execution of the workflow instance in response to executing a first activity in the workflow instance; and

receive a data item collection in response to executing the first activity, the data item collection including the data item, each data item in the data item collection containing information responsive to the query.

18. The electronic computing system of claim 15, the computer-executable instructions further causing the electronic computing system to:

display a workflow design user interface containing a catalog of available activities, the catalog of available activities including names of activities available to be included in the workflow;

receive activity selection input from a user via the workflow design user interface, the activity selection input indicating a selected activity selected by the user from the catalog of available activities,

display, in response to receiving the activity selection input, a natural language sentence in the workflow design user interface, the natural language sentence describing a task of the business process facilitated by the selected activity, the natural language sentence including an input feature, the input feature enabling the user to bind data to an input property of the selected activity;

receive lookup dialog input from the user;

display, in response to receiving the lookup dialog input, a lookup dialog user interface containing a catalog of available lists, the available lists including the list;

receive list selection input from the user via the workflow design user interface, the list selection input indicating a selected list, the selected list being one of the available lists;

receive target field selection input from the user via the workflow design user interface, the target field selection input indicating a target field of the selected list;

receive criterion field selection input from the user via the workflow design user interface, the criterion field selection input indicating a criterion field of the selected list;

receive criterion value selection input from the user via the workflow design user interface, the criterion value selection input indicating a criterion value;

update a workflow file after receiving the list selection input, the target field selection input, the criterion field selection input, and the criterion value selection input, the electronic computing system updating the workflow file such that the workflow file includes an activity element, the workflow file defining the workflow, the activity element indicating the selected activity, the activity element having an attribute associated with the input property of the selected activity, the attribute specifying the selected list, the target field, the criterion field, and the criterion value;

store, after updating the workflow file, the workflow file at the data storage system;

during execution of the workflow instance, invoke a query method of the list object in response to executing the selected activity, the query method being a member of the interface;

during execution of the workflow instance, receive, in response to invoking the query method, a target value, the target value being the value of the target field of a first data item in the selected list, the criterion field of the first data item specifying the criterion value; and

during execution of the workflow instance, use the target value in response to executing the selected activity.

19. The electronic computing system of claim 17, wherein external lists and actual lists are presented in the catalog of available lists such that the user cannot distinguish which lists in the catalog of available lists are external lists and which lists in the catalog of available lists are actual lists.

20. A computer-readable data storage medium comprising computer-executable instructions that, when executed by a processing unit of an electronic computing system, cause the electronic computing system to:

store a first database at a data storage system;

store a second database at the data storage system, the second database having a different schema than the first database;

display a workflow design user interface containing a catalog of available activities, the catalog of available activities including names of activities;

receive activity selection input from a user via the workflow design user interface, the activity selection input indicating a selected activity selected by the user from the catalog of available activities,

display, in response to receiving the activity selection input, a natural language sentence in the workflow design user interface, the natural language sentence describing a business process task facilitated by the selected activity, the natural language sentence including an input feature, the input feature enabling the user to bind data to an input property of the selected activity;

display a lookup dialog user interface containing a catalog of available lists, the available lists including a first list and a second list,

the first list comprising a first data item collection, each data item in the first data item collection comprising an item key field, no two data items in the first data item collection having item key fields specifying a shared item key, each data item in the first data item collection comprising a first set of additional fields, each field in the first set of additional fields having a value stored in or derived from the first database,

the second list comprising a second data item collection, each data item in the second data item collection comprising an item key field, no two data items in the second data item collection having item key fields specifying a shared item key, each data item in the second data item collection comprising a second set of additional fields, each field in the second set of additional fields having a value stored in or derived from the second database;

receive list selection input from the user via the workflow design user interface, the list selection input indicating a selected list, the selected list being one of the available lists;

receive target field selection input from the user via the workflow design user interface, the target field selection input indicating a target field of the selected list;

receive criterion field selection input from the user via the workflow design user interface, the criterion field selection input indicating a criterion field of the selected list;

receive criterion value selection input from the user via the workflow design user interface, the criterion value selection input indicating a criterion value;

after receiving the list selection input, the target field selection input, the criterion field selection input, and the criterion value selection input, store the workflow file at a data storage system, the workflow file containing a plurality of activity elements, each activity element indicating an activity in a workflow that facilitates performance by an enterprise of a business process, the business process being a structured set of tasks routinely performed by the enterprise to accomplish a specific business goal, the plurality of activity elements including a selected activity element that indicates the selected activity, the selected activity element having an attribute associated with the input property of the selected activity, the attribute specifying the target list, the target field, the criterion field, and the criterion item key;

initialize a workflow instance, the workflow instance comprising a plurality of activities, each activity in the plurality of activities being indicated by an activity element in the plurality of activity elements in the workflow file;

initialize a list object, the list object being a software object enabling access to the selected list, the list object implementing an interface, the interface being the same regardless of whether the selected list is the first list or the second list;

initiate execution of the workflow instance;

during execution of the workflow instance, invoke a query method of the list object in response to executing the selected activity, the query method being a member of the interface;

during execution of the workflow instance, receive, in response to invoking the query method, a target value, the target value being the value of the target field of a first data item in the selected list, the criterion field of the first data item specifying the criterion value;

during execution of the workflow instance, use the target value in response to executing the selected activity; and

complete execution of the workflow instance, thereby completing a cycle of the business process.