CN104914818B - The control method of transacter and the transacter - Google Patents

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 control method of transacter and the transacter

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.