CN104914818B - The control method of transacter and the transacter - Google Patents
The control method of transacter and the transacter Download PDFInfo
- Publication number
- CN104914818B CN104914818B CN201510184564.XA CN201510184564A CN104914818B CN 104914818 B CN104914818 B CN 104914818B CN 201510184564 A CN201510184564 A CN 201510184564A CN 104914818 B CN104914818 B CN 104914818B
- Authority
- CN
- China
- Prior art keywords
- data
- workpiece
- file
- inspection
- transacter
- 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
- 238000000034 method Methods 0.000 title claims abstract description 60
- 238000004519 manufacturing process Methods 0.000 claims abstract description 144
- 238000000605 extraction Methods 0.000 claims description 53
- 239000000284 extract Substances 0.000 claims description 10
- 238000007689 inspection Methods 0.000 description 148
- 238000005259 measurement Methods 0.000 description 76
- 238000012545 processing Methods 0.000 description 34
- 238000004891 communication Methods 0.000 description 23
- 230000008569 process Effects 0.000 description 23
- 238000010586 diagram Methods 0.000 description 15
- 230000002159 abnormal effect Effects 0.000 description 14
- 238000007405 data analysis Methods 0.000 description 13
- 238000006243 chemical reaction Methods 0.000 description 9
- 238000003860 storage Methods 0.000 description 9
- 238000004458 analytical method Methods 0.000 description 8
- 230000008859 change Effects 0.000 description 7
- 238000003780 insertion Methods 0.000 description 6
- 230000037431 insertion Effects 0.000 description 6
- 230000009471 action Effects 0.000 description 5
- 230000010354 integration Effects 0.000 description 5
- 238000013480 data collection Methods 0.000 description 4
- 230000000694 effects Effects 0.000 description 4
- 230000015654 memory Effects 0.000 description 4
- 230000006870 function Effects 0.000 description 3
- 238000003754 machining Methods 0.000 description 3
- 238000011084 recovery Methods 0.000 description 3
- 230000011218 segmentation Effects 0.000 description 3
- 230000005540 biological transmission Effects 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 238000012544 monitoring process Methods 0.000 description 2
- 230000008707 rearrangement Effects 0.000 description 2
- 238000012163 sequencing technique Methods 0.000 description 2
- 101150012579 ADSL gene Proteins 0.000 description 1
- 102100020775 Adenylosuccinate lyase Human genes 0.000 description 1
- 108700040193 Adenylosuccinate lyases Proteins 0.000 description 1
- 230000015572 biosynthetic process Effects 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 239000003245 coal Substances 0.000 description 1
- 238000012790 confirmation Methods 0.000 description 1
- 230000001351 cycling effect Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 230000004069 differentiation Effects 0.000 description 1
- 238000009472 formulation Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000010295 mobile communication Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 239000010908 plant waste Substances 0.000 description 1
- 239000002994 raw material Substances 0.000 description 1
- 230000003362 replicative effect Effects 0.000 description 1
- 238000011160 research Methods 0.000 description 1
- 238000012552 review Methods 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 238000007493 shaping process Methods 0.000 description 1
- 239000000758 substrate Substances 0.000 description 1
- 238000007514 turning Methods 0.000 description 1
- 238000011144 upstream manufacturing Methods 0.000 description 1
- 239000002912 waste gas Substances 0.000 description 1
- 230000003442 weekly effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G05—CONTROLLING; REGULATING
- G05B—CONTROL OR REGULATING SYSTEMS IN GENERAL; FUNCTIONAL ELEMENTS OF SUCH SYSTEMS; MONITORING OR TESTING ARRANGEMENTS FOR SUCH SYSTEMS OR ELEMENTS
- G05B19/00—Programme-control systems
- G05B19/02—Programme-control systems electric
- G05B19/418—Total factory control, i.e. centrally controlling a plurality of machines, e.g. direct or distributed numerical control [DNC], flexible manufacturing systems [FMS], integrated manufacturing systems [IMS] or computer integrated manufacturing [CIM]
- G05B19/41875—Total factory control, i.e. centrally controlling a plurality of machines, e.g. direct or distributed numerical control [DNC], flexible manufacturing systems [FMS], integrated manufacturing systems [IMS] or computer integrated manufacturing [CIM] characterised by quality surveillance of production
-
- G—PHYSICS
- G05—CONTROLLING; REGULATING
- G05B—CONTROL OR REGULATING SYSTEMS IN GENERAL; FUNCTIONAL ELEMENTS OF SUCH SYSTEMS; MONITORING OR TESTING ARRANGEMENTS FOR SUCH SYSTEMS OR ELEMENTS
- G05B19/00—Programme-control systems
- G05B19/02—Programme-control systems electric
- G05B19/418—Total factory control, i.e. centrally controlling a plurality of machines, e.g. direct or distributed numerical control [DNC], flexible manufacturing systems [FMS], integrated manufacturing systems [IMS] or computer integrated manufacturing [CIM]
- G05B19/4183—Total factory control, i.e. centrally controlling a plurality of machines, e.g. direct or distributed numerical control [DNC], flexible manufacturing systems [FMS], integrated manufacturing systems [IMS] or computer integrated manufacturing [CIM] characterised by data acquisition, e.g. workpiece identification
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/02—Total factory control, e.g. smart factories, flexible manufacturing systems [FMS] or integrated manufacturing systems [IMS]
Landscapes
- Engineering & Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Manufacturing & Machinery (AREA)
- Quality & Reliability (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Automation & Control Theory (AREA)
- General Factory Administration (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Debugging And Monitoring (AREA)
- Testing And Monitoring For Control Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention provides transacter and the control method of the transacter.The transacter collects the data of each equipment on manufacturing line, and the data of collection are added into database, and the transacter has:Acquiring unit, the file and filename for including the data are obtained from the equipment;In extracting unit, the filename obtained from the acquiring unit, the additional information relevant with the data is extracted;Additional unit, the additional information that the extracting unit is extracted is added in the data in the file that the acquiring unit is obtained, and the data are added into the database.
Description
The application is:March 18, Application No. in 2011:201180065611.9(PCT/JP2011/
056579) invention of, entitled " control method and control program of transacter and the transacter "
The divisional application of patent application.
Technical field
Data are added the present invention relates to the data for collecting each equipment on manufacturing line, and by the data of collection
The control method and control program of the transacter in storehouse and the transacter.
Background technology
Since the past, people are directed to collecting and analyzing the manufacture device from manufacture scene, measurement apparatus, inspection always
The data of the various equipment such as device are looked into, and control, monitoring, improvement or the quality improving that analysis result is used for the said equipment are lived
It is dynamic to wait (such as patent document 1~6).
For the collection of above-mentioned data, recent equipment is mostly with CSV (Comma Separated Value;With comma
The value of differentiation) form (format) data file (hereinafter referred to as " csv file ") form output data.Here, can examine
Consider and the data from the said equipment are collected in the form of csv file.Because, csv file, which has, makes easy, management appearance
Easily, the advantages of versatility is high.It therefore, it can consider to collect the data from the said equipment in the form of csv file.
Above-mentioned making is easily specifically referred to, for example, it is that can be made into csv file only to distinguish data with comma, it is not necessary to distinguish number
The data types such as word, character string are that can be made into csv file etc..Above-mentioned management is easily specifically referred to, for example, can be to csv file
Carry out replicating the file operations such as deletion, the data in csv file can be modified by text editor.In addition,
Above-mentioned versatility height is specifically referred to, for example, because csv file is text formatting, therefore available for general table software for calculation etc..
In addition, in order to more effectively analyze above-mentioned data, it may be considered that by the data DBization (data base system),
That is, above-mentioned data are collected and are added in DB.Above-mentioned DBization for example has the following advantages that.
(a) search function
By using SQL (Structured Query Language;SQL), can be easily to coming
Retrieved, sorted, counted from above-mentioned DB data.
(b) combination of data
, can be by multiple files by adding above-mentioned DB for the file that different by date or customization is different and splits
Data be integrally used as data.For the long-standing data such as leap date, customization, energy
Enough monitored, identical machine is counted etc. respectively.
(c) the unitary management of data
By that by the data DBization from multiple manufacturing lines, can be carried out by accessing same DB to the data
Monitoring and analysis.In addition, the operation such as data backup that can seek unity of action, therefore be easily managed.
(d) to the remote access of data
With DBMS (the Database Management System for managing above-mentioned DB;Data base management system)
Server is via communication network and PC (Personal Computer;PC) it is connected, the PC is via ODBC (Open
Database Connectivity;Open database inter connection) above-mentioned DBMS is accessed, thereby, it is possible to remotely be supervised to data
Depending on and analyze.
(prior art literature)
Patent document 1:Japanese Patent Application Laid " JP 2001-296911 publications ";October 26 in 2001
Day is open.
Patent document 2:Japanese Patent Application Laid " JP 2002-236511 publications ";On August 23rd, 2002
It is open.
Patent document 3:Japanese Patent Application Laid " JP 2004-164635 publications ";On June 10th, 2004
It is open.
Patent document 4:Japanese Patent Application Laid " JP 2006-323505 publications ";November 30 in 2006
Day is open.
Patent document 5:Japanese Patent Application Laid " JP 2007-052571 publications ";On March 1st, 2007
It is open.
Patent document 6:Japanese Patent Application Laid " Unexamined Patent 09-050949 publications ";On 2 18th, 1997
It is open.
The content of the invention
(the problem to be solved in the present invention)
However, by the csv file DBization from manufacture scene, also there is Railway Project.
Normal measured value is not only included in data from each equipment, sometimes also comprising abnormal measured value and measurement
Error.The data that these abnormal measured values and measurement are slipped up are mostly HI, LO, N/A (No Account;It is invalid) etc. character
String.However, csv file can not distinguish the data types such as digit strings, and therefore, even if to analyze measured value,
Can be because causing error comprising nonnumeric data, so as to cause analysis to be interrupted.
In addition, when carrying out data analysis using above-mentioned DB, the order of data needs the input with workpiece (manufacturing object thing)
Sequence consensus as defined in order etc..Because, if data order is inconsistent, when progress cycle analysis and to each equipment
When the correlation of measurement data is compared, it will be unable to correctly be analyzed.
However, in actual manufacturing line, it sometimes appear that the order of the data feelings inconsistent with defined order
Condition.For example, the processing time in order to coordinate each equipment, handles slower equipment (such as check device) sometimes to multiple workpiece
Carry out parallel processing.Now, it is possible that the processing sequence of the workpiece and ordering in launching of workpiece is inconsistent and survey of workpiece
Measure the order of the data situation inconsistent with the ordering in launching of workpiece.In addition, being short of because producing measurement error, or in processing procedure
As the workpiece of process object, equipment can be caused not export measurement data, thus, it is also possible to the measurement data of workpiece occur
The order situation inconsistent with the ordering in launching of workpiece.
In addition, the data measured on manufacturing line by date, customization, the difference of time etc. and be divided into different
Csv file, but be not necessarily all by the unit to be analyzed (customization, machine, (annual, every month, weekly etc. and purpose specified time limit
During matching)) and split.Therefore, can cause can not to the length across the date during data analyzed and can not
Data carry out the inconvenience such as analyzing during to the length in units of machine.In order to avoid above-mentioned inconvenience is, it is necessary to according to the input of workpiece
Order is combined to data.In addition, being usually contained in filename as the unit to be analyzed (letter required for different levels
Breath) the various information such as customization numbering, machine, voltage.These information are not comprised in above-mentioned file sometimes.Now, if
The data in above-mentioned file are only added into above-mentioned DB, then can lose the information included in above-mentioned filename, thus lead to not by
The above-mentioned unit to be analyzed is analyzed data.
What the present invention was exactly completed in view of the above problems, its object is to can not lose information there is provided a kind of
Under the premise of or order unify the data of each equipment on manufacturing line well, and can accurately carry out data
Transacter of analysis etc..
(solution to problem)
In order to solve the above problems, transacter of the invention collects each equipment on manufacturing line
Data, and the data of collection are added into database, the transacter is characterised by:Have:Acquiring unit, acquisition comes from
The measurement data of the equipment;Additional unit, when including character string in the measurement data that the acquiring unit is obtained, by the word
Symbol string is converted into be handled and being different from the value of measured value as numerical string, and measurement data addition is described
Database.
Here, the value that can be handled and be different from measured value as numerical string is, for example, null value, 0, negative value etc..
In addition, in order to solve the above problems, the control method of transacter of the invention is to be filled for Data Collection
The control method put, the transacter collects the data of each equipment on manufacturing line, and by the number of collection
According to database is added, the control method of the transacter is characterised by:Comprising:Obtaining step, obtains and is set from described
Standby measurement data;Additional step, when including character string in the measurement data obtained through the obtaining step, by the character string
It is converted into be handled and being different from the value of measured value as numerical string, and the measurement data is added into the data
Storehouse.
According to said structure and method, when including character string in the measurement data, the character string is first converted into sky
Value, then the measurement data is added into the database.As a result, in the database, measurement is included in the measurement data
Value or null value, and not comprising character string, therefore, it is possible to easily analyze above-mentioned measurement data.
In order to solve the above problems, transacter of the invention collects each equipment on manufacturing line
Data, and the data of collection are added into database, the transacter is characterised by:Have:Production line information recording part,
Between the rule for the order for recording the workpiece handled in production line information, the production line information comprising the equipment and the equipment
Corresponding relation;Acquiring unit, obtains the data of each workpiece of the equipment;Arrangement units, according to from the production line
The production line information of information recording part, according to the order of regulation, arranges the data for each workpiece that the acquiring unit is obtained;Chase after
Plus unit, the data addition database for each workpiece that the arrangement units are arranged.
In order to solve the above problems, the control method of transacter of the invention is the control for transacter
Method processed, the transacter collects the data of each equipment on manufacturing line, and the data of collection are added
Database, the control method of the transacter is characterised by:Comprising:Obtaining step, obtains each work of the equipment
The data of part;Alignment step, reads production line information from record portion, and according to the production line information of reading, according to regulation
Sequentially, the data for each workpiece that arrangement is obtained through the obtaining step, wherein, the equipment is included in the production line information
Corresponding relation between the rule of the order of the workpiece of equipment processing;Additional step, by what is arranged through the alignment step
The data of each workpiece add the database.
Here, order is, for example, as defined in described:The order of workpiece input manufacturing line, defined time sequencing, rule
Fixed batch order, defined machine order etc..The rule of the order is, for example,:Multiple channels, measurement error, upset and its
Number, measurement moment etc..
According to said structure and method, according to the production line information from production line information recording part, according to the suitable of regulation
Sequence, arranges the data of each workpiece obtained from the equipment, and the data are added into database.Then, in the database
Comprising data according to regulation order arrange, therefore, it is possible to accurately carry out data analysis using the database.
In order to solve the above problems, transacter of the invention collects each equipment on manufacturing line
Data, and the data of collection are added into database, the transacter is characterised by:Have:Acquiring unit, sets from described
It is standby to obtain the file and filename for including the data;Extracting unit, from the acquiring unit obtain filename in, extract with
The relevant additional information of the data;Additional unit, the additional information that the extracting unit is extracted adds the acquiring unit
In the data in the file of acquisition, and the data are added into the database.
In order to solve the above problems, the control method of transacter of the invention is the control for transacter
Method processed, the transacter collects the data of each equipment on manufacturing line, and the data of collection are added
Database, the control method of the transacter is characterised by:Comprising:Obtaining step, obtains from the equipment and includes institute
State the file and filename of data;Extraction step, from the filename obtained through the obtaining step, extraction has with the data
The additional information of pass;Additional step, adds what is obtained through the obtaining step by the additional information extracted through the extraction step
In the data in file, and the data are added into the database.
According to said structure and method, file and filename are obtained in slave unit, and from the filename of acquisition, extract with
The relevant additional information of data in the file.Then, the additional information of extraction is added in the data in the file, and
The data are added into database.Thus, it is also added into database not only comprising the data in the file in the filename
Comprising additional information, therefore, it is possible on the premise of additional information is not lost by the data integration from equipment to database
In.
Each step in the transacter can be performed by computer in the way of control program.Separately
Outside, by the way that the control program is stored in the recording medium of embodied on computer readable, it can be performed on arbitrary computer
The control program.
(The effect of invention)
As described above, when including character string in measurement data, transacter of the invention first turns the character string
Change null value into, then the measurement data is added into database, easily above-mentioned measurement data is analyzed therefore, it is possible to play
Effect.
The transacter of the present invention is according to the production line information from production line information recording part, according to the suitable of regulation
Sequence, the data for each workpiece that arrangement slave unit is obtained, and the data are added into database, utilize the number therefore, it is possible to play
The effect of data analysis is accurately carried out according to storehouse.
File and filename are obtained in the transacter slave unit of the present invention, and from file name, is extracted and institute
The relevant additional information of data in file is stated, then, the additional information of extraction is added in the data in the file, and will
The data add database, arrive the data integration from equipment therefore, it is possible to play on the premise of additional information is not lost
Effect in database.
Brief description of the drawings
Fig. 1 is the schematic configuration block diagram of the transacter in the production system of an embodiment of the present invention.
Fig. 2 is the schematic configuration block diagram of above-mentioned production system.
Fig. 3 is the handling process since record check file untill updating and checking DB in above-mentioned transacter
Figure.
Fig. 4 is to represent record in the extraction condition record portion of above-mentioned transacter with the formation of structured document
The schematic diagram of the example of extraction condition.
Fig. 5 is the schematic diagram of the example for the filename that above-mentioned inspection file is represented with tabular form.
Fig. 6 is the flow chart that the additional information extracting part of above-mentioned transacter carries out the extraction processing of additional information.
Fig. 7 is the schematic diagram for representing the example of corresponding relation between entry name and character string in the form of a table.
Fig. 8 is the schematic diagram for the example for representing operator's table in the form of a table.
Fig. 9 is the block diagram for representing the parallel example for checking 3 workpiece of check device in above-mentioned production system.
Figure 10 is when representing that the workpiece that 3 inspection portions in above-mentioned check device are checked is numbered and checked in the form of a table
The schematic diagram at quarter.
Figure 11 be represent in the form of a table it is arranged after above-mentioned workpiece numbering, check CH and check the moment signal
Figure.
Figure 12 is after above-mentioned check device is checked, to be overturn before and after inspection desk, then by another check device to workpiece
The block diagram of the example checked.
Figure 13 is to represent that the schematic diagram at moment is numbered and checked to the workpiece that above-mentioned another check device is checked in the form of a table.
Figure 14 is remembered with the production line information recording part that above-mentioned transacter is represented in the form of structured document
The schematic diagram of the example of the production line information of record.
Figure 15 is that the data combining of above-mentioned transacter carries out the flow chart that data combine processing.
Figure 16 is the signal of the example for the content for representing the inspection file that above-mentioned transacter is obtained in the form of a table
Figure.
Figure 17 is the property value recorded in the inspection DB record portions for represent respectively in the form of a table above-mentioned transacter
The schematic diagram of the example of the content of table and NG tables.
Figure 18 be in the form of a table represent produce without workpiece when it is arranged after workpiece numbering, check channel and check
The schematic diagram at moment.
Figure 19 is to represent the workpiece numbering after arranged when there is workpiece turning in the form of a table and check showing for moment
It is intended to.
Embodiment
1~Figure 19 of reference picture, is illustrated to an embodiment of the invention.In the present embodiment, the present invention is suitable
For the production system with production line, the production line is used to manufacture and assembling parts.But the present invention is not limited to above-mentioned production
System, goes for the general management of process handled the object that is processed.The work handled the object that is processed
Sequence refers to, for example, the production process of industrial product, ore deposit industrial product, inspection operation, the obsolete objects (example of agricultural product or raw material
Such as, plant wastes, plant chimney stalk, waste gas, rubbish etc.) treatment process, the inspection operation of obsolete objects, equipment check work
Sequence, cycling and reutilization process etc..
Fig. 2 represents the schematic configuration of the production system of present embodiment.In production system 1, transacter 11 is received
Collect the various inspection data from the multiple check devices for being arranged at production scene 10, and be made the database of the inspection data
(hereinafter referred to as " check DB "), and via communication network 13, the inspection DB being made is utilized by PC14.Communication network 13
With PC14 using known technology, thus omit related description.
In the present embodiment, part manufacturing line (the early stage process life of manufacture part is provided with production scene 10
Producing line) 20 and the machining production line (assembly line) 21 that is assembled of the part to manufacture.Set in part manufacturing line 20
There are 2 production lines 2223, identical part 24 is manufactured on each production line 2223.
And on machining production line 21, relative to production line 30, be provided with part and device 31, processing unit (plant) 32 are provided
34 and check device 3335.Part provides device 31 and the part 24 manufactured through part manufacturing line 20 is supplied into production
The assembling of part 24 is worked on the substrate of workpiece 36 by line 30, processing unit (plant) 32 again, then after check device 33 is processed
Check.Then, the position unrelated with part 24 in workpiece 36 after 34 pairs of processing unit (plant) is checked is processed, then is filled by checking
Put 35 be processed after inspection.Then, processing and inspection processing are repeated, until completing product.In the present embodiment, process
Device 3234 is different devices from check device 3335, but it is also possible to be integrated the device of type.
Check device 3335 is checked workpiece 36 with regard to various inspection projects, and makes inspection file, in the inspection
In file, the inspection data for the expression inspection result classified by inspection project are included.Checking file can be with every 1 workpiece 36
Unit is made, and can also be made in units of multiple workpiece 36, can also be made, may be used also in units of the workpiece 36 of regulation number
To be made in units of the stipulated time.
In general, most of check devices 3335 except made in the distinctive form of manufacturer check file in addition to,
Can also be with CSV form outgoing inspection files.Here, in the present embodiment, check device 3335 is to transacter
11 provide the inspection file (csv file) of CSV forms.In addition, check device 3335 is also led to while inspection file is provided
Crossing file system, there is provided the various information relevant with above-mentioned inspection file, such as filename, time record (time stamp).
Check device 3335 provides to transacter 11 and checks file, can pass through wire communication, radio communication or cable modem
Letter is combined to complete with radio communication, can also pass through USB (Universal Serial Bus;USB) storage
The recording mediums such as device are completed.
Fig. 1 represents the schematic configuration of transacter 11.As shown in figure 1, transacter 11 have control unit 40,
Record portion 41 and network I/F (interface) portion 42.
The action of each structure in the Comprehensive Control transacter 11 of control unit 40, for example can be by including CPU
(Central Processing Unit;Central processing unit) and the computer of memory constitute.The action control of each structure
It can be completed by making computer perform control program.For the detailed content of control unit 40, it will be described hereinafter.
Record portion 41 is used for record information, is made up of tape decks such as hard disk, flash memories.For the detailed interior of record portion 41
Hold, will be described hereinafter.
Network I/F portions 42 are the interface between control unit 40 and communication network 13.Specifically, shown in network I/F portions 42 and Fig. 2
Communication network 13 be connected.Network I/F portions 42 are not only by the data conversion from control unit 40 into the shape suitable for communication network 13
Formula, and communication network 13 is sent to, also by the data conversion from communication network 13 into the form handled suitable for control unit 40, and
It is sent to control unit 40.
Below, control unit 40 and record portion 41 are described in detail.As shown in figure 1, control unit 40 has additional information
Extracting part (extracting unit) 50, data changing unit (additional unit) 51, data combining (additional unit, arrangement units) 52, number
According to write section (additional unit) 53 and data offer portion 54.Record portion 41, which has, to be checked file record portion (acquiring unit) 60, carries
Take condition record portion 61, production line information recording part 62 and check DB record portions 63.In addition, each check device 3335 is equal
There is additional information extracting part 50, data changing unit 51 respectively and file record portion 60 is checked.
Check that file record portion 60 is directed to check device 3335 respectively, record has the inspection from check device 3335
File.Check that the record also in catalogue of file record portion 60 has each related to above-mentioned inspection file such as filename, time record
Plant information.As described above, checking the file that file is CSV forms.
Extraction condition record portion 61 checks file record portion 60 for each, is prerecorded with for extracting additional information
Extraction condition, the additional information is the information for needing to be added to the inspection data of certain workpiece 36.Production line information recording part 62
It is prerecorded with production line information, the production line information is the information related to manufacturing line, is again the number of permutations according to institute
The information needed.Check that the record of DB record portions 63 has inspection DB.Check attribute value tables of the DB comprising stored attribute values and storage NG
(No Good;Error) data NG tables etc..These tables be able to can also be merged with individualism.
Additional information extracting part 50 extracts above-mentioned additional letter according to the extraction condition recorded in extraction condition record portion 61
Breath, the additional information refers to the information for being attached to and checking in data, and the inspection data are included in should be from inspection file record portion
In the 60 inspection files read.The additional information of extraction is sent to data changing unit 51 by additional information extracting part 50.
Specifically, additional information extracting part 50 is read and above-mentioned inspection text from the catalogue for checking file record portion 60 first
The related various information of part, such as filename, time are recorded.Then, additional information extracting part 50 is according to extraction condition record portion
The extraction condition recorded in 61, extracts said additional information from the information of reading.For extracting the detailed of said additional information
Content, will be described hereinafter.
In addition, parameter is attached with filename sometimes, such as " [customization numbering] .csv [machine] [voltage] [channel] ".
The parameter is also contained in said additional information.In addition, the setting file of the parameter by preserving each machine, can extract with
The corresponding parameter of machine.
Data changing unit 51 is used to change the data included from the inspection file that file record portion 60 is read is checked.Data
Data after change are sent to data combining 52 by changing unit 51.
Specifically, if the inspection data checked in file for coming self-check file record portion 60 are character string, data become
More portion 51 thinks that the inspection data are NG data, and above-mentioned character string is changed into null value (null).If inspection file is CSV lattice
Formula, then above-mentioned character string be changed to null value character string (length be 0 character string).Data changing unit 51 also makes NG files,
In the NG files, on the inspection data identical arrangement position with above-mentioned inspection file, above-mentioned NG data characters are included
String.
Data changing unit 51 into the inspection data of above-mentioned inspection file, it is additional from additional information extracting part 50 with it is upper
The additional information for checking that file is related is stated, attribute value data is used as.Then, data changing unit 51 by the inspection file after processing,
The NG file corresponding with the inspection file is sent to data combining 52.
Data combining 52 is combined the various data received from multiple data changing units 51 in units of workpiece 36.Number
Data write section 53 is sent to according to the combining data in joint portion 52.
Specifically, data combining 52 is according to the production line information recorded in production line information recording part 62, to each work
The attribute value data (checking data and additional information) of part 36 is arranged and combined, and the attribute value data is included in from multiple
In multiple inspection files that data changing unit 51 is received.Equally, data combining 52 is according to above-mentioned production line information, to each work
The NG data of part 36 are arranged and combined, and the NG data are included in the NG files from multiple data changing units 51.
In addition, data combining 52 is according to the production line information recorded in production line information recording part 62, to from data
The attribute value data and NG data of the workpiece 36 of changing unit 51 are rearranged.Then, data combining 52 will be combined and laid equal stress on
Attribute value data and NG data after new arrangement are sent to data write section 53.Content for rearranging attribute value data,
It will be described hereinafter.
The attribute value data received from data combining 52 and the write-in of NG data are checked DB notes by data write section 53 respectively
Attribute value table and NG tables in the inspection DB in record portion 63.Now, data write section 53 assigns continuous compile to above-mentioned attribute value data
Number, and the attribute value data is added into attribute value table.In addition, data write section 53 is by be corresponding with above-mentioned NG data above-mentioned
The serial number that attribute value table is assigned, is given to the NG data, and the NG data are added into NG tables.
Data offer portion 54 is used to, according to external request, various data are read from the inspection DB for checking DB record portions 63,
And it is supplied to outside.If specifically, Data extracting section 54 is received from PC14 via communication network 13 and network I/F portions 42
Request, then according to the request, from checking in DB record portions 63 in the inspection DB that records, reading attributes Value Data and NG data.
Then, the attribute value data of reading and NG data are supplied to by data offer portion 54 via network I/F portions 42 and communication network 13
The PC14.For the specific example analyzed using attribute value data and NG data, it will be described hereinafter.
According to said structure, additional information extracting part 50 extracts the additional information related to checking file, data changing unit
51 add the additional information inspection data checked in file, and then, the additional information, which is added into, checks DB record portions 63
In the attribute value table for checking DB.Therefore, in the attribute value table not only comprising check file in inspection data, also comprising with inspection
The related additional information of file, thus, it is possible on the premise of additional information is not lost, the number of self-check in future device 3335
According to integration into above-mentioned attribute value table.
Character string is included in data if checking, the character string is converted into null value, data write section by data changing unit 51
53 add the inspection data after conversion in the attribute value table for the inspection DB for checking DB record portions 63.As a result, above-mentioned attribute value table
In include inspection value or null value as above-mentioned inspection data, and not comprising character string, therefore, it is possible to easily to above-mentioned inspection
Data are analyzed.
In addition, by data changing unit 51 and data write section 53, the null value after conversion is added into above-mentioned attribute value table,
And it is corresponding with above-mentioned coal addition position, above-mentioned character string is added into the NG tables for the inspection DB for checking DB record portions 63.Thus, energy
Enough prevent from such as checking error, check the loss of abnormal character string information.By referring to the character string corresponding with above-mentioned null value,
For example, can interpolate that out that above-mentioned null value is which type of checks abnormal or inspection error.
Data combining 52, will be from check device 3335 according to the production line information from production line information recording part 62
The inspection data of each workpiece 36 obtained, are arranged by defined order.Data write section 53 adds the inspection data after arrangement
Enter in above-mentioned attribute value table.Then, the data included in above-mentioned attribute value table are arranged according to the order of regulation, it is thus possible to realized
Data analysis is accurately carried out using above-mentioned attribute value table.
Below, the processing action that 3 pairs of reference picture has the transacter 11 of said structure is illustrated.Fig. 3 is represented
In transacter 11, the handling process since record check file untill updating and checking DB.
As shown in figure 3, when checking that record has new inspection file in file record portion 60 (S10), additional information is extracted
Portion 50 additional information related to above-mentioned new inspection file is extracted according to the extraction condition recorded in extraction condition record portion 61
(S11).Then, if the inspection data included in carrying out above-mentioned new the inspections file in self-check file record portion 60 are character string
(S12), then the character string is changed to null value by data changing unit 51, and is made NG files, make in the NG files with the inspection number
According on identical arrangement position include the character string (S13).
Then, data combining 52 was directed to the inspection file obtained from certain data changing unit 51 and additional information before this, will
The additional information is appended in the inspection data of each workpiece 36 included in the inspection file, and by the inspection data after addition
It is used as attribute value data.And inspection file and additional information for being obtained from other data changing units 51, also repeatedly identical
Operate (S14).
Then, production line information of the data combining 52 in production line information recording part 62, rearranges and combines
The attribute value data of the workpiece 36 included in multiple inspection files, also, according to above-mentioned production line information, rearrange and combine
The NG data (S15) of each workpiece 36 included in NG files from data changing unit 51.
Then, data write section 53 assigns serial number to each attribute value data after combining, and by the attribute value data
In the attribute value table for adding the inspection DB for checking DB record portions 63, also, by for the above-mentioned attribute corresponding with above-mentioned NG data
It is worth the serial number that table is assigned, is given to the NG data, and by the above-mentioned inspection DB of NG data addition NG tables (S16).It
Afterwards, return to step S10, repeats above-mentioned action.
Below, 4~Fig. 8 of reference picture, extracts additional information to additional information extracting part 50 and is described in detail.It is general next
Say, check that data are managed with document form, by the different machines of the product in different customizations (order), manufacturing process, difference
(in shifts) on duty is made inspection file.Now, customization name, in shifts machine name, the additional letter related to manufacturing line such as name
Cease and be included in as a part for filename in filename.
Checked however, these additional informations are not included in data mode sometimes in file.Now, if will only check
The data included in file, which are added, checks DB, then can cause to lose said additional information.Therefore, in the present embodiment, data
Joint portion 52 adds additional information in the inspection data of each workpiece 36, is checked so that the additional information be added in DB.
In addition, during certain customization is performed, another customization is inserted sometimes.Now, certain above-mentioned customization will be interrupted
Perform, then after being ready to perform above-mentioned another customization, perform above-mentioned another customization;And after the execution terminates, then
It is ready to perform after certain above-mentioned customization, recovers the execution of certain above-mentioned customization.
At this moment, will be made respectively it is above-mentioned certain customization interrupt before check file, the inspection file of above-mentioned another customization and on
State the inspection file after certain customization recovers.Therefore, it is necessary to identify that the inspection file before above-mentioned interruption and after above-mentioned recovery is
Certain above-mentioned customization is divided the file performed.Therefore, the son numbering of customization can be included in filename.
If however, only the inspection data of the inspection file before above-mentioned interruption and after above-mentioned recovery are combined, it will be difficult to area
Go-on-go looks into the level of data.Therefore, during using checking that DB is analyzed, even if checking the statistic of data above-mentioned
Interrupt different after preceding and above-mentioned recovery, it is also difficult to determine that its reason performs for the segmentation of customization.Therefore, in this embodiment party
In formula, the son numbering of the customization included in above-mentioned filename is added into the inspection number of each workpiece 36 as said additional information
According to.Thereby, it is possible to easily distinguish the level for checking data.
The information included in the filename for checking file for example has:Customize name (customization numbering), machine name, it is on duty (1 class, 2
Class, 3 classes etc.), operator name, early stage process production line numbering, customization son numbering etc..In above-mentioned filename, above- mentioned information
Partly or entirely it is combined with separator (separator).Check device is different, and the information included in above-mentioned filename is not yet
Together.In addition, each information is often represented with the numbering that can be recognized.
It is that each check device determines additional information for analysis, and set for extracting from above-mentioned various information
The extraction condition of the additional information of decision, and the extraction condition is previously recorded in extraction condition record portion 61.Fig. 4 is represented
State an example of extraction condition.As illustrated, above-mentioned extraction condition is with XML (Extensible Markup Language;Can
Extending mark language) structured document such as file describes.
As shown in figure 4, for check device 3335 above-mentioned extraction condition can be set respectively.In the example in the figures,
For check device 33 (check machine 1), included in extraction condition before the additional information for checking data as that should be added to
Phase process production line 20, but for check device 35 (check machine 2), do not include in extraction condition and be used as said additional information
Early stage process production line 20.
The reasons why below to early stage process production line numbering as said additional information, illustrates.In the life shown in Fig. 2
On the part manufacturing line 20 of production system 1,2 production lines 2223 manufacture same kind of part 24.However, existing respectively
The part 24 manufactured on different production lines 2223 can be because of differences such as mould, extruding, shaping environment, and produces in some characteristics
Difference, and just because of the difference, it is generally substandard products that may cause the part 24 manufactured by one of production line 2223.
Therefore, when the part of manufacture is generally substandard products, it is necessary to judge which in production line 2223 part used be
Individual production line manufacture.As can be seen here, the numbering of the production line 2223 in part manufacturing line 20 is to need to be attached to group
The additional information in inspection data collected by assembling production lines 21.In addition, if the part 24 that part manufacturing line 20 is manufactured
Without, or changing new part 24 into the fabrication process, then the characteristic of part 24 may also produce difference, now preferred to make
Cheng Xin inspection file.
The characteristic of the product manufactured in assembly line 21 also can be with the adjustment result of the operator of assembly line 21
Change.Therefore, the information of operator should also belong to said additional information.
Fig. 5 illustrates the example for the filename for checking file with tabular form.Inspection file shown in Fig. 5 (a) is inspection
The inspection file that device 33 (check machine 1) is made is looked into, the inspection file shown in Fig. 5 (b) is made for check device 35 (check machine 2)
The inspection file gone out.In the example in the figures, according to the order made, multiple inspections of check device 3335 are described respectively
The filename of file.
As shown in figure 5, check device 33 (check machine 1) make inspection file filename in, be arranged in sequence with
Customization numbering, machine name, on duty, operator name, early stage process production line numbering and the customization numbering that separator " _ " is connected
Son numbering.In addition, in the filename for the inspection file that check device 35 (check machine 2) is made, with being related to the above-mentioned of check machine 1
Filename is compared, and eliminates early stage process production line numbering.
In the example of fig. 5, during customization " M1121397 " is performed, due to inserting another customization
" M1121398 ", the inspection file of customization " M1121397 " is divided into 2, addition of sub- numbering in its filename respectively.
In addition, person on duty has changed 1 class into by 2 classes, operator has also been changed into " SUZUKI " by " TANAKA ".
Fig. 6 represents that additional information extracting part 50 carries out the flow of additional information extraction processing (S11).As illustrated, first,
The extraction condition (S20) shown in Fig. 4 is read from extraction condition record portion 61.
Then, according to above-mentioned extraction condition, taken out from the filename for checking the inspection file recorded in file record portion 60
Take additional information (S21).Specifically, the filename of above-mentioned inspection file is contained by " separator " label in above-mentioned extraction condition
Character " _ " segmentation.For example, filename " M1121397_A001_2_TANAKA_S1_1.txt " is divided into character string
“M1121397”、“A001”、“2”、“TANAKA”、“S1”、“1”.Contained extension name (txt) is not with checking number in filename
According to related information, thus it can ignore.
Then, it is according to above-mentioned extraction condition, the additional information of extraction is corresponding with entry name (S22).Specifically, will segmentation
Character string it is corresponding with the entry name that " entry name order " label in above-mentioned extraction condition is included.Fig. 7 (a) is with the shape of table
Formula represents to constitute the entry name of corresponding relation and the example of character string.In the example in the figures, character string " M1121397 " is with determining
System numbering correspondence, character string " A001 " is corresponding with machine name, character string " 2 " and on duty corresponding, character string " TANAKA " and operation
Member's name correspondence, character string " S1 " is corresponding with early stage process production line name, and character string " 1 " is corresponding with the sub- numbering of customization.
Then, according to above-mentioned extraction condition, part or all of additional information is converted into code (S23).Specifically, reference
" operator " label in above-mentioned extraction condition, operator ID (identification) code is converted into by aforesaid operations person's name.Fig. 7 (b)
The example of the above-mentioned entry name after conversion and character string is represented in the form of a table.In the example in the figures, operator name
" TANAKA " is converted into ID codes " 0002 ".
Thereby, it is possible to reduce the information content of additional information, so that reduced inspection DB size.In addition, compared with character string,
Computer is easier to handle code, therefore, it is possible to the rapid retrieval process performed to checking DB.In addition, except operator name with
Outside, other character strings such as early stage process production line name, implementor name, machine name are further preferably converted into cognizance code.
The operation of corresponding relation is constituted alternatively, it is also possible to the information for separately sening as an envoy to relevant with operator and above-mentioned ID codes
Member's table.Fig. 8 represents an example of aforesaid operations person's table in the form of a table., can be according to upper by using aforesaid operations person's table
State the information retrieval relevant with operator and check DB, additionally it is possible to which the ID codes of retrieval result are converted into the letter relevant with operator
Breath output.The information relevant with operator can also be obtained by referring to the employee DB of the company of operator work.
Then, number will be sent to comprising the additional information after conversion and corresponding to the information of the entry name of the additional information
According to changing unit (S24).That is, the information shown in Fig. 7 (b) is sent to data changing unit 51., can be by by sending entry name
The entry name of the additional information adds above-mentioned attribute value table.Thus, PC14 user can be easy by above-mentioned entry name
Grasp the project of additional additional information in ground.Then, terminate the extraction processing of additional information, return to original flow.
Below, 9~Figure 15 of reference picture, the arrangement and rearrangement that data are carried out to data combining 52 is described in detail.It is first
First, the importance of the rearrangement to carrying out data is illustrated.
When using checking that DB carries out data analysis, checking the order of the data in DB needs the ordering in launching with workpiece 36
Unanimously.Because, if the order of above-mentioned data and the ordering in launching of workpiece 36 are inconsistent, carry out cycle analysis or
When being compared to the result of each equipment, cannot correctly it be analyzed.
On the other hand, on actual manufacturing line, in order to which the processing time with each process is engaged, handle slower
The multiple workpiece 36 of equipment (such as check device) parallel processing sometimes.Now, to production line 30 put into workpiece 36 order,
Checks sequence with workpiece 36 is inconsistent sometimes.Accordingly, it would be desirable to the order of the inspection data of workpiece 36 is rearranged, so that its
Match with the ordering in launching of workpiece 36.
For example, setting:The process velocity of processing unit (plant) is 1 second/1, and the inspection speed of check device is 3 seconds/1, then
In order that the processing time of manufacturing procedure is engaged with the processing time of inspection operation, it is necessary to or set 3 in inspection operation
Platform check device, or 3 inspection portions of setting in 1 check device.
Fig. 9 represents that check device 33 checks the example of 3 workpiece 36 parallel.As illustrated, in check device 33, under
Side is flowed to upstream side, is respectively provided with 1CH (channel)~3CH inspection portion 330.In addition, being additionally provided with the He of arm 37 on production line 30
Inspection desk 38.
The workpiece 36 that arm 37 is used to process processing unit (plant) 32 is placed on inspection desk 38.3 workpiece 36 are placed by arm 37
On inspection desk 38.1CH, 2CH and 3CH inspection portion 330 check respectively for right side on inspection desk 38 in 3 workpiece 36, in
Centre and the workpiece 36 in left side.
Figure 10 (a)~(c) represents the inspection of 1CH~3CH in the check device 33 shown in Fig. 9 in the form of a table respectively
Workpiece numbering and check the moment that portion 330 is checked.In the example in the figures, time of each inspection portion 330 needed in inspection
For 3 ± 1 seconds.
Figure 11 represent in the form of a table arrangement after Figure 10 (a)~(c) shown in workpiece 36 numbering, check CH and
Check the moment.Wherein, Figure 11 (a) is by the table checked after moment arrangement.(a) of the figure does not press the number order of workpiece 36
(ordering in launching) is arranged.
On the other hand, the table shown in Figure 11 (b) is arranged in the following manner, i.e. for shown in Figure 10 (a)~(c)
Workpiece numbering and check the moment, it is earliest to select the time one by one respectively according to the order for checking CH, and repeats the operation.The figure
(b) according to workpiece 36 number order arrange.
In addition, workpiece 36 is changed on fixture or rotates the fixture sometimes, and the order of workpiece 36 can change.Figure
12 represent after being checked by check device 33, upset (180 degree rotation) before and after inspection desk 38, and then, check device 35 checks work
The example of part 36.Figure 13 represents that the moment is numbered and checked to the workpiece that the check device 35 shown in Figure 12 is checked in the form of a table.
In example illustrated, time of the check device 35 needed in inspection is 1 ± 0.5 second.The numbering that Figure 13 does not press workpiece 36 is suitable
Sequence is arranged.At this time, it may be necessary to consider above-mentioned upset and rearrange.
Therefore, in the present embodiment, pre-recorded each by production line 30 of production line information recording part 62 is set
The inspection data of the workpiece such as standby arrangement, channel content 36 production line required when being rearranged according to the ordering in launching of workpiece 36
Information.Figure 14 represents an example of above-mentioned production line information.As illustrated, above-mentioned production line information can be with XML file etc.
The form of structured document is described.
Figure 15 represents that data combining 52 carries out the flow that data combine processing.As illustrated, first, from production line information
The production line information (S40) shown in Figure 14 is read in record portion 62, and judges to whether there is channel in the production line information read
Label (S41).
If there is no channel tag, then the data (S42) of workpiece 36 are arranged according to the order for checking the moment.The opposing party
Face, if there is channel tag, then arranges the data (S43) of workpiece 36 according to the content of the channel tag.For example, in such as Figure 14
In shown production line information, the content of the arrangement label of the channel tag of the label of check machine 1 is " 1CH, 2CH, 3CH ".Therefore,
Inspection according to the data (Figure 10 (a)) of 1CH inspection file, the data (Figure 10 (b)) of 2CH inspection file, 3CH is literary
The order of the data (Figure 10 (c)) of part is selected and arranged, and by repeating the operation, can obtain suitable by the input of workpiece
The data (Figure 11 (b)) of sequence arrangement.
Then, judge with the presence or absence of upset label (S44) in above-mentioned production line information, if in the presence of the upset label, root
According to above-mentioned upset label, the data to arrangement are rearranged (S45).Then, terminate data and combine processing, return originally
Flow.For example, in the production line information shown in Figure 14, the workpiece number in the upset label of the label of check machine 2 is 3.Therefore, it is right
In the data (Figure 13) of the inspection file of check machine 2, by by the turn in sequence (reverses) of the data of 3 workpiece, and repeatedly this
One operation, can arrange data according to workpiece ordering in launching.
Below, reference picture 16 and Figure 17, check that data conversion when in DB record portions 63 is said to recording data in
It is bright.Figure 16 represents to check an example of the content of file, the check device of inspection file as shown in Figure 12 in the form of a table
35 make, and are obtained by transacter 11.Figure 17 (a) (b) represents to check DB record portions 63 respectively in the form of a table
The example of the attribute value table of middle record and the content of NG tables.In Figure 16 and Figure 17, the project respectively arranged is respectively work from left to right
Part numbering (work ID), checks sequence, measure the item 1~6, inspection result, measurement moment and channel number.
Attribute value table is used for stored attribute values.As shown in Figure 17 (a), the data being stored in attribute value table are numerical value
Data.Therefore, the attribute value table recorded by using checking in DB record portions 63, PC14 can carry out data analysis.For example, every
The data of above-mentioned attribute value table were read every 1 hour, being capable of research property value by calculating average value, the centrifugal pump of each channel
Passage, or calculate and include the code number of null value, so that yield rate is calculated, thereby, it is possible to investigate the state of check machine.Property value
The number category (integer, natural number, single precision, double precision etc.) of projects checks corresponding in file to shown in Figure 16 in table
The number category of project is identical.
On the other hand, NG tables, which are used to store, checks error and the abnormal character string of inspection.As shown in Figure 17 (b), in NG
In the data of table storage, only work ID is numeric data, and other are string data.
In the present embodiment, check error if checking and being included in file, the character string such as abnormal checked, by the character
String is converted into null value, then is stored in attribute value table.For example, in the inspection file shown in Figure 16, the 3rd row the 3rd row, the 17th row
Character string is included in 6th the~the 17 row the 8th of row row and the 18th row the 4th row.Correspondingly, the attribute value table shown in (a) in Figure 17
In, the character string is converted into null value.
However, when be stored with attribute value table null value when, although can understand due to check error, check it is abnormal etc. certain
Reason causes to measure, but does not know that and cause immeasurable concrete reason, thus, causes to lose important analysis letter
Breath.
Therefore, in the present embodiment, the respective item for not only adding the character string in NG tables has also added workpiece
ID.For example, in NG tables shown in (b) in Figure 17, it is additional:1st row store work ID=3 and the 3rd row store character string
The record of " LO ".In addition, also additional:1st row store the note of work ID=17 and the 6th the~the 8 row storage character string " N/A " of row
Record, and the 1st row store the record of work ID=18 and the 4th row storage character string " HI ".
Thus, by using NG tables, PC14 just can be to checking error, checking abnormal etc. analyze.For example, using upper
State NG tables, by computational rules during in represent check error character string number, can check-up through statistical means error.And pass through table and seat
Mark on a map expression statistical result, the tendency (increase, reduce etc.) thus, it is possible to confirm to check error, so as to confirm the state of equipment.
In the present embodiment, due to being made above-mentioned NG tables, it is thus possible to realize above-mentioned statistics and above-mentioned confirmation.
In addition, reading the value of each measure the item of above-mentioned attribute value table by different customizations, and represented with column diagram,
Thereby, it is possible to determine the abnormal place produced from the shape of the column diagram.In the present embodiment, deposited in above-mentioned attribute value table
The additional informations such as customized information are stored up, therefore, it is possible to be counted in units of said additional information.
Record portion 41 also has permissible range record portion, and the permissible range record portion allows model for storage inspection data
Enclose (upper and lower bound).And then, if checking that the inspection data of the inspection file in file record portion 60 allow model in above-mentioned
Enclose outer, then data changing unit 51 can also will represent that abnormal character string adds NG files.Now, added with above-mentioned inspection data
The position of above-mentioned attribute value table is corresponding, and the abnormal character string of above-mentioned expression is added into NG tables.Thus, by referring to NG tables, just
Can be to checking error and checking abnormal analyze.Even if in addition, checking that data are in outside permissible range, can also be added into
Attribute value table is stated, therefore, it is possible to prevent information from losing.
Below, reference picture 18, data insertion process during to data defect is described in detail.For check device 33
For 35, when there is no workpiece (hereinafter referred to as " during no workpiece "), it is possible to do not make data.Now, according to attribute value table
The periodicity of the attribute value data of statistics has deviation, it is difficult to carry out data analysis.
When in the absence of without workpiece, shown in such as Figure 11 (a), according to the order number of permutations for checking moment (the measurement moment)
According to.On the other hand, workpiece numbering, inspection channel and inspection when Figure 18 represents the generation after arrangement without workpiece in the form of a table
Moment.Now, by shown in Figure 14<Check machine 1><Without workpiece>Information defined in label, you can recognize and do not export number
According to.Therefore, the position in the absence of data in synchronization, 1CH~3CH is to produce the position without workpiece.
Situation shown in Figure 18 is to check the moment " 9:00:09 ", 2CH data are not present, therefore, it will be understood that arriving
Workpiece 8 produces the situation of no workpiece.However, checking how much the moment can produce some errors, at this point it is possible to reference to shown in Figure 14
<Review time><Error>Information set by label, by judge check moment ± error in the range of 1CH~3CH whether
All there are data, to judge whether the situation for producing no data.
Thus, when (not existing entirely) is not present in the data measured in synchronization, it is judged as because causing not make without workpiece
Go out data, between the inspection data of above-mentioned workpiece 36 (being workpiece 412 in Figure 18 example), insertion indicates no workpiece
Data, then the data of each workpiece 36 are arranged by defined order.Thereby, it is possible to prevent the week of attribute value data
Deviation occurs for phase property.
As shown in figure 9, for check device 33 (check machine 1), checking that 3CH inspection portion 330 is to workpiece when starting
3 are checked, and workpiece is not present in 1CH2CH inspection portion 330.Therefore, as shown in figure 18, inspection when starting is being checked
Moment " 9:00:00 ", there are 3CH data, but in the absence of 1CH2CH data.At this point it is possible to check the moment " 9:00:
00 ", insertion indicates the data of no workpiece, is used as 1CH2CH data.
Then, when checking next time, 3CH inspection portion 330 is checked workpiece 6, and 2CH inspection portion 330 is to work
Part 2 is checked, and workpiece is not present in 1CH inspection portion 330.Therefore, as shown in figure 18, next time check when inspection when
Carve " 9:00:03 ", there are 2CH3CH data, but in the absence of 1CH data.At this point it is possible to check the moment " 9:00:
03 ", insertion indicates the data of no workpiece, is used as 1CH data.
Below, reference picture 19, the modification processing to the moment is described in detail.In the mistake for carrying out the production line shown in Figure 12
Cheng Zhong, if the order of workpiece changes, measuring the order at moment and the ordering in launching of workpiece will all be disturbed.Now,
If the ordering in launching according to workpiece rearranges data, the order at measurement moment will be disturbed.Therefore, workpiece order changes
Measured value (measured value of Figure 12 check machine 1) before change and workpiece order change after measured value (Figure 12 check machine 2
Measured value) it will be unable to constitute corresponding relation.Accordingly, it would be desirable to the measurement moment be changed, so that the ordering in launching of workpiece and measurement moment
Order arrange in order.
In fact, when shown in Figure 14<Check machine 2><Upset>When label is " having ", in order that data press the input of workpiece
Order is arranged, as long as with shown in Figure 14<Check machine 2><Upset>Value (3) set by label overturns for unit.
Figure 19 represents that the moment is numbered and checked to the workpiece that the check machine 2 after arrangement is checked in the form of a table.Figure 19 (a) be
Actual data., will be suitable by the input of workpiece such as shown in Figure 19 (b) if the data rearranged in units of 3
Sequence is arranged.Then, in order that checking that the order at moment is consistent with the ordering in launching of workpiece, changed in units of 3 and check the moment.
As a result, as shown in Figure 19 (c), the measurement moment of the data is arranged by the ordering in launching of workpiece.
For check machine 1, if data arranged according to the ordering in launching of workpiece, such as shown in Figure 11 (b).As schemed
Shown in 9, for check machine 1, in 3 workpiece placed on inspection desk 38, one is checked by 3CH inspection portion 330, another
It is individual to be checked by 2CH inspection portion 330, and remaining 1 is checked by 1CH inspection portion 330, then terminates the inspection of check machine 1.
Therefore, as long as making the inspection moment of 3 workpiece placed on inspection desk 38 consistent, particularly preferably and check machine
1 last inspection moment, i.e. the inspection moment of 1CH is consistent.Figure 11 (c) is, for the data shown in Figure 11 (b), to make continuous
1CH~3CH the inspection moment it is consistent with the 1CH inspection moment, and repeat aforesaid operations obtained from.Thus, Figure 11 (c)
Data for measurement the moment by workpiece ordering in launching arrange data.
As described above, data combining 52 is pressed after the order arrangement by the inspection data of each workpiece 36 according to regulation
Rearranged according to the measurement moment of each workpiece 36 by the early order to evening, thus, in attribute value table, the measurement moment can also press
Order is arranged, so as to easily be analyzed according to the measurement moment data.
According to above-mentioned processing, the attribute value table shown in Figure 17 (a) is recorded in inspection DB record portions 63.In the attribute
It is worth in table, data are arranged according to the ordering in launching of workpiece, the data measured store null value for the position of exceptional value, and during measurement
Carve and arranged according to the ordering in launching of workpiece.The data of workpiece numbering 23 are the data without workpiece, during except workpiece numbering, measurement
Beyond quarter and channel number, sundry item saves as null value.Measurement data is modified through the above way, Neng Gougeng
Accurately realize data analysis.
The present invention is not limited to above-mentioned embodiment, and various changes can be carried out in the scope shown in claim.That is,
Embodiment obtained from by combining the technical scheme suitably changed in the scope shown in claim is also contained in
In the technical scope of the present invention.
For example, in the present embodiment, be illustrated to collecting the inspection data from check device 3335, but this
Invention goes for collecting the data of set various equipment on manufacturing line, as collected from measurement apparatus
Measurement data, the setting data of collection from processing unit (plant) 3234 etc..
Finally, each functional block of transacter 11, particularly control unit 40, can be made up of hardware logic,
Can be as described below, using CPU, realized by software.
That is, transacter 11 has:Perform the CPU (central of the order of control program for realizing each function
processing unit:Central processing unit);Store ROM (the read only memory of said procedure:Read-only storage);Exhibition
Open RAM (the random access memory of said procedure:Random access memory);Store said procedure and various data
The storage devices such as memory (recording medium).In addition, providing recording medium to transacter 11, the recording medium can be by counting
Calculate program code (executable program, intermediate code program, the source of the machine-readable control program for taking and recording transacter 11
Program), the control program is the software for realizing function described above, passes through the calculating by the transacter 11
Machine (or CPU, MPU) reads and performed the program code recorded in recording medium, can also realize the purpose of the present invention.
On aforementioned recording medium, the band class such as can be tape, cartridge tape;Can also include floppy disk (registrar
Mark), the disk class of the CD such as disk and CD-ROM, MO, MD, DVD, CD-R such as hard disk;Can also be IC-card (including storage card),
The card class such as light-card;Or the semiconductor memory class such as mask-type ROM, EPROM, EEPROM, flash rom etc..
In addition, transacter 11 also can connection communication network, said procedure code also can be by means of communication network
Network is provided.On above-mentioned communication network, it is not particularly limited, for example, it is possible to use internet (internet), inline
Net (intranet), extranet (extranet), LAN, ISDN, VAN, CATV communication network, VPN (virtual
Private network), phone loop line network, mobile communications network, satellite communication network etc..In addition, on logical to constitute
The transmission medium of communication network, is not particularly limited, for example, it is possible to use IEEE1394, USB, power line, cable TV are returned
The wire communications such as line, telephone wire, ADSL loop lines, can also utilize the infrared rays such as IrDA or remote control, Bluetooth (notes
Volume trade mark), 802.11 radio communications, HDR, mobile telephone network, satellite loop line, received terrestrial digital broadcasting network
Radio communications such as (terrestrial digital net).In addition, realizing said procedure generation even by electric transmission
The computer data signal for being placed in carrier wave of code, can also realize the present invention.
As described above, in order to solve the above problems, transacter of the invention is collected on manufacturing line
The data of each equipment, and the data of collection are added into database, the transacter is characterised by:Have:Obtain single
Member, obtains the measurement data from the equipment;Additional unit, when including character in the measurement data that the acquiring unit is obtained
During string, the character string is converted into being handled and be different from as numerical string the value of measured value, and by the measurement number
According to the addition database.
Here, the value that can be handled and be different from measured value as numerical string is, for example, null value, 0, negative value etc..
In addition, in order to solve the above problems, the control method of transacter of the invention is to be filled for Data Collection
The control method put, the transacter collects the data of each equipment on manufacturing line, and by the number of collection
According to database is added, the control method of the transacter is characterised by:Comprising:Obtaining step, obtains and is set from described
Standby measurement data;Additional step, when including character string in the measurement data obtained through the obtaining step, by the character string
It is converted into be handled and being different from the value of measured value as numerical string, and the measurement data is added into the data
Storehouse.
According to said structure and method, when including character string in the measurement data, the character string is first converted into sky
Value, then the measurement data is added into the database.As a result, in the database, measurement is included in the measurement data
Value or null value, and not comprising character string, therefore, it is possible to easily analyze above-mentioned measurement data.
In the transacter of the present invention, preferably, the additional unit is also adding institute with the value after conversion
State on the corresponding position in position of database, the character string is added in string table.
Now, on position corresponding with the position of the null value addition database after conversion, the character string is added
Enter in string table.Thereby, it is possible to prevent from losing the character string informations such as measurement error, measurement exception.Also, by referring to institute
State the corresponding character string of null value, for example, can interpolate that out the null value why sample measurement is abnormal or measurement error.
In the transacter of the present invention, can also further have permissible range record portion, permissible range note
Record portion records the permissible range of the measurement data;Allow model described in being not included in when the measurement data that the acquiring unit is obtained
When enclosing in the permissible range in record portion, the additional unit and then the position of the database is being added with the measurement data
On corresponding position, the character string for representing abnormal is added in string table.Now, can be to surveying by referring to string table
Amount error and measurement exception are analyzed.Even if also, measurement data is in outside permissible range, can also be added into the data
Storehouse, therefore, it is possible to prevent information from losing.
In order to solve the above problems, transacter of the invention collects each equipment on manufacturing line
Data, and the data of collection are added into database, the transacter is characterised by:Have:Production line information recording part,
Between the rule for the order for recording the workpiece handled in production line information, the production line information comprising the equipment and the equipment
Corresponding relation;Acquiring unit, obtains the data of each workpiece of the equipment;Arrangement units, according to from the production line
The production line information of information recording part, according to the order of regulation, arranges the data for each workpiece that the acquiring unit is obtained;Chase after
Plus unit, the data addition database for each workpiece that the arrangement units are arranged.
In order to solve the above problems, the control method of transacter of the invention is the control for transacter
Method processed, the transacter collects the data of each equipment on manufacturing line, and the data of collection are added
Database, the control method of the transacter is characterised by:Comprising:Obtaining step, obtains each work of the equipment
The data of part;Alignment step, reads production line information from record portion, and according to the production line information of reading, according to regulation
Sequentially, the data for each workpiece that arrangement is obtained through the obtaining step, wherein, the equipment is included in the production line information
Corresponding relation between the rule of the order of the workpiece of equipment processing;Additional step, by what is arranged through the alignment step
The data of each workpiece add the database.
Here, order is, for example, as defined in described:The order of workpiece input manufacturing line, defined time sequencing, rule
Fixed batch order, defined machine order etc..The rule of the order is, for example,:Multiple channels, measurement error, upset and its
Number, measurement moment etc..
According to said structure and method, according to the production line information from production line information recording part, according to the suitable of regulation
Sequence, arranges the data of each workpiece obtained from the equipment, and the data are added into database.Then, in the database
Comprising data according to regulation order arrange, therefore, it is possible to accurately carry out data analysis using the database.
However, some equipment does not generate data when in the absence of objective workpiece.Now, the periodicity of data can be produced partially
Difference, causes to be difficult to data analysis.
Therefore, in the transacter of the present invention, preferably, including the data in the data of each workpiece
The measurement moment;Corresponding relation between during measurement in the production line information also comprising the equipment and the equipment, its
In, it is the time that the equipment measures needs during the measurement;The arrangement units are according to from production line letter
The production line information of record portion is ceased, if the difference at the measurement moment of the data between the adjacent workpiece is more than corresponding with the equipment
Measurement during, then between the data between the workpiece, insertion show the non-existent data of objective workpiece, then according still further to rule
Fixed order arranges the data of each workpiece.
If during the difference at the measurement moment is more than the measurement, it is considered that objective workpiece is not present.Here, passing through
Between data between the workpiece, insertion shows that objective workpiece is non-existent without workpiece data, can prevent the cycle of data
Property produce deviation.
In addition, it is described without the workpiece identification information that identification workpiece is preferably comprised in workpiece data, and when preferentially comprising measurement
Carve, the measurement moment is in the data between one of measurement moment in the data between the adjacent workpieces or the adjacent workpieces
The measurement moment between at the time of.The other values without in workpiece data can be null value.
In the transacter of the present invention, the measurement moment of the data is included in the data of each workpiece;Institute
Arrangement units are stated after the data of each workpiece are arranged according to the order of regulation, each workpiece can also be changed
The moment is measured, the measurement moment of each workpiece is arranged according to the order of regulation.So, the measurement moment also arranges in order
Row, it is thus possible to data analysis is easily carried out according to the measurement moment.Being related to the defined order for measuring the moment is, for example,
Order of workpiece input manufacturing line etc..
In order to solve the above problems, transacter of the invention collects each equipment on manufacturing line
Data, and the data of collection are added into database, the transacter is characterised by:Have:Acquiring unit, sets from described
It is standby to obtain the file and filename for including the data;Extracting unit, from the acquiring unit obtain filename in, extract with
The relevant additional information of the data;Additional unit, the additional information that the extracting unit is extracted adds the acquiring unit
In the data in the file of acquisition, and the data are added into the database.
In order to solve the above problems, the control method of transacter of the invention is the control for transacter
Method processed, the transacter collects the data of each equipment on manufacturing line, and the data of collection are added
Database, the control method of the transacter is characterised by:Comprising:Obtaining step, obtains from the equipment and includes institute
State the file and filename of data;Extraction step, from the filename obtained through the obtaining step, extraction has with the data
The additional information of pass;Additional step, adds what is obtained through the obtaining step by the additional information extracted through the extraction step
In the data in file, and the data are added into the database.
According to said structure and method, file and filename are obtained in slave unit, and from the filename of acquisition, extract with
The relevant additional information of data in the file.Then, the additional information of extraction is added in the data in the file, and
The data are added into database.Thus, it is also added into database not only comprising the data in the file in the filename
Comprising additional information, therefore, it is possible on the premise of additional information is not lost by the data integration from equipment to database
In.
The present invention transacter in, preferably, in the filename include with separator be combined it is many
The individual additional information;The transacter also has:Extraction condition record portion, is recorded for extracting the additional information
Extraction condition;Between information of the extraction condition comprising the separator and the order and entry name of the additional information
Corresponding relation;The extracting unit is taken out according to the extraction condition from the extraction condition record portion from the filename
The additional information is taken, and makes the entry name corresponding with the additional information extracted;The additional unit will also with it is described attached
Plus the entry name of information structure corresponding relation adds the database.Now, the user of the database can easily pass through
The entry name grasps the project of the additional information added.
Each step in the transacter can be performed by computer in the way of control program.Separately
Outside, by the way that the control program is stored in the recording medium of embodied on computer readable, it can be performed on arbitrary computer
The control program.
(the utilization possibility in industry)
Information can not be lost or sequentially integration comes from manufacturing line the transacter of the present invention well
Each equipment data, therefore, be applicable not only to Data Collection and the data analysis of the inspection data from check device, also
The Data Collection from the arbitrary equipment such as measurement apparatus, processing unit (plant) and data analysis can be applied to.
[description of reference numerals]
1 production system
10 production scenes
11 transacters
13 communication networks
14 PC
20 early stage process production line part manufacturing lines
21 machining production line assembly lines
2223 production lines
24 parts
30 production lines
31 parts provide device
3234 processing unit (plant)s
3335 check devices
36 workpiece
37 arms
38 inspection desks
40 control units
41 record portions
42 network I/F portions
50 additional information extracting parts (extracting unit)
51 data changing units (additional unit)
52 data combinings (additional unit, arrangement units)
53 data write sections (additional unit)
54 data offer portions
60 check file record portion (acquiring unit)
61 extraction condition record portions
62 production line information recording parts
63 check DB record portions
330 inspection portions
Claims (3)
1. a kind of transacter, collects the data of each equipment on manufacturing line, and the data of collection are added
Enter database, the transacter is characterised by:
Have:
Acquiring unit, the file and filename for including the data are obtained from the equipment;
In extracting unit, the filename obtained from the acquiring unit, the additional information relevant with the data is extracted;
Additional unit, the number that the additional information that the extracting unit is extracted is added in the file that the acquiring unit is obtained
In, and the addition of the data after the additional information database will be addition of.
2. transacter according to claim 1, it is characterised in that:
The multiple additional informations being combined with separator are included in the filename;
The transacter also has:
Extraction condition record portion, records the extraction condition for extracting the additional information;
Correspondence between information of the extraction condition comprising the separator and the order and entry name of the additional information
Relation;
The extracting unit is extracted described attached according to the extraction condition from the extraction condition record portion from the filename
Plus information, and make the entry name corresponding with the additional information extracted;
The entry name that corresponding relation is constituted with the additional information is also added the database by the additional unit.
3. a kind of control method of transacter, the transacter collects each equipment on manufacturing line
Data, and the data of collection are added into database, the control method of the transacter is characterised by:
Comprising:
Obtaining step, the file and filename for including the data are obtained from the equipment;
Extraction step, from the filename obtained through the obtaining step, extracts the additional information relevant with the data;
Additional step, the institute that the additional information extracted through the extraction step is added in the file obtained through the obtaining step
State in data, and the data after the additional information will be addition of and add the database.
Applications Claiming Priority (3)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
JP2011-018024 | 2011-01-31 | ||
JP2011018024A JP5327239B2 (en) | 2011-01-31 | 2011-01-31 | Data collection device, and control method and control program for the data collection device |
CN201180065611.9A CN103314335B (en) | 2011-01-31 | 2011-03-18 | The control method of transacter and this transacter and control program |
Related Parent Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201180065611.9A Division CN103314335B (en) | 2011-01-31 | 2011-03-18 | The control method of transacter and this transacter and control program |
Publications (2)
Publication Number | Publication Date |
---|---|
CN104914818A CN104914818A (en) | 2015-09-16 |
CN104914818B true CN104914818B (en) | 2017-08-29 |
Family
ID=46602302
Family Applications (3)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201180065611.9A Active CN103314335B (en) | 2011-01-31 | 2011-03-18 | The control method of transacter and this transacter and control program |
CN201510185123.1A Active CN104914820B (en) | 2011-01-31 | 2011-03-18 | The control method of transacter and the transacter |
CN201510184564.XA Active CN104914818B (en) | 2011-01-31 | 2011-03-18 | The control method of transacter and the transacter |
Family Applications Before (2)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201180065611.9A Active CN103314335B (en) | 2011-01-31 | 2011-03-18 | The control method of transacter and this transacter and control program |
CN201510185123.1A Active CN104914820B (en) | 2011-01-31 | 2011-03-18 | The control method of transacter and the transacter |
Country Status (4)
Country | Link |
---|---|
JP (1) | JP5327239B2 (en) |
CN (3) | CN103314335B (en) |
MY (3) | MY189890A (en) |
WO (1) | WO2012105063A1 (en) |
Families Citing this family (9)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JP6270395B2 (en) * | 2013-09-26 | 2018-01-31 | 株式会社日立国際電気 | Substrate processing apparatus, semiconductor device manufacturing method, and program |
CN106663048B (en) * | 2014-06-12 | 2018-06-22 | 三菱电机株式会社 | Diary record system, log recording apparatus, data log record method |
JP6399586B2 (en) * | 2014-10-03 | 2018-10-03 | エヌ・ティ・ティ・インフラネット株式会社 | Inspection data management device and inspection data management method |
JP6407946B2 (en) | 2016-12-12 | 2018-10-17 | ファナック株式会社 | Device information and position information management device and management system |
JP7134453B2 (en) * | 2017-09-05 | 2022-09-12 | 株式会社Kmc | Production monitoring system and production monitoring method |
CN107765885B (en) * | 2017-09-13 | 2021-10-19 | 浙江电力建设监理有限公司 | Input verification method and system for intelligent monitoring management |
KR102009253B1 (en) * | 2018-02-14 | 2019-08-09 | 호전실업 주식회사 | Modularized clothing manufacturing method and system for small quantity batch clothes production |
CN110609820A (en) * | 2018-05-28 | 2019-12-24 | 吴俊逸 | Modeling system based on character mining and modeling method using same |
JP7352494B2 (en) * | 2020-03-05 | 2023-09-28 | 堺ディスプレイプロダクト株式会社 | Production information management system |
Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101086665A (en) * | 2006-06-07 | 2007-12-12 | 欧姆龙株式会社 | Data display apparatus and method of controlling the same, data associating apparatus and method of controlling the same |
CN101609331A (en) * | 2009-07-30 | 2009-12-23 | 西安科技大学 | A kind of data storage and read method that is applicable in the industrial process control |
Family Cites Families (9)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JPH09289396A (en) * | 1996-04-24 | 1997-11-04 | Matsushita Electric Ind Co Ltd | Maintenance method for installation |
JP4275359B2 (en) * | 2002-06-21 | 2009-06-10 | 富士通マイクロエレクトロニクス株式会社 | Data analysis method |
US7953842B2 (en) * | 2003-02-19 | 2011-05-31 | Fisher-Rosemount Systems, Inc. | Open network-based data acquisition, aggregation and optimization for use with process control systems |
US7647301B2 (en) * | 2003-08-08 | 2010-01-12 | Open-Circuit, Ltd. | Information provision apparatus, format separation apparatus, information provision method and program |
JP3705296B1 (en) * | 2004-04-30 | 2005-10-12 | オムロン株式会社 | Quality control apparatus and control method therefor, quality control program, and recording medium recording the program |
JP2005316826A (en) * | 2004-04-30 | 2005-11-10 | Fujitsu Ltd | Traceability management data formation method, traceability management data formation device, and traceability management data formation program |
JP4321443B2 (en) * | 2004-11-16 | 2009-08-26 | オムロン株式会社 | Specific apparatus, processing system, control method for specific apparatus, control program for specific apparatus, recording medium recording control program for specific apparatus |
JP5171211B2 (en) * | 2007-11-01 | 2013-03-27 | 三菱電機株式会社 | Data format converter |
JP2010033391A (en) * | 2008-07-30 | 2010-02-12 | Fujifilm Corp | Production system and method for processing the same |
-
2011
- 2011-01-31 JP JP2011018024A patent/JP5327239B2/en active Active
- 2011-03-18 CN CN201180065611.9A patent/CN103314335B/en active Active
- 2011-03-18 MY MYPI2018001226A patent/MY189890A/en unknown
- 2011-03-18 WO PCT/JP2011/056579 patent/WO2012105063A1/en active Application Filing
- 2011-03-18 CN CN201510185123.1A patent/CN104914820B/en active Active
- 2011-03-18 MY MYPI2018001225A patent/MY193471A/en unknown
- 2011-03-18 MY MYPI2013002584A patent/MY171680A/en unknown
- 2011-03-18 CN CN201510184564.XA patent/CN104914818B/en active Active
Patent Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101086665A (en) * | 2006-06-07 | 2007-12-12 | 欧姆龙株式会社 | Data display apparatus and method of controlling the same, data associating apparatus and method of controlling the same |
CN101609331A (en) * | 2009-07-30 | 2009-12-23 | 西安科技大学 | A kind of data storage and read method that is applicable in the industrial process control |
Also Published As
Publication number | Publication date |
---|---|
JP2012159942A (en) | 2012-08-23 |
CN104914820A (en) | 2015-09-16 |
CN104914820B (en) | 2017-11-10 |
MY189890A (en) | 2022-03-17 |
WO2012105063A1 (en) | 2012-08-09 |
MY171680A (en) | 2019-10-23 |
CN103314335A (en) | 2013-09-18 |
CN103314335B (en) | 2016-04-27 |
MY193471A (en) | 2022-10-14 |
JP5327239B2 (en) | 2013-10-30 |
CN104914818A (en) | 2015-09-16 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN104914818B (en) | The control method of transacter and the transacter | |
US11409764B2 (en) | System for data management in a large scale data repository | |
US11360950B2 (en) | System for analysing data relationships to support data query execution | |
US11461294B2 (en) | System for importing data into a data repository | |
CA2701046C (en) | Analysis of a system for matching data records | |
CN104572895B (en) | MPP databases and Hadoop company-datas interoperability methods, instrument and implementation method | |
US6708185B2 (en) | SQL execution analysis | |
CN113849483A (en) | Real-time database system architecture for intelligent factory | |
CN104204980A (en) | Information-gathering system, information-gathering method, and storage medium | |
CN112163017A (en) | Knowledge mining system and method | |
KR101175475B1 (en) | Workflow processing method and device | |
CN104484375B (en) | Establish the method and system of database automatically in project analysis flow | |
JP5516797B2 (en) | Data collection device, and control method and control program for the data collection device | |
JP5672336B2 (en) | Data collection device, and control method and control program for the data collection device | |
CN118132946A (en) | BI application system based on big data modeling | |
CN116431618A (en) | Data missing prediction and exception correction method and device based on multidimensional associated fields | |
JPH0830676A (en) | Automatic gathering management device for actual development result |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |