Balance program for monitoring the efficiency of production plants for acrylic monomers
Project duration: 2 years, 4 months
Brief description
The application is used internationally at several locations to monitor the efficiency of several production plants. The goal is to migrate the existing MS-DOS-Pascal technology to a web-based 3-tier architecture and platform in order to provide users worldwide with a user-friendly intranet application with convenient further processing and evaluation of data. This has been done since 2005. Since then, the application has been maintained and extended.
Supplement
Porting the data flat files to a relational Oracle database that acts as the central database. Converting and migrating the old data. Mapping the complex calculation routine with a larger degree of calculational precision (code analysis). These routines are mapped in PL/ SQL because the program sequence is almost 1:1. Creating the dialogs with Java and the Struts framework as the browser interface. All list tasks are provided as Excel files for individual processing and saving.
Subject description
The graphics are output in a client Excel template for individual layout. Additionally, a data interface is developed to the process control systems for the various plants, in order to automate the copying of measured values.