Design Database for an Automated Control System of Typical Wastewater Treatment Processes

Current requests, that are advanced to the cleaning parameters of wastewaters, including the offered by the EU community standards, are quite high. To satisfy them, a lot of parameters need to be maintained at a proper level. The presence of a significant number of control points, and a wastewater treatment process management, many situations affect the cleaning process in the case of deviations from the specified conditions, as well as many pollutants indicate that currently structured information for quality cleaning processes management should be available. Even an experienced operator cannot handle the monitoring and management of so many parameters optimally without the relevant database. The modern phase of the water-saving technology enterprises is characterized by large volumes and complexity of the information being processed, by the need for public access to data elements, by high demands to the speed of the information acquisition and its reliability that can be realized under the conditions of the functioning database. Since the database should not only be a storage, but should also have a link between the different elements, the data structure must be described formally. For that reason, the database subschema was designed (as the conceptual data model) for automation of water-saving processes. With the help of normalization, the hierarchical database model has been reduced to relational. It has significant advantages over the hierarchical and network data structures including the following: clarity of data presentation, ability to use one relational algebra (a language of Codd algebra), as well as simplicity of database reorganization. Due to the lack of a recognized analytical method of database management system selection, the choice of database for automatic water-saving control processes was carried out based on an expert estimations method. To maintain the functioning of the database on the defined criteria, the PostgreSQL database management system has been selected. As a result, that will implement the interface with application software concerning the automation of wastewater treatment technological processes, as well as the main production automation.