1. Technical Field
The present invention relates to an inspection system, a management server, an inspection apparatus and a method for managing inspection data, and in particular to an inspection system that manages data of inspection results from inspecting products that are produced in a factory or the like, as well as a management server, an inspection apparatus, and a method for managing inspection data that are used in such an inspection system.
2. Related Art
When producing products in a factory or the like, it is common that the production is carried out through a plurality of steps. Moreover, individual processing conditions are set for each of the steps. A production system that collects, among others, the processing conditions at each step and the inspection result data, which is the data of the results of inspecting the products in each step, is disclosed for example in JP 2007-157061A (Patent Document 1).
According to Patent Document 1, the production system collects the data for the purpose of preempting defective products by ascertaining the processing conditions and the inspection result data of products that have been judged to be defective as a result of the inspection.
Here, the production system disclosed in Patent Document 1 is configured to include an operation control computer that includes a data memory in which the processing conditions of each step are stored, a data collection computer that cycles and collects the data written into the operation control computer, and a DB (database) server that stores the data collected by the data collection computer.
That is to say, in Patent Document 1, the production system is configured to store the processing conditions in a data memory. When this configuration is applied to the inspection of a substrate on the top of which electronic components are mounted, for example, then there is a large number of process steps and a broad variety of inspection items in each process step for the inspection of the substrate, so that there is a massive amount of data, and this massive amount of data is stored in the data memory. In this case, there is the risk that the consistency of the data stored in the data memory and the association of the data of the various process steps becomes very complex.
Moreover, when trying to manage the inspection result data from a large number of inspection apparatuses with one database as with a DB server, there is the risk that there is a concentration in the processes of collecting the data, and the processes for collecting from certain inspection apparatuses affect the processes for collecting from other inspection apparatuses.
It is an object of the present invention to provide an inspection system that can efficiently manage the data obtained from a plurality of apparatuses, as well as a management server, an inspection apparatus and a method for managing inspection data that can be used in such an inspection system.
An inspection system according to the present invention includes a plurality of inspection apparatuses to inspect products, and a management server connected to the inspection apparatuses via a communication line. The inspection apparatuses each include an inspection unit for inspecting products; an inspection apparatus-side storage unit for storing inspection result data representing a result of an inspection with the inspection unit, the inspection apparatus-side storage unit being a key-value database; and a sending unit for sending the inspection result data stored by the inspection apparatus-side storage unit to the management server. The management server includes a receiving unit for receiving the inspection result data sent by the sending unit; and a server-side storage unit for storing the inspection result data received by the receiving unit.
With this configuration, the inspection system can store the inspection result data in key-value databases in the inspection apparatuses. In this case, it is possible to store the inspection result data in a format that is easy to search, even if there is a lot of inspection result data. Moreover, since the databases are provided on the inspection apparatus side, a large amount of inspection result data can be held on the inspection apparatus side, and it is possible to send the inspection result data at an appropriate timing of the inspection apparatuses, without the need to send the inspection result data to the management server immediately after the inspection. Consequently, also in a state in which a plurality of inspection apparatuses are connected to the management server, there is no concentration of the processing of the sending of the inspection result data. As a result, it is possible to efficiently manage the data obtained by the plurality of inspection apparatuses.
Preferably, the server-side storage unit comprises a key-value database and a relational database; and the management server comprises an inspection information storage unit for storing information relating to an inspection of a product by the inspection apparatus; and a conversion unit for converting the inspection result data received with the receiving unit into relational data, based on the information relating to the inspection of the product stored in the inspection information storage unit. Thus, since a key-value database is also provided on the side of the management server, it is easy to store the inspection result data that has been temporarily stored in the inspection apparatus without converting its type on the management server side. Consequently, since there is no need for processing entailing a load on the management server side, it is possible to perform stable processing when receiving and storing the inspection result data on the management server side and to shorten the processing time, even when the inspection result data are sent from a plurality of inspection apparatuses. Moreover, since the inspection result data is converted from key-value data to relational data on the management server side, it is possible to perform the detailed aggregation of the inspection result data using a relational database. Moreover, the conversion into a relational database can be carried out based on information relating to the product inspection with the inspection apparatuses, so that a suitable conversion can be carried out based on the inspection.
More preferably, the management server includes an analysis unit for analyzing the inspection result data converted by the conversion unit. Thus, it is possible to analyze the inspection result on the management server side. Consequently, it is possible to use a relational database when analyzing the inspection result, so that a detailed analysis can be carried out.
More preferably, the information relating to the inspection of the product stored in the inspection information storage unit is associated among the plurality of inspection apparatuses. Thus, when analyzing the inspection results, the inspection results of a plurality of inspection apparatuses can be linked and analyzed.
More preferably, the inspection unit includes an image obtaining unit for obtaining data of an image of the product when inspecting the product, and the inspection apparatuses each include a holding unit for holding the data of the image of the product obtained by the image obtaining unit; and an image control unit for controlling the data of the image of the product held by the holding unit in accordance with the result of the analysis with the analysis unit. Thus, it is possible to suitably process the image data. For example, there will be no situation in which the image data is left on the inspection apparatus side.
Another aspect of the present invention relates to a management server that can be connected via a communication line to a plurality of inspection apparatuses to inspect products. The management server includes a receiving unit for receiving inspection result data sent from the plurality of inspection apparatuses, the inspection result data being key-value data; and a server-side storage unit for storing the inspection result data received by the receiving unit, the server-side storage unit being a key-value database.
With this configuration, the management server is configured to include a key-value database, so that it is easy to store the key-value inspection result data from the inspection apparatuses as it is without performing a type conversion. Consequently, since there is no need for processing entailing a load on the management server side, it is possible to perform stable processing when receiving and storing the inspection result data on the management server side and to shorten the processing time, even when the inspection result data are sent from a plurality of inspection apparatuses. As a result, it is possible to efficiently manage with the management server the data obtained from the plurality of apparatuses.
Yet another aspect of the present invention relates to an inspection apparatus to inspect products, the inspection apparatus being connectable to a management server and comprising an inspection unit for inspecting products; an inspection apparatus-side storage unit for storing inspection result data representing a result of an inspection with the inspection unit, the inspection apparatus-side storage unit being a key-value database; and a sending unit for sending the inspection result data stored by the inspection apparatus-side storage unit to the management server.
Thus, the inspection apparatus can store inspection result data in a key-value database. In this case, it is possible to store the inspection result data in a format that is easy to search, even if there is a lot of inspection result data. Moreover, a large amount of inspection result data can be held, and it is possible to send the inspection result data at an appropriate timing of the inspection apparatus, without the need to send the inspection result data to the management server immediately after the inspection. Consequently, also in a state in which a plurality of inspection apparatuses are connected to the management server, there is no concentration of the processing of the sending of the inspection result data. As a result, it is possible to efficiently manage the data.
Yet another aspect of the present invention relates to an inspection data management method. The inspection data management method includes a step of inspecting a product with an inspection apparatus for inspecting products; a step of storing inspection result data representing a result of an inspection with the inspection apparatus in a key-value database; a step of sending the inspection result data stored by the inspection apparatus to a management server; a step of receiving, with the management server, the inspection result data sent by the inspection apparatus; and a step of storing the received inspection result data with the management server.
Thus, with this inspection data management method, the inspection result data can be stored in a key-value database. In this case, it is possible to store the inspection result data in a format that is easy to search, even if there is a lot of inspection result data. Moreover, since the databases are provided on the inspection apparatus side, a large amount of inspection result data can be held on the inspection apparatus side, and it is possible to send the inspection result data at an appropriate timing of the inspection apparatuses, without the need to send the inspection result data to the management server immediately after the inspection. Consequently, also in a state in which a plurality of inspection apparatuses are connected to the management server, there is no concentration of the processing of the sending of the inspection result data. As a result, it is possible to efficiently manage the data obtained by the plurality of inspection apparatuses.
With the present invention, an inspection system can store inspection result data in a key-value database in an inspection apparatus. In this case, it is possible to store the inspection result data in a format that is easy to search, even if there is a lot of inspection result data. Moreover, since the databases are provided on the inspection apparatus side, a large amount of inspection result data can be held on the inspection apparatus side, and it is possible to send the inspection result data at an appropriate timing of the inspection apparatuses, without the need to send the inspection result data to the management server immediately after the inspection. Consequently, also in a state in which a plurality of inspection apparatuses are connected to the management server, there is no concentration of the processing of the sending of the inspection result data. As a result, it is possible to efficiently manage the data obtained by the plurality of inspection apparatuses.
Referring to the drawings, the following is an explanation of an inspection system according to embodiments of the present invention.
The first to third inspection apparatuses 11a, 11b and 11c are respectively provided at the individual steps for producing the product. The steps of mounting the electronic product onto the substrate in this embodiment are, for example, a printing step of printing lands or the like on the substrate, a mounting step of mounting the electronic components on the substrate, and a reflowing step of soldering terminals of electronic components to the lands. Then, the first inspection apparatus 11a is arranged at the position of the printing step, and carries out the post-printing inspection. The second inspection apparatus 11b is arranged at the position of the mounting step, and carries out the post-mounting inspection. The third inspection apparatus 11c is arranged at the position of the reflowing step, and carries out the post-soldering inspection. Note that the arrow A in
The following is an explanation of the configuration of the first inspection apparatus 11a. The first inspection apparatus 11a includes a control unit 13a, an apparatus-side inspection result DB (database) 14a serving as an inspection apparatus-side storage unit, and an apparatus-side inspection program DB 15a. The control unit 13a includes a CPU (central processing unit) that controls the overall first inspection apparatus 11a, an interface unit serving as a communication interface with the outside, and a memory, for example. The apparatus-side inspection program DB 15a stores information concerning the inspection of the substrate. It should be noted that also the second inspection apparatus 11b and the third inspection apparatus 11c have the same configuration, so that their further explanation is omitted.
The apparatus-side inspection result DB 14a stores the inspection result data, which is data representing the results of inspecting the substrate with the first inspection apparatus 11a. The apparatus-side inspection result DB 14a is a key-value database constituted by keys and values.
Moreover, also the apparatus-side inspection program DB 15a is a key-value database. The apparatus-side inspection program DB 15a stores information regarding the inspection of substrates. Here, the information regarding the inspection of substrates is information indicating the inspection conditions and the like, and contains for example information specifying specific positions on the substrate subjected to inspection, information indicating specific components, or information on inspection criteria for determining whether a substrate is good or poor.
The management server 30 includes a control unit 31, a server-side inspection result DB 32, a server-side inspection program DB 33, and a statistical analysis DB 34. The control unit 31 includes a CPU that controls the overall management server 30, an interface unit serving as a communication interface with the outside, and a memory, for example. The server-side inspection result DB 32 serves as a server-side storage unit. The server-side inspection program DB 33 serves as an inspection information storage unit for storing information relating to the inspection of the substrates. The statistical analysis DB 34 serves as a server-side storage unit for storing statistics and analyses of the inspection result data, based on the server-side inspection result DB 32 and the server-side inspection program DB 33.
Like the apparatus-side inspection result DB 14a, the server-side inspection result DB 32 is a key-value database. The server-side inspection result DB 32 stores the key-value inspection result data received from the first to third inspection apparatuses 11a to 11c. It should be noted that the dotted lines in
Similarly, also the server-side inspection program DB 33 is a key-value database. The server-side inspection program DB 33 stores the same information as the information relating to the inspection of substrates stored in the first to third inspection apparatuses 11a to 11c. For example, in the server-side inspection program DB 33, information relating to the inspection of substrates with the first to third inspection apparatuses 11a to 11c is stored, and by forwarding information corresponding respectively to the first to third inspection apparatuses 11a to 11c at a predetermined timing, it stores the same information as the first to third inspection apparatuses 11a to 11c.
The statistical analysis DB 34 is a relational database. The control unit 31 converts the inspection result data stored in the server-side inspection result DB 32 from key-value to relational, and the statistical analysis DB 34 stores the converted inspection result data.
That is to say, the management server 30 is configured to include two databases of different types, that is, a key-value database and a relational database.
Here, the case was explained that, using the inspection system 10, substrates are examined with the first to third inspection apparatuses 11a to 11c, and the inspection result data are managed by the management server 30.
First, as shown in
Referring now to
It should be noted that similarly, also the first inspection apparatus 11a and the second inspection apparatus 11b carry out the substrate inspection and send the inspection result data to the management server 30. At this time, the substrates are conveyed in the forward direction of the steps, so that the inspections may be carried out in the order of first inspection apparatus 11a, second inspection apparatus 11b, and third inspection apparatus 11c.
Thus, as shown in
Then, as shown in
Thus, the inspection system 10 can store the inspection result data in a key-value database in the inspection apparatuses 11a to 11c. In this case, even if there is a large amount of inspection result data, it is possible to store it in a format in which it can be easily searched. That is to say, it is possible to make the processing time when accessing the data base shorter, and to perform a high-speed process. Moreover, since the configuration is such that databases are provided on the side of the inspection apparatuses 11a to 11c, it is possible to hold a large amount of inspection result data on the side of the inspection apparatuses 11a to 11c, there is no need to send the inspection result data immediately after carrying out the inspection to the management server 30, and it is possible to send the inspection result data from the inspection apparatuses 11a to 11c at any time. Consequently, even when a plurality of inspection apparatuses 11a to 11c are connected to the management server 30, there is no concentration of the processes of sending the inspection result data. As a result, the data obtained from the plurality of inspection apparatuses 11a to 11c can be managed efficiently.
Moreover, since the inspection system 10 is configured to include a key-value database also in the management server 30, the inspection result data stored temporarily in the inspection apparatuses 11a to 11c can be easily stored as it is and without a type conversion or the like on the side of the management server 30. Consequently, it is not necessary to perform a process exerting a load on the side of the management server 30, so that even if inspection result data is sent from a plurality of inspection apparatuses 11a to 11c, it is possible to perform the process of receiving and storing the inspection result data on the side of the management server 30 in a stable manner, and to shorten the processing time. Moreover, since the inspection result data is converted from a key-value database to a relational database on the side of the management server 30, it is possible to perform the detailed aggregation of the inspection result data using a relational database. Moreover, since the data can be converted into a relational database based on information relating to the inspection of products with the inspection apparatuses 11a to 11c, it is possible to carry out a suitable conversion based on the inspection.
Note that in S21 in
And in S41 in
It should be noted that the above embodiment has been explained for an example in which the first to third inspection apparatuses 11a to 11c are a first inspection apparatus 11a performing post-printing inspection, a second inspection apparatus 11b performing post-mounting inspection, and a third inspection apparatus 11c performing post-soldering inspection, but there is no limitation to this, and they may by any apparatus in a production line. For example, they may be inspection apparatuses for other inspections, such as X-ray inspection apparatuses. Moreover, the production line also may be a plurality of different inspection apparatuses.
Moreover, in the above-noted embodiment, an example was explained in which the timing at which the inspection result data is sent from the third inspection apparatus 11c to the management server 30 is the timing at which the inspection result data for a predetermined number is stored, but there is no limitation to this, and it is also possible to send the data at predetermined intervals, for example every five minutes, or at timings set freely by the user.
Moreover, in addition to the management server 30 and the inspection apparatuses 11a to 11c, the inspection system 10 may also be configured to include other devices, such as a display apparatus that displays the inspection result data.
Here, a case was explained in which the image data that is obtained by the inspection apparatuses 11a to 11c in S11 as explained above is processed based on an analysis on the side of the management server 30.
As shown in S11, the image data is obtained to carry out the substrate inspection with the inspection apparatuses 11a to 11c, and is temporarily stored inside the inspection apparatuses 11a to 11c. Here, the control units 13a to 13c serve as holding unit. After this, when an analysis or the like has been performed in the management server 30 using the inspection result data, it is decided, depending on the analysis result, whether the image data is deleted, sent to the management server 30 or kept stored in the inspection apparatuses 11a to 11c. Here, the control units 13a to 13c serve as image control unit.
Thus, it is possible to send only the image data necessary at the necessary time to the management server 30, in accordance with the analysis of the inspection result by the management server 30. In this case, it is possible for the user using the inspection system 10 to determine the capacity for storing the image data based on the load and the state of utilization of the image data, in view of process improvement of the steps. For example, it is possible to make the capacity for storing image data as small as possible.
Moreover, it is possible to send the inspection results to the management server 30 not only when they are poor, but also when they are good.
Moreover, in the above-described embodiment, an example was explained in which the data are aggregated for each machine type during the analysis with the management server 30, but there is no limitation to this, and if there is a plurality of inspected items, then the configuration may also be such that the analysis is possible for each of the inspection items.
When the management server 30 receives such inspection result data, using the information relating to the substrate inspection stored in the server-side inspection program DB 33, it converts the inspection result data from key-value data to relational data, performs an analysis, and stores the data in the statistical analysis DB 34. Here, the inspection result data for a plurality of substrates is analyzed for each inspection item.
Thus, it is possible to appreciate the temporal change of the soldering state of the corresponding product. For example, if data indicating that the solder area increases gradually from 350 to 360 etc., then it is possible to recognize that the solder area of the components differs greatly between the first substrate and the tenth substrate. That is to say, it is easy to recognize the change in the inspection points, such as the solder area, for a plurality of substrates.
The following is an explanation of another embodiment of the present invention, in which an analysis is carried out based on information relating to substrate inspection that is stored in the server-side inspection program DB and the server-side inspection program DB.
In this embodiment, a solder inspection machine, a mounting inspection machine, and a solder attachment inspection machine are included as inspection apparatuses. As in the above-described embodiment, the solder inspection machine, the mounting inspection machine, and the solder attachment inspection machine each include an apparatus-side inspection program DB.
As noted above, the apparatus-side inspection program DB stores information relating to the substrate inspection.
Thus, the inspection apparatuses contain information serving as criteria for the inspection. Here, the information relating to the substrate inspection contained in the inspection apparatuses is criterion information indicating inspection criteria. Moreover, the criterion information is associated among a plurality of inspection apparatuses. For example, criterion information of different viewpoints may be contained in a single component.
On the other hand, similar to the above-described embodiment, the management server includes a server-side inspection program DB. As noted above, the server-side inspection program DB stores information relating to substrate inspection.
Moreover, the management server contains not only criterion information for each inspection apparatus, but also general determination rules for comprehensively determining the criterion information of the various inspection apparatuses. As shown in
Thus, since the information relating to the substrate inspection is shared between the management server and the inspection apparatuses, it is possible to properly carry out the analysis of inspection result data on the management server side. The management server can combine and use the information relating to the substrate inspection contained in the various inspection apparatuses, and can comprehensively analyze the inspection results of the various inspection apparatuses.
In the foregoing, embodiments of the invention have been explained with reference to the accompanying drawings, however the present invention is not limited to the illustrated embodiments. Various modifications and adaptations of the illustrated embodiments are possible within a scope that is identical or equivalent to the present invention.
Number | Date | Country | Kind |
---|---|---|---|
2011-040510 | Feb 2011 | JP | national |