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 6,516,326 B1
• Filed: 10/30/2000
• Issued: 02/04/2003
• Est. Priority Date: 10/30/2000
• Status: Expired due to Term

• Current Assignee: Siemens Industry Incorporated (Siemens AG)
• Original Assignee: Stone And Webster Consultants, Inc.
• Inventors: Perry, Kevin B, Goodrich, Margaret E, McClendon, David B, Peterson, Jeffrey S
• Primary Examiner(s): Amsbury, Wayne
• Assistant Examiner(s): AL HASHEMI, SANA A
• Application Number:
  US09/702,150
• Time in Patent Office: 827 Days
• Field of Search: 707/104.1, 707/102
• US Class Current: 707/602
• 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 computer implemented system and method of providing interoperability of various proprietary Energy Management System raw data formats, comprising the steps of:

(a) means for importing proprietary Energy Management System raw data, which is extracted from a running system or simulation, containing electrical network topology, measurements and related data to produce a source Common Information Model database that is properly electrically connected;

(b) means for recursively integrating a source and target Common Information Model databases into a new Common Information Model database that is properly electrically connected;

(c) means for maintaining said Common Information Model database using a graphical user interface to display and edit database entries; and

(d) means for exporting a said Common Information Model database to a specific proprietary Energy Management System raw data format contained in one or more files,

whereby an electrically connected network topology and related data can be exchanged and maintained between any proprietary Energy Management System of the same or different data format for the purpose of obtaining a complete and accurate network topology model while maintaining proprietary Energy Management System specific data format confidentiality.

2. The method of claim 1 wherein the step of importing proprietary Energy Management System raw data further comprising the steps of:

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

(b) means for creating one or more comma separated values schema template(s) based on the specific proprietary Energy Management System data format;

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

(d) means for resolving the connectivity nodes by data association or device context;

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

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

(g) means for inserting various power systems equipment into the temporary work(Base) database using an encrypted database query language and possibly code fragments during processing;

(h) means for loading the power systems equipment into a final power systems database(Master) from the temporary work(Base)database using a database query language and possibly code fragments during processing; and

(i) optionally verifying the electrical connectivity and providing a device level report for any error encountered.

3. The method of claim 2 wherein the step of creating a base database template with basic Common Information Model column headers further comprising the steps of:

(a) creating the terminal types table;

(b) creating the system type table;

(c) creating the foreign key tables;

(d) creating the reference convert table;

(e) optionally creating the auxiliary types table;

(f) optionally creating the auxiliary data table;

(g) means for creating the temporary data templates tables; and

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

4. The method of claim 2 wherein the step of creating the comma separated values schema templates internally further comprising the steps of:

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

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

(c) including the proprietary Energy Management System specific objects in the auxiliary types table, auxiliary data table or an specific table.

5. The method of claim 2 wherein the step of duplicating the proprietary Energy Management System data hierarchy internally further comprising the steps of:

(a) creating and processing a flat data hierarchy of the proprietary Energy Management System supplied data elements if the specification has flat data organization; and

(b) means for creating and processing an internal table with an assigned data level to match the input file name and data element for multi-leveled proprietary Energy Management System specific raw data formats.

6. The method of claim 2 wherein the step of resolving the connectivity nodes further comprises the steps of:

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

(b) means for locating the source and destination nodes from equipment specifications;

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

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

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

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

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

7. The method of claim 2 wherein the step of inserting various power systems equipment into the temporary work(Base) database using a database query language and possibly code fragments during processing further comprising the steps of:

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

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

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

8. The method of claim 1 wherein the step of recursively integrating a source and target Common Information Model databases into a new Common Information Model database that is properly electrically connected comprising the steps of:

(a) a user selection of whole or partial network topology from a first and second Common Information Model database;

(b) means for integrating said first and second Common Information Model databases into a single target database;

(c) means for detecting any disconnected equipment encountered during connectivity checking said source and target combined database; and

(d) means for automatically resolving disconnected equipment.

9. The method of claim 8 wherein the step of integrating said first and second Common Information Model databases into a single target database further comprising the steps of:

(a) creating a foreign key relational map of the source and target databases;

(b) removing non-selected companies from a first and second user selected database model;

(c) means for creating temporary cross-reference tables in combination with the original database;

(d) creating a temporary copy of said first and second user-selected models;

(e) means for integrating unique lookup information from said first and second user-selected models;

(f) merging al said non-static tables;

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

(h) means for processing remaining equipment contained in said master power system resource table;

(i) re-indexing of said connectivity table;

(j) copying the temporary data to said target database; and

(k) means for looping on all tables in said target database to convert temporary foreign keys into their newly indexed values.

10. The method of claim 1 wherein the step of maintaining said Common Information Model database using a graphical user interface to display and edit database entries further comprises the steps of:

(a) means for a user selected company or plurality of companies and type of topological view, displaying the data in a downward tree expansion for any of the selected said views including;

transmission lines, connectivity nodes, transformers and substations by base voltage;

(b) means for optionally editing existing equipment parameters to the network topology for any device and any said topological view;

(g) means for optionally adding new equipment to the network topology in any said topological view; and

(h) means for optionally deleting equipment from the network topology in any said topological view.

11. The method of claim 1 wherein the step of exporting said proprietary Energy Management System raw data format from a Common Information Model database to a different vendor data format further comprising the steps of:

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

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

(c) means for optionally applying a cross-reference of power system equipment names that replace original equipment names;

(d) means for applying an encrypted proprietary Energy Management System specific database query language and possibly code fragments to populate the associated specific raw data output fields into the native raw data file format; and

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

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

(a) means for matching the data format in the proprietary Energy Management System file(s) and fields to the Common Information Model equivalents for al equipment;

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

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