Event synchronized reporting in process control systems

• US 8,326,666 B2
• Filed: 09/29/2008
• Issued: 12/04/2012
• Est. Priority Date: 09/29/2008
• Status: Expired due to Fees

• Current Assignee: Fisher-Rosemount Systems Incorporated (Emerson Electric Company)
• Original Assignee: Fisher-Rosemount Systems Incorporated (Emerson Electric Company)
• Inventors: Caldwell, John M., Felts, Christopher J.
• Primary Examiner(s): Singh, Gurkanwaljit
• Application Number:
  US12/240,948
• Publication Number:
  US 20100082396A1
• Time in Patent Office: 1,527 Days
• Field of Search: None
• US Class Current: 705/7.12
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: G06Q 10/063116 Schedule adjustment for a person or group

Abstract

Methods, systems, and computer-executable instructions for event synchronized reporting in an process control system are disclosed. Events may be synchronized by a synchronization parameter, whose instances of occurrence may be non-contiguous in time. Examples of synchronization parameters may include a work shift, a work group, an individual'"'"'s on-duty time, a logged-on period of an individual, the execution times of a process control entity, a batch run type, and a procedure or sub-unit of a batch run. Instances of occurrence of the synchronization parameter may be recorded into a process control event database. Event synchronized reports may contain at least one synchronization value based on both the instances of occurrence of the synchronization parameter as well as historical process control data. Data from various historian databases may be accessed from process control system tools and integrated into a single report.

Claims

1. A method of reporting synchronized events in a process control system of a process plant, comprising:

collecting, by an event historian database in the process control system, events corresponding to process data generated by executing a control strategy to control an operation of a process in the process control system, the process control system having one or more process controllers executing one or more control modules in conjunction with one or more function blocks at the one or more field devices to perform a physical function in the process plant to perform executions of process control loops;

storing, in the event historian database, the collected events; and

executing, by a processor of a computing device in communicative connection with the event historian database, computer executable instructions stored on the memory of the computing device to;

obtain, at the computing device of the process control system, a synchronization parameter, the synchronization parameter being a parameter of the process control system having instances of occurrence of a measurable time duration;

extract, by the computing device from the event historian database of the process control system, first data for a first event corresponding to the synchronization parameter, the first event occurring over a first time interval;

extract, by the computing device from the event historian database, second data for a second event corresponding to the synchronization parameter, the second event occurring over a second time interval and the first and the second time intervals are non-contiguous;

generate, by the computing device, a synchronized value based on the first and the second data; and

generate, by the computing device, an event synchronized report for the synchronization parameter, the event synchronized report including the synchronized value.

2. The method of claim 1, wherein:

the events stored in the event historian database are historical discrete event process data;

the method further comprises obtaining, by the computing device, historical process control data for the first and the second time intervals from at least one of;

historical continuous process data, the historical discrete event process data, or historical batch process data;

the synchronized value is based on the first data, the second data and the historical process control data; and

the synchronized value is one of;

an aggregate value, an average value, a percentage, or a total count.

3. The method of claim 2, wherein obtaining the historical process control data comprises obtaining the historical process control data from a centralized database of the process control system different from the event historian database.

4. The method of claim 1, wherein executing the computer executable instructions to obtain the synchronization parameter comprises executing computer executable instructions to obtain, as the synchronization parameter, at least one of:

a work shift, a work group, an individual, or a logged-on time period of the individual.

5. The method of claim 4, wherein executing the computer executable instructions to obtain the synchronization parameter comprises executing computer executable instructions to obtain, as the synchronization parameter, at least one of:

the work shift, the work group, the individual, the logged-on time period of the individual, an executing process control entity in the process control system, a run of a batch process type, or a procedure or sub-unit of a specific batch run.

6. The method of claim 1, further comprising generating a synchronization parameter event record in the event historian database corresponding to at least one of:

a start time or a stop time of the synchronization parameter.

7. The method of claim 1, wherein executing the computer executable instructions to extract the first data comprises extracting a start time and a stop time of the first event, and wherein executing the computer executable instructions to extract the second data comprises extracting a start time and a stop time of the second event.

8. The method of claim 1, wherein executing the computer executable instructions to extract the second data for the second event comprises executing computer executable instructions to extract the second data for each of a plurality of events, and wherein a time interval of at least one of the each of the plurality of events is non-contiguous with the first time interval.

9. The method of claim 1, further comprising:

scheduling a generation of the event synchronized report, or

generating the event synchronized report per a user request.

10. The method of claim 1, wherein:

executing the computer executable instructions to obtain the synchronization parameter comprises executing computer executable instructions to obtain a first synchronization parameter and a second synchronization parameter,

executing the computer executable instructions to extract the first data for the first event corresponding to the synchronization parameter comprises executing computer executable instructions to extract first data for the first event corresponding to the first and the second synchronization parameters,

executing the computer executable instructions to extract the second data for the second event corresponding to the synchronization parameter comprises executing computer executable instructions to extract second data for the second event corresponding to the first and the second synchronization parameters, and

executing the computer executable instructions to generate the event synchronized report for the synchronization parameter comprises executing computer executable instructions to generate the event synchronized report for the first and the second synchronization parameters.

11. An event synchronized reporting system for use in a process control plant having a process control system, the event synchronized reporting system comprising:

a computer having a processor and a memory;

a historian database accessible by the computer, the historian database storing process data generated by executions of process control loops within the process control system, the process control system having one or more process controllers connected to one or more field devices, the one or more process controllers executing one or more control modules in conjunction with one or more function blocks at the one or more field devices to perform a physical function in the process plant to perform the executions of the process control loops; and

an event synchronizer stored on the memory of the computer and adapted to be executed on the processor, wherein the event synchronizer is adapted to;

obtain a synchronization parameter,

the synchronization parameter being a parameter of the process control system having instances of occurrence of a measurable time duration,

wherein a first instance of occurrence of the synchronization parameter and a second instance of occurrence of the synchronization parameter are non-contiguous over time;

generate a first event corresponding to at least one of a start time and an end time of the first instance;

generate a second event corresponding to at least one of a start time and an end time of the second instance;

record the first and the second events in the historian database; and

generate an event synchronized report for the synchronization parameter, the event synchronized report including at least one synchronized value based on;

data associated with the first event,

data associated with the second event, and

historical data corresponding to a particular process control entity included in executing a control strategy to control an operation of a process in the process control plant, the historical data generated by the process control plant during at least one of the first or the second instance of occurrence of the synchronization parameter, and the historical data stored in the historian database.

12. The event synchronized reporting system of claim 11, further comprising the computer further having a user interface, and wherein the event synchronizer is adapted to at least one of:

obtain the synchronization parameter via the user interface,

obtain the start and end times of the first and second instances via the user interface, or

obtain a report time interval for the event synchronized report, wherein at least a portion of the first instance and at least a portion of the second instance each occur during the report time interval.

13. The event synchronized reporting system of claim 11, wherein the event synchronizer is further adapted to generate the event synchronized report including the at least one synchronized value, wherein the at least one synchronized value is one of:

an aggregate value, an average value, a percentage, or a total value.

14. The event synchronized reporting system of claim 11, wherein the synchronization parameter comprises a work group, a work shift, an individual, or a logged-on time of the individual.

15. The event synchronized reporting system of claim 14, wherein the synchronization parameter further comprises an executing process control entity in the process control plant, a batch run type, or a procedure or sub-unit of a specific batch run.

16. The event synchronized reporting system of claim 15, wherein the executing process control entity comprises one of:

a physical process control entity, a logical process control entity, or an alarm.

17. The event synchronized reporting system of claim 11, wherein the event synchronizer is adapted to:

obtain more than one synchronization parameter; and

generate an event synchronized report for the more than one synchronization parameter,

wherein the at least one synchronized value is based on data associated with the first and second events of the more than one synchronization parameter and the historical data corresponding to the process control entity.

18. The event synchronized reporting system of claim 11, wherein the event synchronizer is adapted to obtain, from at least one other database accessible by the computer, at least one of:

the synchronization parameter,

the start and end times of the first and second instances of occurrence of the synchronization parameter, or

a report time interval for the event synchronized report, wherein at least a portion of the first instance and at least a portion of the second instance each occur during the report time interval.

19. The event synchronized reporting system of claim 11, wherein the historical data corresponding to the process control entity is obtained from a different centralized database than the historian database.

20. The event synchronized reporting system of claim 19, wherein the different centralized database is one of:

a continuous process historian database, a discrete event historian database, or a batch historian database.