Access to line-of-business databases in declarative workflow
First Claim
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;
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 a workflow;
initializing, at a server computing system, a workflow instance, the workflow instance being an instance of the 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 the 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;
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 the task of the business process facilitated by the selected activity, the natural language sentence including an input feature inserted within the natural language sentence, the input feature enabling the user to directly bind data to an input property of the selected activity by entering input data into the input feature, and the input feature further enabling the user to indirectly bind data to the input property of the selected activity by designing a lookup query through a lookup dialog user interface displayed by the design computing system, wherein the design computing system selects input data based on the lookup query;
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 Assignments
0 Petitions
Accused Products
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.
25 Citations
20 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; 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 a workflow; initializing, at a server computing system, a workflow instance, the workflow instance being an instance of the 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 the 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; 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 the task of the business process facilitated by the selected activity, the natural language sentence including an input feature inserted within the natural language sentence, the input feature enabling the user to directly bind data to an input property of the selected activity by entering input data into the input feature, and the input feature further enabling the user to indirectly bind data to the input property of the selected activity by designing a lookup query through a lookup dialog user interface displayed by the design computing system, wherein the design computing system selects input data based on the lookup query; 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. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14)
-
-
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; 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 a workflow; initialize a workflow instance, the workflow instance being an instance of the 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 the 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; 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 the task of the business process facilitated by the selected activity, the natural language sentence including an input feature, the input feature represented by an underscored blank, the input feature enabling the user to directly bind data to an input property of the selected activity by entering input data into the underscored blank, and the input feature further enabling the user to indirectly bind data to the input property of the selected activity by designing a lookup query through a lookup dialog user interface; 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. - View Dependent Claims (16, 17, 18, 19)
-
-
20. A computer-readable data storage device 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 represented by an underscored blank, the input feature enabling the user to directly bind data to an input property of the selected activity by entering input data into the underscored blank, and the input feature further enabling the user to indirectly bind data to the input property of the selected activity by designing a lookup query; display a lookup dialog user interface containing a catalog of available lists to enable the user to design the lookup query, 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 the item key field, no two data items in the second data item collection having the item key fields specifying the 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 the 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 a workflow file at the 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 selected 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 the 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.
-
Specification