JP2012159942A - Data storage device, and control method and control program of data storage device - Google Patents

Abstract

PROBLEM TO BE SOLVED: To integrate data from respective facilities of a manufacturing line without any lack of information.SOLUTION: A data collection device 11 collects inspection data from inspection devices 33 and 35 of the manufacturing line and adds it to a characteristic value table of an inspection DB recording unit 63. The data collection device 11 includes: an inspection file recording unit 60 that acquires an inspection file including the inspection data and its file name from the inspection devices 33 and 35 and records them therein; an additional information extracting unit 50 that extracts additional information related to the inspection data from the file name read from the inspection file recording unit 60; a data changing unit 51 that adds the extracted additional information to the inspection data in the inspection file from the inspection file recording unit 60 and defines it as characteristic value data; and a data writing unit 53 that adds the characteristic value data from the data changing unit 51 to the characteristic value table of the inspection DB recording unit 63.

Description

  The present invention relates to a data collection device that collects data from each facility on a production line and adds the collected data to a database, and a control method and control program for the data collection device.

  Conventionally, it is required to collect and analyze data from various equipment such as manufacturing equipment, measuring equipment, and inspection equipment at the manufacturing site, and use the analysis results for the control, monitoring, improvement, or quality improvement activities of the equipment. (For example, Patent Documents 1 to 6).

  Regarding the collection of the above data, many of the recent facilities can output data in a CSV (Comma Separated Value) format (format) data file (hereinafter abbreviated as “CSV file”). Therefore, it is conceivable to collect data from the above facilities as a CSV file. This is because the CSV file has advantages such as ease of creation, ease of management, and high versatility. Therefore, it is conceivable to collect data from the above facilities as a CSV file.

  Examples of the ease of creation include that a CSV file can be created simply by separating the data with commas, and that a CSV file can be created without distinguishing the type of data such as numbers and character strings. . Examples of the ease of management include that a CSV file can be copied and deleted by file operations, and that data in a CSV file can be modified by a text editor. Moreover, as an example of the high versatility, the CSV file is in a text format, so that it can be used with general spreadsheet software.

  In order to efficiently analyze the data, it is conceivable to convert the data into a DB (database), that is, collect the data and add it to the DB. The following are mentioned as an advantage by the above DB.

(A) Search function By using SQL (Structured Query Language), it is possible to easily search, sort, and count data from the DB.

(B) Combining data By adding a file divided by date, order, etc. to the DB, data in a plurality of files can be used as a series of data. As a result, it is possible to monitor long-term data straddling dates, orders, etc., and to aggregate the same model.

(C) Centralized management of data By making data from a plurality of production lines into a DB, the data can be monitored and analyzed by accessing the same DB. In addition, data backup and the like can be executed in a batch, so management becomes easy.

(D) Remote data access A PC (Personal Computer) connected to a server having a DBMS (Database Management System) for managing the DB via a communication network can access the DBMS via an ODBC (Open Database Connectivity). Access allows remote data monitoring and analysis.

JP 2001-296911 A (released on October 26, 2001) JP 2002-236511 A (released on August 23, 2002) JP 2004-164635 A (released on June 10, 2004) JP 2006-323505 A (published on November 30, 2006) JP 2007-052571 A (published Mar. 1, 2007) JP 09-050949 A (published February 18, 1997)

  However, there are some problems in converting a CSV file from a manufacturing site into a DB.

  The data from each facility may include abnormal measurement values and measurement errors in addition to normal measurement values. These abnormal measurement values and measurement error data are often character strings such as HI, LO, N / A (No Account). However, in the CSV file, there is no distinction depending on the type of data such as numbers and character strings. For this reason, even if an attempt is made to execute analysis of a measured value, an error occurs and analysis cannot be continued because a non-numeric value is included.

  When data analysis is performed using the DB, the data order needs to be matched with a predetermined order such as a work (manufacturing object) order. This is because if the order of the data is shifted, accurate analysis cannot be performed when comparing the periodic analysis or the correlation of measurement data of individual facilities.

  However, in an actual production line, the data order may deviate from a predetermined order. For example, in order to match the processing time of each facility, in a facility (for example, an inspection apparatus) whose processing is slow, a plurality of workpieces may be processed in parallel. At this time, the workpiece processing order may deviate from the workpiece loading order, and the workpiece measurement data sequence may deviate from the workpiece loading sequence. Further, when a measurement error occurs or a workpiece to be processed is interrupted, the equipment does not output measurement data, and thus the order of workpiece measurement data may deviate from the workpiece input sequence.

  The data measured on the production line is divided into CSV files by date, order, time, etc., and the units to be analyzed (by order, by model, every predetermined period (every year, every month) It is not always the case that a period according to the purpose such as every week)). For this reason, inconveniences such as long-term data analysis across dates and long-term data analysis for each model cannot be performed. In order to avoid the inconvenience, it is necessary to combine the data in the order in which the workpieces are input. In addition, as a unit to analyze (information required for each layer), various information such as order number, model, voltage, etc. are often included in the file name, and such information may not be included in the above file. is there. In this case, only by adding the data in the file to the DB, information included in the file name is lost, and data analysis in the unit to be analyzed cannot be performed.

  The present invention has been made in view of the above-described problems, and the object thereof is to enable data analysis with high accuracy by integrating data from each facility of a production line without missing information or in order. It is to provide a data collection device and the like.

  A data collection device according to the present invention is a data collection device that collects data from each facility on a production line and adds the collected data to a database. When a character string is included in the acquisition means to be acquired and the measurement data acquired by the acquisition means, the character string is a value that can be processed as a numeric string, and is converted into a value that can be distinguished from the measurement value. And adding means for adding measurement data to the database.

  Here, examples of values that can be processed as numeric strings and that can be distinguished from measured values include null, 0, and a minus value.

  The data collection device control method according to the present invention is a data collection device control method for collecting data from each facility of a production line and adding the collected data to a database. If the character string is included in the acquisition step for acquiring the measurement data from the equipment and the measurement data acquired in the acquisition step, the character string can be processed as a numerical value string, An additional step of converting the data into a value that can be distinguished from the value and adding the measurement data to the database.

  According to the above configuration and method, when a character string is included in the measurement data, the measurement data is added to the database after the character string is converted to null. As a result, since the measurement data or null is included as the measurement data and the character string is not included in the database, the measurement data can be easily analyzed.

  In the data collection device according to the present invention, it is preferable that the adding means further adds the character string to the character string table in association with the position where the converted value is added to the database.

  In this case, the character string is added to the character string table in association with the position where the converted null is added to the database. Thereby, for example, it is possible to prevent missing character string information such as measurement errors and measurement abnormalities. Further, by referring to the character string corresponding to the null, for example, it is possible to determine what measurement abnormality or measurement error the null is.

  The data collection device according to the present invention further includes an allowable range recording unit that records the allowable range of the measurement data, and the additional unit further includes the measurement data acquired by the acquisition unit from the allowable range recording unit. If the measurement data is not included in the allowable range, a character string indicating abnormality may be added to the character string table in association with the position where the measurement data is added to the database. In this case, it is possible to analyze a measurement error and a measurement abnormality by referring to the character string table. Moreover, since measurement data is added to the database even if it is outside the allowable range, it is possible to prevent information from being lost.

  A data collection device according to the present invention is a data collection device that collects data from each facility on a production line and adds the collected data to a database. Based on the line information from the line information recording unit for storing the line information including the correspondence relationship with the rule of the order of the workpieces processed, the acquisition means for acquiring the data for each workpiece in the facility, and the line information recording unit And arranging means for arranging the data for each work obtained by the obtaining means in a predetermined order, and adding means for adding the data for each work arranged by the arranging means to the database.

  The data collection device control method according to the present invention is a data collection device control method for collecting data from each facility of a production line and adding the collected data to a database. In addition, line information including a correspondence relationship between the acquisition step of acquiring data for each workpiece in the facility, the facility, and the order rule of the workpiece processed by the facility is read from the recording unit, and based on the read line information And arranging the data for each work obtained in the obtaining step in a predetermined order, and adding the data for each work arranged in the arranging step to the database. It is a feature.

  Here, as examples of the predetermined order, there are a work order on the production line, a predetermined time order, a predetermined lot order, a predetermined model order, and the like. Examples of the order rules include a plurality of channels, measurement errors, inversions and the number thereof, measurement time, and the like.

  According to said structure and method, the data for every workpiece | work acquired from the said equipment are arranged in a predetermined order based on the line information from a line information recording part, and are added to the said database. Accordingly, since the data included in the database is arranged in a predetermined order, data analysis using the database can be executed with high accuracy.

  By the way, there is equipment that does not create data when there is no target workpiece. In this case, the periodicity of the data is shifted, and it is difficult to execute the data analysis.

  Therefore, in the data collection device according to the present invention, the data for each work includes the measurement time of the data, and the line information includes the measurement of the equipment and the period required for the measurement. The arrangement means further includes a measurement period in which a difference in measurement time in the data between the adjacent workpieces corresponds to the equipment based on the line information from the line information recording unit. Is larger than the data between the workpieces, it is preferable to insert data indicating that the target workpiece does not exist, and then arrange the data for each workpiece in a predetermined order.

  When the difference in the measurement time is larger than the measurement period, it is considered that the target workpiece did not exist. Therefore, it is possible to prevent the periodicity of data from shifting by inserting data without a work indicating that there is no target work between the data of the works.

  The data without a workpiece preferably includes workpiece identification information for identifying a workpiece, and includes one of the measurement times in the data between adjacent workpieces or a time between the measurement times as the measurement time. It is preferable. Further, the other values in the data without work may be null.

  In the data collection device according to the present invention, the data for each work includes a measurement time of the data, and the arranging unit arranges the data for each work in a predetermined order, and then The measurement times may be changed so that they are arranged in a predetermined order. In this case, the measurement times are also arranged in order, and it is easy to execute data analysis based on the measurement times. An example of the predetermined order related to the measurement time includes a work order on a production line.

  A data collection device according to the present invention is a data collection device that collects data from each facility of a production line and adds the collected data to a database. An acquisition unit that acquires a file name from the facility, an extraction unit that extracts additional information related to the data from the file name acquired by the acquisition unit, and a file that the acquisition unit acquires additional information extracted by the extraction unit And adding means for adding to the database.

  The data collection device control method according to the present invention is a data collection device control method for collecting data from each facility of a production line and adding the collected data to a database. In addition, an acquisition step for acquiring the file and file name including the data from the equipment, an extraction step for extracting additional information regarding the data from the file name acquired in the acquisition step, and an extraction step The additional information is added to the data in the file acquired in the acquisition step and added to the database.

  According to said structure and method, a file and a file name are acquired from an installation, and the additional information regarding the data in the said file is extracted from the acquired file name. Then, the extracted additional information is added to the data in the file and added to the database. Therefore, not only the data in the file but also the additional information included in the file name is added to the database, so that the data from the facility can be integrated into the database without missing the additional information.

  In the data collection device according to the present invention, the file name includes a combination of a plurality of the additional information via a separator, and an extraction condition recording unit for recording an extraction condition for extracting the additional information. The extraction condition further includes information on the separator, a correspondence relationship between the order of the additional information and the item name, and the extraction means is based on the extraction condition from the extraction condition recording unit. The additional information is extracted from the file name, the item name is associated with the extracted additional information, and the adding unit further adds the item name associated with the additional information to the database. It is preferable. In this case, the user of the database can easily grasp the added additional information item from the item name.

  Each step in the data collection device can be executed by a computer by a control program. Furthermore, the control program can be executed on any computer by storing the control program in a computer-readable recording medium.

  As described above, when the measurement data contains a character string, the data collection device according to the present invention converts the character string into null and then adds the measurement data to the database. There is an effect that the analysis can be easily performed.

  Further, the data collection device according to the present invention is arranged so that the data for each work acquired from the equipment is arranged in a predetermined order based on the line information from the line information recording unit and is added to the database. There is an effect that data analysis using can be executed with high accuracy.

  Further, the data collection device according to the present invention acquires a file and a file name from the facility, extracts additional information related to data in the file from the file name, and extracts the extracted additional information as data in the file. Since it is added to the database and added to the database, there is an effect that the data from the facility can be integrated into the database without missing additional information.

It is a block diagram which shows schematic structure of the data collection device in the production system which is one Embodiment of this invention. It is a block diagram which shows schematic structure of the said production system. It is a flowchart which shows the flow of a process after test | inspection file is recorded until test | inspection DB is updated in the said data collection device. It is a figure which shows an example of the extraction conditions recorded on the extraction condition recording part in the said data collection device in a structured document. It is a figure which shows an example of the file name of the said inspection file in a list format. It is a flowchart which shows the flow of the extraction process of the additional information in the additional information extraction part of the said data collection device. It is a figure which shows an example of the correspondence of an item name and a character string with a table format. It is a figure which shows an example of an operator table in a table format. It is a block diagram which shows the example in which three workpiece | work is test | inspected in parallel with the inspection apparatus in the said production system. It is a figure which shows the number and inspection time of the workpiece | work which the three test | inspection part in the said inspection apparatus test | inspected in table format. It is a figure which shows what arranged the number of said work, inspection CH, and inspection time in a tabular form. It is a block diagram which shows the example in which a workpiece | work is test | inspected by another test | inspection apparatus, after reverse | inverting the test stage after the test | inspection by the said test | inspection apparatus. It is a figure which shows the work number and test | inspection time which the said another test | inspection apparatus test | inspected in table format. It is a figure which shows an example of the line information recorded on the line information recording part in the said data collection device with a structured document. It is a flowchart which shows the flow of the data combination process in the data combination part of the said data collection device. It is a figure which shows an example of the content of the test | inspection file which the said data collection device acquires in a table format. It is a figure which shows an example of the content of the characteristic value table and NG table which are each recorded on the test | inspection DB recording part in the said data collection device in a table format. It is a figure which shows what arranged the work number, the test | inspection channel, and test | inspection time at the time of absence of a workpiece | work in tabular form. It is a figure which shows what arranged the work number and inspection time in case of the inversion of a workpiece | work in tabular form.

  An embodiment of the present invention will be described with reference to FIGS. In the present embodiment, the present invention is applied to a production system having a production line for manufacturing and assembling parts. However, the present invention is not limited to the production system described above, and management of a processing process for an object. It can be applied in general. In addition, the treatment process of the object is, for example, an industrial product production process, an industrial product, an agricultural product, or a raw material inspection process, a waste object (for example, factory waste, factory wastewater, waste gas, garbage, etc.) It means a processing process, an inspection process for waste objects, an inspection process for equipment, a recycling process, and the like.

  FIG. 2 shows a schematic configuration of the production system of the present embodiment. In the production system 1, the data collection device 11 collects various inspection data from a plurality of inspection devices provided in the production site 10 and creates a database of the inspection data (hereinafter referred to as “inspection DB”). The created inspection DB can be used by the PC 14 via the communication network 13. In addition, since a well-known thing can be utilized as the communication network 13 and PC14, the description is abbreviate | omitted.

  In the present embodiment, the production site 10 is provided with a part manufacturing line (pre-process line) 20 for manufacturing parts and a processing line (assembly line) 21 for assembling the manufactured parts. The parts production line 20 is provided with two lines 22, 23, and the same parts 24 are produced from the lines 22, 23.

  On the other hand, in the processing line 21, a component supply device 31, processing devices 32 and 34, and inspection devices 33 and 35 are provided for the line 30. The component 24 manufactured in the component manufacturing line 20 is supplied to the line 30 by the component supply device 31, processed to be assembled to the substrate of the workpiece 36 by the processing device 32, and processed by the inspection device 33. Inspection is performed. Next, the inspected work 36 is processed at a place unrelated to the component 24 by the processing device 34, and the inspection after the processing is performed by the inspection device 35. Thereafter, processing and inspection are repeated to complete the product. In the present embodiment, the processing devices 32 and 34 are separate from the inspection devices 33 and 35, but may be integrated.

  The inspection devices 33 and 35 inspect the workpiece 36 for various inspection items, and create inspection files that include inspection data indicating inspection results for each inspection item. The inspection file may be created for each workpiece 36, may be created for each of the plurality of workpieces 36, may be created for every predetermined number, or may be created for every predetermined time. Also good.

  In general, many inspection apparatuses 33 and 35 can generate inspection files in a format unique to the manufacturer, while outputting inspection files in CSV format. Therefore, in the present embodiment, the inspection devices 33 and 35 provide the data collection device 11 with a CSV format inspection file (CSV file). The inspection devices 33 and 35 provide various information about the inspection file such as a file name and a time stamp from the file system together with the inspection file. The provision of the inspection file from the inspection devices 33 and 35 to the data collection device 11 may be performed by wired communication, wireless communication, or a combination thereof, or a recording medium such as a USB (Universal Serial Bus) memory. It may be done.

  FIG. 1 shows a schematic configuration of the data collection device 11. As shown in FIG. 1, the data collection device 11 includes a control unit 40, a recording unit 41, and a network I / F (interface) unit 42.

  The control unit 40 comprehensively controls the operation of various components in the data collection device 11, and is configured by a computer including a CPU (Central Processing Unit) and a memory, for example. And operation control of various composition is performed by making a computer run a control program. Details of the control unit 40 will be described later.

  The recording unit 41 records information and includes a recording device such as a hard disk or a flash memory. Details of the recording unit 41 will be described later.

  The network I / F unit 42 performs an interface between the control unit 40 and the communication network 13. Specifically, the network I / F unit 42 is connected to the communication network 13 illustrated in FIG. 2, converts the data from the control unit 40 into a format suitable for the communication network 13, and transmits the data to the communication network 13. On the other hand, data from the communication network 13 is converted into a format suitable for processing by the control unit 40 and transmitted to the control unit 40.

  Next, details of the control unit 40 and the recording unit 41 will be described. As shown in FIG. 1, the control unit 40 includes an additional information extracting unit (extracting unit) 50, a data changing unit (adding unit) 51, a data combining unit (adding unit, arraying unit) 52, a data writing unit (adding unit). ) 53 and the data providing unit 54. The recording unit 41 includes an inspection file recording unit (acquisition means) 60, an extraction condition recording unit 61, a line information recording unit 62, and an inspection DB recording unit 63. The additional information extracting unit 50, the data changing unit 51, and the inspection file recording unit 60 are provided for each of the inspection devices 33 and 35.

  The inspection file recording unit 60 records the inspection file from the inspection devices 33 and 35 for each of the inspection devices 33 and 35. The inspection file recording unit 60 records various information about the inspection file such as a file name and a time stamp in a directory. As described above, the inspection file is a CSV file.

  The extraction condition recording unit 61 records in advance extraction conditions for extracting additional information, which is information to be added to inspection data of a certain workpiece 36, for each inspection file recording unit 60. The line information recording unit 62 records in advance line information that is information related to the production line and is necessary for rearranging the data. The inspection DB recording unit 63 records the inspection DB. The inspection DB includes a characteristic value table that stores characteristic values, an NG table that stores NG (No Good) data, and the like. Note that these tables may be separate or the same.

  The additional information extraction unit 50 extracts the additional information to the inspection data included in the inspection file to be read from the inspection file recording unit 60 based on the extraction condition recorded in the extraction condition recording unit 61. The additional information extraction unit 50 transmits the extracted additional information to the data change unit 51.

  Specifically, the additional information extraction unit 50 first reads various information related to the inspection file such as a file name and a time stamp from the directory of the inspection file recording unit 60. Next, the additional information is extracted from the read information based on the extraction condition recorded in the extraction condition recording unit 61. Details of the extraction of the additional information will be described later.

  Note that an argument may be added to the file name, for example, “[order number] .csv [model] [voltage] [channel]”. This argument is also included in the additional information. By storing an argument setting file for each model, an argument corresponding to the model can be extracted.

  The data changing unit 51 changes data included in the inspection file read from the inspection file recording unit 60. The data changing unit 51 transmits the changed data to the data combining unit 52.

  Specifically, when the inspection data in the inspection file from the inspection file recording unit 60 is a character string, the data changing unit 51 determines that the inspection data is NG data and changes the character string to null. In the case of the CSV format, the character string is changed to a null character string (character string having a length of 0). Further, the data changing unit 51 creates an NG file that includes the NG data that is the character string at the same array position as the inspection data in the inspection file.

  Further, the data changing unit 51 adds the additional information related to the inspection file from the additional information extracting unit 50 to the inspection data in the inspection file to obtain characteristic value data. Then, the data changing unit 51 transmits the processed inspection file and the NG file corresponding to the inspection file to the data combining unit 52.

  The data combining unit 52 combines various data received from the plurality of data changing units 51 in units of work 36. The data combining unit 52 transmits the combined data to the data writing unit 53.

  Specifically, the data combining unit 52 records the characteristic value data (inspection data and additional information) for each workpiece 36 included in the plurality of inspection files received from the plurality of data changing units 51 in the line information recording unit 62. Are combined by arranging based on the line information. Similarly, the data combining unit 52 combines the NG data for each work 36 included in the NG files from the plurality of data changing units 51 by arranging them based on the line information.

  The data combining unit 52 rearranges the characteristic value data and NG data of the workpiece 36 from the data changing unit 51 based on the line information recorded in the line information recording unit 62. Then, the data combining unit 52 transmits the characteristic value data and the NG data that have been combined and rearranged to the data writing unit 53. The rearrangement of the characteristic value data will be described later.

  The data writing unit 53 writes the characteristic value data and NG data received from the data combining unit 52 to the characteristic value table and the NG table in the inspection DB of the inspection DB recording unit 63, respectively. At this time, the data writing unit 53 assigns a serial number to the characteristic value data and adds it to the characteristic value table. Further, the data writing unit 53 adds the serial number assigned to the characteristic value table corresponding to the NG data to the NG data and adds it to the NG table.

  The data providing unit 54 reads and provides various data from the inspection DB of the inspection DB recording unit 63 in response to a request from the outside. Specifically, when the data providing unit 54 receives a request from the PC 14 via the communication network 13 and the network I / F unit 42, based on the request, the data providing unit 54 reads from the inspection DB recorded in the inspection DB recording unit 63. Read characteristic value data and NG data. Then, the data providing unit 54 provides the read characteristic value data and NG data to the PC 14 via the network I / F unit 42 and the communication network 13. A specific example of analysis using characteristic value data and NG data will be described later.

  According to the above configuration, the additional information regarding the inspection file is extracted by the additional information extraction unit 50, added to the inspection data in the inspection file by the data changing unit 51, and the characteristics of the inspection DB of the inspection DB recording unit 63 Added to the value table. Accordingly, since not only the inspection data in the inspection file but also additional information related to the inspection file is added to the characteristic value table, data from the inspection devices 33 and 35 is deleted from the characteristic value table. Can be integrated without any problems.

  When the inspection data includes a character string, the data changing unit 51 converts the character string into null, and the converted inspection data is stored in the inspection DB recording unit 63 by the data writing unit 53. It is added to the characteristic value table of DB. As a result, since the inspection value or null is included as the inspection data and the character string is not included in the characteristic value table, the inspection data can be easily analyzed.

  Further, the character string is stored in the NG table of the inspection DB of the inspection DB recording unit 63 in association with the position where the converted null is added to the characteristic value table by the data changing unit 51 and the data writing unit 53. Added. Thereby, for example, it is possible to prevent missing character string information such as inspection errors and inspection abnormalities. Further, by referring to the character string corresponding to the null, for example, it is possible to determine what inspection abnormality or inspection error the null has.

  The inspection data for each workpiece 36 acquired from the inspection devices 33 and 35 is arranged in a predetermined order on the basis of the line information from the line information recording unit 62 by the data combining unit 52, and the data writing unit 53. To be added to the characteristic value table. Accordingly, since the data included in the characteristic value table is arranged in a predetermined order, data analysis using the characteristic value table can be executed with high accuracy.

  Next, the processing operation in the data collection apparatus 11 having the above configuration will be described with reference to FIG. FIG. 3 shows the flow of processing in the data collection device 11 from when the inspection file is recorded until the inspection DB is updated.

  As shown in FIG. 3, when a new inspection file is recorded in the inspection file recording unit 60 (S10), the additional information extraction unit 50 records additional information relating to the new inspection file in the extraction condition recording unit 61. Extraction is performed based on the extracted extraction conditions (S11). Next, when the inspection data included in the new inspection file from the inspection file recording unit 60 is a character string (S12), the data changing unit 51 changes the character string to null, An NG file including the character string at the same array position is created (S13).

  Next, the data combining unit 52 first adds the additional information to the inspection data for each work 36 included in the inspection file and adds characteristic information to the inspection file and additional information received from the data changing unit 51. This is repeated for the inspection file and additional information received from the other data changing unit 51 (S14).

  Next, the data combining unit 52 combines the characteristic value data of the workpieces 36 included in the plurality of inspection files after rearrangement based on the line information of the line information recording unit 62, while the data from the data changing unit 51 is combined. The NG data for each work 36 included in the NG file is rearranged based on the line information and combined (S15).

  Then, the data writing unit 53 assigns a serial number to the combined characteristic value data, adds it to the characteristic value table in the inspection DB of the inspection DB recording unit 63, and the characteristic value table corresponding to the NG data. The serial number assigned to is added to the NG data and added to the NG table in the inspection DB (S16). Then, it returns to step S10 and repeats the said operation | movement.

  Next, details of extraction of additional information in the additional information extraction unit 50 will be described with reference to FIGS. In general, inspection data is managed in a file format, and an inspection file is created for each order (order), for each model of a product being manufactured, and for each direct (work number). At this time, additional information related to the production line such as an order name, model name, and work number name is included as a part of the file name.

  However, these additional information may not be included as data in the inspection file. In this case, the additional information is lost only by adding data included in the inspection file to the inspection DB. Therefore, in this embodiment, the data combining unit 52 adds additional information to the inspection data for each workpiece 36 and adds the additional information to the inspection DB.

  Further, another order may be entered during execution of a certain order. In this case, the execution of the certain order is interrupted, the setup change for the other order is performed, the other order is executed, and the setup change for the certain order is returned after the execution is completed. The execution of the certain order may be resumed.

  At this time, the inspection file before the interruption of the certain order, the inspection file of the other order, and the inspection file after the resumption of the certain order are created. For this reason, the inspection file before the interruption and after the resumption needs to be able to identify that the certain order is divided and executed, and therefore, the branch number of the order is included in the file name.

  However, it is difficult to stratify the inspection data only by combining the inspection data of the inspection file before the interruption and after the restart. For this reason, even if the statistics of the inspection data are different between before the interruption and after the restart in the analysis using the inspection DB, it is difficult to specify that the cause is due to the division of the order. Become. Therefore, in the present embodiment, the order branch number included in the file name is added to the inspection data for each work 36 as the additional information. Thereby, stratification of inspection data becomes easy.

  Information included in the file name of the inspection file includes the order name (order number), model name, direct (1st, 2nd, 3rd, etc.), operator name, previous process line number, order branch number, etc. Is mentioned. In the file name, a part or all of the information is combined through a separator. Which information is included in the file name depends on the inspection apparatus. Each information is often expressed by an identifiable number.

  From the various information, additional information used for analysis is determined for each inspection apparatus, and an extraction condition for extracting the determined additional information is set and recorded in the extraction condition recording unit 61 in advance. FIG. 4 shows an example of the extraction conditions. As illustrated, the extraction condition can be described in a structured document such as an XML (Extensible Markup Language) document.

  Moreover, as shown in FIG. 4, the said extraction conditions can be set for every inspection apparatus 33 * 35. In the illustrated example, regarding the inspection apparatus 33 (inspection machine 1), the preprocess line 20 is included in the extraction condition as additional information to be added to the inspection data, but regarding the inspection apparatus 35 (inspection machine 2), As the additional information, the previous process line 20 is not included in the extraction condition.

  The reason why the line number of the previous process can correspond to the additional information will be described. In the parts production line 20 of the production system 1 shown in FIG. 2, the same kind of parts 24 are produced by the two lines 22 and 23. However, the parts 24 manufactured in the different lines 22 and 23 are slightly different in characteristics due to differences in molds, presses, molding environments, and the like. There may be many defective products from the component 24.

  Accordingly, when defective products occur frequently, it is necessary to determine which line 22 or 23 is used for the part, so the number of the line 22 or 23 in the part manufacturing line 20 is assigned to the assembly line 21. This corresponds to additional information to be added to the inspection data collected in this way. In addition, when the part 24 manufactured in the part manufacturing line 20 disappears or is replaced with a new part 24 in the middle, a difference in the characteristics of the part 24 may occur, so a new inspection file is created. It is desirable.

  In addition, the characteristics of products manufactured in the assembly line 21 may change depending on the adjustment result by the operator of the assembly line 21. Therefore, operator information can also be the additional information.

  FIG. 5 shows an example of the file name of the inspection file in a list format. The inspection file shown in (a) of the figure is created by the inspection apparatus 33 (inspection machine 1), and the inspection file shown in (b) of the figure is created by the inspection apparatus 35 (inspection machine 2). Is. In the illustrated example, the file names of a plurality of inspection files are described in the order of creation for each of the inspection devices 33 and 35.

  As shown in FIG. 5, the file name of the inspection file created by the inspection apparatus 33 (inspection machine 1) includes an order number, model name, direct, operator name, line number of the previous process, and branch number of the order number. The separators “_” are arranged in order. On the other hand, in the file name of the inspection file created by the inspection device 35 (inspection machine 2), the line number of the previous process is omitted from the file name related to the inspection machine 1.

  In the example of FIG. 5, since another order “M1121398” is entered in the middle of the order “M1121397”, the inspection file of the order “M1121397” is divided into two, and a branch number is added to each file name. Yes. Also, the duty is changed from 2 to 1 and the operator is changed from “TANAKA” to “SUZUKI”.

  FIG. 6 shows a flow of additional information extraction processing (S11) in the additional information extraction unit 50. As shown in the drawing, first, the extraction condition shown in FIG. 4 is read from the extraction condition recording unit 61 (S20).

  Next, additional information is extracted from the file name of the inspection file recorded in the inspection file recording unit 60 based on the extraction condition (S21). Specifically, the file name of the inspection file is divided for each character “_” included in the “separator” tag in the extraction condition. For example, the file name “M1121397_A001_2_TANAKA_S1_1.txt” is divided into character strings “M1121397”, “A001”, “2”, “TANAKA”, “S1”, and “1”. Note that the extension (txt) included in the file name is ignored because it is not information about the inspection data.

  Next, the extracted additional information is associated with the item name based on the extraction condition (S22). Specifically, the divided character strings are associated with the item names included in the “list of item names” tag in the extraction condition. FIG. 7A shows an example of the associated item names and character strings in a table format. In the example shown in the figure, the character string “M1121397” is the order number, the character string “A001” is the model name, the character string “2” is immediately, the character string “TANAKA” is the operator name, and the character string “S1” is The character string “1” is associated with the branch number of the order in the line name of the previous process.

  Next, part or all of the additional information is converted into a code based on the extraction condition (S23). Specifically, the operator name is converted into an operator ID (identification) code with reference to the “operator” tag in the extraction condition. FIG. 7B shows an example of the item names and character strings after conversion in a table format. In the illustrated example, the operator name “TANAKA” is converted into an ID code “0002”.

  As a result, the amount of additional information can be reduced, so that the size of the inspection DB can be reduced, and the code is easier to process on the computer than the character string, so the search processing from the inspection DB Can be done quickly. In addition to the operator name, it is desirable to convert other character strings such as the line name, equipment name, and model name of the previous process into an identification code.

  Note that an operator table in which information about operators and the ID code are associated with each other may be created separately. FIG. 8 shows an example of the operator table in a table format. By using the operator table, it is possible to search the examination DB based on the information related to the operator, or to convert the ID code of the search result into information related to the operator and output it. Information about the operator may be acquired by referring to the employee DB of the company where the operator works.

  Next, information including the converted additional information and the item name associated with the additional information is transmitted to the data changing unit 51 (S24). That is, the information shown in (b) of FIG. By transmitting the item name, the item name of the additional information can be added to the characteristic value table. Thereby, the user of PC14 can grasp | ascertain easily the item of the added additional information from the said item name. Thereafter, the additional information extraction process is terminated and the process returns to the original routine.

  Next, details of data arrangement and rearrangement in the data combination unit 52 will be described with reference to FIGS. First, the necessity of rearranging data will be described.

  When data analysis is performed using the inspection DB, the order of data in the inspection DB needs to match the order in which the workpieces 36 are input. This is because if the order of the data is deviated from the order in which the workpieces 36 are input, accurate analysis cannot be performed when performing periodic analysis or comparing the results of individual facilities.

  On the other hand, in an actual production line, in order to match the processing time of each process, equipment (for example, an inspection device) that is slow in processing may process a plurality of workpieces 36 in parallel. At this time, there is a case where the order of loading the work 36 into the line 30 and the inspection order of the work 36 are shifted. Therefore, it is necessary to rearrange the order of the inspection data of the workpiece 36 so as to match the order of loading the workpiece 36.

  For example, if the processing speed of the processing apparatus is 1 second / piece and the inspection speed of the inspection apparatus is 3 seconds / 1 piece, in order to match the processing time of the processing process and the processing time of the inspection process, three units are included in the inspection process. It is necessary to provide three inspection units in one inspection apparatus.

  FIG. 9 shows an example in which three workpieces 36 are inspected in parallel by the inspection device 33. As illustrated, the inspection device 33 is provided with inspection units 330 of 1CH (channel) to 3CH from the downstream side to the upstream side. Further, the line 30 is further provided with an arm 37 and an inspection table 38.

  The arm 37 is used to place the workpiece 36 processed by the processing device 32 on the inspection table 38. Three workpieces 36 are placed on the inspection table 38 by the arm 37. The 1CH, 2CH, and 3CH inspection units 330 inspect the right, center, and left workpieces 36 among the three workpieces 36 on the inspection table 38, respectively.

  FIGS. 10A to 10C show the work numbers and inspection times inspected by the inspection units 330 of 1CH to 3CH in the inspection apparatus 33 shown in FIG. In the illustrated example, the time taken for each inspection unit 330 to perform the inspection is 3 ± 1 seconds.

  FIG. 11 shows, in tabular form, an arrangement of the workpiece 36 numbers, inspection CH, and inspection time shown in FIGS. 10 (a) to 10 (c). Among these, (a) of FIG. 11 is arranged in order of inspection time. In the case of (a) in the figure, the workpieces 36 are not arranged in the order of numbers (the order of input).

  On the other hand, (b) of FIG. 11 selects work numbers and inspection times shown in FIGS. 10 (a) to 10 (c) one by one from the earliest time in the order of inspection CH, and repeats this arrangement. ing. In the case of (b) in the figure, the workpieces 36 are arranged in the order of numbers.

  Moreover, the order of the workpieces 36 may change due to the workpiece 36 being placed on a jig or the jig rotating. FIG. 12 shows an example in which after the inspection by the inspection device 33, the inspection table 38 is reversed in the front and back (rotated 180 degrees) and then the workpiece 36 is inspected by the inspection device 35. FIG. 13 shows the work numbers and inspection times inspected by the inspection apparatus 35 shown in FIG. 12 in a table format. In the illustrated example, the time required for the inspection by the inspection device 35 is 1 ± 0.5 seconds. In the case of FIG. 13, the workpieces 36 are not arranged in the order of numbers. In this case, rearrangement in consideration of the inversion is necessary.

  Therefore, in the present embodiment, line information necessary for rearranging the inspection data of the work 36, such as the arrangement of each facility on the line 30 and the channel contents, in the order of loading of the work 36 is recorded in the line information recording unit 62 in advance. ing. FIG. 14 shows an example of the line information. As shown in the figure, the line information can be described by a structured document such as an XML document.

  FIG. 15 shows the flow of data combining processing in the data combining unit 52. As shown in the figure, first, the line information shown in FIG. 14 is read from the line information recording unit 62 (S40), and it is determined whether or not a channel tag exists in the read line information (S41).

  If there is no channel tag, the data of the work 36 is arranged in the order of the inspection time (S42). On the other hand, if a channel tag exists, the data of the work 36 is arranged based on the contents of the channel tag (S43). For example, in the line information shown in FIG. 14, the contents of the alignment tag in the channel tag of the inspection machine 1 tag are “1CH, 2CH, 3CH”. Therefore, 1CH inspection file data (FIG. 10 (a)), 2CH inspection file data (FIG. 10 (b)), and 3CH inspection file data (FIG. 10 (c)) are sequentially selected. Then, by repeating this, it is possible to arrange the data in the order of workpiece loading ((b) in FIG. 11).

  Next, it is determined whether or not an inversion tag exists in the line information (S44). If the inversion tag exists, the arranged data is rearranged based on the inversion tag (S45). Thereafter, the data combining process is terminated, and the process returns to the original routine. For example, in the line information shown in FIG. 14, the number of works in the inversion tag of the inspection machine 2 tag is 3. Therefore, the data of the inspection file of the inspection machine 2 (FIG. 13) can be arranged in the data of the workpiece input order by inverting (reversing) the order of the data of the three workpieces and repeating this.

  Next, data conversion when recording in the inspection DB recording unit 63 will be described with reference to FIGS. 16 and 17. FIG. 16 shows an example of the contents of the inspection file created by the inspection device 35 shown in FIG. 12 and acquired by the data collection device 11 in a table format. FIGS. 17A and 17B show the inspection DB. An example of the contents of the characteristic value table and the NG table recorded in the recording unit 63 is shown in a table format. In FIG. 16 and FIG. 17, items in each column are a work number (work ID), an inspection order, measurement items 1 to 6, an inspection result, a measurement time, and a channel number in order from the left.

  The characteristic value table stores characteristic values. As shown in FIG. 17A, all data stored in the characteristic value table is numerical data. Accordingly, data analysis can be performed by the PC 14 by using the characteristic value table recorded in the inspection DB recording unit 63. For example, by reading the data of the characteristic value table every hour and calculating the average value and variance value for each channel, the transition of the characteristic value is examined, or the record including null is counted to calculate the yield. By doing so, the state of the inspection machine can be checked. Note that the types of numerical values (integer, natural number, single precision, double precision, etc.) in each item in the specific value table are the same as the numerical values of the corresponding items in the inspection file shown in FIG.

  On the other hand, the NG table stores character strings of inspection errors and inspection abnormalities. As shown in FIG. 17B, the data stored in the NG table is only numeric data for the work ID, and the other is character string data.

  In this embodiment, when a character string such as an inspection error or an inspection abnormality is included in the inspection file, the character string is converted to null and stored in the characteristic value table. For example, in the inspection file shown in FIG. 16, character strings are included in the third row and third column, the 17th row and the sixth column to the 17th row and the eighth column, and the 18th row and the fourth column. On the other hand, in the characteristic value table shown in FIG. 17A, the character string is converted to null.

  However, when null is stored in the characteristic value table, it is possible to grasp that the measurement could not be performed due to some cause such as an inspection error or inspection abnormality, but the cause cannot be grasped, and as a result, an important analysis is performed. Information will be lost.

  Therefore, in this embodiment, the character string is added to the corresponding item in the NG table, and a work ID is added. For example, in the NG table shown in FIG. 17B, a record in which the work ID = 3 is stored in the first column and the character string “LO” is stored in the third column is added. Further, a record is added in which the work ID = 17 is stored in the first column and the character string “N / A” is stored in the sixth to eighth columns, and the work ID = 18 is stored in the first column. A record storing the character string “HI” is added.

  Therefore, by using the NG table, the PC 14 can perform an analysis regarding inspection mistakes, inspection abnormalities, and the like. For example, inspection errors can be tabulated by counting character strings indicating inspection errors in a predetermined period using the NG table. By displaying the tabulated results in a table and a graph, it is possible to check the tendency of inspection mistakes (increase, decrease, etc.) and check the state of the equipment. In the present embodiment, since the NG table is created, the aggregation and the confirmation can be performed.

  For each order, the value of each measurement item in the characteristic value table is read and a histogram is displayed, so that an abnormal part can be identified from the shape of the histogram. In the present embodiment, additional information such as order information is stored in the characteristic value table, so that it is possible to aggregate in units of the additional information.

  The recording unit 41 further includes an allowable range recording unit that stores the allowable range (upper limit and lower limit) of the inspection data, and the data changing unit 51 further includes the inspection data in the inspection file from the inspection file recording unit 60 described above. If it is outside the allowable range, a character string indicating abnormality may be added to the NG file. In this case, the character string indicating the abnormality is added to the NG table in association with the position where the inspection data is added to the characteristic value table. Therefore, by referring to the NG table, it is possible to analyze inspection errors and inspection abnormalities. In addition, since the inspection data is added to the characteristic value table even if it is outside the allowable range, it is possible to prevent the loss of information.

  Next, details of data insertion when data is lost will be described with reference to FIG. Some inspection apparatuses 33 and 35 do not create data when there is no work (hereinafter, this case is referred to as “no work”). In this case, the periodicity of the characteristic value data tabulated in the characteristic value table is shifted, making it difficult to perform data analysis.

  When there is no workpiece, the data is arranged in the order of the inspection time (measurement time) as shown in FIG. On the other hand, FIG. 18 shows, in tabular form, an arrangement of work numbers, inspection channels, and inspection times when no work occurs. In this case, it can be seen that no data is output from the information defined by the <inspection machine 1> <no work> tag in FIG. Therefore, a place where data of 1CH to 3CH are not prepared at the same time is a place where no work is generated.

  In the case of FIG. 18, since the data of 2CH at the inspection time “9:00:09” is missing, it can be understood that there is no work in the work 8. If a slight error occurs in the inspection time, data of 1CH to 3CH is prepared within the inspection time ± error in consideration of the information set in the <inspection time> <error> tag in FIG. Whether or not no data has occurred may be determined based on whether or not the data is present.

  As described above, when the data measured at the same time does not exist (are not prepared), it is determined that the data is not created because there is no work, and the works 36 are mutually connected (in the example of FIG. 18, works 4 and 12). The data indicating the absence of a workpiece may be inserted between the inspection data, and the data for each workpiece 36 may be arranged in a predetermined order. Thereby, it is possible to prevent the periodicity of the characteristic value data from deviating.

  As shown in FIG. 9, the inspection apparatus 33 (inspection machine 1) inspects the work 3 by the 3CH inspection unit 330 at the start of the inspection, but there is no work in the 1CH · 2CH inspection unit 330. Therefore, as shown in FIG. 18, 3CH data exists but 1CH and 2CH data do not exist at the inspection time “9:00:00”, which is the start time of the inspection. Also in this case, data indicating no work may be inserted as the data of 1CH and 2CH at the inspection time “9:00:00”.

  At the next inspection, the 3CH inspection unit 330 inspects the workpiece 6, and the 2CH inspection unit 330 inspects the workpiece 2, but the 1CH inspection unit 330 has no workpiece. For this reason, as shown in FIG. 18, the 2CH and 3CH data exist at the inspection time “9:00:03”, which is the next inspection time, but the 1CH data does not exist. Also in this case, data indicating no work may be inserted as 1CH data at the inspection time “9:00:03”.

  Next, details of the time correction processing will be described with reference to FIG. As shown in FIG. 12, when the order of the workpieces changes in the middle of the line, the order of the measurement times and the order of loading the workpieces vary. In this case, if the data is rearranged in the work input order, the order of the measurement times becomes different. For this reason, the correspondence between the measurement value before the workpiece order changes (measurement value of the inspection machine 1 in FIG. 12) and the measurement value after the workpiece order changes (measurement value of the inspection machine 2 in FIG. 12) I can't take it. Therefore, it is necessary to correct the measurement time so that the workpiece loading sequence and the measurement time sequence are aligned.

  Actually, in the case of “Yes” in the <inspection machine 2> <reverse> tag in FIG. 14, in order to arrange the data in the workpiece loading sequence, <inspection machine 2> <reverse> <in FIG. It can be seen that the data should be inverted by the value (3) set in the number of workpieces> tag.

  FIG. 19 shows a table in which work numbers and inspection times to be inspected by the inspection machine 2 are arranged. (A) of the figure is actual data. When this data is rearranged three by three, the workpiece loading order is obtained as shown in FIG. Next, the inspection time is changed by three so that the order of the inspection times becomes the order of loading workpieces. As a result, as shown in (c) of the figure, the measurement time is arranged in the order of loading of the workpiece.

  In the case of the inspection machine 1, when the data is arranged in the workpiece loading sequence, the result is as shown in FIG. In the case of the inspection machine 1, as shown in FIG. 9, any one of the three works placed on the inspection table 38 is inspected by the 3CH inspection unit 330 and the other one is in the 2CH inspection unit 330. The remaining one is inspected by the 1CH inspection unit 330, and the inspection by the inspection machine 1 is completed.

  Therefore, it is only necessary to align the inspection time for each of the three workpieces placed on the inspection table 38. In particular, it is desirable to align the inspection time of 1CH which is the last inspection time in the inspection machine 1. FIG. 11C shows the data shown in FIG. 11B in which the inspection times of consecutive 1CH to 3CH are aligned with the inspection time of 1CH, and this is repeated. Thereby, the data of (c) of the figure becomes data in which the measurement times are arranged in the order of loading of the workpiece.

  As described above, after arranging the inspection data for each work 36 in a predetermined order, the data combining unit 52 rearranges the measurement times for each work 36 in order, thereby arranging the measurement times in order in the characteristic value table. This makes it easy to perform data analysis based on the measurement time.

  Through the above process, the characteristic value table shown in FIG. 17A is recorded in the inspection DB recording unit 63. In this characteristic value table, data is arranged in the order of workpiece loading, nulls are stored at locations where the measured data are abnormal values, and measurement times are arranged in the order of workpiece loading. The data of the work number 23 is data without a work, and nulls are stored in items other than the work number, the measurement time, and the channel number. By correcting the measurement data in this way, more accurate data analysis can be performed.

  The present invention is not limited to the above-described embodiments, and various modifications can be made within the scope shown in the claims. That is, embodiments obtained by combining technical means appropriately modified within the scope of the claims are also included in the technical scope of the present invention.

  For example, in the present embodiment, the collection of inspection data from the inspection devices 33 and 35 has been described. However, in the production line, collection of measurement data from the measurement devices, collection of setting data from the processing devices 32 and 34, and the like. The present invention can be applied to the collection of data from various facilities provided.

  Finally, each block of the data collection device 11, particularly the control unit 40, may be configured by hardware logic, or may be realized by software using a CPU as follows.

  That is, the data collection device 11 includes a central processing unit (CPU) that executes instructions of a control program that implements each function, a read only memory (ROM) that stores the program, and a random access memory (RAM) that expands the program. And a storage device (recording medium) such as a memory for storing the program and various data. An object of the present invention is a recording medium on which a program code (execution format program, intermediate code program, source program) of a control program of the data collection device 11 which is software for realizing the functions described above is recorded so as to be readable by a computer. This can also be achieved by supplying the data collection device 11 and reading and executing the program code recorded on the recording medium by the computer (or CPU or MPU).

  Examples of the recording medium include a tape system such as a magnetic tape and a cassette tape, a magnetic disk such as a floppy (registered trademark) disk / hard disk, and an optical disk such as a CD-ROM / MO / MD / DVD / CD-R. Card system such as IC card, IC card (including memory card) / optical card, or semiconductor memory system such as mask ROM / EPROM / EEPROM / flash ROM.

  Further, the data collection device 11 may be configured to be connectable to a communication network, and the program code may be supplied via the communication network. The communication network is not particularly limited. For example, the Internet, intranet, extranet, LAN, ISDN, VAN, CATV communication network, virtual private network, telephone line network, mobile communication network, satellite communication. A net or the like is available. Also, the transmission medium constituting the communication network is not particularly limited. For example, even in the case of wired such as IEEE 1394, USB, power line carrier, cable TV line, telephone line, ADSL line, etc., infrared rays such as IrDA and remote control, Bluetooth ( (Registered trademark), 802.11 wireless, HDR, mobile phone network, satellite line, terrestrial digital network, and the like can also be used. The present invention can also be realized in the form of a computer data signal embedded in a carrier wave in which the program code is embodied by electronic transmission.

  The data collection device according to the present invention can integrate data from each facility of the production line without missing information or in order, so that not only inspection data from the inspection device but also measurement devices, processing devices, etc. It can be applied to data collection and data analysis from other facilities.

1 Production System 10 Production Site 11 Data Collection Device 13 Communication Network 14 PC
20 Pre-process line / parts production line 21 Processing line / Assembly line 22/23 Line 24 Part 30 Line 31 Part supply device 32/34 Processing device 33/35 Inspection device 36 Work 37 Arm 38 Inspection table 40 Control unit 41 Recording unit 42 Network I / F unit 50 Additional information extraction unit (extraction means)
51 Data change part (addition means)
52 Data coupling part (addition means, arrangement means)
53 Data writing section (addition means)
54 Data providing unit 60 Inspection file recording unit (acquisition means)
61 Extraction condition recording unit 62 Line information recording unit 63 Inspection DB recording unit 330 Inspection unit

Claims (14)

A data collection device that collects data from each facility on the production line and adds the collected data to a database.
An acquisition means for acquiring measurement data from the equipment;
When the measurement data acquired by the acquisition means includes a character string, the character string is a value that can be processed as a numerical string, and converted into a value that can be distinguished from the measurement value, and the measurement data is stored in the database. A data collection device comprising: an adding means for adding.   The data collection apparatus according to claim 1, wherein the adding means further adds the character string to the character string table in association with the position where the converted value is added to the database. It further includes an allowable range recording unit for recording the allowable range of the measurement data,
In the case where the measurement data acquired by the acquisition unit is not included in the allowable range from the allowable range recording unit, the adding unit further associates the measurement data with the position added to the database, and detects an abnormality. The data collection device according to claim 1, wherein a character string to be indicated is added to the character string table. A data collection device that collects data from each facility on the production line and adds the collected data to a database.
A line information recording unit for storing line information including a correspondence relationship between the facility and the rules of the order of workpieces processed by the facility;
Obtaining means for obtaining data for each workpiece in the equipment;
Based on the line information from the line information recording unit, arrangement means for arranging the data for each workpiece acquired by the acquisition means in a predetermined order;
A data collecting apparatus comprising: an adding means for adding data for each work arranged by the arranging means to the database. The data for each workpiece includes the measurement time of the data,
The line information further includes a correspondence relationship between the equipment and a measurement period, which is a period necessary for the equipment to measure,
The arrangement means, based on the line information from the line information recording unit, when the difference in measurement time between the data of the adjacent workpieces is larger than the measurement period corresponding to the equipment, the data of the workpieces 5. The data collection apparatus according to claim 4, wherein data indicating that there is no target work is inserted between the data and the data for each work is arranged in a predetermined order. The data for each workpiece includes the measurement time of the data,
5. The data collection apparatus according to claim 4, wherein the arrangement unit changes the measurement times of the workpieces so as to be arranged in a predetermined order after arranging the data of the workpieces in a predetermined order. . A data collection device that collects data from each facility on the production line and adds the collected data to a database.
An acquisition means for acquiring a file including the data and a file name from the facility;
Extraction means for extracting additional information related to the data from the file name acquired by the acquisition means;
An additional means for adding additional information extracted by the extraction means to the database by adding the additional information extracted by the acquisition means to the data in the file. The file name includes a plurality of additional information combined through a separator,
It further comprises an extraction condition recording unit for recording an extraction condition for extracting the additional information,
The extraction condition includes the information on the separator, the order of the additional information, and the correspondence between the item names.
The extraction means extracts the additional information from the file name based on the extraction condition from the extraction condition recording unit, associates the item name with the extracted additional information,
8. The data collection apparatus according to claim 7, wherein the adding means further adds an item name associated with the additional information to the database. A data collection device control method for collecting data from each facility of a production line and adding the collected data to a database.
An acquisition step of acquiring measurement data from the equipment;
When a character string is included in the measurement data acquired in the acquisition step, the character string is a value that can be processed as a numerical string, and is converted into a value that can be distinguished from the measurement value. And a step of adding to the database. A data collection device control method for collecting data from each facility of a production line and adding the collected data to a database.
An acquisition step of acquiring data for each workpiece in the facility;
Line information including the correspondence relationship between the equipment and the rules of the order of works processed by the equipment is read from the recording unit, and data for each work obtained in the obtaining step is determined based on the read line information. Arranging steps arranged in the order of:
And a data collection device control method comprising: an addition step of adding data for each workpiece arranged in the arrangement step to the database. A data collection device control method for collecting data from each facility of a production line and adding the collected data to a database.
An acquisition step of acquiring a file and a file name including the data from the facility;
An extraction step of extracting additional information related to the data from the file name acquired in the acquisition step;
And adding the additional information extracted in the extraction step to the data in the file acquired in the acquisition step and adding the additional information to the database. Method. In a control program for operating a data collection device that collects data from each facility on the production line and adds the collected data to the database,
An acquisition step of acquiring measurement data from the equipment;
When a character string is included in the measurement data acquired in the acquisition step, the character string is a value that can be processed as a numerical string, and is converted into a value that can be distinguished from the measurement value. A control program for causing a computer to execute an additional step to be added to a database. In a control program for operating a data collection device that collects data from each facility on the production line and adds the collected data to the database,
An acquisition step of acquiring data for each workpiece in the facility;
Line information including the correspondence relationship between the equipment and the rules of the order of works processed by the equipment is read from the recording unit, and data for each work obtained in the obtaining step is determined based on the read line information. Arranging steps arranged in the order of:
A control program for causing a computer to execute an additional step of adding data for each workpiece arranged in the arrangement step to the database. In a control program for operating a data collection device that collects data from each facility on the production line and adds the collected data to the database,
An acquisition step of acquiring a file and a file name including the data from the facility;
An extraction step of extracting additional information related to the data from the file name acquired in the acquisition step;
A control program for causing a computer to execute an additional step of adding the additional information extracted in the extraction step to the data in the file acquired in the acquisition step and adding the additional information to the database.

Images