Refocussing Sfemp Software
Within the activity of ` Fugitive Emission Management ' the application ` SfempX ' is used at present (current version is 3.5.1). This application has been developed in MS Visual Basic 6 and makes use of MS Access Database.
The most important sticking points in the current application are:
- Restriction of the size of MS Access database of 2 GB.
- The application and the database are not foreseen to work with several users simultaneously.
For improvement of these sticking points, one wants to let rewrite the application with newest technologies and the most modern tools.
Processes and functionalities
The process model of The Sniffers is, from the organisational responsibilities, to be shown schematically:
The redesign must result in the following positive points:
- Fast and efficient processing of data. Both reading in and calculating data and asking of reports must happen within few minutes.
- The database is unlimited concerning size. The integrity of the data is guaranteed at all times.
- The database can be used by several users at the same time, both for asking and processing.
- The application and the database use the optimum of the available system resources such as processors and memory (Multi-processing and Multi-threading).
- The application contains the facility to become web-enabled in the future.
Result
The new application contains following properties:
- Developed in MS Visual Studio 2005
- Uses MS SQL Server 2005 database
- Several users can simultaneously work in the same database
- Database can operate on a central server without speed loss for the application or overload of network
- Optimised data model ensures fast processing and asking of data. Data and results are available within minutes.
