Method and apparatus for retrieving event data related to an activity

• US 7,225,193 B2
• Filed: 12/21/2001
• Issued: 05/29/2007
• Est. Priority Date: 12/21/2001
• Status: Expired due to Fees

• Current Assignee: Honeywell International Inc.
• Original Assignee: Honeywell International Inc.
• Inventors: Mets, Christiaan M. H., Strilich, James A., Rybarczyk, David F., Emery, Michael J.
• Primary Examiner(s): Breene; John
• Assistant Examiner(s): Ly; Anh
• Application Number:
  US10/026,326
• Publication Number:
  US 20030120661A1
• Time in Patent Office: 1,985 Days
• Field of Search: 707 2- 6, 707100-1041, 707/10, 705/1, 705/7, 705/32, 702/2, 702/3, 702/187, 702178-179, 709/318, 709217-219
• US Class Current: 1/1
• CPC Class Codes: G05B 23/0264 Control of logging system, e.g. decision on which data to store; time-stamping measurements
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation

Abstract

A method and apparatus that processes time series, event and/or activity data of a process according to a data structure is disclosed. The data structure defines one or more activities that frame the time series, event and/or activity data. Each activity and each event has one or more attributes. Each attribute has a value. At least one of the attributes defines an interval of the activity by start and end times. Another attribute includes a time varying parameter that represents the time series data. Another attribute defines a time stamp of an event. The time varying parameter is linked to a device that produces the time series data when the process is run. The time series, event and/or activity data is collected and processed according to the data structure for storage in and/or retrieval from a memory. A relationship between data of one or more activities and the time series, event and/or activity data is processed according to the data structure to retrieve the time series, event and/or activity data from the memory.

Claims

1. A computer apparatus for processing output data of an industrial process comprising:

a computer, a database and a monitor that collects said output data of said industrial process and provides said output data to said computer, wherein said computer comprises an activity framing program that when executed responds to input data entered by a user to define a data structure,

wherein said activity framing program responds to said input data to define said data structure with a plurality of activities and events of said industrial process, at least a first attribute of a first one of said activities, and at least one attribute of a first one of said events, wherein said first event is time framed by said first activity, wherein said first attribute of said first activity has an attribute value that is linked to said first event, and wherein said request additionally identifies said attribute value, wherein said first attribute identifies an item used in said process and said attribute value identifies a device that is associated with said item and that is linked to said first event,

wherein said framing program uses said data structure to store said output data in said database based on said activities, events and attributes, and

wherein said framing program further responds to a request that identifies said first activity and said first attribute of said first activity by using said data structure to access said output data of said industrial process stored in said database to retrieve event data of said first event.

2. The computer apparatus of claim 1, wherein said first activity further comprises a second attribute, and wherein said first and second attributes define start and end times of said first activity, respectively.

3. The computer apparatus of claim 1, wherein said data structure is stored in one of said database and a separate memory.

4. A method for using a computer to process output data of an industrial process comprising:

operating said computer with an activity framing program in response to input data entered by a user to define a data structure,

wherein said activity framing program responds to said input data to define said data structure with a plurality of activities and events of said industrial process, at least a first attribute of a first one of said activities, and at least one attribute of a first one of said events, wherein said first event is time framed by said first activity, wherein said first attribute of said first activity has an attribute value that is linked to said first event, and wherein said request additionally identifies said attribute value, wherein said first attribute identifies an item used in said process and said attribute value identifies a device that is associated with said item and that is linked to said first event,

wherein said framing program uses said data structure to store said output data in a database based on said activities, events and attributes, and

wherein said framing program further responds to a request that identifies said first activity and said first attribute of said first activity by using said data structure to access said output data of said industrial process in said database to retrieve event data of said first event.

5. A memory media comprising a computer readable activity framing program that when executed on a computer controls said computer to process output data of an industrial process,

wherein said activity framing program controls said computer in response to input data entered by a user to define a data structure,

wherein said activity framing program responds to said input data to define said data structure with a plurality of activities and events of said industrial process, at least a first attribute of a first one of said activities, and at least one attribute of a first one of said events, wherein said first event is time framed by said first activity, wherein said first attribute of said first activity has an attribute value that is linked to said first event, and wherein said request additionally identifies said attribute value, wherein said first attribute identifies an item used in said process and said attribute value identifies a device that is associated with said item and that is linked to said first event,

wherein said framing program uses said data structure to store said output data in a database based on said activities, events and attributes, and

wherein said framing program further responds to a request that identifies said first activity and said first attribute of said first activity by using said data structure to access said output data of said industrial process in said database to retrieve event data of said first event.

6. A method for using a computer to access output data of an industrial process that is stored in a memory, said method comprising:

(a) operating said computer with a program that generates an access request that is based on a data structure that comprises a plurality of activities and events of said industrial process, one or more attributes of a first one of said activities, and one or more attributes of a first one of said events, wherein said first event is framed by said first activity;

wherein a first attribute of said first activity has an attribute value that is linked to said first event, and wherein said request additionally identifies said attribute value, wherein said first attribute identifies an item used in said process and said attribute value identifies a device that is associated with said item and that is linked to said first event,

wherein said output data is stored in said memory based on said activities, events and attributes, and

(b) operating said computer with said program in response to said access request, using said data structure to access said output data of said industrial process in said memory to retrieve event data of said first event.

7. The method of claim 6, wherein said data structure further comprises an identity of each of said attributes and an identity of each of said events.

8. The method of claim 7, wherein said activity attributes and said event attributes are selected from the group consisting of:

time stamp, activity and item used in said industrial process.

9. The method of claim 8, wherein said item is an equipment, and wherein each of said activity attributes and each of said event attributes has an attribute value selected from the group consisting of:

date and time, activity identity and device of said equipment used in said industrial process.

10. The method of claim 9, wherein said event data is linked to said device of said equipment.

11. The method of claim 7, wherein at least one of said event attributes matches at least one of said activity attributes.

12. The method of claim 6, wherein said request identifies said first event with a reference selected from the group consisting of:

time based reference with respect to an interval of said first activity, direct reference to said first activity and indirect reference to said first activity.

13. The method of claim 12, wherein said time based reference is with respect to all events that occur during said interval.

14. The method of claim 12, wherein said direct reference directly refers to said first activity.

15. The method of claim 12, wherein said indirect reference includes a reference to an item used by said industrial process during said first activity.

16. A computer apparatus for accessing output data of an industrial process that is stored in a memory, said computer apparatus comprising:

a computer and a framing program that generates an access request that is based on a data structure that comprises a plurality of activities and events of said industrial process, one or more attributes of a first one of said activities, and one or more attributes of a first one of said events, wherein said first event is time framed by said first activity, wherein a first attribute of said first activity has an attribute value that is linked to said first event, and wherein said request additionally identifies said attribute value, wherein said first attribute identifies an item used in said process and said attribute value identifies a device that is associated with said item and that is linked to said first event;

wherein said output data is stored in said memory based on said activities, events and attribute; and

wherein said computer in response to said access request, uses said data structure to access said output data of said industrial process in said memory to retrieve event data of said first event.

17. The apparatus of claim 16, wherein said data structure further comprises an identity of each of said attributes and each of said events.

18. The apparatus of claim 17, wherein said activity attributes and said event attributes are selected from the group consisting of:

time stamp, activity and item used in said industrial process.

19. The apparatus of claim 18, wherein said item is an equipment, and wherein each of said activity attributes and each of said event attributes has an attribute value selected from the group consisting of:

date and time, activity identity and device of said equipment used in said industrial process.

20. The apparatus of claim 19, wherein said event data is linked to said device of said equipment.

21. The apparatus of claim 17, wherein at least one of said event attributes matches at least one of said activity attributes.

22. The apparatus of claim 16, wherein said request identifies said first event with a reference selected from the group consisting of:

time based reference with respect to an interval of said first activity, direct reference to said first activity and indirect reference to said first activity.

23. The apparatus of claim 22, wherein said time based reference is with respect to all events that occur during said interval.

24. The apparatus of claim 22, wherein said direct reference directly refers to said first activity.

25. The apparatus of claim 22, wherein said indirect reference includes a reference to an equipment used by said industrial process during said first activity.

26. A memory media comprising a computer readable activity framing program that when executed on a computer controls said computer to process output data of an industrial process stored in a memory,

wherein said activity framing program controls said computer to generate an access request that is based on a data structure that comprises a plurality of activities and events of said industrial process, one or more attributes of a first one of said activities, and one or more attributes of a first one of said events, wherein said first event is time framed by said first activity, wherein a first attribute of said first activity has an attribute value that is linked to said first event, and wherein said request additionally identifies said attribute value, wherein said first attribute identifies an item used in said process and said attribute value identifies a device that is associated with said item and that is linked to said first event;

wherein said output data is stored in said memory based on said activities, events and attribute; and

wherein said activity framing program control said computer to respond to said access request by using said data structure to access said output data of said industrial process in said memory to retrieve event data of said first event.