Plant information management system

• US 7,155,450 B2
• Filed: 05/09/2002
• Issued: 12/26/2006
• Est. Priority Date: 05/10/2001
• Status: Expired due to Fees

• Current Assignee: Automsoft R & D Limited
• Original Assignee: Automsoft R & D Limited
• Inventors: Cagney, Austin, Prylowski, Anthony, Pepper, Ian Anthony
• Primary Examiner(s): Le, Debbie M.
• Application Number:
  US10/141,337
• Publication Number:
  US 20020188366A1
• Time in Patent Office: 1,692 Days
• Field of Search: 707 1- 3, 707/104.1, 707100-102
• US Class Current: 1/1
• 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/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

In a plant information management system (PIMS, 1), data received from a process device (PCC, 10) is cached by a data logger (2) in blocks. A database controller (4) receives, for each data event, a time string, a value string, and a data quality indicator. The quality indicator is stored by exception only (if “bad”). MSBs of the time string are encoded in a hierarchical database structure of item (process device)—year—day levels. LSBs of the time string, the value string, and quality exceptions are stored as event objects in linked list arrays referenced to a day array object. There is thus no need for an index and the structure provides hierarchical compression.

Claims

1. A plant information management system comprising:

a data logger for interfacing with a plant process device to receive plant process measuring point data in real time, and at a non-uniform rate, said data comprising a plurality of events, each of said plurality of events comprising a time stamp having most significant bits, least significant bits, an event value and a data quality indicator;

a plant information database; and

a database controller for storing the events in said database, wherein;

the database comprises a time-encoded structure which is hierarchical according to time periods of the most significant bits of the time stamps of the measuring point data, with successive hierarchical levels associated with shorter time periods;

said time-encoded structure is defined according to a breakdown of bits of the time stamp;

the database controller stores each event value in an event object in a value level linked with the time-encoded structure;

the database controller stores the least significant bits of the time stamps in the event objects, the most significant bits being encoded in the time encoded structure;

the database controller stores each event value as an attribute of an associated event object;

the database controller accesses said value level to perform writing by using said time-encoded database structure as an index;

the database controller performs time-based data queries by using a time value to drill down through the time-encoded structure to reach at least one selected event object in the value; and

the database controller stores the data quality indicator only if it is exceptional.

2. The plant information management system as claimed in claim 1, wherein the database controller comprises means for storing the value data in linked list arrays.

3. The plant information management system as claimed in claim 1, wherein the database controller comprises means for storing item objects at an upper hierarchical level, each said item object being associated with a particular process device.

4. The plant information management system as claimed in claim 3, wherein the database controller comprises means for storing a year array object linked to each item object, said year array object comprising an array of references to day array objects.

5. The plant information management system as claimed in claim 4, wherein the database controller comprises means for storing an event bucket linked with each day array object, said event bucket comprising linked list arrays of data event objects.

6. The plant information management system as claimed in claim 1, wherein the data logger comprises means for determining quality of a data event, and for associating a quality indicator with the data event.

7. The plant information management system as claimed in claim 6, wherein the database controller comprises means for storing the quality indicator only if it is exceptional.

8. The plant information management system as claimed in claim 7, wherein the database controller comprises means for storing an event object as time and value strings in one array and exceptional quality indicators in a linked array.

9. The plant information management system as claimed in claim 1, wherein the data logger comprises means for caching received event data.

10. The plant information management system as claimed in claim 9, wherein the data logger comprises means for caching the event data intact in blocks which are linked list structures.

11. The plant information management system as claimed in claim 10, wherein the data logger comprises means for allocating a fresh linked list initially and for subsequently transferring flushed blocks to the fresh linked list to avoid the need to destroy flushed blocks and create fresh blocks after a data flush operation.

12. The plant information management system as claimed in claim 11, wherein the data logger comprises means for inserting a time stamp in each block of the fresh linked list and for periodically destroying blocks which have been unused for a time period exceeding a threshold.

13. A computer program product comprising computer-executable software code stored on a computer readable medium in a computer processor, said computer-executable software code comprising code for performing operations of a plant information management system as claimed in claim 1.