Distributed database in an industrial automation environment

• US 7,676,281 B2
• Filed: 09/29/2005
• Issued: 03/09/2010
• Est. Priority Date: 05/13/2005
• Status: Active Grant

• Current Assignee: Rockwell Automation Technologies Incorporated (Allen-Bradley Co., Inc.)
• Original Assignee: Rockwell Automation Technologies Incorporated (Allen-Bradley Co., Inc.)
• Inventors: Hood, Gavan W., Hall, Kenwood H., Kappelhoff, Ralph
• Primary Examiner(s): DeCady; Albert
• Assistant Examiner(s): Rapp; Chad
• Application Number:
  US11/238,537
• Publication Number:
  US 20060259160A1
• Time in Patent Office: 1,622 Days
• Field of Search: 700/2, 700/4, 700/19, 700/20
• US Class Current: 700/20
• CPC Class Codes: G05B 19/4188 characterised by CIM planning or realisation
• CPC Class Codes: G05B 2219/31101 Configuration file with format of relevant messages for different equipment
• CPC Class Codes: G05B 2219/31166 Access data by name, object, stored in list, database
• CPC Class Codes: G05B 2219/31324 Distributed real time knowledge, database
• CPC Class Codes: G05B 2219/31334 Database with devices, configuration, of plant
• CPC Class Codes: Y02P 90/02 Total factory control, e.g. smart factories, flexible manufacturing systems [FMS] or integrated manufacturing systems [IMS]

Abstract

A distributed database system within an industrial automation environment comprises a plurality of associated programmable logic controllers, wherein each of the programmable logic controllers includes data relating to one of a process and a device. Furthermore, the data within the plurality of programmable logic controllers can conform to a hierarchically structured data model, which, for example, can be based upon ISA S95, ISA S88, OMAC, or any suitable combination thereof. A reception component receives and services a request for data that is located within at least one of the programmable logic controllers.

Claims

1. A distributed database system within an industrial automation environment, comprising:

a processor;

a memory communicatively coupled to the processor, the memory having stored thereon computer-executable instructions configured to implement the system, including;

a hierarchically structured data model representation of a plurality of controllers within an industrial automation system, the hierarchically structured data model representing data stored within the plurality of controllers as data objects located within a nested plant hierarchy;

a reception component that receives and services a request for data that is located within at least one of the plurality of controllers, the reception component employs the hierarchically structured data model to collectively query the plurality of controllers as a single unit and to retrieve the requested data from the at least one of the plurality of controllers; and

a directory structure that receives a pointer from one of the plurality of controllers indicating a location of a data object within the plant hierarchy, the directory structure maintaining the pointer to facilitate location and retrieval of the data object by the reception component.

2. The database system of claim 1, further comprising an archiving component that automatically archives data from within at least one of the controllers a pre-defined amount of time after creation of the data.

3. The database system of claim 1, further comprising a monitoring component that facilitates transfer of data from a first controller to a second controller upon available data storage in the first controller reaching a pre-defined threshold.

4. The database system of claim 1, further comprising a proxy component that facilitates utilizing at least one of a legacy or a third party controller within the database system.

5. The database system of claim 4, the proxy component comprises a mapping component that maps data from the one of the legacy or the third party controller from a first data format to a second data format that conforms to the hierarchically structured data model.

6. The database system of claim 4, the proxy component comprises a bridging component that packages data adapted for transmission over a first network for transmission over a second network.

7. The database system of claim 6, the second network is CIP.

8. The database system of claim 1, further comprising a security component that ensures that an entity requesting the data is authorized to received the data.

9. The database system of claim 1, further comprising a filtering component that filters data from the plurality of controllers based at least in part upon one or more of identity of an entity requesting the data or versioning information associated with the requested data.

10. The database system of claim 1, the hierarchically structured data model is based at least in part upon one or more of ISA S95, ISA S88, OMAC or a combination thereof.

11. The database system of claim 1, further comprising an interface component that facilitates access to the data within the plurality of controllers from a remote location.

12. The database system of claim 11, the interface component facilitates accessing the data by way of the Internet.

13. The database system of claim 1, further comprising an aggregation component that aggregates related data from within the plurality of controllers and stores the aggregated data in a same location.

14. The database system of claim 1, further comprising a subscription component that enables an operator to subscribe to receive a specific data object within the database system.

15. The database system of claim 14, further comprising a distribution component that automatically distributes the specified data object to the subscribing operator upon creation of the specified objects within the database system, the distribution based at least in part upon parameters associated with the subscription.

16. The database system of claim 14, further comprising a notification component that automatically notifies the subscribing operator regarding creation of the specific data object, the notification based at least in part upon parameters associated with the subscription.

17. The database system of claim 16, further comprising a scheduling component that ensures that the subscribing operator is at a specified location prior to notifying the subscribing operator.

18. The database system of claim 1, further comprising an interface component that generates a unified hierarchical view of the data within the plurality of controllers, the hierarchical view including at least a factory level, a cell level, a line level, and a device level, wherein the interface component facilitates traversal of the hierarchical view to locate and obtain data within the plant hierarchy.

19. A computer implemented method for utilizing a plurality of controllers as a distributed database comprising:

representing an automation environment that includes the plurality of controllers as a hierarchically structured data model having at least a site level, an area level, a line level, and a workcell level;

communicatively associating the plurality of controllers;

representing data stored within the plurality of controllers as data objects within the hierarchically structured data model;

providing a unified hierarchical view of the data objects within the plurality of controllers, the data conforms to the hierarchically structured data model;

receiving a pointer from at least one of the plurality of controllers indicating a location of a data object within the automation environment; and

maintaining the pointer to facilitate location and retrieval of the data object from the automation environment.

20. The method of claim 19, further comprising:

receiving a request for a subset of the data stored within the plurality of controllers;

collectively querying the plurality of controllers as a single entity for the requested data; and

retrieving the requested data from at least one of the plurality of controllers.

21. The method of claim 20, further comprising authenticating an initiator of the request prior to querying the plurality of controllers.

22. The method of claim 20, further comprising filtering the retrieved data based at least in part upon user identity.

23. The method of claim 20, further comprising mapping data stored in at least one of the plurality of controllers so that the data conforms to the hierarchically structured data model.

24. The method of claim 20, further comprising converting data formatted in accordance with a first network protocol to data formatted in accordance with a second network protocol.

25. The method of claim 24, the second network protocol is Common Industrial Protocol (CIP).

26. A distributed database system for utilization in an industrial automation environment, the system is recorded on a computer-readable medium and capable of execution by a computer, comprising:

means for providing direct access to content stored on a plurality of controllers, the content including data that conforms to a hierarchically structured data model representation of the industrial automation environment;

means for receiving a pointer from at least one of the plurality of controllers indicating a location of a subset of the content;

means for maintaining the pointer to facilitate location and retrieval of the subset of the content from the industrial automation environment;

means for receiving a request for the subset of the content; and

means for employing the hierarchically structured data model and the pointer to collectively search the content of the plurality of controllers for the requested subset as a single entity.

27. The distributed database system of claim 26, further comprising means for transferring data between controllers based at least in part upon available storage capacity associated therewith.

28. The distributed database system of claim 26, further comprising means for archiving data relating to at least one of the plurality of controllers to an external data store.

29. The distributed database system of claim 26, further comprising means for mapping data that does not conform to the hierarchically structured data model to data that conforms to the hierarchically structured data model.