System and method for integrating electrical power grid and related data from various proprietary raw data formats into a single maintainable electrically connected database

• US 7,111,018 B1
• Filed: 02/04/2003
• Issued: 09/19/2006
• Est. Priority Date: 10/30/2000
• Status: Expired due to Term

• Current Assignee: Siemens Industry Incorporated (Siemens AG)
• Original Assignee: David B. Mcclendon, Jeffrey S. Peterson, Kevin B. Perry, Margaret E. Goodrich
• Inventors: Perry, Kevin B, Goodrich, Margaret E, McClendon, David B, Peterson, Jeffrey S
• Primary Examiner(s): AL HASHEMI, SANA A
• Application Number:
  US10/357,693
• Time in Patent Office: 1,323 Days
• Field of Search: None
• US Class Current: 1/1
• CPC Class Codes: G06F 16/256 in federated or virtual databases
• CPC Class Codes: Y10S 707/94 Infrastructure
• 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
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 707/99948 Application of database or data structure, e.g. distributed, multimedia, or image

Abstract

An improved system and method of automating the integration of different Energy Management Systems (EMS) electrical power grid databases into a single power grid database. This method imports proprietary EMS raw data from various vendors'"'"' formats into a Common Information Model (CIM) with specific connectivity extensions and produces an electrically connected power systems database that can be viewed or edited. Direct network topology conversion from one EMS vendor data format to another is also supported. Two generated databases can then be selectively integrated and maintained to produce a fully populated network topology without disclosing EMS vendor specific proprietary information. The new, possibly larger, database can then be added to yet another database that is similarly processed.

Claims

1. A method of providing interoperability of various Energy Management System raw data formats, comprising the steps of:

(a) importing Energy Management System raw data to produce a first Common Information Model database and a second Common Information Model database;

(b) recursively integrating said first and second Common Information Model database into a merged Common Information Model database that is properly electrically connected;

(c) Exporting said merged Common Information Model database to a specific Energy Management System raw data format;

(d) whereby electrically connected network topology and related data can be exchanged and maintained between any Energy Management System of the same or different data format for the purpose of obtaining a complete and accurate network topology model while maintaining confidentiality of said raw data format;

(e) creating a base database template with Common Information Model column headers;

(f) creating at least one comma separated values schema template based on the specific Energy Management System data format;

(g) duplicating the Energy Management System data hierarchy such that the Energy Management System specific raw data is properly inserted into the comma separated values;

(h) resolving the connectivity nodes by data association or device context;

(i) converting the raw Energy Management System data fields into a comma separated value file format based on the associated specification;

(k) linking the comma separated values to a temporary work database;

(l) inserting various power system equipment into the temporary work database using an encrypted database query; and

(m) loading the power system equipment into final power systems database from the temporary work database using a database query language.

2. The method of claim 1 further comprising the steps of verifying electrical connectivity and providing a device level report for any error encountered.

3. The method of claim 1 wherein the step of recursively integrating said fist and second Common Information Model databases into a merged Common Information Model database comprises the steps of:

(a) selecting whole or partial network topology from said first and second Common Information Model databases;

(b) integrating said selection from said first and second Common Information Model databases into said merged Common Information Model database;

(c) detecting any disconnected equipment; and

(d) resolving disconnected equipment.

4. The method of claim 1 further comprising, prior to export, the steps of:

(a) selecting the data for a company or plurality of companies;

(b) selecting type of topology view;

(c) displaying said data in a downward tree expansion by base voltage for said selected type of topology view including;

transmission lines, connectivity nodes, transformers and substations; and

(d) editing existing equipment parameters to the network topology for any device and any said topology view as necessary.

5. The method of claim 4 further comprising the step of adding new equipment to the network topology in any said selected topology view, as necessary.

6. The method of claim 4 further comprising the step of deleting equipment from the network topology in any said topology view, as necessary.

7. The method of claim 1 wherein the step of exporting said merged Common Information Model database to a specific data format further comprises the steps of:

(a) creating and processing a base database template with basic Common Information Model column headers and Energy System specific export definitions;

(b) creating and processing a master database template with Energy Management System specific extensions and Common Information Model compliant tables;

(c) applying an encrypted Energy Management System specific database query language to populate the associated specific raw data output fields into the native raw data file format; and

(d) writing the Energy Management System specific raw data file(s) to disk or a permanent storage medium.

8. The method of claim 7 further comprising the step of, prior to step (c), applying a cross-reference of power system equipment names that replace original equipment names.

9. The method of claim 7 wherein the step of populating the associated specific raw data output fields into the native raw data file format is accomplished with the use of code fragments.

10. The method of claim 1 wherein the step of creating a base database template with Common Information Model column headers further comprises the steps of:

(a) creating a terminal types table;

(b) creating a system type table;

(c) creating a foreign key table;

(d) creating a reference convert table;

(e) creating a temporary data template table; and

(f) combining said tables into a base database template.

11. The method of claim 10 further comprising the steps of:

(a) creating an auxiliary types table; and

(b) creating an auxiliary data tables.

12. The method of claim 11 wherein the step of creating said comma separated values schema template further comprises the steps of:

(a) creating an internal structure of the Energy Management System data elements to be represented in a comma separated values format;

(b) matching said Energy Management System data elements to corresponding Common Information Model objects; and

(c) incorporating said Energy Management System data elements into said auxiliary types table and said auxiliary data table.

13. The method of claim 1 wherein the step of duplicating the Energy Management System data hierarch internally comprises, for specification with a flat data organization, the step of creating and processing a flat data hierarchy of the Energy Management System supplied data elements.

14. The method of claim 1 wherein the step of duplicating the Energy Management System data hierarchy internally comprises, for specification with a multi-level data organization, the step of creating and processing an internal table with an assigned data level to match the input file name and data element.

15. The method of claim 1 wherein the step of resolving the connectivity nodes further comprises the steps of:

(a) determining the state of the Energy Management System supplied data and documentation to be without specific connectivity nodes;

(b) locating the source and destination nodes from equipment specification;

(c) creating the busbar connectivity nodes in the connectivity table;

(d) creating the connectivity nodes for all switches nodes in the connectivity table;

(e) creating remaining source nodes in the connectivity table;

(f) creating remaining destination nodes in the connectivity table; and

(g) creating connectivity nodes for all grounds nodes in the connectivity table.

16. The method of claim 1 wherein the step of converting the raw Energy Management System data to a comma separated value file format further comprises the steps of:

(a) matching the data format of the Energy Management System to the Common Information Model equivalents for all equipment;

(b) optionally processing a multi-level data hierarchy by parsing Energy Management System raw data based on the level; and

(c) inserting the equipment type into the comma separated values based on the previously defined Energy Management System specific schema for all equipment types.

17. The method of claim 1 wherein the step of inserting various power systems equipment into the temporary work database using an encrypted database query language further comprises the steps of:

(a) creating generic records for all Energy Management System specific output fields definitions;

(b) establishing the field output for each Energy Management System file type and setting the order of Sequential Query Language processing; and

(c) combining the database records and the Energy Management System tables into an output field for the target record type for all records and for all files.

18. The method of claim 1 wherein the step of inregrating said first and second Common Information Model database into a merged Common Information Model database further comprises the steps of:

(a) creating a foreign key relational map of said first and second database;

(b) removing non-selected companies from said first and second databases;

(c) creating temporary cross-reference tables;

(d) creating a temporary copy of said first and second database;

(e) merging all non-static tables contained in said temporary copies of said first and second database using unique lookup information from said first and second database;

(f) dynamically assigning new primary keys to non-static tables during merge processing;

(g) processing remaining equipment contained in the power system resource table generated in the merge process;

(h) re-indexing the connectivity table;

(i) copying all temporary data to said merged database; and

(j) looping on all tables in said merged to convert temporary foreign keys into their newly indexed values.