CN106093185A - The conversion of line flaw detection data is derived and sharing query method - Google Patents
The conversion of line flaw detection data is derived and sharing query method Download PDFInfo
- Publication number
- CN106093185A CN106093185A CN201610522823.XA CN201610522823A CN106093185A CN 106093185 A CN106093185 A CN 106093185A CN 201610522823 A CN201610522823 A CN 201610522823A CN 106093185 A CN106093185 A CN 106093185A
- Authority
- CN
- China
- Prior art keywords
- data
- detection
- flaw detection
- product
- line flaw
- 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
- 238000001514 detection method Methods 0.000 title claims abstract description 96
- 238000000034 method Methods 0.000 title claims abstract description 16
- 238000006243 chemical reaction Methods 0.000 title claims abstract description 10
- 230000005540 biological transmission Effects 0.000 claims abstract description 9
- 238000012216 screening Methods 0.000 claims abstract description 8
- 230000000149 penetrating effect Effects 0.000 claims abstract description 7
- 238000012545 processing Methods 0.000 claims description 3
- 230000005611 electricity Effects 0.000 claims description 2
- 230000000472 traumatic effect Effects 0.000 abstract description 10
- 238000003908 quality control method Methods 0.000 abstract description 3
- 239000004020 conductor Substances 0.000 description 5
- 238000007689 inspection Methods 0.000 description 5
- 230000007547 defect Effects 0.000 description 2
- 238000009795 derivation Methods 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 238000004519 manufacturing process Methods 0.000 description 2
- 238000012360 testing method Methods 0.000 description 2
- RYGMFSIKBFXOCR-UHFFFAOYSA-N Copper Chemical compound [Cu] RYGMFSIKBFXOCR-UHFFFAOYSA-N 0.000 description 1
- 238000004458 analytical method Methods 0.000 description 1
- 239000000306 component Substances 0.000 description 1
- 238000007796 conventional method Methods 0.000 description 1
- 229910052802 copper Inorganic materials 0.000 description 1
- 239000010949 copper Substances 0.000 description 1
- 239000008358 core component Substances 0.000 description 1
- 230000002596 correlated effect Effects 0.000 description 1
- 238000013523 data management Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000006698 induction Effects 0.000 description 1
- 230000005389 magnetism Effects 0.000 description 1
- 239000002184 metal Substances 0.000 description 1
- 229910052751 metal Inorganic materials 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 238000009659 non-destructive testing Methods 0.000 description 1
- 238000012797 qualification Methods 0.000 description 1
- 238000012372 quality testing Methods 0.000 description 1
- 238000004088 simulation Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G01—MEASURING; TESTING
- G01N—INVESTIGATING OR ANALYSING MATERIALS BY DETERMINING THEIR CHEMICAL OR PHYSICAL PROPERTIES
- G01N27/00—Investigating or analysing materials by the use of electric, electrochemical, or magnetic means
- G01N27/72—Investigating or analysing materials by the use of electric, electrochemical, or magnetic means by investigating magnetic variables
- G01N27/82—Investigating or analysing materials by the use of electric, electrochemical, or magnetic means by investigating magnetic variables for investigating the presence of flaws
- G01N27/90—Investigating or analysing materials by the use of electric, electrochemical, or magnetic means by investigating magnetic variables for investigating the presence of flaws using eddy currents
-
- G—PHYSICS
- G01—MEASURING; TESTING
- G01N—INVESTIGATING OR ANALYSING MATERIALS BY DETERMINING THEIR CHEMICAL OR PHYSICAL PROPERTIES
- G01N27/00—Investigating or analysing materials by the use of electric, electrochemical, or magnetic means
- G01N27/72—Investigating or analysing materials by the use of electric, electrochemical, or magnetic means by investigating magnetic variables
- G01N27/82—Investigating or analysing materials by the use of electric, electrochemical, or magnetic means by investigating magnetic variables for investigating the presence of flaws
- G01N27/90—Investigating or analysing materials by the use of electric, electrochemical, or magnetic means by investigating magnetic variables for investigating the presence of flaws using eddy currents
- G01N27/9073—Recording measured data
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/903—Querying
Landscapes
- Engineering & Computer Science (AREA)
- Chemical & Material Sciences (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Health & Medical Sciences (AREA)
- Pathology (AREA)
- Analytical Chemistry (AREA)
- Biochemistry (AREA)
- General Health & Medical Sciences (AREA)
- Electrochemistry (AREA)
- Immunology (AREA)
- Life Sciences & Earth Sciences (AREA)
- Chemical Kinetics & Catalysis (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Computational Linguistics (AREA)
- Investigating Or Analyzing Materials By The Use Of Magnetic Means (AREA)
Abstract
The invention discloses a kind of line flaw detection data conversion to derive and sharing query method, on-line checking product is after penetrating detection system and rotated detection system, analogue signal is transferred to detection circuit system and is converted to digital signal by it, by coding in data base's relevant interface, database data is converted to Excel data, share transmission by the network of Excel data, provide the download of Excel data for terminal and carry out inquiry screening.Present invention, avoiding quality control officer carry out in substantial amounts of flaw detection data data query screening collect, it is effectively improved the efficiency identifying that product is good and bad, can the position of positioning product traumatic condition and grade exactly, improve product warehousing efficiency, providing foundation to effectively analyzing the reason causing product quality quality, the sale that preferably carries out for product provides guarantee.
Description
Technical field
The invention belongs to data management field, for the process of DEFECTOTEST fault detection system data, particularly to one
The conversion of line flaw detection data is derived and sharing query method.
Background technology
DEFECTOTEST crack detector is that the traumatic condition to produced copper bar is distributed the equipment analyzed in real time, record and add up.
This equipment mainly uses eddy current inspection (eddy current inspection) working method that product surface is carried out traumatic condition inspection
Survey.Eddy current inspection is the nondestructive testing technique producing eddy current with AC electromagnetic coil in metal component surface sensing.EDDY CURRENT
Close for the conductor coil being connected with alternating current, coil setting up alternating magnetic field, this alternating magnetic field passes through conductor, and electricity occurs therewith
Magnetic induction effect, sets up eddy current in conductor.Eddy current in conductor also can produce the magnetic field of oneself, and the effect of eddy current magnetism changes
The power in former magnetic field, and then cause the change of coil voltage and impedance.When defect occur in conductive surface or near surface, by shadow
Ringing the intensity to eddy current and distribution, the change of eddy current causes again detection coil voltage and the change of impedance, according to this change,
Just can indirectly know the existence of defect in conductor.
Due to the merit that the data volume of flaw detection data is big and DEFECTOTEST software kit does not provide data qualification to inquire about
Can, Tong Gan quality testing department certainly will be caused producing product quality control difficulty.DEFECTOTEST software system cannot be inquired about
The traumatic condition of product in certain period, cannot filter out and hinder greatly, the distribution situation slandered, length cannot be inquired more than certain numerical value
Traumatic condition etc..But these data are for being accurately positioned product traumatic condition, the factor of analyzing influence product quality and production marketing
It is all highly important.
Summary of the invention
It is an object of the invention to provide the conversion of a kind of line flaw detection data and derive the method sharing inquiry, thus solve relevant
Department's convenient quick search garbled data, the problem accurately understanding product quality.Improve qualified products warehouse-in efficiency, be also product
Quality monitoring strong data support is provided.
The present invention realizes above-mentioned purpose by the following technical solutions.The conversion of line flaw detection data is derived and shared issuer
Method, including penetrating detection system, rotated detection system, detection circuit system, line flaw detection instrument and terminal, in detection product flowing
Direction is from top to bottom sequentially installed with and penetrates detection system and rotated detection system, penetrates detection system and rotated detection system will
Analogue signal is transferred to detection circuit system, and detection circuit system is converted into digital signal and is transferred to line flaw detection instrument,
Line flaw detection instrument is provided with data base, is changed data to Excel data by the data-interface in data base, and terminal passes through net
Excel data are shared in network transmission；
On-line checking product, after penetrating detection system and rotated detection system, is transferred to detection circuit system through analogue signal
Unite and be converted to digital signal, processing to line flaw detection instrument through digital data transmission, and process data are stored number
According in storehouse, by coding in data base's relevant interface, converting data to Excel data, line flaw detection instrument passes through net
Network 9 transmits, and provides the sharing download of Excel data for terminal and carries out inquiry screening.
The present invention changed from the data base at its place by flaw detection data collected by line flaw detection instrument export as conventional
Method that Excel electrical form also carries out sharing inquiry, it is to avoid quality control officer turns in the flaw detection data of magnanimity
Page checks the inefficient operation that data query collects, and is effectively improved the efficiency identifying that product is good and bad, it is possible to position product exactly
The position of product traumatic condition and grade, improve product warehousing efficiency, causes the reason of product quality quality to provide effectively analysis and depends on
According to, the advantages such as the sale that preferably carries out for product provides guarantee, has efficiently, convenient, clear.
Accompanying drawing explanation
Fig. 1 is the structure principle chart of the present invention；
Fig. 2 is the operational flowchart of the present invention；
In figure: 1-penetrates detection system, 2-rotated detection system, 3-analogue signal, 4-detection circuit system, 5-numeral
Signal, 6-line flaw detection instrument, 7-data base, 8-Excel data, 9-network, 10-terminal, 11-detects product.
Detailed description of the invention
Below in conjunction with drawings and Examples, the invention will be further described, sees Fig. 1 and Fig. 2, and the conversion of line flaw detection data is led
Go out and sharing query method, including penetrating detection system 1, rotated detection system 2, detection circuit system 4, line flaw detection instrument 6 and
Terminal 9, is from top to bottom sequentially installed with at detection product 11 flow direction and penetrates detection system 1 and rotated detection system 2, penetrate
Analogue signal 3 is transferred to detection circuit system 4 by detection system 1 and rotated detection system 2, and detection circuit system 4 is converted
For digital signal 5 and be transferred to line flaw detection instrument 6, line flaw detection instrument 6 is provided with data base 7, is connect by the data in data base 7
Data conversion to Excel data 8, terminal 10 are shared Excel data 8 by network 9 transmission by mouth；On-line checking product 11 passes through
After penetrating detection system 1 and rotated detection system 2, it is transferred to detection circuit system 4 through analogue signal 3 and is converted to numeral letter
Number, transmit to line flaw detection instrument 6 through digital signal 5 and process, and process data are stored in data base 7, by
Coding in data base 7 relevant interface, converts data to Excel data 8, and line flaw detection instrument 6 is transmitted by network 9, for
Terminal 10 provides the sharing download of Excel data 8 and carries out inquiry screening.
Embodiment: in the present invention, line flaw detection instrument 6 model is DEFECTOTEST DS2000；Penetrate detection system 1 model
For DEFECTOMAT；Rotated detection system 2 model is CIRCOGRAPH；Detection circuit system 4 model is Test
Electronics；Line flaw detection instrument 6 uses DEFECTOTEST software system；Data base 7 uses Sybase SQL Anywhere
Data base.
DEFECTOTEST DS2000 line flaw detection instrument, described DEFECTOTEST DS2000 line flaw detection instrument is provided with
DEFECTOMAT penetrates detection system, CIRCOGRAPH rotated detection system and Test Electronics detection circuit system
System, the core component such as DEFECTOTEST software system composition.The product produced through DEFECTOMAT penetrate detection system and
After CIRCOGRAPH rotated detection system, fault detection system produces detection simulation signal 3, and this analogue signal 3 passes through cable transmission
Digital signal 5 is converted to, finally by the DEFECTOTEST software system of line flaw detection instrument 6 to detection circuit system 4 and by this system
System carries out processing and process data being stored in Sybase SQL Anywhere data base.Afterwards, by Sybase SQL
Coding in Anywhere data base's relevant interface, it would be desirable to data be converted to Excel spread-sheet data and by its
LAN is shared.Terminal 10 user can download Excel data 8 at any time and carry out inquiry screening.
The concrete operation step of the present invention is as follows: line flaw detection system starts, first, DEFECTOTEST detects a flaw
The flaw detection data 101 that instrument detects are ultimately stored on Sybase SQL in DEFECTOTEST software system after transmission
In the result data base of Anywhere data base 102；Open Sybase Central data center and connect Sybase data
Storehouse, finds result data base and opens it；Connect result data base and open ISQL data manipulation platform interface 103,
In this interface, data are changed derivation 104 by coding；Deriving result to be stored in LAN-sharing file, operator can
To download the data of derivation in other LAN computers, and open the looking into of carrying out being correlated with of imposing a condition with Excel electrical form
Ask screening cohersive and integrated data 105 to work；End operation.
The program function wherein write in ISQL can directly derive the flaw detection data of detail and through the number collected
Table according to statistics.Quality inspection personnel can derive the data of certain time period as required.
During operation, first, Shared Folders is set up in a computer at DEFECTOTEST software system so that this article
All data in part folder can be accessed by terminal 10 client in LAN and download.Owing to line flaw detection instrument detects
Flaw detection data, after transmission, are ultimately stored on Sybase SQL Anywhere data base in DEFECTOTEST software system
In result data base, it is therefore necessary to connect Sybase SQL Anywhere data base and open result database instance.It
After, open ISQL data manipulation platform interface, in this interface, coding converts data to dbase iii number as required
According to flowing and deriving.The information derived includes production code member, product length, traumatic condition position, traumatic condition length, traumatic condition grade and remittance
Total information.Export all stores in Shared Folders to download and using.The transcode write will be set up respectively
Code Template is so that other staff can directly replicate use.The file data derived commonly will be used by Excel Table recognition
Family can directly utilize the inquiry screening function of Excel electrical form and collect desired data.
Claims (1)
1. the conversion of line flaw detection data is derived and sharing query method, including penetrating detection system, rotated detection system, detection electricity
Road system, line flaw detection instrument and terminal, it is characterised in that be from top to bottom sequentially installed with at detection product flow direction and penetrate spy
Examining system and rotated detection system, penetrate detection system and rotated detection system and analogue signal be transferred to detection circuit system,
Detection circuit system is converted into digital signal and is transferred to line flaw detection instrument, and line flaw detection instrument is provided with data base, passes through
Data conversion to Excel data, terminal are shared Excel data by network transmission by the data-interface in data base；
On-line checking product, after penetrating detection system and rotated detection system, is transferred to detection circuit system through analogue signal
Unite and be converted to digital signal, processing to line flaw detection instrument through digital data transmission, and process data are stored number
According in storehouse, by coding in data base's relevant interface, converting data to Excel data, line flaw detection instrument passes through net
Network transmits, and provides the sharing download of Excel data for terminal and carries out inquiry screening.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610522823.XA CN106093185A (en) | 2016-07-06 | 2016-07-06 | The conversion of line flaw detection data is derived and sharing query method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610522823.XA CN106093185A (en) | 2016-07-06 | 2016-07-06 | The conversion of line flaw detection data is derived and sharing query method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106093185A true CN106093185A (en) | 2016-11-09 |
Family
ID=57212279
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610522823.XA Pending CN106093185A (en) | 2016-07-06 | 2016-07-06 | The conversion of line flaw detection data is derived and sharing query method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106093185A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107679094A (en) * | 2017-09-08 | 2018-02-09 | 郑州金润高科电子有限公司 | One kind, which is connected, hinders point statistical method |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JPH07209258A (en) * | 1994-01-18 | 1995-08-11 | Tokyo Gas Co Ltd | Noise suppression for remote field eddy current flaw detector |
| CN1588084A (en) * | 2004-09-08 | 2005-03-02 | 华南理工大学 | Supersonic vortex and metal magnetic memory composite detecting system |
| CN102004129A (en) * | 2010-12-13 | 2011-04-06 | 山东哈大电气有限公司 | On-line vortex flaw detecting system |
| CN202886332U (en) * | 2012-07-26 | 2013-04-17 | 北京交通大学 | Multichannel ultrasonic flaw detection system for railway vehicle wheel online flaw detection |
| CN103163224A (en) * | 2011-12-14 | 2013-06-19 | 西安扩力机电科技有限公司 | On-line verification system for non-destructive detector |
| CN104461534A (en) * | 2014-12-05 | 2015-03-25 | 华东交通大学 | Android mobile terminal-based portable intelligent ultrasonic flaw detection system |
| CN204758536U (en) * | 2015-06-23 | 2015-11-11 | 南京博克纳自动化系统有限公司 | Novel eddy current flaw detector |
-
2016
- 2016-07-06 CN CN201610522823.XA patent/CN106093185A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JPH07209258A (en) * | 1994-01-18 | 1995-08-11 | Tokyo Gas Co Ltd | Noise suppression for remote field eddy current flaw detector |
| CN1588084A (en) * | 2004-09-08 | 2005-03-02 | 华南理工大学 | Supersonic vortex and metal magnetic memory composite detecting system |
| CN102004129A (en) * | 2010-12-13 | 2011-04-06 | 山东哈大电气有限公司 | On-line vortex flaw detecting system |
| CN103163224A (en) * | 2011-12-14 | 2013-06-19 | 西安扩力机电科技有限公司 | On-line verification system for non-destructive detector |
| CN202886332U (en) * | 2012-07-26 | 2013-04-17 | 北京交通大学 | Multichannel ultrasonic flaw detection system for railway vehicle wheel online flaw detection |
| CN104461534A (en) * | 2014-12-05 | 2015-03-25 | 华东交通大学 | Android mobile terminal-based portable intelligent ultrasonic flaw detection system |
| CN204758536U (en) * | 2015-06-23 | 2015-11-11 | 南京博克纳自动化系统有限公司 | Novel eddy current flaw detector |
Non-Patent Citations (1)
| Title |
|---|
| 吕世磊: "高速在线涡流探伤系统的设计与实现", 《中国优秀硕士学位论文全文数据库工程科技Ⅰ辑》 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107679094A (en) * | 2017-09-08 | 2018-02-09 | 郑州金润高科电子有限公司 | One kind, which is connected, hinders point statistical method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101907437B (en) | Wavelet difference algorithm-based cable fault localization method | |
| CN102707203A (en) | Discriminating and measuring method for partial discharge modes of transformer | |
| CN108037449A (en) | A kind of high-voltage circuitbreaker automatic checkout system | |
| CN108984755A (en) | A kind of geological geographic information system processing method | |
| CN108548962A (en) | A kind of grounded screen alternating current and direct current and impulse resistance integrated test system and method | |
| CN107884646B (en) | Emergency warning method for transformer substation online monitoring system | |
| CN106093185A (en) | The conversion of line flaw detection data is derived and sharing query method | |
| CN107862472A (en) | Quality data collection system and its collecting method based on terminal profile | |
| Chai et al. | Tampering detection of digital recordings using electric network frequency and phase angle | |
| CN205982172U (en) | On -line flaw detection data conversion derives and sharing inquiry system | |
| CN112881879A (en) | High-voltage cable terminal partial discharge mode identification method, device and equipment | |
| CN205301474U (en) | Examination article leakage current and wireless output data's testing system is got in survey | |
| Du et al. | On-line partial discharge monitoring and diagnostic system for power transformer | |
| CN105158630B (en) | A kind of system for measuring test product leakage current of direct convenience | |
| Zhong et al. | Partial discharge recognition based on pulse waveform using time domain data compression method | |
| CN109655009A (en) | A kind of high-speed rail component rapid detection system | |
| CN105137267B (en) | A kind of experimental rig directly measuring test product leakage current and wireless output data | |
| CN205246814U (en) | Examination article leakage current's device is got in direct convenient survey | |
| CN2731460Y (en) | Theoretical line loss monitor | |
| CN113077063A (en) | Power transformation equipment defect management method and equipment based on voice and image identification | |
| CN110275063A (en) | Current vortex retarder coil resistance test macro and its test method | |
| CN205246748U (en) | High precision measurement's test equipment can carry out examination article leakage current | |
| CN109993373A (en) | Platform area total management system | |
| Huang et al. | A near-field magnet peak values detecting method to locate short circuit points on PCB | |
| Shi et al. | Analysis on the Application of Electronic Diagnosis Technology in the Components of Energy Meters in Intelligent Equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20161109 |