Data management for Energy Companies

Based on an existing specification (thesis at the Fachhochschule Wiener Neustadt) we developed a prototype and production database application managing up to 200.000 structural data records of the Austrian high-voltage network.

• database modeling and adjustment to the proprietary data model of the network control system

• automated import interface for updates from the control system

• prototyping of a client/server system based on MS-Access 2002/2003 and Oracle 9i database server

• management of measurement data records and their types

• extensive filtering and data analysis functions

• logging of data updates with versioning functionality, alerts for special changes to data types

• interfaces to MS-Excel with individual export profiles

• import and export interfaces to process control system

• implementation of a user and role conception