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