This application is related to the following copending and commonly assigned patent filed on the same date herewith, which are incorporated herein by reference in their entirety:
1. Field of the Invention
The present invention relates to a method, system, and program for using objects in data stores during execution of a workflow.
2. Description of the Related Art
A workflow program allows businesses and other organizations to define their business operations as a computer model known as a workflow. A workflow defines a series of processes to be performed by users at a client computer. The user activities at the client computers may involve updating an electronic form, reviewing information, etc. After one user in the workflow performs a specified action, the work item or other information is then routed to one or more further nodes where further action may be taken. For instance, an on-line purchase of a product may involve numerous steps, such as receiving the customer order, routing the customer order to the credit department to process the bill and then routing the order to the shipment department to prepare the shipment. Once the shipment is prepared, the product may be shipped and information on the purchase is then transferred to the customer service department to take any further action. Each of these processes may be defined as nodes in a workflow. A workflow program would then route the customer order to the business agents designated to handle the job. For instance, the initial order would be received by the order department and then routed to a person in shipping and billing. Once the bill and package are prepared, a further invoice may be forwarded to shipping. After shipping sends the package, the shipping agent may then enter information into the invoice and forward the electronic invoice to customer service for any follow up action.
A workflow is designed using workflow software, such as the International Business Machines (IBM) MQSERIES** Workflow software product. A process modeler is a person that analyzes the business operations, determines how the information related to the operations is routed electronically to client computers, and then defines a workflow model of the operations. The workflow model may be coded in the FlowMark Definition Language (FDL). The workflow model is then imported into a Runtime program that verifies and translates the workflow model into a process template. An instance of the process template can then be invoked to automates the sequence of events defined by the model.
There is a continued need in the art to provide improved techniques for building and utilizing workflow models.
Provided is a method, system, and program for implementing a workflow comprised of nodes. A workflow packet is generated that is accessed by users at the nodes in the workflow. A request is received to add one target object in one of the data stores to the packet, wherein each data store includes multiple objects. A determination is made of a first object identifier of the target object that is used to identify the target object in one data store. A second object identifier is generated indicating the data store including the target object and the first object identifier. The generated second object identifier is inserted into the workflow packet, where nodes accessing objects in the workflow packet use the second object identifier to access the target object for use at the node.
In further implementations, the data stores are capable of being different types of data stores and from different vendors
Further provided is a method, system, and program for performing an Input/Output (I/O) operation on an object during execution of a workflow comprised of nodes. A plurality of objects are stored in one of multiple data stores, wherein each object is identified within the data store with a first object identifier. A workflow packet references at least one object with a second object identifier, wherein the second object identifier indicates one of the data stores and the first object identifier of the referenced object in the data store. An I/O request for one target object referenced by one second object identifier in the workflow packet is received from one node. A determination is made from the second object identifier of the data store for the target object and the first object identifier of the target object. The I/O request is performed on the target object at the determined first object identifier in the determined data store.
In further implementations, one workflow packet is associated with a plurality of the nodes in the workflow, wherein the nodes submit I/O requests for one or more objects referenced by the second object identifiers in the workflow packet.
In still further implementations, the I/O request comprises a workflow I/O request and each data store is accessed using data store interfaces. Provided is a mapping of workflow I/O requests to the data store interfaces for each of the data stores, wherein each workflow I/O request maps to one or more data store interfaces for each data store. Each data store interfaces for each data that are capable of implementing the workflow I/O request in the data store. A determination is made from the mapping the at least one data store interface for the determined data store that implements the workflow I/O request in the determined data store. The workflow I/O request is performed using the determined at least one data store interface.
Still further, the data stores are capable of comprising different types of data stores from different vendors that utilize different sets of data store interfaces to enable access to objects in the data store. In such case, the mapping enables the workflow I/O requests to be executed across heterogeneous data stores.
The described implementations provide a technique for implementing references to objects dispersed across multiple data stores to allow nodes in a workflow to access the objects in any of the data stores. The described techniques are capable of allowing nodes access to the objects in the different data stores even when the data stores comprise heterogeneous data stores of different types and from different vendors.
Referring now to the drawings in which like reference numbers represent corresponding parts throughout:
In the following description, reference is made to the accompanying drawings which form a part hereof and which illustrate several embodiments of the present invention. It is understood that other embodiments may be utilized and structural and operational changes may be made without departing from the scope of the present invention.
The workflow server 6 coordinates and manages the execution of processes for a defined process template 8. The workflow server 6 executes any programs associated with a process defined for the workflow, interprets the process definitions, creates process instances and manages their execution, manages processes and states, logs events, communicates with users as part of the workflow, etc. The workflow server 6 may include a database client program (not shown) to access and update records related to the workflow being processed maintained in the runtime database 4. The workflow server 6 processing may be distributed across multiple computers to achieve workload balancing.
The workflow clients 12a, b . . . n represent the client computers that execute workflow application program interfaces (APIs) to perform workflow related actions and activities and return messages to the workflow server 6. The workflow clients 12a, b . . . n thus comprise instances of the workflow code on the client computers that allow users to interface with the executing workflow and the workflow server 6. The workflow server 6 would execute activity programs as part of executing the workflow and transmit messages and data to the workflow client 12 to request user action to proceed with the workflow. The actions associated with the nodes and executed by the workflow server 6 may comprise Java servlets. The workflow client 12 may comprise a Web browser capable of executing Java scripts transferred from the Java servlet executing on the workflow server 6. Further, details on implementations and interactions of the workflow server 6 and client 12 are described in the IBM publication “IBM MQSeries Workflow: Concepts and Architecture, Version 3.3”, IBM document no. GH12-6285-03 (March, 2001), which publication is incorporated herein by reference in its entirety.
A workflow builder 20 comprises a system including a buildtime program 22 that implements a plurality of graphical user interface (GUI) panels in which a user may define the components of a workflow model 24. A workflow translator 26 converts the workflow model 24, with the defined workflow components, into a workflow definition language (WDL) file 10 that implements the workflow model 24. The workflow definition language (WDL) may comprise the FlowMark Definition Language (FDL), Workflow Process Definition Language (WPDL) or any other workflow definition language known in the art that is used to define workflows. The workflow translator 24 would transfer the WDL file 10 to the workflow server 6 to transform into a process template 8 in the runtime database 4 in a manner known in the art.
The workflow engine 2, and each of the program components therein, such as the runtime database 4 and workflow server 6, may be implemented in one or more computing machines. The workflow clients 12 which provide the workflow interface to users may be implemented on one or more client machines. The workflow builder 20, including the buildtime program 22 and workflow translator 26 programs, may be implemented on one or more computing machines. Any portion of the workflow engine 2, workflow builder 20, and/or workflow client 12, and program components therein, may be implemented on the same computing machines or separate machines. The computing machines used to implement the workflow engine 2, workflow clients 12, and workflow builder 20 may comprise any computing device known in the art, such as a server, workstation, mainframe, personal computer, laptop computer, hand held computer, telephony device, etc.
As discussed, the buildtime program 22 generates a series of graphical user interface (GUI) panels through which the user may define a workflow. Before utilizing the buildtime program 22, the process modeler would plan the workflow and analyze the work the business performs, how it is performed, and by whom. The process modeler may then develop a workflow to generate a final product, which may comprise the result of the effort of a single business unit or the cumulative efforts of multiple users and units within an organization. To produce the final product, a workflow packet comprised of one or more documents would transfer through various user work stations in the company defined as nodes in the workflow to require the user associated with such node to handle and process and forward to another user to handle. A document is comprised of a multimedia item that has digital content.
For instance, an insurance company may have to process numerous documents related to an insurance claim, such as photographs, appraisals, expert reports, etc. Employees may spend a substantial amount of time sorting through documents and associating the documents with particular claims. In the workflow model, all the documents related to a single claim would be part of a work packet that may move through various user stations to review and process. The workflow would comprise the flow of work and actions that are performed on the documents or workflow packet by multiple users in the system.
The workflow defines the sequence and boundaries of how the work is performed with respect to the documents in the workflow packet, and any restrictions on the order in which documents in the workflow packet must be processed. For instance, before the claim can proceed to a further step, a claims adjuster might be required to ensure that certain documents are included in the workflow packet for the claim before the workflow packet can proceed to further nodes in the workflow, e.g., determining the amount of compensation.
In workflow terminology, a worklist is a queue of work items. Each work item comprises a unit of work for a node in the workflow that is performed by the users associated with that node. Each work item may be associated with one work packet, which comprises documents or objects that are processed during the work defined for that work item. When a user at one node accesses the work item to perform the work defined therein, that workitem is locked, thereby preventing others at that node from accessing the work item.
A worklist, which is a queue of work for the users of the organization to perform with respect to the workflow packet. The work items within the worklist can be handled by any of the employees/users assigned to the worklist. An action list defines the actions that a user can perform on the work packet objects associated with the work item, such as selections or data that may be entered in the work packet. For example, an adjuster in the claim process workflow can select an option to continue consideration of the claim if it appears valid or select an option to reject the claim. The workflow further consists of the paths defined as the connections between nodes which indicate the order of execution of nodes in the workflow.
As mentioned, the start 54 and end 56 icons may be automatically added to the workflow 52 when the user starts a blank workflow model 24. The user may move the start 54 and end 56 icons to any location on the drawing surface. The user may select the control icons 66 and 68 to add work and user exit nodes, respectively, to the workflow. Control icon 70 is used to define a path between two nodes defining the sequence in which the nodes are processed, and the order in which the work items are processed. The path lines, which are shown as the arrows between the start 54, end 56, work and user exit icons 58, 60, 62, and 64 illustrate the operation flow from one node to another.
Once the process modeler has defined the general layout of a workflow using the control icons 66, 68, 70, and 72, as shown in the workflow 52 in
After defining the properties for the new workflow and placing icons in the drawing area and path arrows to define the workflow, the user would then use the GUI panels shown in
Using all the above described panels shown in
In certain implementations, the workflow model 24 defined using the buildtime program 22 is document centric in that the actions performed at the node concern the processing of work packages that may comprise any content or object that is processed and routed through the workflow.
If (at block 314) notification is enabled for the current node and the deadline has passed (at block 316) without receiving a response from the user, then the workflow server 6 notifies the user specified with the enable notification that the deadline has passed. Upon receiving (at block 318) a response from the user, which may comprise entering information, modifying a work item, adding a work item to the work package, selecting an option, etc., the workflow server 6 unlocks (at block 320) the work item(s) previously locked for the user. If (at block 322) the current node is the stop node, then control ends; otherwise, if there are further nodes to process in the workflow, then the workflow server 6 determines (at block 324) from the path from the current node the next node in the workflow and accesses (at block 326) the next node. Control then proceeds back to block 326 to process the next node.
The workflow logic of
With the described implementations, the workflow builder 20 generates a WDL file 10 that may be compatible with workflow engines from different vendors because different vendors may design their workflow engines to be compatible with the WDL format of the WDL file 10. This allows the workflow model defined in the WDL file 10 to be transportable across different vendor workflow engine platforms. Utilizing Documents from Heterogeneous Data Stores in the Workflow
Each of the data stores 432a, b, c may be accessed using data store APIs 430a, b, c provided by the particular data store vendor. For instance, if the data store 432a, b, c comprises a database, then the data store APIs 430a, b, c would comprise the database client APIs needed to request data from a database server managing access to the database. In the case of the database, the data store APIs 430a, b, c would comprise the data store vendor's particular implementation of the Structured Query Language (SQL).
The data store interface 422 further includes a workflow/data store API mapping 434 that provides a correspondence of the workflow APIs 420 to APIs in each of the data store APIs 430a, b, c. For instance, if the workflow API requests to OPEN a document, then the workflow/data store API mapping 434 would provide the corresponding OPEN command for one of the vendor data stores API 430a, b, c. The workflow/data store API mapping 434 may use any technique known in the art to map commands from the workflow APIs 420 to one or more commands in each of the data store APIs 430a, b, c.
In certain implementations, objects in the data stores 432a, b, c are provided a unique identifier across all the data stores 432a, b, c, such that the unique identifier can be used to identify one object in one of the data stores 432a, b, c, referred to herein as a persistent identifier (“PID”).
The described implementations provide an architecture to allow the workflow clients 412a, b, c performing actions defined in a work item 512a, b, c, d at one node 504a, b, c, d in the workflow to seamlessly access any object in one of multiple heterogeneous data stores 432a, b, c, that may comprise different data store types, e.g., databases, data repositories, etc., from different vendors. The workflow client 412a, b, c uses the workflow APIs to perform I/Os with respect to a PID referencing an object in any of the data stores 432a, b, c and the data store interface 422 determines the API from the data store APIs 430a, b, for the determined data store 432a, b, c to use to execute the submitted data store APIs 430a, b, c at the data store 432a, b, c.
Further, with the described implementations, the content or documents referenced in the workflow packet at the nodes 504a, b, c, d may be modified by modifying the PIDs 500a, b, c listed in the workflow packet 502. This allows the content of the workflow packet 502 to be modified as the workflow packet 502 is being routed between the workflow nodes 504a, b, c, d.
The preferred embodiments may be implemented as a method, apparatus or article of manufacture using standard programming and/or engineering techniques to produce software or code. The term “article of manufacture” as used herein refers to code or logic implemented in a computer readable medium (e.g., magnetic storage medium (e.g., hard disk drives, floppy disks, tape, etc.), optical storage (CD-ROMs, optical disks, etc.), volatile and non-volatile memory devices (e.g., EEPROMs, ROMs, PROMs, RAMs, DRAMs, SRAMs, firmware, programmable logic, etc.). Code in the computer readable medium is accessed and executed by a processor. The code in which preferred embodiments are implemented may further be accessible through a transmission media or from a file server over a network. In such cases, the article of manufacture in which the code is implemented may comprise a transmission media, such as a network transmission line, wireless transmission media, signals propagating through space, radio waves, infrared signals, etc. Of course, those skilled in the art will recognize that many modifications may be made to this configuration without departing from the scope of the present invention, and that the article of manufacture may comprise any information bearing medium known in the art.
The workflow client and server may be implemented within any vendor workflow program known in the art.
In the described implementations, the actions were implemented as Java methods. Alternatively, the actions may be implemented in any programming language known in the art.
In the described implementations, particular icons were used to represent different information in the workflow, such as work nodes, exit nodes, etc. However, any icon design may be used to represent the workflow components. Further, additional graphical representations may be provided for different types of work nodes, e.g., collection work nodes, assign value node, decision point node, etc.
In the described implementations, the class architecture is implemented as an object oriented class architecture. Alternatively, non-object oriented programming techniques may be used to implement the described class architecture.
In the described implementations, the data stores comprised heterogeneous data stores managed by different types of data management programs and from different vendors. Additionally, the data stores may be of a same type and from a same vendor.
The foregoing description of the preferred embodiments of the invention has been presented for the purposes of illustration and description. It is not intended to be exhaustive or to limit the invention to the precise form disclosed. Many modifications and variations are possible in light of the above teaching. It is intended that the scope of the invention be limited not by this detailed description, but rather by the claims appended hereto. The above specification, examples and data provide a complete description of the manufacture and use of the composition of the invention. Since many embodiments of the invention can be made without departing from the spirit and scope of the invention, the invention resides in the claims hereinafter appended.
Number | Name | Date | Kind |
---|---|---|---|
5301320 | McAtee et al. | Apr 1994 | A |
5535322 | Hecht | Jul 1996 | A |
5572673 | Shurts | Nov 1996 | A |
5596744 | Dao et al. | Jan 1997 | A |
5596750 | Li et al. | Jan 1997 | A |
5634053 | Noble et al. | May 1997 | A |
5634127 | Cloud et al. | May 1997 | A |
5644768 | Periwal et al. | Jul 1997 | A |
5721912 | Stepczyk et al. | Feb 1998 | A |
5721913 | Ackroff et al. | Feb 1998 | A |
5734837 | Flores et al. | Mar 1998 | A |
5745683 | Lee et al. | Apr 1998 | A |
5745687 | Randell | Apr 1998 | A |
5752027 | Familiar | May 1998 | A |
5774661 | Chatterjee et al. | Jun 1998 | A |
5790789 | Suarez | Aug 1998 | A |
5794250 | Cari{overscore (n)}o, Jr. et al. | Aug 1998 | A |
5826086 | Arima et al. | Oct 1998 | A |
5826239 | Du et al. | Oct 1998 | A |
5860066 | Rouse | Jan 1999 | A |
5864843 | Cari{overscore (n)}o, Jr. et al. | Jan 1999 | A |
5873083 | Jones et al. | Feb 1999 | A |
5892905 | Brandt et al. | Apr 1999 | A |
5913214 | Madnick et al. | Jun 1999 | A |
5926636 | Lam et al. | Jul 1999 | A |
5930512 | Boden et al. | Jul 1999 | A |
5937388 | Davis et al. | Aug 1999 | A |
5951649 | Dobbins et al. | Sep 1999 | A |
5960420 | Leymann et al. | Sep 1999 | A |
5987422 | Buzsaki | Nov 1999 | A |
5991733 | Aleia et al. | Nov 1999 | A |
6006193 | Gibson et al. | Dec 1999 | A |
6012067 | Sarkar | Jan 2000 | A |
6044378 | Gladney | Mar 2000 | A |
6061667 | Danford-Klein et al. | May 2000 | A |
6065009 | Leymann et al. | May 2000 | A |
6073109 | Flores et al. | Jun 2000 | A |
6073111 | Leymann et al. | Jun 2000 | A |
6115646 | Fiszman et al. | Sep 2000 | A |
6151583 | Ohmura et al. | Nov 2000 | A |
6170002 | Ouchi | Jan 2001 | B1 |
6226641 | Hickson et al. | May 2001 | B1 |
6278977 | Agrawal et al. | Aug 2001 | B1 |
6308163 | Du et al. | Oct 2001 | B1 |
6338074 | Poindexter et al. | Jan 2002 | B1 |
6349238 | Gabbita et al. | Feb 2002 | B1 |
6430538 | Bacon et al. | Aug 2002 | B1 |
6453320 | Kukura et al. | Sep 2002 | B1 |
6487607 | Wollrath et al. | Nov 2002 | B1 |
6539396 | Bowman-Amuah | Mar 2003 | B1 |
6578006 | Saito et al. | Jun 2003 | B1 |
6606740 | Lynn et al. | Aug 2003 | B1 |
6665674 | Buchanan et al. | Dec 2003 | B1 |
6665814 | Hobson et al. | Dec 2003 | B1 |
6681243 | Putzolu et al. | Jan 2004 | B1 |
6691299 | Hart et al. | Feb 2004 | B1 |
6721713 | Guheen et al. | Apr 2004 | B1 |
6769113 | Bloom et al. | Jul 2004 | B1 |
6769124 | Schoening et al. | Jul 2004 | B1 |
6816902 | Bandat et al. | Nov 2004 | B1 |
6853974 | Akifuji et al. | Feb 2005 | B1 |
6877153 | Konnersman | Apr 2005 | B1 |
6920456 | Lee et al. | Jul 2005 | B1 |
20020022485 | Kolsky et al. | Feb 2002 | A1 |
20020032783 | Tuatini | Mar 2002 | A1 |
20020038357 | Haverstock et al. | Mar 2002 | A1 |
20020040312 | Dhar et al. | Apr 2002 | A1 |
20020059411 | Barnhouse et al. | May 2002 | A1 |
20020103811 | Fankhauser et al. | Aug 2002 | A1 |
20020120685 | Srivastava et al. | Aug 2002 | A1 |
20020143949 | Rajarajan et al. | Oct 2002 | A1 |
20030023472 | Lee et al. | Jan 2003 | A1 |
20030023662 | Yaung | Jan 2003 | A1 |
20030023728 | Yaung | Jan 2003 | A1 |
20030023773 | Lee et al. | Jan 2003 | A1 |
20030033415 | Graylin et al. | Feb 2003 | A1 |
20030131075 | Bear et al. | Jul 2003 | A1 |
20040015821 | Lu et al. | Jan 2004 | A1 |
Number | Date | Country |
---|---|---|
982675 | Aug 1999 | EP |
10-081425 | Mar 1998 | JP |
10-326314 | Dec 1998 | JP |
11-003298 | Jan 1999 | JP |
11-175644 | Jul 1999 | JP |
11-249983 | Sep 1999 | JP |
9963469 | Dec 1999 | WO |
0014618 | Mar 2000 | WO |
Number | Date | Country | |
---|---|---|---|
20030005406 A1 | Jan 2003 | US |