Evgeniy S. Cheropkin

Work place: Department of Chemical Production Automation, National Technical University of Ukraine “Igor Sikorsky Kyiv Polytechnic Institute”, Kyiv, Ukraine

E-mail: e.cheropkin@kpi.ua


Research Interests: Process Control System, Computational Learning Theory, Artificial Intelligence


Evgeniy S. Cheropkin is working as Assistant at the Automation of Chemical Production Department at National Technical University of Ukraine ―Igor Sikorsky Kyiv Polytechnic Institute‖. His research includes automatic control system, technology of artificial intelligence, machine learning, using web technology for creation of automatic control systems. Author 34 research papers in reputed journals and conferences.

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

By Anatolii I. Zhuchenko Liudmyla V. Osipa Evgeniy S. Cheropkin

DOI: https://doi.org/10.5815/ijem.2017.04.04, Pub. Date: 8 Jul. 2017

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.

[...] Read more.
Other Articles