CN110489402A - A kind of method of pair of traditional waste water treatment process production process data model construction - Google Patents
A kind of method of pair of traditional waste water treatment process production process data model construction Download PDFInfo
- Publication number
- CN110489402A CN110489402A CN201910792874.8A CN201910792874A CN110489402A CN 110489402 A CN110489402 A CN 110489402A CN 201910792874 A CN201910792874 A CN 201910792874A CN 110489402 A CN110489402 A CN 110489402A
- Authority
- CN
- China
- Prior art keywords
- data
- control system
- data model
- treatment process
- plc control
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Testing And Monitoring For Control Systems (AREA)
Abstract
The invention discloses the methods of a kind of pair of traditional waste water treatment process production process data model construction, including following construction step: establish data model: the various data models that each subsystem in sewage treatment process is dynamically set up in a manner of data dynamic modeling establish database table structure: database table structure is used to store the real time data table, analysis data table and physical device parameter list of each subsystem process data, in-line meter and equipment;Establish the incidence relation between database table structure and data model, according to technological parameter, the device parameter in sewage treatment process production process, the data and laboratory data of in-line meter actual monitoring calculate the technological parameter of each process section data model by process simulation module dynamic.Sewage treatment process can be carried out digitlization and key equipment operation digitlization well by the present invention, and realize that the two is combined closely, and complete water treatment procedure dynamic optimization and equipment is most effectively run.
Description
Technical field
The invention belongs to processing technology fields in sewage art production process, and in particular to a kind of pair of traditional wastewater handles work
The method of skill production process data model construction.
Background technique
The existing municipal sewage plant's technological means in China more falls behind, and the technological design of traditional industry is by long term
Technique is designed, the development that looks to the future, least favorable time point hour operating condition, safety coefficient etc. element, determines that maximum operation is negative
Lotus (power generating system), therefore the state designed is static.And in actual production process, each element is dynamic change;Often
(power demand) is how many in a dynamic operation condition, and no technological means is implemented in existing conventional industries technology,
Thus power generating system provides power also according to maximum operating load, this is current conventional industries technology platform common fault,
It is current conventional industries energy consumption, the main reason for material consumption is excessively high.
The automation that sewage disposal system is commonly made of industrial personal computer (host computer) and the station several PLC (slave computer) at present
Control system, upper computer and lower computer generally passes through Ethernet or other communication modes carry out data exchange.Host computer is general
It is arranged in the central control room of sewage treatment plant, is responsible for the operation of full plant and the acquisition of data, stores and check, under
The all devices and instrument of position machine PLC Station To Station point range are individually managed, and are grasped in addition to being automated according to user's setting program
Make outside the process control of equipment, the order of host computer sending, the operation of Lai Zhihang equipment can also be received.But it is such automatic
Networked control systems are data acquisition and simple digital output modul, and automatic control level is lower, cannot be in conjunction with specific
Technology establishment goes out more optimized control strategy.
Summary of the invention
The purpose of the present invention is to provide the method for a kind of pair of traditional waste water treatment process production process data model construction,
To solve the problems mentioned in the above background technology.
To achieve the above object, the invention provides the following technical scheme:
The method of a kind of pair of traditional waste water treatment process production process data model construction, including following construction step:
It establishes data model: dynamically setting up each subsystem in sewage treatment process in a manner of data dynamic modeling
Various data models;
Establish database table structure: the database table structure for store each subsystem process data, in-line meter and
Real time data table, analysis data table and the physical device parameter list of equipment;
Establish the incidence relation between database table structure and data model: according in sewage treatment process production process
Technological parameter, device parameter, the data and laboratory data of in-line meter actual monitoring are calculated by process simulation module dynamic
The technological parameter of each process section data model out guarantees that stable effluent quality is up to standard.
As the preferred of the present embodiment, in the data model in a manner of data displayed page dynamic configuration dynamically
The various data displayed pages of the process data subsystem are configured, and are the data displayed page configuration data model, from
And set up the incidence relation between the data displayed page and the data model.
As the preferred of the present embodiment, in multiple sewage treatment process each subsystem include PLC control system,
DCS robot control system(RCS), analysis data management system and Intelligent Simulation System;
PLC control system is responsible for acquiring the instrumented data in coagulation stage and two stage treatment stage in sewage treatment process
With the equipment in the control process section;
DCS robot control system(RCS) is used to acquire the data of pretreatment section PLC control system and the number of biological section PLC control system
According to;The control command of user is transferred to pretreatment section PLC control system and biological section PLC control system by DCS robot control system(RCS);
Analysis data management system is for storing the water quality data that the laboratory personnel of sewage treatment plant chemically examine every time.
As the preferred of the present embodiment, the PLC control system includes pretreatment section PLC control system and biological section PLC
Control system;
The pretreatment section PLC control system be responsible for acquire sewage treatment process in the coagulation stage instrumented data and
Control the equipment in the process section;
Biological section PLC control system is responsible for acquiring the instrumented data in two stage treatment stage in sewage treatment process and controls this
Equipment in process section.
It is described that the process data is dynamically configured in a manner of integrated interface dynamic configuration as the preferred of the present embodiment
The integrated interface of subsystem, other systems can call the technique number of the process data subsystem by the integrated interface
According to.
Compared with prior art, the invention has the benefit that
The method of a kind of pair of traditional waste water treatment process production process data model construction of the present invention, by with number
The various data models of each subsystem in sewage treatment process are dynamically set up according to the mode of dynamic modeling;Establish database
Table structure, and the incidence relation between database table structure and data model is established, it can be well by sewage treatment process
Process carries out digitlization and key equipment operation digitlization, and realizes that the two is combined closely, and completes water treatment procedure dynamic optimization
It is most effectively run with equipment, guarantees that stable water outlet is up to standard, and bring huge economic benefit to user, realize energy-saving and emission-reduction
Purpose.
Detailed description of the invention
Fig. 1 is block diagram of the present invention to the method for traditional waste water treatment process production process data model construction.
Specific embodiment
Following will be combined with the drawings in the embodiments of the present invention, and technical solution in the embodiment of the present invention carries out clear, complete
Site preparation description, it is clear that described embodiments are only a part of the embodiments of the present invention, instead of all the embodiments.It is based on
Embodiment in the present invention, it is obtained by those of ordinary skill in the art without making creative efforts every other
Embodiment shall fall within the protection scope of the present invention.
Refering to Figure 1, the embodiment of the present invention provides a kind of pair of traditional waste water treatment process production process data model
The method of building specifically includes following construction step:
The first step establishes data model: being dynamically set up in sewage treatment process in a manner of data dynamic modeling
The various data models of each subsystem.
In the present embodiment, each of the subsystem in sewage treatment process is dynamically set up in a manner of data dynamic modeling
Kind data model.We explain by taking PLC control subsystem as an example below, and PLC control subsystem is used to store various PLC
The database table of control subsystem process data.In embodiments of the present invention, specifically, sewage treatment process data is being established
When the data model of system, the title of data model is determined by user first and is after the title that user determines data model
User provides a data model field template.In the data model Field Template with various fields usually all include it is some
Field attribute, such as serial number, title, ID, school weight field, data type, data dictionary, chained address, width, default value, length
It spends, must fill out, edits display, check display, illustrate.
After providing the data model Field Template for user, user is by inserting phase in each field attribute
Holding inside the Pass or selecting options provided by template can be the data model according to the data model Field Template
Add a field.It certainly, should be in data dictionary attribute if the selected data type of user is " data dictionary "
The middle corresponding data dictionary of selection.In this way, user can be its phase according to the process data of required storage and the difference of knowledge
The data model answered adds the field needed for oneself, to complete the building of data model.
Certainly, after building a data model, if it is considered to the certain field attribute of certain field is improper, also
It can be modified.For example, if it is considered to the field " being subordinate to profession " of some sewage treatment process data model " must
Fill out " attribute should be changed to "No" by "Yes", then can modify to it.After building a data model, such as
The field of the fruit data model is improper, for example, if it is considered to also need to increase a field or delete a field, then
The field of the data model can be increased or be deleted, to meet the needs of users.It is also possible to allow user to each
The operations such as a field moved up, moved down, top set, bottom set, to meet the individual demand of user.
Complete process data subsystem to be built and then the identical method and steps of use construct other process datas
Subsystem, until all process data subsystems of the process resource management system have all constructed.
Second step establishes database table structure: the database table structure is for storing each subsystem process data, online
The real time data table of instrument and equipment, analysis data table and physical device parameter list.
In the present embodiment, each subsystem mainly includes PLC control system, DCS automatic control system in sewage treatment process
System, analysis data management system and Intelligent Simulation System;PLC control system is responsible for acquiring coagulation rank in sewage treatment process
The instrumented data in section and two stage treatment stage and the equipment in the control process section, wherein PLC control system includes pretreatment section
PLC control system and biological section PLC control system;Pretreatment section PLC control system is responsible for acquiring level-one in sewage treatment process
The instrumented data of processing stage and the equipment in the control process section;Biological section PLC control system is responsible for acquiring sewage treatment work
The instrumented data in two stage treatment stage and the equipment in the control process section in skill;DCS robot control system(RCS) is for acquiring pretreatment section
The data of the data of PLC control system and biological section PLC control system;The control command of user is transferred to by DCS robot control system(RCS)
Pretreatment section PLC control system and biological section PLC control system;Analysis data management system is used to store the change of sewage treatment plant
Test the water quality data that room personnel chemically examine every time.
In the present embodiment, pretreatment section PLC control system includes PLC controller, analog quantity spread module, digital quantity expansion
Open up module, communication extension module, meters equipment, frequency converter, for the pump apparatus of promotion and other mechanical equipments.In sewage
Pretreatment stage mainly uses physical treatment method in treatment process, and commonly used equipment has elevator pump, grid, sieve, setting pot, sand
Separator etc., measuring instrument mainly have feed water flow meter, water inlet PH meter, influent COD analyzer, influent ammonia nitrogen analyzer, into
Water total phosphorus analyzer and some liquidometers and liquid level difference meter.The analog quantity spread module is for acquiring pretreatment stage instrument
4-20mA electric current ring signal, be converted into actual instrumented data by range conversion;The digital quantity expansion module, can be with
Multipath digital quantity input and output signal is provided, the start and stop of working condition and control equipment for acquiring equipment;The use
In equipment and the maximum equipment of power consumption that the pump apparatus of promotion is pretreatment stage key, the rated power of configuration
It is bigger, need to increase frequency converter to protect control, the RS485 signal and frequency converter provided with communication extension module is led to
Letter, can acquire running current, running frequency and the revolving speed of frequency converter, also the running frequency of adjustable frequency converter;Described
PLC controller is uploaded for instrumented data and device status data, and certainly according to the pre-programmed sequential logic program of user
The operation of dynamic control equipment.
Biological section PLC control system includes PLC controller, analog quantity spread module, digital quantity expansion module, communication extension
Module, meters equipment, frequency converter, the equipment for being aerated reflux and other mechanical equipments.It is biological in sewage treatment process
Processing stage mainly uses microbial treatment method, and common treatment process has AO technique, AAO technique, opel (Orbal) oxygen
Change ditch technique etc., by taking opel (Orbal) oxidation ditch process as an example, which has surface aerating machine, interior reflux pump, digestion
Liquid reflux pump, movable motor etc..On oxidation ditch, measuring instrument mainly has online dissolved oxygen instrument, online transmissometer, on-line oxidation
Reduction potential meter and some liquidometers;At discharge outlet, measuring instrument mainly has water flow meter, PH meter, COD analyzer, ammonia
Blood urea/nitrogen analyzer, total phosphorus analyzer.Analog quantity spread module is used to acquire the 4-20mA electric current loop of all instrument of biological treatment stage
Signal is converted into actual instrumented data by range conversion;The digital quantity expansion module, can provide Multipath digital quantity
Input and output signal, the start and stop of working condition and control equipment for acquiring biological treatment stage all devices;Described
Equipment for being aerated reflux is the equipment and the maximum equipment of power consumption of biological treatment stage key, the specified function of configuration
Rate is also bigger, needs to increase frequency converter to protect control, and the RS485 signal and frequency converter provided with communication extension module carries out
Communication, can acquire running current, running frequency and the revolving speed of frequency converter, also the running frequency of adjustable frequency converter;It is described
PLC controller uploaded for instrumented data and device status data, and the sequential logic program pre-programmed according to user
The operation of automatic control equipment.
DCS robot control system(RCS) is carried out by industrial ethernet protocol and pretreatment section PLC control system and biology section PLC control
Communication, the instrumented data all to sewage plant be acquired, storage and management, and the working condition of all devices is scheduled, complete
At the functions such as centralized operation, monitoring, record, report generation and printing, fault alarm and printing.It can intuitively be shown by LCD
The trend picture of the real-time working condition of each operation stage of factory, each technological parameter entirely, makes operator grasp full factory's operating condition in time.
Analysis data management system passes through curve for storing the water quality data that laboratory personnel chemically examine every time
Variation of water is intuitively shown with report.Laboratory needs the basic parameter measured mainly to have COD (COD), biochemistry
Oxygen demand (BOD), suspended solid substance (SS), total phosphorus (TP), total nitrogen (TN), ammonia nitrogen (NH3-N), nitrate nitrogen (NO3-N),
Dissolved oxygen (DO), sludge concentration (MLSS), sludge settling ratio (SV30) and sludge volume index (SVI) etc., these parameters are to dirt
Water process operation is of great significance, and analysis data management system can found perfect archives for these parameters, and pass through industry
These parameters are sent to data model systems by Ethernet.
Third step establishes incidence relation between database table structure and data model: being produced according to sewage treatment process
Technological parameter, device parameter in the process, the data and laboratory data of in-line meter actual monitoring, pass through process simulation module
Dynamic calculates the technological parameter of each process section data model, guarantees that stable effluent quality is up to standard.
In the present embodiment, the sewage treatment process number is dynamically configured in a manner of data displayed page dynamic configuration
It according to the various data displayed pages of subsystem, and is the data displayed page configuration data model, to set up the number
According to the incidence relation between displayed page and the data model, and then convenient for showing the number on the data displayed page
According to the data of the various sewage treatment process stored in the table of library.
In the present embodiment, dynamically matched in a manner of integrated interface dynamic configuration between the data model of subsystems
Set the integrated interface of the subsystem, the technique that subsystem can call other data subsystems by the integrated interface
Data, wherein the specific method for dynamically configuring integrated interface is completed by the mode of integrated interface template and middle table,
By integrated interface, the integrated of this data model can be realized.
It should be noted that, in this document, the terms "include", "comprise" or its any other variant are intended to non-row
His property includes, so that the process, method, article or equipment for including a series of elements not only includes those elements, and
And further include other elements that are not explicitly listed, or further include for this process, method, article or equipment institute it is intrinsic
Element.
It although an embodiment of the present invention has been shown and described, for the ordinary skill in the art, can be with
A variety of variations, modification, replacement can be carried out to these embodiments without departing from the principles and spirit of the present invention by understanding
And modification, the scope of the present invention is defined by the appended.
Claims (5)
1. the method for a kind of pair of traditional waste water treatment process production process data model construction, which is characterized in that including following structure
Build step:
It establishes data model: dynamically setting up each of each subsystem in sewage treatment process in a manner of data dynamic modeling
Kind data model;
Establish database table structure: the database table structure is for storing each subsystem process data, in-line meter and equipment
Real time data table, analysis data table and physical device parameter list;
Establish the incidence relation between database table structure and data model: according to the technique in sewage treatment process production process
Parameter, device parameter, the data and laboratory data of in-line meter actual monitoring are calculated each by process simulation module dynamic
The technological parameter of a process section data model guarantees that stable effluent quality is up to standard.
2. the method according to claim 1 to traditional waste water treatment process production process data model construction, feature
It is: dynamically configures the process data subsystem in a manner of data displayed page dynamic configuration in the data model
Various data displayed pages, and be the data displayed page configuration data model, so that setting up the data shows page
Incidence relation between face and the data model.
3. the method according to claim 1 to traditional waste water treatment process production process data model construction, feature
Be: each subsystem includes PLC control system, DCS robot control system(RCS), analysis data pipe in multiple sewage treatment process
Reason system and Intelligent Simulation System;
PLC control system is responsible for acquiring the instrumented data and control in coagulation stage and two stage treatment stage in sewage treatment process
Make the equipment in the process section;
DCS robot control system(RCS) is used to acquire the data of pretreatment section PLC control system and the data of biological section PLC control system;DCS
The control command of user is transferred to pretreatment section PLC control system and biological section PLC control system by robot control system(RCS);
Analysis data management system is for storing the water quality data that the laboratory personnel of sewage treatment plant chemically examine every time.
4. the method according to claim 3 to traditional waste water treatment process production process data model construction, feature
Be: the PLC control system includes pretreatment section PLC control system and biological section PLC control system;
The pretreatment section PLC control system is responsible for acquiring the instrumented data in coagulation stage and control in sewage treatment process
Equipment in the process section;
Biological section PLC control system is responsible for acquiring the instrumented data in two stage treatment stage in sewage treatment process and controls the technique
Equipment in section.
5. the method for a kind of pair of traditional waste water treatment process production process data model construction according to claim 1,
It is characterized in that: the integrated interface that the process data subsystem is dynamically configured in a manner of integrated interface dynamic configuration,
Other systems can call the process data of the process data subsystem by the integrated interface.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910792874.8A CN110489402A (en) | 2019-08-26 | 2019-08-26 | A kind of method of pair of traditional waste water treatment process production process data model construction |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910792874.8A CN110489402A (en) | 2019-08-26 | 2019-08-26 | A kind of method of pair of traditional waste water treatment process production process data model construction |
Publications (1)
Publication Number | Publication Date |
---|---|
CN110489402A true CN110489402A (en) | 2019-11-22 |
Family
ID=68554152
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201910792874.8A Pending CN110489402A (en) | 2019-08-26 | 2019-08-26 | A kind of method of pair of traditional waste water treatment process production process data model construction |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN110489402A (en) |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102902257A (en) * | 2012-10-30 | 2013-01-30 | 威水星空(北京)环境技术有限公司 | Sewage treatment process optimization and energy-saving control system and method |
CN104484777A (en) * | 2015-01-06 | 2015-04-01 | 北京索为高科系统技术有限公司 | Process resource data management system and construction method thereof |
CN106774222A (en) * | 2017-02-07 | 2017-05-31 | 河南和方科技有限公司 | Municipal sewage treatment digitizes accuracy-control system and Intelligent Simulation Method |
-
2019
- 2019-08-26 CN CN201910792874.8A patent/CN110489402A/en active Pending
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102902257A (en) * | 2012-10-30 | 2013-01-30 | 威水星空(北京)环境技术有限公司 | Sewage treatment process optimization and energy-saving control system and method |
CN104484777A (en) * | 2015-01-06 | 2015-04-01 | 北京索为高科系统技术有限公司 | Process resource data management system and construction method thereof |
CN106774222A (en) * | 2017-02-07 | 2017-05-31 | 河南和方科技有限公司 | Municipal sewage treatment digitizes accuracy-control system and Intelligent Simulation Method |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN102902257B (en) | sewage treatment process optimization and energy-saving control system and method | |
CN106774222A (en) | Municipal sewage treatment digitizes accuracy-control system and Intelligent Simulation Method | |
AU2021101438A4 (en) | Adaptive control method and system for aeration process | |
CN109857056A (en) | A kind of Intelligent sewage processing control system | |
US20030234218A1 (en) | System and method for AI controlling waste-water treatment by neural network and back-propagation algorithm | |
CN104238527A (en) | Precise control method of sewage treatment plant aeration total quantity | |
CN109761456A (en) | One kind being used for sewage treatment plant's electric control system | |
CN109534501A (en) | A kind of monitoring and managing method of rural domestic sewage treatment facility | |
Mulas | Modelling and control of activated sludge processes | |
CN105892363B (en) | The water utilities data acquisition control intelligent terminal and water utilities centralized monitoring system of NC series | |
CN108643278A (en) | A kind of energy-saving Township water supply system and its water-supply control | |
Bertanza et al. | Energy saving for air supply in a real WWTP: application of a fuzzy logic controller | |
CN105906032A (en) | Sewage treatment plant personification experience management control system and method | |
CN202808475U (en) | Surface aeration energy-saving control device | |
CN110489402A (en) | A kind of method of pair of traditional waste water treatment process production process data model construction | |
CN108763595B (en) | Sewage treatment data backtracking method and system | |
CN116088450A (en) | Intelligent terminal control system of sewage treatment plant, construction method and control method | |
CN109613191A (en) | A kind of Life cycle municipal sewage treatment monitoring method | |
Johnson | Water reuse and recovery facility connected digital twin case study: Singapore PUB’s Changi WRP process, control, and hydraulics digital twin | |
JP2004267865A (en) | Support system of water treatment process | |
CN105931139A (en) | Water data standardization management system | |
CN205676222U (en) | Accurate aeration control system for Orbal oxidation ditch | |
Olsson et al. | Plant-wide control: dream, necessity or reality? | |
CN203402990U (en) | Smart Internet of Things wastewater treatment device | |
CN204116928U (en) | The accuracy-control system of sewage treatment plant's aeration total amount |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
RJ01 | Rejection of invention patent application after publication | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20191122 |