System controller database manager with query stacking and caching for electrical distribution system

• US 7,765,202 B2
• Filed: 12/07/2006
• Issued: 07/27/2010
• Est. Priority Date: 09/22/2006
• Status: Expired due to Fees

• Current Assignee: Siemens Industry Incorporated (Siemens AG)
• Original Assignee: Siemens Industry Incorporated (Siemens AG)
• Inventors: Balasubramaniam, Ravikumar, Terricciano, Paul, Marellapudi, Seshagiri R, Williams, David M
• Primary Examiner(s): Pardo; Thuy N
• Application Number:
  US11/635,449
• Publication Number:
  US 20080126315A1
• Time in Patent Office: 1,328 Days
• Field of Search: 707/1, 707/2, 707/3, 707/4, 707/5, 707/10, 707/713, 707/758, 707/770, 707/782, 711/118, 709/229, 705/1.1
• US Class Current: 707/713
• CPC Class Codes: H02J 13/00028 involving the use of Internet protocols
• CPC Class Codes: H02J 13/00034 the elements or equipment being or involving an electric power substation

Abstract

An electrical distribution system includes a database manager using a query stack, comprising a panel with a plurality of remote operated devices mounted in the panel. Each remote operated device is for connection in a branch circuit to a load device. A panel controller is operatively connected to each of the remote operated devices. The panel controller comprises a programmed controller for controlling operation of the remote operated devices. A database is operatively associated with the programmed controller storing configuration data relating to operation of the remote operated devices. The panel controller is programmed to implement a database manager for accessing data in the database responsive to requests of the programmed controller, comprising storing a cache of data queries and responsive to a received request for data determining if a query relating to the received request is stored in the cache and returning the stored query, and operating the returned query to access data in the database.

Claims

1. A method of requesting access to data in an electrical distribution system, comprising:

providing a panel comprising a plurality of remote operated devices mounted in the panel, each remote operated device for connection in a branch circuit to a load device;

providing a panel controller operatively connected to each of the remote operated devices, the panel controller comprising a programmed controller for controlling operation of the remote operated devices;

providing a database associated with the programmed controller storing configuration data relating to operation of the remote operated devices; and

operating a database manager for accessing data in the database responsive to requests of the programmed controller, comprising storing a cache of data queries and responsive to a received request for data operating a get query routine and a get data routine, the get query routine comprising determining if a query relating to the received request is stored in the cache and if the query is stored in the cache then returning the stored query, or if the query is not stored in the cache then retrieving the query from a resource and returning the retrieved query, and the get data routine comprising operating the returned query against the database to access data in the database for use by the programmed controller.

2. The method of claim 1 wherein operating the get query routine further comprises storing the retrieved query in the cache.

3. The method of claim 2 further comprising removing a least accessed query form the cache.

4. The method of claim 1 wherein operating the database manager further comprises providing a single resource to access data in the database and wherein operating the returned query to access data in the database comprises establishing a connection with the single resource.

5. The method of claim 4 wherein the single resource allows only a single database connection at a time.

6. A method of requesting access to data in an electrical distribution system including a panel comprising a plurality of remote operated devices mounted in the panel, each remote operated device for connection in a branch circuit to a load device, and a panel controller operatively connected to each of the remote operated devices, the panel controller comprising a programmed controller for controlling operation of the remote operated devices, the method comprising:

providing a database associated with the programmed controller storing configuration data relating to operation of the remote operated devices;

providing a cache of database queries;

receiving a request for accessing data in the database;

operating a get query routine comprising determining if a query relating to the received request is stored in the cache and if the query is stored in the cache then returning the stored query, or if the query is not stored in the cache then retrieving the query from a resource and returning the retrieved query; and

operating a get data routine comprising operating the returned query against the database to access data in the database for use by the programmed controller.

7. The method of claim 6 further comprising storing the retrieved query in the cache.

8. The method of claim 7 further comprising removing a least accessed query form the cache.

9. The method of claim 6 further comprising providing a single resource to access data in the database and wherein operating the returned query to access data in the database comprises establishing a connection with the single resource.

10. The method of claim 9 wherein the single resource allows only a single database connection at a time.

11. An electrical distribution system including a database manager using a query stack, comprising:

a panel comprising a plurality of remote operated devices mounted in the panel, each remote operated device for connection in a branch circuit to a load device;

a panel controller operatively connected to each of the remote operated devices, the panel controller comprising a programmed controller for controlling operation of the remote operated devices;

a database operatively associated with the programmed controller storing configuration data relating to operation of the remote operated devices;

wherein the panel controller is programmed to implement a database manager for accessing data in the database responsive to requests of the programmed controller, comprising storing a cache of data queries and responsive to a received request for data operating a get query routine and a get data routine, the get query routine comprising determining if a query relating to the received request is stored in the cache and if the query is stored in the cache then returning the stored query, or if the query is not stored in the cache then retrieving the query from a resource and returning the retrieved query, and the get data routine comprising operating the returned query against the database to access data in the database for use by the programmed controller.

12. The electrical distribution system of claim 11 wherein the get query routine further comprises storing the retrieved query in the cache.

13. The electrical distribution system of claim 12 wherein the database manager further comprises removing a least accessed query form the cache.

14. The electrical distribution system of claim 11 wherein the database manager further comprises providing a single resource to access data in the database and wherein operating the returned query to access data in the database comprises establishing a connection with the single resource.

15. The electrical distribution system of claim 14 wherein the single resource allows only a single database connection at a time.