Method, system, and program for performing workflow related operations

• US 20030023773A1
• Filed: 07/30/2001
• Published: 01/30/2003
• Est. Priority Date: 07/30/2001
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Yaung, Alan Tsu-I, Lee, Taejae, Lin, Jy-Jine James
• Granted Patent: US 7,047,535 B2
• Time in Patent Office: Days
• US Class Current: 719/328
• CPC Class Codes: G06F 9/4486 Formation of subprogram jump address
• CPC Class Codes: G06F 9/541 via adapters, e.g. between incompatible applications
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching

Abstract

Provided is a method, system, and program for performing workflow related operations. An application programming interface call (API) is received to perform a workflow related operation. A determination is made of at least one stored procedure call associated with the received API. The determined at least one stored procedure is then called to cause the execution of one determined stored procedure on a database server to perform the workflow related operation of the API.

Claims

1. A method for performing workflow related operations, comprising:

receiving an application programming interface call (API) to perform a workflow related operation;

determining at least one stored procedure call associated with the received API; and

calling the determined at least one stored procedure to cause the execution of one determined stored procedure on a database server to perform the workflow related operation of the API.

2. The method of claim 1, wherein at least one stored procedure call invokes one stored procedure in the database server that includes native workflow server code to communicate to a workflow server to execute to perform the workflow related operation of the API and wherein at least one stored procedure call invokes one stored procedure in the database server that includes database statements executed by a database program to access workflow related metadata for the API.

3. The method of claim 1, wherein the workflow related operation for at least one API is to be performed on a workflow server and wherein the workflow related operation for at least one API is to access workflow metadata from a workflow database

4. The method of claim 1, wherein the workflow related operation comprises a function to perform on a workflow server, wherein the database server includes a database program that executes one determined stored procedure to perform:

communicating native workflow server code included in the executed stored procedure to the workflow server, wherein the workflow server executes the native workflow server code to perform the workflow related operation of the API.

5. The method of claim 4, wherein the API and native workflow server code are in different programming languages.

6. The method of claim 1, wherein the workflow related operation concerns accessing workflow metadata in a workflow database, wherein the database server includes a database program that executes one determined stored procedure to perform:

executing database statements included in the executed stored procedure to access workflow metadata in the workflow database.

7. The method claim 3, wherein the database statements comprise Structured Query Language (SQL) statements.

8. A method for performing workflow related operations at a database server in communication with a client, comprising:

receiving at least one call to one stored procedure at the database server associated with an application programming interface call (API) invoked from the client to perform a workflow related operation; and

executing, at the database server, the at least one called stored procedure to perform the workflow related operation of the API.

9. The method of claim 8, wherein the received at least one call to one stored procedure comprises a first and second stored procedure calls to first and second stored procedures, respectively, on the database server to implement the workflow related operation of the API.

10. The method of claim 9, wherein executing the first stored procedure comprises authenticating the client and establishing a connection and wherein executing the second received stored procedure call comprises performing the workflow related operation of the API.

11. The method of claim 9, wherein executing the first stored procedure comprises accessing workflow metadata from a workflow database and wherein executing the second stored procedure comprises communicating native workflow server code and the accessed workflow metadata to a workflow server, wherein the workflow server processes the communicated native workflow server code and the workflow metadata to perform the workflow related operation of the API.

12. The method of claim 9, wherein executing the first stored procedure comprises communicating native workflow server code to a workflow server, wherein the workflow server processes the communicated native workflow server code to perform the workflow related operation of the API and returns workflow metadata, and wherein executing the second stored procedure call for the API comprises updates a workflow database with the workflow metadata returned by the workflow server.

13. The method of claim 8, wherein the received call to the stored procedure comprises a first call to a first stored procedure associated with a first API, wherein the first stored procedure includes database statements, wherein executing the first stored procedure comprises communicating the database statements to a database program to access workflow metadata from a workflow database, further comprising:

receiving a second stored procedure call associated with a second API that invokes a second stored procedure on the database server, wherein the second stored procedure includes native workflow server code; and

executing the second stored procedure to communicate the native workflow server code and the accessed workflow metadata included therein to a workflow server to process to perform the workflow related operation associated with he second API.

14. The method of claim 13, wherein the first stored procedure returns the accessed workflow metadata to the client, and wherein the second stored procedure call from the client passes the accessed workflow metadata to the second stored procedure to communicate to the workflow server with the native workflow server code.

15. The method of claim 8, wherein the received call to the stored procedure comprises a first call to a first stored procedure associated with a first API, wherein the first stored procedure includes native workflow server code, wherein executing the first stored procedure comprises communicating the native workflow server code to a workflow server to process to perform the workflow related operation associated with the first API, wherein the workflow server returns workflow metadata, further comprising:

receiving a second stored procedure call associated with a second API that invokes a second stored procedure on the database server, wherein the second stored procedure includes database statements; and

executing the second stored procedure to cause a database program to execute the database statements to update a workflow database with the returned workflow metadata.

16. The method of claim 14, wherein the first stored procedure returns the returned workflow metadata from the workflow server to the client, and wherein the second stored procedure call from the client passes the returned workflow metadata from the workflow server to the second stored procedure to call the database program to update the workflow database with the returned workflow metadata.

17. A system for performing workflow related operations, comprising:

a database server;

a computer readable medium including a plurality of stored procedures, wherein each stored procedure is associated with at least one application programming interface call (API) defined to perform a workflow related operation, wherein the computer readable medium is accessible to the database server;

means for receiving one API call to perform one workflow related operation;

means for determining at least one stored procedure call associated with the received API; and

means for calling the determined at least one stored procedure; and

means, performed by the database server, for executing the at least one called stored procedure in response to the call to perform the workflow related operation of the API.

18. The system of claim 17, wherein at least one stored procedure call invokes one stored procedure that includes native workflow server code to perform the workflow related operation of the API , and wherein at least one stored procedure call invokes one stored procedure that includes database statements to access workflow related metadata for the API, further comprising:

a workflow server;

a database;

means, performed by the workflow server, for receiving native workflow server code from one stored procedure;

means, performed by the workflow server, for executing the received native workflow server code to perform the workflow related operation; and

means for executing database statements from one stored procedure to access workflow related metadata for the API from the database.

19. The system of claim 17, wherein the workflow related operation for at least one API is to be performed on a workflow server and wherein the workflow related operation for at least one API is to access workflow metadata from a workflow database

20. The system of claim 17, further comprising:

a workflow server, wherein the workflow related operation comprises a function to perform on the workflow server;

means, performed at the database server, for executing one determined stored procedure to communicate native workflow server code included in the executed stored procedure to the workflow server; and

means, performed by the workflow server, for executing the native workflow server code to perform the workflow related operation of the API.

21. The system of claim 20, wherein the API and native workflow server code are in different programming languages.

22. The system of claim 17, further comprising:

a workflow database, wherein the workflow related operation concerns accessing workflow metadata in the workflow database; and

means, performed at the database server, for executing the database statements in the determined stored procedure to access workflow metadata in the workflow database.

23. The system claim 18, wherein the database statements comprise Structured Query Language (SQL) statements.

24. A system for performing workflow related operations, comprising:

a database server;

a client in communication with the database server;

means, performed by the client, for executing an application programming interface call (API) to perform a workflow related operation, wherein at least one stored procedure at the database server is associated with the executed API;

means, performed by the client, for communicating the at least one call to at least one stored procedure associated with the executed API to the database server; and

means, performed by the database server, for executing the at least one called stored procedure to perform the workflow related operation of the API.

25. The system of claim 24, wherein the received at least one stored procedure call comprises a first and second stored procedure calls to first and second stored procedures, respectively, on the database server to implement the workflow related operation of the API.

26. The system of claim 25, wherein the means for executing the at least one called stored procedure performs executing the first stored procedure to authenticate the client and establish a connection and wherein executing the second received stored procedure call comprises performing the workflow related operation of the API.

27. The system of claim 25, further comprising:

a workflow database, wherein the means for executing the at least one called stored procedure at the database server executes the first stored procedure to access workflow metadata from the workflow database;

a workflow server, wherein the means for executing the second stored procedure at the database server comprises communicating native workflow server code and the accessed workflow metadata to the workflow server; and

means performed by the workflow server for processing the communicated native workflow server code and the workflow metadata to perform the workflow related operation of the API.

28. The system of claim 25, further comprising:

a workflow server, wherein the means for executing the at least one called stored procedure at the database server executes the first stored procedure to communicate native workflow server code to the workflow server;

means, performed by the workflow server, for processing the communicated native workflow server code to perform the workflow related operation of the API and returning workflow metadata; and

a workflow database, wherein the means for executing the at least one called stored procedure executes the second stored procedure call for the API updates the workflow database with the workflow metadata returned by the workflow server.

29. The system of claim 25, wherein the first stored procedure is associated with a first API and includes database statements, further comprising:

a workflow database in communication with the database server;

means, performed by the database server, for accessing access workflow metadata from the workflow database in response to executing the first stored procedure;

means, performed by the database server, for receiving the second stored procedure call associated with a second API;

a workflow server;

wherein the means, performed by the database server, for executing the at least one stored procedure performs;

(i) executing the second stored procedure including native workflow server code; and

(ii) executing the second stored procedure to communicate the native workflow server code and the accessed workflow metadata included therein to the workflow server; and

means, performed by the workflow server, for executing the native workflow server code communicated from the database server to process the workflow metadata received from the database server to perform the workflow related operation associated with he second API.

30. The system of claim 29, wherein the means for executing the at least one stored procedure further performs executing the first stored procedure to return the accessed workflow metadata to the client;

and

means, performed by the client, for passing the accessed workflow metadata received from the database server with the second stored procedure call to the database server to communicate to the workflow server with the native workflow server code.

31. The system of claim 25, wherein the received call to the stored procedure comprises a first call to a first stored procedure associated with a first API, wherein the first stored procedure includes native workflow server code, further comprising:

a workflow server, wherein the means for executing the at least one stored procedure performs executing the first stored procedure to communicate the native workflow server code in the first stored procedure to the workflow server to process and perform the workflow related operation associated with the first API;

means for returning, performed by the workflow server, workflow metadata, wherein the means for executing the at least one stored procedure further performs receiving the second stored procedure call associated with a second API that invokes the second stored procedure on the database server, wherein the second stored procedure includes database statements;

a workflow database; and

executing, at the database server, the database statements in the second stored procedure to update the workflow database with the returned workflow metadata.

32. The system of claim 25, wherein the first stored procedure returns the returned workflow metadata from the workflow server to the client, and wherein the second stored procedure call from the client passes the returned workflow metadata from the workflow server to the second stored procedure to call the database program to update the workflow database with the returned workflow metadata.

33. An article of manufacture including code for performing workflow related operations by:

receiving an application programming interface call (API) to perform a workflow related operation;

determining at least one stored procedure call associated with the received API; and

calling the determined at least one stored procedure to cause the execution of One determined stored procedure on a database server to perform the workflow related operation of the API.

34. The article of manufacture of claim 33, wherein at least one stored procedure call invokes one stored procedure in the database server that includes native workflow server code to communicate to a workflow server to execute to perform the workflow related operation of the API and wherein at least one stored procedure call invokes one stored procedure in the database server that includes database statements executed by a database program to access workflow related metadata for the API.

35. The article of manufacture of claim 33, wherein the workflow related operation for at least one API is to be performed on a workflow server and wherein the workflow related operation for at least one API is to access workflow metadata from a workflow database

36. The article of manufacture of claim 33, wherein the workflow related operation comprises a function to perform on a workflow server, wherein the database server includes a database program that executes one determined stored procedure to perform:

communicating native workflow server code included in the executed stored procedure to the workflow server, wherein the workflow server executes the native workflow server code to perform the workflow related operation of the API.

37. The article of manufacture of claim 36, wherein the API and native workflow server code are in different programming languages.

38. The article of manufacture of claim 33, wherein the workflow related operation concerns accessing workflow metadata in a workflow database, wherein the database server includes a database program that executes one determined stored procedure to perform:

executing database statements included in the executed stored procedure to access workflow metadata in the workflow database.

39. The article of manufacture of claim 37, wherein the database statements comprise Structured Query Language (SQL) statements.

40. An article of manufacture including code for performing workflow related operations at a database server in communication with a client by:

receiving at least one call to one stored procedure at the database server associated with an application programming interface call (API) invoked from the client to perform a workflow related operation; and

executing, at the database server, the at least one called stored procedure to perform the workflow related operation of the API.

41. The article of manufacture of claim 40, wherein the received at least one call to one stored procedure comprises a first and second stored procedure calls to first and second stored procedures, respectively, on the database server to implement the workflow related operation of the API.

42. The article of manufacture of claim 41, wherein executing the first stored procedure comprises authenticating the client and establishing a connection and wherein executing the second received stored procedure call comprises performing the workflow related operation of the API.

43. The article of manufacture of claim 41, wherein executing the first stored procedure comprises accessing workflow metadata from a workflow database and wherein executing the second stored procedure comprises communicating native workflow server code and the accessed workflow metadata to a workflow server, wherein the workflow server processes the communicated native workflow server code and the workflow metadata to perform the workflow related operation of the API.

44. The article of manufacture of claim 41, wherein executing the first stored procedure comprises communicating native workflow server code to a workflow server, wherein the workflow server processes the communicated native workflow server code to perform the workflow related operation of the API and returns workflow metadata, and wherein executing the second stored procedure call for the API comprises updates a workflow database with the workflow metadata returned by the workflow server.

45. The article of manufacture of claim 40, wherein the received call to the stored procedure comprises a first call to a first stored procedure associated with a first API, wherein the first stored procedure includes database statements, wherein executing the first stored procedure comprises communicating the database statements to a database program to access workflow metadata from a workflow database, further comprising:

receiving a second stored procedure call associated with a second API that invokes a second stored procedure on the database server, wherein the second stored procedure includes native workflow server code; and

executing the second stored procedure to communicate the native workflow server code and the accessed workflow metadata included therein to a workflow server to process to perform the workflow related operation associated with he second API.

46. The article of manufacture of claim 45, wherein the first stored procedure returns the accessed workflow metadata to the client, and wherein the second stored procedure call from the client passes the accessed workflow metadata to the second stored procedure to communicate to the workflow server with the native workflow server code.

47. The article of manufacture of claim 40, wherein the received call to the stored procedure comprises a first call to a first stored procedure associated with a first API, wherein the first stored procedure includes native workflow server code, wherein executing the first stored procedure comprises communicating the native workflow server code to a workflow server to process to perform the workflow related operation associated with the first API, wherein the workflow server returns workflow metadata, further comprising:

receiving a second stored procedure call associated with a second API that invokes a second stored procedure on the database server, wherein the second stored procedure includes database statements;

executing the second stored procedure to cause a database program to execute the database statements to update a workflow database with the returned workflow metadata.

48. The article of manufacture of claim 47, wherein the first stored procedure returns the returned workflow metadata from the workflow server to the client, and wherein the second stored procedure call from the client passes the returned workflow metadata from the workflow server to the second stored procedure to call the database program to update the workflow database with the returned workflow metadata.