Distributed data access methods and apparatus for process control systems

• US 7,809,679 B2
• Filed: 03/03/2003
• Issued: 10/05/2010
• Est. Priority Date: 03/03/2003
• Status: Expired due to Fees

• Current Assignee: Fisher-Rosemount Systems Incorporated (Emerson Electric Company)
• Original Assignee: Fisher-Rosemount Systems Incorporated (Emerson Electric Company)
• Inventors: Lucas, Mike, Chatkoff, Teresa, Nixon, Mark J., Gilbert, Stephen
• Primary Examiner(s): Corrielus; Jean M
• Application Number:
  US10/378,357
• Publication Number:
  US 20040177060A1
• Time in Patent Office: 2,773 Days
• Field of Search: 707/2, 707/3, 707/609, 707/610, 707/626, 707/633, 707/635, 707 1- 10, 707200-204, 709210-225
• US Class Current: 707/609
• CPC Class Codes: G06F 16/24561 Intermediate data storage techniques for performance improvement

Abstract

Systems and methods of accessing a database associated with a process control system send a request for information from a client application to an intermediate data server process and determine if the information is stored within a data source associated with the intermediate data server process. The systems and methods also send a request for the information from the intermediate data server process to another process if the information is not stored within the data source and access the database to retrieve the information subsequent to the other process receiving the request for the information.

Claims

1. A method of propagating information within a networked system, comprising:

receiving, at a first one of a plurality of intermediate data servers within the networked system, a request for first information, the plurality of intermediate data servers in communication with a plurality of client applications and adapted to interoperate to retrieve and store, in respective local data sources, subsets of information in accordance with informational needs of at least some of the client applications, the request for the first information associated with a first one of the plurality of client applications;

receiving, at a second one of the plurality of intermediate data servers, the request for the first information when the first information is not locally stored in a first one of the local data sources associated with the first intermediate data server;

when the first information is not locally stored in a second one of the local data sources associated with the second intermediate data server, determining an access pattern associated with a database and the first client application, wherein the access pattern is indicative of different information separately requestable by the first client application from the database, the database storing information associated with a process control system;

selecting the first information within the database to form second information based on the access pattern and the first client application;

sending the second information to the second intermediate data server within the networked system;

sending the second information from the second intermediate data server to the first intermediate data server; and

storing at least a portion of the second information in the first local data source associated with the first client application, wherein the first local data source is local to the first client application to enable the client application to access the at least the portion of the second information in the first local data source when the first client application is off-line.

2. A method as defined in claim 1, wherein sending the second information from the second intermediate data server to the first intermediate data server includes sending an extensible markup language document from the second intermediate data server to the first intermediate data server.

3. A method as defined in claim 1, wherein storing the at least the portion of the second information in the first local data source associated with the first client application includes storing information associated with other information requested by the first client application.

4. A method as defined in claim 1, wherein the second information includes rules for accessing data associated with the process control system.

5. A method as defined in claim 1, wherein storing the at least the portion of the second information in the first local data source enables the first client application to access the second information from the first local data source faster than accessing the second information from the second intermediate data server.

6. A method as defined in claim 1, further comprising storing the at least the portion of the second information in a plurality of other data sources, each of which is local to another client application.

7. A method as defined in claim 1, further comprising communicating a listing of changes associated with the first information and the second information to the database.

8. A method as defined in claim 1, further comprising:

receiving a first data access request from the first client application, wherein the first information is not requested via the first data access request; and

responsive to the first data access request, selecting the first information within the database in response to predicting based on the first data access request, that the first information is to be requested via a subsequent data access request.

9. A system to propagate information within a networked system, comprising:

a first one of a plurality of intermediate data servers within the networked system to receive a request for first information, the plurality of intermediate data servers in communication with a plurality of client applications and adapted to interoperate to retrieve and store, in respective local data sources, subsets of information in accordance with informational needs of at least some of the client applications, the request for the first information associated with a first one of the plurality of client applications;

a second one of the plurality of intermediate data servers to receive the request for the first information when the first information is not locally stored in a first one of the local data sources associated with the first intermediate data server;

a database to store information associated with a process control system and configured to determine an access pattern associated with the first client application when the first information is not locally stored in a second one of the local data sources associated with the second intermediate data server, and the database to select the first information to form second information based on the access pattern and the first client application, wherein the access pattern is indicative of different information separately requestable by the first client application from the database;

the second intermediate data server configured to receive the second information from the database;

the first intermediate data server configured to receive the second information from the second intermediate data server; and

a first one of the local data sources associated with the first client application and configured to store at least a portion of the second information, wherein the first local data source is local to the first client application and enables the first client application to access the at least the portion of the second information in the first local data source when the first client application is off-line.

10. A system as defined in claim 9, wherein the first intermediate data server is configured to receive the second information from the second intermediate data server using an extensible markup language document.

11. A system as defined in claim 9, wherein the first local data source is configured to store the at least the portion of the second information in association with other information requested by the first client application.

12. A system as defined in claim 9, wherein the second information includes rules for accessing data associated with the process control system.

13. A system as defined in claim 9, wherein the first local data source is configured to enable the first client application to access the second information from the first local data source faster than accessing the second information from the second intermediate data server.

14. A system as defined in claim 9, further comprising a plurality of other data sources, each of which is local to another client application and configured to store the at least the portion of the second information.

15. A system as defined in claim 9, wherein the first intermediate data server is configured to communicate a listing of changes associated with the first information and the second information to the database.

16. A system as defined in claim 9, wherein the database is further configured to:

receive a first data access request from the first client application, wherein the first information is not requested via the first data access request; and

responsive to the first data access request, select the first information in response to predicting, based on the first data access request, that the first information is to be requested via a subsequent data access request.

17. A machine readable medium having instructions stored thereon that, when executed, cause:

a first one of a plurality of intermediate data servers within the networked system to receive a request for first information, the plurality of intermediate data servers in communication with a plurality of client applications and adapted to interoperate to retrieve and store, in respective local data sources, subsets of information in accordance with informational needs of at least some of the client applications, the request for the first information associated with a first one of the plurality of client applications;

a second one of the plurality of intermediate data servers to receive the request for the first information when the first information is not locally stored in a first one of the local data sources associated with the first intermediate data server;

a database to store information associated with a process control system, determine an access pattern associated with the first client application when the first information is not locally stored in a second one of the local data sources associated with the second intermediate data server, and select the first information to form second information based on the access pattern and the first client application, wherein the access pattern is indicative of different information separately requestable by the first client application from the database;

the second intermediate data server to receive the second information from the database;

the first intermediate data server to receive the second information from the second intermediate data server; and

the first local data source to store at least a portion of the second information, wherein the first local data source is local to the first client application and enables the first client application to access the at least the portion of the second information in the first local data source when the first client application is off-line.

18. A machine readable medium as defined in claim 17 having instructions stored thereon that, when executed, cause the first intermediate data server to receive the second information from the second intermediate data server using an extensible markup language document.

19. A machine readable medium as defined in claim 17 having instructions stored thereon that, when executed, cause the first local data source to store the at least the portion of the second information in association with other information requested by the first client application.

20. A machine readable medium as defined in claim 17, wherein the second information includes rules for accessing data associated with the process control system.

21. A machine readable medium as defined in claim 17 having instructions stored thereon that, when executed, cause the first local data source to enable the first client application to access the second information from the first local data source faster than accessing the second information from the second intermediate data server.

22. A machine readable medium as defined in claim 17 having instructions stored thereon that, when executed, cause a plurality of other data sources, each of which is local to another client application, to store the at least the portion of the second information.

23. A machine readable medium as defined in claim 17 having instructions stored thereon that, when executed, cause the first intermediate data server to communicate a listing of changes associated with the first information and the second information to the database.

24. A machine readable medium as defined in claim 17 having instructions stored thereon that, when executed, cause the database to:

receive a first data access request from the first client application, wherein the first information is not requested via the first data access request; and

responsive to the first data access request, select the first information in response to predicting, based on the first data access request, that the first information is to be requested via a subsequent data access request.

25. A method, comprising:

receiving, at a first one of a plurality of intermediate data servers, a request for first information, the plurality of intermediate data servers in communication with a plurality of client applications and adapted to interoperate to retrieve and store, in respective local data sources, subsets of information in accordance with informational needs of at least some of the client applications, the request for the first information associated with a first one of the plurality of client applications;

receiving, at a second one of the plurality of intermediate data servers, the request for the first information when the first information is not locally stored in a first one of the local data sources associated with the first intermediate data server;

when the first information is not locally stored in a second one of the local data sources associated with the second intermediate data server, determining an access pattern associated with accessing data in a database, wherein the access pattern is indicative of different information separately requestable from the database;

selecting the first information within the database to form second information based on the access pattern;

storing the second information in the first and second intermediate data servers; and

storing at least a portion of the second information in the first local data source associated with the first client application to enable the first client application to access the portion of the second information in the first local data source.

26. A method as defined in claim 25, wherein the second information is stored in the first and second intermediate data servers using an extensible markup language format.

27. A method as defined in claim 25, wherein the second information includes a plurality of rules associated with processing at least some of the second information.

28. A method as defined in claim 25, further comprising selecting the first information within the database in response to a request from the first client application.

29. A method as defined in claim 25, further comprising communicating a listing of changes associated with the first information and the second information to the database.

30. A method as defined in claim 25, further comprising:

receiving a first data access request, wherein the first information is not requested via the first data access request; and

responsive to the first data access request, selecting the first information within the database in response to predicting, based on the first data access request, that the first information is to be requested via a subsequent data access request.