Method, system, and program for maintaining information in database tables and performing operations on data in the database tables.
First Claim
1. A method for maintaining workflow related information, comprising:
- providing at least one table in a database storing workflow related data;
providing a plurality of programming interfaces, wherein each programming interface specifies an operation to perform on the workflow related data in the at least one table, wherein each programming interface is associated with one stored procedure call;
providing in the database one stored procedure for each stored procedure call and corresponding method, wherein the stored procedure includes a plurality of database statements to perform the programming interface operation; and
executing one stored procedure in the database to perform the corresponding programming interface operation on workflow related data in one table.
1 Assignment
0 Petitions
Accused Products
Abstract
Provided is a method, system, and program for maintaining workflow related information. At least one table is provided in a database storing workflow related data. A plurality of methods are provided, wherein each method specifies an operation to perform on the workflow related data in the at least one table, and wherein each method is associated with one stored procedure call. One stored procedure is provided in the database for each stored procedure call and corresponding method, wherein the stored procedure includes a plurality of database statements to perform the method operation. One stored procedure is executed in the database to perform the corresponding method operation on workflow related data in one table.
-
Citations
57 Claims
-
1. A method for maintaining workflow related information, comprising:
-
providing at least one table in a database storing workflow related data;
providing a plurality of programming interfaces, wherein each programming interface specifies an operation to perform on the workflow related data in the at least one table, wherein each programming interface is associated with one stored procedure call;
providing in the database one stored procedure for each stored procedure call and corresponding method, wherein the stored procedure includes a plurality of database statements to perform the programming interface operation; and
executing one stored procedure in the database to perform the corresponding programming interface operation on workflow related data in one table. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 54, 55)
-
-
13. A method for maintaining information in a database, comprising:
-
(a) receiving column definitions for multiple columns in at least one table; and
(b) for each table for which column definitions are received, performing;
(i) generating a table in the database including one column for each column definition, wherein each column is generated with attributes specified by the column definition for which the column is generated; and
(ii) generating at least one stored procedure including database statements in the database to perform an operation on the data in the generated table, wherein the stored procedure is capable of accessing the columns generated according to the column definitions. - View Dependent Claims (14, 15, 16, 17, 18, 19)
-
-
20. A system for maintaining workflow related information, comprising:
-
a storage device;
a database in the storage device including at least one table storing workflow related data;
a computer readable medium including a plurality of programming interfaces, wherein each programming interface specifies an operation to perform on the workflow related data in the at least one table, wherein each programming interface is associated with one stored procedure call in the computer readable medium;
means for providing one stored procedure in the database for each stored procedure call and corresponding programming interface, wherein the stored procedure includes a plurality of database statements to perform the programming interface operation; and
means for executing one stored procedure in the database to perform the corresponding programming interface operation on workflow related data in one table. - View Dependent Claims (21, 23, 24, 25, 26, 27, 28, 29, 30, 31)
-
-
22. The system of claim 22, further comprising:
one table in the database including information on actions associated with one workflow file in the workflow file table, wherein the associated actions are capable of being performed at the nodes defined in the associated workflow file.
-
32. A system for maintaining information in a database, comprising:
-
(a) means for receiving column definitions for multiple columns in at least one table;
(b) means for generating a table in the database including one column for each received column definition, wherein each column is generated with attributes specified by the column definition for which the column is generated; and
(c) means for generating at least one stored procedure including database statements in the database to perform an operation on the data in the generated table, wherein the stored procedure is capable of accessing the columns generated according to the column definitions. - View Dependent Claims (33, 34, 35, 36, 37, 38)
-
-
39. An article of manufacture including code for maintaining workflow related information by:
-
providing at least one table in a database storing workflow related data;
providing a plurality of programming interfaces, wherein each programming interface specifies an operation to perform on the workflow related data in the at least one table, wherein each programming interface is associated with one stored procedure call;
providing in the database one stored procedure for each stored procedure call and corresponding programming interface, wherein the stored procedure includes a plurality of database statements to perform the programming interface operation; and
executing one stored procedure in the database to perform the corresponding programming interface operation on workflow related data in one table. - View Dependent Claims (40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50)
-
-
51. An article of manufacture including code for maintaining information in a database by:
-
(a) receiving column definitions for multiple columns in at least one table;
(b) for each table for which column definitions are received, performing;
(i) generating a table in the database including one column for each column definition, wherein each column is generated with attributes specified by the column definition for which the column is generated; and
(ii) generating at least one stored procedure including database statements in the database to perform an operation on the data in the generated table, wherein the stored procedure is capable of accessing the columns generated according to the column definitions. - View Dependent Claims (52, 53, 56, 57)
-
Specification