Method and apparatus for retrieving activity data related to an activity

• US 7,027,954 B2
• Filed: 12/21/2001
• Issued: 04/11/2006
• Est. Priority Date: 12/21/2001
• Status: Expired due to Fees

• Current Assignee: Honeywell International Inc.
• Original Assignee: Honeywell International Inc.
• Inventors: Rybarczyk, David F., Montalvo Roel, Ila K., Strilich, James A., Mets, Christian M. H.
• Primary Examiner(s): Barlow, John
• Assistant Examiner(s): BHAT, ADITYA S
• Application Number:
  US10/026,297
• Publication Number:
  US 20030120465A1
• Time in Patent Office: 1,572 Days
• Field of Search: 702182-184, 702/41, 705/5, 705/8, 705/9, 705/29, 705/32, 705/178, 73 53- 54, 700/296, 709/224, 707/1, 707/3, 707/6, 707/9, 707/101, 707/102, 713/201
• US Class Current: 702/187
• CPC Class Codes: G05B 23/0221 Preprocessing measurements, e.g. data collection rate adjustment; Standardization of measurements; Time series or signal analysis, e.g. frequency analysis or wavelets; Trustworthiness of measurements; Indexes therefor; Measurements using easily measured parameters to estimate parameters difficult to measure; Virtual sensor creation; De-noising; Sensor fusion; Unconventional preprocessing inherently present in specific fault detection methods like PCA-based methods
• CPC Class Codes: G05B 23/0264 Control of logging system, e.g. decision on which data to store; time-stamping measurements
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database

Abstract

A method and apparatus that processes time series, event and/or activity data of a process according to a data structure. 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 accessing data of an industrial process, said apparatus comprising:

a processor and an activity framing program that 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 of said industrial process, at least a first attribute of a first one of said activities, and at least one attribute of a second one of said activities, wherein said second activity is framed at least in part by said first activity, 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 data of said industrial process to retrieve activity data of said second activity.

2. The computer apparatus of claim 1, wherein said first attribute of said first activity has an attribute value that is linked to said second activity, and wherein said request add itionally identifies said attribute value.

3. The computer apparatus of claim 2, wherein said first attribute identifies an item used in said industrial process and said attribute value identifies a device that is associated with said item and that is linked to said second activity.

4. 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.

5. The computer apparatus of claim 1, wherein said activity data is stored in a database.

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

7. A method for using a computer to access data of an industrial process, said method 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 of said industrial process, at least a first attribute of a first one of said activities, and at least one attribute of a second one of said activities, wherein said second activity is framed at least in part by said first activity, 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 data of said industrial process to retrieve activity data of said second activity.

8. The method of claim 7, wherein said first attribute of said first activity has an attribute value that is linked to said second activity, and wherein said request additionally identifies said attribute value.

9. The method of claim 8, wherein said first attribute identifies an item and said attribute value identifies a device that is associated with said item and that is linked to said second activity.

10. A memory media for controlling a computer to process data of an industrial process, said memory media comprising:

program instructions of an activity framing program for controlling a 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 of said industrial process, at least a first attribute of a first one of said activities, and at least one attribute of a second one of said activities, wherein said second activity is framed at least in part by said first activity, 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 data of said industrial process to retrieve activity data of said second activity.

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

(a) generating an access request that is based on a data structure that comprises a plurality of activities of said industrial process, one or more attributes of a first one of said activities, and one or more attributes of a second one of said activities, wherein said second activity is framed at least in part by said first activity, wherein said request identifies said first activity and said first attribute of said first activity; and

(b) in response to said access request, using said data structure to access said memory to retrieve activity data of said second activity.

12. The method of claim 11, wherein steps (a) and (b) utilize an identity and a plurality of activity attributes for each of said first and second activities.

13. The method of claim 12, wherein said activity attributes are selected from the group consisting of:

start time, end time and item used in said industrial process.

14. The method of claim 13, wherein said item is an equipment, and wherein said activity attributes have an attribute value selected from the group consisting of:

date and/or time and device of said equipment used in said industrial process.

15. The method of claim 14, wherein at least one of said attribute values of said second activity matches at least one of said attribute values of said first activity.

16. The method of claim 11, wherein step (b) identifies said second activity with a reference selected from the group consisting of:

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

17. The method of claim 16, wherein said time based reference is with respect to said first activity, and wherein all sub-activities are retrieved that are framed at least in part by said first activity.

18. The method of claim 16, wherein said direct reference directly refers to said first activity.

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

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

a processor and a framing program that generates an access request that is based on a data structure that comprises a plurality of activities of said industrial process, one or more attributes of a first one of said activities, and one or more attributes of a second one of said activities, wherein said second activity is framed at least in part by said first activity, wherein said request identifies said first activity and said first attribute of said first activity; and

wherein said processor in response to said access request, uses said data structure to access said memory to retrieve activity data of said second activity.

21. The apparatus of claim 20, wherein said activity attributes are selected from the group consisting of:

start time, end time and item used in said industrial process.

22. The apparatus of claim 21, wherein said item is an equipment, and wherein said activity attributes have an attribute value selected from the group consisting of:

date and/or time and device of said equipment used in said industrial process.

23. The apparatus of claim 22, wherein at least one of said attribute values of said second activity matches at least one of said attribute values of said first activity.

24. The apparatus of claim 20, wherein said access request identifies said second activity with a reference selected from the group consisting of:

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

25. The apparatus of claim 24, wherein said time based reference is with respect to said first activity, and wherein all sub-activities are retrieved that are framed at least in part by said first activity.

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

27. The apparatus of claim 24, wherein said indirect reference includes a reference to an item used by said industrial process during said first activity.

28. A memory media for controlling a computer to access data of an industrial process, said memory media comprising:

program instructions of an activity framing program for controlling a computer to generate an access request that is based on a data structure that comprises a plurality of activities of said industrial process, one or more attributes of a first one of said activities, and one or more attributes of a second one of said activities, wherein said second activity is framed at least in part by said first activity, wherein said request identifies said first activity and said first attribute of said first activity; and

wherein said program instructions cause said computer to respond to said access request by using said data structure to access said memory to retrieve activity data of said second activity.