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

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.