CIM Based Virtual DataWarehouse for Oracle
SISCO’s Virtual Data Warehouse (VDW) Reduces the Time and Cost to
Develop IEC Common Information Model (CIM) Based Data Warehouse
Description
SISCO’s VDW allows information stored in existing legacy databases to appear as CIM data and to be integrated with other utility information assets using the CIM as a common data model for information integration. The VDW provides the capability to map diverse legacy data into the CIM and provides client access to the data using a standard ODBC interface. The VDW provides a single version of the data contained in legacy systems to enable utilities to create an open analysis platform for maximum flexibility.
The VDW leverages important industry standards to provide a unique and powerful solution for operational data analysis:
- Enables a unified schema for all utility information assets based on the CIM.
- Drag and drop configuration of legacy database schema to the CIM schema
- Connectors to major database products such as Oracle and ODBC based client applications
- Support for CIM XML import
- Can be integrated with other CIM sources using SISCO UIB products.
The result is a powerful standards-based data analysis tool tailored for utilities that allows data that is locked in proprietary data bases to be shared enterprise wide.
Benefits
- Leverages existing data sources without requiring modification of legacy data bases.
- Organizes isolated departmental data bases into a common CIM based view to unlock legacy data enabling enterprise wide usage and analysis.
- Accessing data within the context of a standardized CIM model exposes power system context making applications easier to develop and manage.
- Support for Common Information Model (CIM) and Generic Interface Definition (GID) standards of IEC eliminates dependency on proprietary schemas and interfaces reducing complexity and cost of integration.
