System and method for automated process control
View Patent ↗A process control system that automatically monitors processes and performs activities based on conditions detected during monitoring. The information needed to do the monitoring and perform activities is contained in tables in a database system. The process control system may be configured by configuring entries in the tables. An administrative query table has records that define administrative queries. Each administrative query has associated with it a query to be executed on a table of process records that indicate statuses of the processes being monitored, a scope that defines a subset of the process records upon which the query is to be executed, a schedule from which a time of next execution of the administrative query can be computed, and an activity. The activity is a set of one or more actions. When an administrative query is executed and the query associated with the administrative query is run on the table of process records and the result set is not empty, the activity is performed with regard to the process records of the result set. A plurality of activities may be associated with the administrative query, with the activity to be performed being selected on the basis of a state of a given process record with regard to the query.
1. A process control system comprising:
a server that includes a processor that has access to a database system, the processor executing program code for the process control system;
a table of process records in the database system, each process record indicating a current status of a process being controlled by the system;
a table of administrative query records in the database system, each administrative query record specifying an administrative query that is associated with a query on the table of process records and with a plurality of administrative activities; and
the processor executing a portion of the program code which selects one of the administrative queries for execution, executes the query associated therewith, and performs an associated administrative activity of the plurality thereof with regard to a result set of the process records returned by the associated query; and
a log table in the database system that has records logging executions of the query and process records returned thereby and from whose records the portion of the code can, when executed, determine whether a record belonging to the result set is in one of a plurality of states with regard to the current execution of the administrative query;
wherein:
which of the plurality of administrative activities is performed with regard to a record belonging to the result set depends on the state of the record.
2. The process control system set forth in claim 1 wherein:
more than one of the administrative activities is associated with one of the states;
the portion of the code can further, when executed, determine from the log table whether a record is in one of a plurality of substates of the one state; and
which of the more than one of the administrative activities is performed with regard to a record belonging to the result state depends on which of a plurality of substates of the state the record is in.
3. The process control system set forth in claim 1 further comprising:
a program sequence table in the database system that contains a set of program sequence records that are associated with the administrative query, each of the associated records specifying at least an administrative activity and a way of determining a next record in the set;
and wherein
the records logging the executions of the query and process records returned thereby further include a next sequence pointer for a given execution of the administrative query and a given process record, the next sequence pointer specifying a next record of the set of program sequence records,
the portion of code, when executed, responding when a process record is again returned by a future execution of the administrative query by performing the administrative activity specified in the program sequence record specified by the next record pointer and setting the next sequence pointer as specified in the program sequence record.
4. The process control system set forth in claim 3 wherein:
the program sequence record specifies that the next sequence pointer's value remains unchanged.
5. The process control system set forth in claim 1 wherein:
an administrative activity associated with the administrative query includes one or more actions; and
when the administrative activity is performed, the actions included therein are executed.
6. The process control system set forth in claim 5 wherein:
there is a plurality of different types of actions that may be included in an administrative activity.
7. The process control system set forth in claim 6 wherein:
the types of actions include actions which modify values in process records belonging to the result set when the activity in which the action is included is executed.
8. The process control system set forth in claim 6 wherein:
the types of actions include actions which post a record for a process in a further table in the database system when the activity in which the action is included is executed.
9. The process control system set forth in claim 6 wherein:
the types of actions include actions which generate a report listing the result set when the activity in which the action is included is executed.
10. The process control system set forth in claim 5
wherein there is a plurality of administrative actions and the process control system further comprises:
an action record table in the database system, each action record in the table representing an action associated with one of the administrative activities; and
when the associated administrative activity is performed, the portion of the program code executes the action records associated with the associated administrative activity.
11. The process control system set forth in claim 10 wherein:
there is a plurality of types of actions; and
there is a plurality of the action tables, each action table of the plurality thereof containing action records for actions of one type of the plurality thereof.
12. The process control system set forth in claim 1 wherein
the administrative query record further specifies future scheduling information that is associated with the administrative query; and
the process control system further comprises;
a schedule accessible to the server that relates administrative queries to times for execution; and
when executed, the portion of the program code accesses the schedule to determine a time for a next administrative query to be executed, executes the next administrative query at the determined time on the table of process records to obtain a result set of the process records that are of interest to the process control system, and employs the executed administrative query's future scheduling information to update the executed administrative query's time for execution in the schedule.
13. The process control system set forth in claim 12 further comprising:
a future scheduling information table in the database whose records specify the future scheduling information,
the administrative query record for an administrative query specifying the future scheduling information by specifying a record in the schedule table.
14. The process control system set forth in claim 1 wherein:
the administrative query record further specifies scope information that defines a subset of the process records; and
when executed, the portion of the program code executes the query associated with the administrative query on the subset of the process records that is defined by the scope information associated with the administrative query.
15. The process control system set forth in claim 14 further comprising:
an administrative query scope table in the database system whose records specify subsets of the process records;
the administrative query record for an administrative query specifying the scope information by specifying a record in the administrative query scope table.
16. The process control system set forth in claim 1 further comprising:
an administrative query trend table wherein each record is associated with an administrative query and specifies an administrative action that is to be performed in response to a trend concerning the associated administrative query; and
when executed, the portion of code determines from the administrative query trend record associated with the administrative query being executed whether a trend exists and when so, performs the specified administrative action.
17. The process control system set forth in claim 1 further comprising:
a query table in the database system whose records specify queries on the process record table; and
an administrative activity type table in the database system whose records specify administrative activity types,
the administrative query record for an administrative query specifying the query on the table of process records by specifying a record in the query table and specifying the administrative action by specifying a record in the administrative activity type table.