CN100433000C - Date acquiring method realized by using object oriented data base development - Google Patents
Date acquiring method realized by using object oriented data base development Download PDFInfo
- Publication number
- CN100433000C CN100433000C CNB2005100266735A CN200510026673A CN100433000C CN 100433000 C CN100433000 C CN 100433000C CN B2005100266735 A CNB2005100266735 A CN B2005100266735A CN 200510026673 A CN200510026673 A CN 200510026673A CN 100433000 C CN100433000 C CN 100433000C
- Authority
- CN
- China
- Prior art keywords
- data
- finished product
- product volume
- key word
- coil
- 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.)
- Active
Links
Images
Abstract
The present invention provides a date collection method developed and implemented for a data base, which comprises the following steps: step 1: a process control computer saves the received data unchanged in the full process in a full-process data list; step 2: the process control computer saves the received data changed according to cycles in a region list divided according to technology processes; step 3: after a finished product volume is produced, the process control computer insert the key word of the finished product volume into each technology process region list and each full-process data list, and then the finished product volume is used as a unit, all the process data of the volume are collected to form a report of the finished product volume and send out the report. The date collection method not only can accurately collect various data uploaded from production control devices on a base layer, but also can dispense sampled data to a branched volume and can directly exchange data with the application functions of a foreground, such as an HMI, an IPC, etc. Producing conditions can be controlled better, and the control function of the process computer is perfected.
Description
Technical field
The present invention relates to a kind of method of data capture, relate in particular to a kind of method of data capture that realizes with the object-oriented database exploitation.
Background technology
The information architecture of steel plant generally is divided into level Four: L1-basic automation systems (hereinafter to be referred as L1), L2-process computer (hereinafter to be referred as L2), L3-(branch level of factory) production control computer system (hereinafter to be referred as L3), L4-management information management system of company level (hereinafter to be referred as L4).And it is generally higher to produce the performance requirement of handling line in the general iron and steel cold rolling mill continuously, has very high technology content and technical difficulty.Data gathering system is one of major function of process computer, can help people to grasp the on-the-spot real time data that constantly changes, various model datas etc. effectively, and reduction failure rate, raising production output are played important effect.
Present existing data gathering system major part all is that the utilization standard C language is developed by the traditional file tactic pattern, the program structure complexity, interface is many, take big system memory space, relatively poor with the associativity of other application functions, in case and after production technology changed, corresponding software module all will be done corresponding change, the reusability of program is relatively poor.
Summary of the invention
Technical matters to be solved by this invention provides the method for data capture that a kind of object-oriented database exploitation realizes, it can not only collect the various data of uploading from bottom production control equipment exactly, and sampled data is assigned to bundling, can also be directly and each application function of foreground, as HMI, IPC etc., carry out exchanges data, can grasp the situation of production better, the perfect control function of process computer.
In order to solve the problems of the technologies described above, the invention provides a kind of method of data capture that realizes with the object-oriented database exploitation, comprise the steps:
Step 1: the data that process computer is constant with the overall process that receives, setting the stock roll key word is that unit is kept in the overall process tables of data with the stock roll;
Step 2, the data that will change by the cycle sent to process computer by cycle of prior setting, and process computer is that unit is saved in the regional form of dividing by technological process with the stock roll with the data that receive;
Step 3, after finished product volume produces, process computer is according to the corresponding relation of finished product volume key word and stock roll key word, finished product is rolled up key word to be inserted in each technological process zone form and the overall process tables of data, be unit with the finished product volume then, should roll up all process datas and gather, form finished product volume form and transmission.
Owing to adopted technique scheme, the present invention to have following advantage and technical progress:
(1) adopts object-oriented database, exactly sampled data is assigned to bundling
The purpose of collection system is by collecting each coil of strip data in process of production, studying the situation of the operating process and the quality control of unit on this basis.L2 process machine is accepted the data that L1 uploads by network, produce the processing line continuously for each, the sampled value that L1 at a time uploads, it is the different length position that is distributed in coil of strip, perhaps be assigned on the different coil of strips, and the sampled value of same coil of strip in same extension position should be stored in a record of the data storage form in the process computer system.The past data collection system all is to design and develop by traditional file structure basically, collection system just simply directly stores the sampled data that collects into form, need then to put in order these data again, could obtain according to time sequencing, along the valid data of the reflection practical condition of coil of strip length direction arrangement by other programs.The data gathering system that adopts the object-oriented database exploitation to realize after receiving data, is assigned to bundling with sampled data exactly, with the coil of strip is that unit forms record, and after the coil of strip outlet is sheared, data are processed, handled, form finished product volume form and directly send to L3.
(2) program structure simplicity of design, has flexibly reduced the load and the memory capacity of process computer effectively
If it is longer to enter the coil of strip of producing unit, because the dynamic change of unit, may there be bigger difference in each physical points to the processing of these points through the asynchronism(-nization) of the same equipment of unit on the coil of strip; In addition, handle line for the production that technical difficulty is higher, the project of sampled data is more, and time requirement is also inconsistent.Like this, the arrangement of sampled data and form all more complicated, the collection system of traditional file mechanical development, data are generally preserved hereof with the form of sequence, and complicated data may just need store with structure of arrays.Structure of arrays difficulty on handling is higher, also makes mistakes easily, causes the words of deadlock will directly have influence on the operation of whole process computer system.And file system is in the process of designing and developing, and must at first define the size of the file of storage data, and the size of file is also fixed, even there are not data in the file, the storage space of computing machine is also occupied.And because the memory capacity of computing machine is limited, so that file can not design is too much, promptly system generally can only store the production data in the certain hour.But with database development, the size of the form of storage data all is according to the stored number dynamic change of reality, and can regularly empty on demand, and data are that unit is deposited with the coil of strip, operation with strong points, and the structure of form is also simple; When collecting data, directly will be assigned to bundling after the data preparation, other the program of need not to redevelop is come deal with data, just makes that the program structure of whole process computer system is fairly simple; If a program is made mistakes, system is display alarm information immediately, also can not influence the normal operation of other programs.Therefore, the data gathering system that realizes with database development has reduced the load and the memory capacity of process computer effectively, has improved travelling speed greatly.
(3) combine with other functional modules are good, and help the foreground application function development
Data gathering system with object-oriented database exploitation realization, born main data processing function, the coil of strip mobile location information that one side provides according to tracking module, the sampled data that receives is corresponding with coil of strip, on the one hand reduced data is sent to L3, the data that are stored in the table also can be used for other modules.Simultaneously, data gathering system is directly carried out exchanges data with foreground application systems such as HMI, IPC, and this is that original document framework system can not be accomplished.
(4) can be used for different computer platforms, program test is simple, convenient
Database can be used for different computer operating system platforms, and adoptable development language is varied, and the common SQL statement is simple and easy to grasp.And operation tool that database carries or available is more, can directly operate data on the operation interface intuitively, makes program test get up simply, make things convenient for many.
Embodiment
The method of data capture that realizes with the object-oriented database exploitation of the present invention comprises the steps:
Step 1: the data that process computer is constant with the overall process that receives, setting the stock roll key word is that unit is kept in the overall process tables of data with the stock roll;
The data that described overall process is constant comprise the specification, material etc. (only preserving a cover in the system) of coil of strip.
Generally, according to predetermined sampled point, coil of strip is behind process a certain (group) PROCESS FOR TREATMENT equipment, L1 (basic automation systems) sends one group of data (comprising coil of strip ID) to L2 (process computer by network, data gathering system (belonging to process computer) is received data, and is that key word is kept at (overall process tables of data) (seeing Table one) in the form with data in proper order by production with stock roll ID.
If in the information that L1 (basic automation systems) sends, do not have stock roll ID, data gathering system can be followed the tracks of the mapping table (seeing attached list two) from coil of strip and be obtained the coil of strip ID of current time by should (group) process equipment (as from subordinate list two as can be known, in the entry loop position is coil of strip B).
Table two (coil of strip tracking mapping table)
The unit position | Coil of strip ID |
Uncoiler | Coil of strip B |
Entry loop | Coil of strip B |
Stove | Coil of strip A |
。。 | 。。。 |
Weigher | Coil of strip A |
Step 2, the data that will change by the cycle sent to process computer by cycle of prior setting, and process computer is that unit is saved in the regional form of dividing by technological process with the stock roll with the data that receive;
The described data that change by the cycle are the real time data of unit, comprise furnace temperature, gas flow etc., electric or instrumentation by L1 (basic automation systems) sent to L2 (process computer) by the cycle of setting in advance, preserve the overall process data in L2 (process computer) system, after coil of strip is sheared by outlet, data are processed processing, form finished product volume form.
These cycle datas that L1 (basic automation systems) sends have plenty of by the set time order and send, and have plenty of that the regular length passed through by coil of strip sends; Have plenty of that PLC (electric) equipment sends, have plenty of that DCS (instrument) equipment sends.Data gathering system, with the data that receive, sequencing according to time of reception is saved in the regional form of dividing by technological process (shearing as the most general inlet uncoiling, stove heating, outlet) (seeing Table three ~ five), and follows the tracks of the stock roll ID that passes through this group process equipment that finds current time the mapping table from coil of strip.
Table three:
Inlet uncoiling tables of data
Sequence number | Raw material coil of strip ID | Finished product volume ID | Uncoiler tension force (n) | Uncoiler tension force setting value (n) |
1 | Coil of strip A | Coil of strip A ' | 50 | 55 |
2 | Coil of strip B | Coil of strip B ' | 60 | 65 |
。。 | 。。。 | 。。。 | 。。。 | 。。。 |
N | Coil of strip N | Coil of strip N ' | 80 | 85 |
Table four:
Tables of data in the stove
Sequence number | Raw material coil of strip ID | Finished product volume ID | Belt steel temperature (℃) | Temperature in the stove (℃) | Oxygen concentration (ppm) | Density of hydrogen (ppm) |
1 | Coil of strip A | Coil of strip A ' | 50 | 55 | 100 | 200 |
2 | Coil of strip B | Coil of strip B ' | 60 | 65 | 150 | 250 |
。。 | 。。。 | 。。。 | 。。。 | 。。。 | 。。。 | 。。。 |
N | Coil of strip N | Coil of strip N ' | 80 | 85 | 400 | 450 |
Table five:
Tables of data is sheared in outlet
Sequence number | Raw material coil of strip ID | Finished product volume ID | Cut mode | Number of samples | Finished product volume length (m) | Finished product volume weight (kg) |
1 | Coil of strip A | Coil of strip A ' | 0 | 0 | 500 | 1000 |
2 | Coil of strip B | Coil of strip B ' | 1 | 2 | 550 | 1400 |
。。 | 。。。 | 。。。 | 。。。 | 。。。 | 。。。 | 。。。 |
N | Coil of strip N | Coil of strip N ' | 2 | 3 | 600 | 1800 |
Step 3, after finished product volume produces, process computer is according to the corresponding relation of finished product volume key word and stock roll key word, finished product is rolled up key word to be inserted in each technological process zone form and the overall process tables of data, be unit with the finished product volume then, should roll up all process datas and gather, form finished product volume form and transmission.In this specific embodiment, step 3 is specially:
After coil of strip is sheared through outlet, be after finished product volume ID produces, data gathering system according to the corresponding relation of finished product volume ID and raw material coil of strip ID (as from table one as can be known, the corresponding raw material coil of strip of finished product volume A ' is coil of strip A), finished product is rolled up ID to be inserted in each technological process zone form, be unit with the finished product volume then, should roll up all process datas and gather (seeing accompanying drawing 2), arrangement back forms finished product volume form (seeing Table six) and sends to L3 (production control computer system) and other application programs, module.After finished product volume form forms, former process data will be eliminated, and to discharge storage space, improve computer run speed.
Table six:
Finished product volume form
Sequence number | Finished product volume ID | Uncoiler tension force (n) | Uncoiler tension force setting value (n) | Cut mode | Belt steel temperature (℃) | Temperature in the stove (℃) | Number of samples | Oxygen concentration (pp m) | Finished product volume length (m) | Finished product volume weight (kg) |
1 | Coil of strip A ' | 50 | 55 | 0 | 50 | 55 | 0 | 100 | 500 | 1000 |
2 | Coil of strip B ' | 60 | 65 | 1 | 60 | 65 | 2 | 150 | 550 | 1400 |
。。 | 。。。 | 。。。 | 。。。 | 。。。 | 。。。 | 。。。 | 。。。 | 。。。 | 。。。 | 。。。 |
N | Coil of strip N ' | 80 | 85 | 2 | 80 | 85 | 3 | 400 | 600 | 1800 |
Claims (5)
1, a kind of method of data capture that realizes with the object-oriented database exploitation is characterized in that, comprises the steps:
Step 1: the data that process computer is constant with the overall process that receives, set the stock roll key word, be that unit is kept in the overall process tables of data with the stock roll;
Step 2, the data that will change by the cycle sent to process computer by cycle of prior setting, and process computer is that unit is saved in the regional form of dividing by technological process with the stock roll with the data that receive;
Step 3, after finished product volume produces, generate corresponding finished volume key word according to the stock roll key word, process computer is according to the corresponding relation of finished product volume key word and stock roll key word, finished product is rolled up key word to be inserted in each technological process zone form and the overall process tables of data, be unit with the finished product volume then, should roll up all process datas and gather, form finished product volume form and transmission.
2, the method for data capture that realizes with object-oriented database exploitation according to claim 1 is characterized in that, also comprises: step 4, after the finished product volume forms, former process data will be eliminated.
3, the method for data capture that realizes with the object-oriented database exploitation according to claim 1 is characterized in that described stock roll key word is stock roll ID, and described finished product volume key word is finished product volume ID.
4, the method for data capture that realizes with the object-oriented database exploitation according to claim 1 is characterized in that the method for the preservation overall process data described in the step 1 is for to preserve data in proper order by the rise time of data.
5, the method for data capture that realizes with the object-oriented database exploitation according to claim 1 is characterized in that, the cycle transmission data by prior setting described in the step 2 are meant by set time order transmission.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CNB2005100266735A CN100433000C (en) | 2005-06-10 | 2005-06-10 | Date acquiring method realized by using object oriented data base development |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CNB2005100266735A CN100433000C (en) | 2005-06-10 | 2005-06-10 | Date acquiring method realized by using object oriented data base development |
Publications (2)
Publication Number | Publication Date |
---|---|
CN1719441A CN1719441A (en) | 2006-01-11 |
CN100433000C true CN100433000C (en) | 2008-11-12 |
Family
ID=35931275
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CNB2005100266735A Active CN100433000C (en) | 2005-06-10 | 2005-06-10 | Date acquiring method realized by using object oriented data base development |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN100433000C (en) |
Families Citing this family (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103150624B (en) * | 2013-02-06 | 2016-03-30 | 北京化工大学 | Based on the equipment control supervisory system of process chart |
CN104239362A (en) * | 2013-06-24 | 2014-12-24 | 上海梅山钢铁股份有限公司 | High frequency data retrieval and storage method for use in cold rolling process |
CN103744367A (en) * | 2013-12-20 | 2014-04-23 | 武汉钢铁(集团)公司 | Production-line actual-performance information processing method, device and system |
Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1346452A (en) * | 1999-03-31 | 2002-04-24 | 麦特索纸业公司 | Maintenance management system for production plant |
CN1406348A (en) * | 2000-02-29 | 2003-03-26 | 本特利内华达有限公司 | An industrial plant asset management system |
-
2005
- 2005-06-10 CN CNB2005100266735A patent/CN100433000C/en active Active
Patent Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1346452A (en) * | 1999-03-31 | 2002-04-24 | 麦特索纸业公司 | Maintenance management system for production plant |
CN1406348A (en) * | 2000-02-29 | 2003-03-26 | 本特利内华达有限公司 | An industrial plant asset management system |
Also Published As
Publication number | Publication date |
---|---|
CN1719441A (en) | 2006-01-11 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN111077870A (en) | Intelligent OPC data real-time acquisition and monitoring system and method based on stream calculation | |
CN112330490B (en) | Intelligent water affair comprehensive information processing platform | |
WO2004074954A3 (en) | Apparatus and method for open network-based data acquisition using xml | |
CN112614011B (en) | Power distribution network material demand prediction method and device, storage medium and electronic equipment | |
CN101393453A (en) | Energy consumption real time monitoring system for thermal generator set | |
CN105843936A (en) | Service data report form method and system | |
CN100433000C (en) | Date acquiring method realized by using object oriented data base development | |
Schroer et al. | Just-In-Time (JIT), with Kanban, manufacturing system simulation on a microcomputer | |
CN105786996A (en) | Electricity information data quality analyzing system | |
CN102314336A (en) | Data processing method and system | |
CN111625583B (en) | Business data processing method and device, computer equipment and storage medium | |
CN109993506A (en) | Intelligent mine industry Internet of Things operating system platform performance test methods | |
CN115328068A (en) | Digital twinning system applied to industrial production | |
CN106600029A (en) | Macro-economy predictive quantization correction method based on electric power data | |
CN104678937A (en) | Beer fermentation tank wireless monitoring system | |
CN113610296B (en) | Method for predicting peak value of electrical load in region and method for planning investment of power grid | |
CN103069351A (en) | Data retrieval system | |
CN102359879A (en) | Measurement and control system for test network and data acquisition control method | |
CN104834787B (en) | Perception and analysis method for energy consumption of bearing grinding machine production workshop | |
CN103279073A (en) | Control system for steel continuous production line | |
CN103196660A (en) | Multistation computer test system facing multitandem valves | |
CN115952236A (en) | Power failure data analysis processing method and device based on real-time flow calculation | |
CN105046583A (en) | Power grid model partitioning method suitable for distributed real-time data processing | |
CN104415976A (en) | Cross-unit product quality association analysis method for cold rolling production line | |
CN104809584A (en) | Substation routing maintenance method and system |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
C14 | Grant of patent or utility model | ||
GR01 | Patent grant |