The present application claims priority from Japanese application JP2005-263960 filed on Sep. 12, 2005, the content of which is hereby incorporated by reference into this application.
The present invention relates to a method and a system for evaluating the accuracy of component attribute information provided by third parties. More particularly, the present invention relates to a method and a system for extracting incorrect component information that are suited for quantifying the degree of accuracy of information on chemical substances contained in a component that is provided by third parties to specify the components that should be preferentially analyzed by measurement instruments.
Now, legal regulations for restricting the use of specific chemical substances are being enacted and put into force in various countries. The legal regulations include the RoHS directive (Restriction of the use of Hazardous substances: a directive for prohibiting the use of specific chemical substances), and an ELV directive (End of Life Vehicles Directive: a directive concerning used vehicles). The trend of tightening of environmental regulations of these days as foregoing suggests that the regulations will possibly be extended, resulting in the addition of chemical substances to be regulated or of regulated items other than chemical substances (such as a duty to disclose information on the effect of a product on the environment and a limitation of CO2 emission during manufacturing). Accordingly, in order to respond to these environmental regulations, assembly manufactures are requesting component suppliers (referred to as “suppliers” hereinafter, and the “suppliers” include component venders and component manufactures) to provide them with component attribute information including chemical substance information in green procurement that has been promoted by each corporation these days. The assembly manufactures are pursuing to respond to the legal regulations based on the information provided by the suppliers.
However, there is sometimes a case in which regulated chemical substances, which are not contained in components according to the information provided by the suppliers, are actually contained, which takes place due to data inputting errors, problems in measurement instruments, or the like. There is concern that once a violation is found, the corporate image of the assembly manufacture concerned is tarnished.
Therefore, in order to obtain correct component attribute information, the assembly manufactures are requesting the suppliers to submit an appended document that guarantees the accuracy of the information, such as a written guarantee of not containing the regulated chemical substances. Furthermore, the assembly manufactures are employing a system for assisting the selection of components that contain less regulated chemical substances such as one described in a Japanese Laid-open Patent Application JP-A-11-238069.
It should be noted that the “component” in the present specifications refers to a “part” that constitutes a product and exhibits part of the product's functions, and to a “material” that means a raw material necessary to manufacture the part.
The appended document like a conventional guarantee of not-containing them can not guarantee that actual attribute values match the component attribute information provided by the suppliers by 100 percent.
Additionally, the invention disclosed in the Japanese Laid-open Application JP-A-11-238069 relates to a method for assisting the selection of optimal components from among a plurality of components under given conditions. This is a method employed under a condition that the component attribute information is correct instead of a method for evaluating the accuracy of the component attribute information.
Therefore, conventionally, inspections have been performed sequentially by measurement instruments in the order in which the components are delivered or by extracting the components at random. However, in recent years, measurement manhour has become enormous because of an increase in the number of items and survey items of target components. The operations for measuring the components have prolonged the lead times from product planning to the design completion and the start of commercial production. Thus, there is a need for shortening the lead times by finding information on components that can lead to violations at an early stage.
It is an object of the present invention to provide a method of imparting quantitative evaluation values to the accuracy degree of the component attribute information of a plurality target components, and thereby to clarify the order in which the components are analyzed. It is another object of the present invention to provide a method of specifying the chemical substances which are considered to cause poor accuracy, and thereby to enhance analytical accuracy.
In order to achieve above objects, the present invention comprises an input means for receiving a components list and evaluation conditions; an external storage device for holding component attribute information or the like; a calculation unit for performing the evaluation of the attribute information of target components; an internal storage device for storing intermediate data such as evaluation result or the like; and an output means for outputting the evaluation result.
The performance unit for performing the evaluation of the attribute information has a means for extracting components similar to the target components; a means for determining the abnormality in the component attribute information when the component attribute information takes limited values such as 0 or 1; a means for determining the degree of abnormality of the component attribute information when the component attribute information takes various values such as integers; and means for sorting the component attribute information in the order of descending degree of abnormality of the component attribute information to clarify the basis for the evaluation result.
Especially, a means for quantifying the abnormality degree of the component attribute information has a means for converting the component attribute information; and a means for quantifying the excess degree or undersize degree of the component attribute information. By implementing the present invention, it becomes possible for users to start checking preferentially from component attribute information with poor accuracy, thus enabling the users to find inaccurate components at an early stage and to facilitate the completion of qualification.
It becomes possible to find inaccurate component attribute information at an early stage to advance the completion of inspection by implementing the present invention. Moreover, the specification of the information on the chemical substances that is possibly inaccurate enhances the analytical accuracy and enables the reduction of inaccurate information and simultaneously the reduction of the risk of violating the regulation of the use of target chemical substances contained in products including ones specified in the RoHS directive.
Other objects, features and advantages of the invention will become apparent from the following description of the embodiments of the invention taken in conjunction with the accompanying drawings.
Embodiments of the present invention will be described in the following sections with reference to drawings. In the present embodiments, information on the composition of chemical substances is given as an evaluation example of component attribute information. It should be noted that an “object” refers to a thing whose entity and concept can be identified such as software and hardware, and a “component” is an exemplary object.
(1) An Entire System Configuration
A system for extracting incorrect object attribute information is an information processing apparatus that can be connected to an external data storage unit 1208 via the Internet 1209, and comprises a main storage device 1207, a processing device (calculation unit) 1203, an auxiliary storage device (storage unit) 1204, an input device (input unit) 1201, and an output device (output unit) 1202, as is shown in
A block diagram of the system in the present embodiment is shown in
(2) Search for Similar Components
Next, details of each step in calculation processing will be described in accordance with flow charts in FIGS. 2 to 5.
Item codes of the target components are extracted from the received components list 201, and the component classification of the target components is specified based on Table 211 stored in an external storage device 207 (step 204). The Table 211 holds data for linking the item codes to component classifications. The component classifications in the Table 211 shown in
Furthermore, the item codes of the components belonging to the same component classifications that are specified in step 204 are extracted from the Table 211 (step 205). An evaluation conditions setting and receiving interface 202 of the system can receive conditions that lead to narrowing of similar components to further narrow down the components extracted at the step 205 (step 206).
The system outputs a linkage between the target components and the similar components that are narrowed down in this way as a list 209. The list 209 is held in the main storage device or in the auxiliary storage within the system.
(3) The Concept of Determination of Whether Containing or Not-Containing (Containing or Not-Containing Evaluation) and Calculation of Content Ratio (Content Ratio Evaluation)
Next, an explanation will be given to processing that compares chemical substance information of the target components with that of similar components using information on containing or not-containing and information on content ratio at the accuracy evaluation step (step 109) to obtain the degree of similarity.
The information on whether containing or not-containing indicates whether each substance group is contained in each item code, as shown in Table 310 of
The chemical substance described here refers to a component that corresponds to a substance code in a one-to-one relationship. The substance code defines a symbol inherent to the element or compound thereof. Typically, CAS numbers (CAS Registry Numbers) that are defined by American Chemical Society are employed.
Information on content ratio refers to the information in which substance code and content ratio are linked to the item code, as is shown by Table 411 in
The determination of whether containing or not-containing and the calculation of content ratio are used instantaneously in the processing of obtaining the degree of similarity. There are two reasons why the two processes are instantaneously used as in the following. With just the determination of whether containing or not-containing, it is impossible to differentiate between the codes with “contain.” The defect is complemented by the calculation of content ratio. On the other hand, with just the calculation of content ratio, it is impossible to verify that certain chemical substances are not contained. The defect is complemented by the determination of whether containing or not-containing. In this way, these two evaluation processes are preferably performed simultaneously so as to complement defects of each other.
However, it should be noted that while the attribute information used for evaluation refers to the information on whether containing or not-containing or information on content ratio for each substance group in the present embodiments that follow, when comparing chemical substance information, it is not necessary to limit the attribute information to the substance group. For example, if the present embodiment aims to evaluate not only the chemical substance information but also the accuracy of the information provided by suppliers itself, specification values (temperature characteristic or resistance value in the case of a resistor, and capacitance or the like in the case of a capacitor), and weight of the component can be employed as attribute information.
Furthermore, evaluation can also be executed by narrowing the attribute information. It is unnecessary to make a comparison using the information on whether containing or no-containing for all substance groups that number about 20 to 30. For example, in order to improve the accuracy of the evaluation, it is also possible to narrow the attribute information to the information on substance groups that are provided from suppliers and include a lot of information.
(4) The Determination of Whether Containing or Not-Containing (Containing or Non-Containing Evaluation)
At step 303, the information on whether the target components and components similar to them contain or do not contain the chemical substances is extracted from a database 309.
At step 304, the content ratio for each substance group contained in the similar components is obtained. In other words, assuming that the number of items in the similar components is N, the number of items that “contain” a substance group A is NY, the number of items that “do not contain” the substance group A is NN, the number of items that are “under inspection” on whether containing or not containing the substance group A, or that are not registered is NU, and the content ratio of the substance group A is PA, the content ratio of the substance group A is obtained by the following expression.
Where, NY+NN+NU=N. The expression 3 is used to obtain the content ratio for all substance groups.
At step 305, a substance group that is contained in almost all similar components is extracted in accordance with a set value, input of which is received at an interface 302 for setting and receiving evaluation conditions. A threshold value of the content ratio is mainly assumed as the set value received at 302, and at step 305, substance groups, which are contained in the similar components in the proportion equal to the set value or more, are extracted. In addition, the set value can be set for each component classification and for each substance group. Alternately, a value, which is set such that x (arbitrary number) pieces, of substance groups which are contained in high proportions are extracted, can also be received.
At step 306, it is checked whether the substance groups extracted at the step 305 are contained in the target components. If all the extracted substance groups turn out to be contained, the similarity degree of the target component is set to 1, and a record is stored in a database 311 that stores the result of checking if the substance groups are contained at step 308. The database 311 is preferably constructed in an auxiliary storage within the system. If at least one of the extracted substance groups is not contained, the similarity degree of the target component is set to 0, and a record is stored in the database 311 together with a substance group (sometimes a plurality of substance groups) that is (are) not contained in the target component at step 307. An exemplary display of the checking result at this point is shown in
At step 314, the similar components list 301 and the database 311 are referred to, and if the evaluation of all the target components is not finished, the flow returns to step 313, where target components that are not inspected yet are evaluated in a similar way. When the evaluation of all the target components is finished, the check of whether the substance groups are contained terminates.
(5) The Calculation of Content Ratio (Content Ratio Evaluation)
At step 402, information on the content ratio in the target components and their similar components is extracted from a database 410.
In Table 411 stored in the database 410, substance codes and content ratio are linked to item codes. However, codes inherent to elements and compounds like CAS numbers are sometimes used for the substance codes. Here, in order to totalize the content ratio for each chemical substance on a substance group basis, Table 413 for holding information relating to unit conversion, which is stored in a database 412, is used to convert the substance codes into substance groups and into the content ratio by unit of a substance group (step 403). At this time, the Table 413 includes columns for at least substance groups and substance codes. The Table 413 sometimes includes columns for metal conversion coefficients. The metal conversion coefficients are values for converting the content ratio of chemical substances that include metal into the content ratio of metal itself.
Furthermore, at step 404, the unit of content ratio in Table 411 is unified into ppm. At this time, if the column of the content ratio includes information equivalent to contained amount (mg, g, kg, or the like), reference is made to Table 415 holding information on the component attribution that is stored in a database 414 in order to convert the information into content ratio. The information on component weight stored in the table is extracted, and the contained weight is divided by component weight for conversion into content ratio in ppm.
At steps 406 to 409, the degree of similarity of the information on the content ratio is obtained by comparing the content ratio of the target components with the content ratio of the similar components. In the following sections, an evaluation method will be described on the assumption that the distribution of content ratio of the similar components approximates the normal distribution. However, the evaluation method is exemplary and is not restricted to the one described in the present embodiments as far as the method is capable of defining continuous similarity.
Step 406 is the processing of converting the content ratio of the target components and similar components. It is an object of the processing to extract the characteristic of the distribution of the content ratio. For example, a cube root of the content ratio is taken. In many cases, it is difficult to limit the range of the content ratio without being subjected to the processing. Especially, the processing is useful when extracting excessively small content ratio, since it is possible to emphasize small values by executing conversion using a function in which as x (content ratio) increases like y=x1/3 or y=log x, so the rate of increase of y (conversion value of content ratio) gradually decreases.
Step 407 is the processing of obtaining the similarity degree of the content ratio of the target components. First, one substance group is selected (tentatively assuming that this is a substance group A) and an average value mA and a standard deviationσA of the distribution of a cubic root of the content ratio of the similar components that are converted at step 406 are obtained. At this time, similar components that do not contain the substance group are not considered in obtaining the average value and standard deviation. Next, assuming that the distribution follows the normal distribution, a value PA is obtained when the cubic root of the content ratio of the substance group A of the target component is CA.
where
The PA is an area shown by a shaded part 602 in
At step 408, it is confirmed if Pi, which is defined by expression 4, is obtained in all substance groups i that are contained in the target components, and if not obtained, the processings of steps 405 to 407 are repeated.
In this manner, Pi is obtained for all substance groups. Step 409 is the processing for obtaining the similarity degree of the target component based on Pi. As an exemplary definition method of similarity degree S, a minimum value of Pi is taken in the present embodiment. This is an exemplary embodiment in which the substance group with low accuracy, if any of all substance groups, is extracted. However, the definition of the similarity degree is not limited to taking the minimum value. For example, it is possible to evaluate the degree of similarity as the entire chemical substance information by taking an average value of Pi. Then, a substance group that gives the similarity degree S and the minimum Pi of the target component is stored in Table 417 that stores the result of the calculation of content ratio in a database 416. It should be noted that the database 416 exists in a main storage device or an auxiliary storage held within the system.
Then, at step 419, reference is made to a components list 401. If the calculation of content ratio is not finished for all target components, the flow returns to step 418, where the degree of similarity is obtained for the components that are not inspected yet. If the inspection of all target components is finished, the calculation of the content ratio terminates.
(6) Setting an Order of Priority for Analysis
At step 702, the degree of similarity for all target components described in the target components list 101 is extracted from Table 705, which stores the result of determination of whether containing the substance groups or not, and from Table 707, which stores the result of the calculation of the content ratio. When one target component is subjected to the processes of the determination of whether containing or not-containing as well as the calculation of the content ratio, two different similarity degrees are defined or provided by the two evaluation processes. However, in the present embodiment, the degree of similarity with a lower value out of the two similarity degrees provided is regarded as the similarity degree of the target component. At this time, data relating to the substance groups, which are linked to the item codes from the Table 705 or Table 707, are also simultaneously extracted.
At step 703, the target components in the components list 101 are prioritized in the order of ascending degree of similarity, and a priority list of components to be analyzed 708 is outputted. Although the output is in a form that is stored as a file, it can also be displayed on the screen.
The above processes enable incorrect suppliers' information to be extracted. A method of effectively extracting incorrect information by means of above processes is introduced in the following sections.
As one principal example of incorrect information provided by suppliers, a fixed resistor equipped with lead wires will be given. In the fixed resistor, components are constituted of a plurality of sites, and sometimes there are errors included in the information provided by the suppliers. A fluorescent X-rays analyzer can analyze only very small parts when it is employed for the analysis of content ratio. Therefore, when analyzing a component that comprises a plurality of sites, it is necessary to analyze all sites that constitute the component. Otherwise, there is a possibility that a certain chemical substance contained fails to be detected. When the suppliers actually provide information without noticing such detection failures, the information provided by the suppliers is correct in terms of the content ratio of almost all chemical substances. At this time, the suppliers provide the information that the content ratio of the chemical substance in question is extremely low, or that the chemical substance “is not contained.”
Above processes of the present invention are effective in this instance. When the content ratio is very low according to the information provided by suppliers, the processes of the present invention compare the target component with similar component in terms of the content ratio inspected, and the chemical substance that fails to be detected is determined as “similarity degree is low” in content ratio. In the case of the chemical substance that “is not contained” according to the information provided by suppliers, the target component is compared with the similar component in terms of whether containing or not containing and is determined as “similarity degree is low” in the same way.
When the system is used at a design stage, a user 811 may possibly be design staff, quality assurance staff, or procurement staff. The system receives a target components list 801 which is inputted by the user through an input means 802, and generates a priority list of components to be analyzed 804 via a components information evaluation means 803. The evaluation means 803 is connected to a database managed by user's company 805 via a network 814 and is capable of obtaining components information including similar components. The system outputs the priority list of components to be analyzed 807 to the user via an output means 806. In the outputted priority list of components to be analyzed, item codes of components, the name of a substance group with lowest accuracy, and determination reasons are described (list 708 in
When filing a request for analysis 808, the user can also send the priority list of components to be analyzed 807 to an analyzing company. In the operational flow, there is something that must be done before filing a request with the supplier for reinspection so as to recognize the determination result of the system. Also in this case, the analyzing company intensively analyzes the substance groups with low accuracy based on the contents outputted to the priority list of components to be analyzed 807. The accuracy of the information provided by third parties is effectively enhanced through the operational flow.
When the system is used at a manufacture stage, the user may possibly be manufacture staff, quality assurance staff, or procurement staff. While an operational flow used at the manufacture stage does not basically differ from that used at the design stage, the components list prepared by the user sometimes includes lot numbers, serial numbers or the like, which allow the recognition of individual component data, in addition to item codes.
In this case, a case is assumed in which the system is used by assembly manufactures as well as suppliers. First, the system receives a components list 901 and evaluation conditions 902 through an input means for the assembly manufactures.
An exemplary input interface screen of the evaluation conditions 902 is shown in
The system receives the evaluation conditions 902 to generate a priority list of components to be analyzed 905 via a component information evaluation means 904. Then, the system retrieves information such as a mail address or the like of the supplier from a database managed by user's company 916 to file a request for registration from an output means 919 for the supplier via a network 908, and transmits a reinspection request 909, a priority list of components to be analyzed 910, and a content guarantee format 911 to a supplier 918.
In the present embodiment, the output means 919 for the supplier directly files a request with the supplier for registration via a network 908, thus needing no manual operations by the assembly manufacture 917. In order to achieve this, supplier basic information Table 1104 is stored in the database-managed by user's company 916. Since item codes are specified in the components list 901, (one or a plurality of) suppliers for the item codes are specified via component basic information Table 1103 that is held in the database managed by user's company 916, and basic information, such as the name, mail address, address or the like of the staff on duty of the supplier, is linked from the supplier basic information Table 1104 by using a supplier's code as a key. While some of the supplier basic information is illustrated in
User basic information on the side of a customer, besides the supplier basic information, can also be linked to the item code in a similar way. For example, a registration request is performed by procurement staff of almost all manufactures. When managing the procurement staff for each item code, the item code is linked to the procurement staff code from component procurement information Table 1102. Then, the item code is linked to the name, mail address, or the like of the procurement staff from procurement basic information Table 1101 by using company code, business place, staff code as a key. By linking basic information on the customer side as well as on the supplier side to the item code in this way, it becomes possible to perform the registration request not only by E mail via the network, but also by direct mail or the like.
Alternately, the supplier can download a reinspection request 909, a priority list of components to be analyzed 910, and a content guarantee format 911 directly from the system via the network 908. When performing the registration request by mail, the system can not only mail a reinspection request, but also append the priority list of components to be analyzed 910 and the content guarantee format 911 to the mail at the same time. In the content of the reinspection request mail 909, a reply deadline of the reinspection and a contact point serving as a window to the customer are described. This information is held in the database managed by user's company 913.
The content guarantee format 911 guarantees the composition of the chemical substances contained in the components to be reinspected. In addition to 6 substance groups (Cd, Pb, Cr(VI), Hg, PBB, PBDE) which are regulated by the RoHS directive, substance groups that are determined to be possibly inaccurate in the priority list of components to be analyzed 910 may also be included in the substance group to be guaranteed in content thereof. The supplier can complement the information such as a content ratio, a contained site, or an object of the target chemical substances to the content guarantee format 911 outputted by the system, access to the database managed by user's company 916 from the input means for supplier 915 via the network 914, and perform the registration of the content guarantee 913.
It is possible to facilitate the procurement of components and to reduce man-hours for design and approval by making the information communication means between the own company (the assembly manufacture) 917 and the supplier 918 seamless in accordance with the present embodiment.
It should be noted that while the present embodiment includes the composition of chemical substances contained in components as attribute information to be evaluated, and components belonging to the same component classification as comparison targets, a combination of attribute information and comparison targets to which the present invention can be adapted is not limited to them. The present invention is also adaptable to the information which is provided by third parties and of which truth is difficult to determine. Here, the third party includes an entity having a data generation function such as measurement equipment or the like in addition to persons and corporations. The sample, to which the present invention is adapted, other than the chemical substance information of components is considered to include the following:
Environmental Load information such as CO2 emission, or energy usage at a component manufacturing stage. Components that belong to the same component classification, and are used as comparison objects.
Information on materials that constitute the components. Components that belong to the same component classification, and are used as comparison objects.
Specification values of components and errors in the specification values. The components that belong to the same component classification, are similar in the unit price, and are used as comparison objects.
There are other examples to which the present invention is adaptable even in a field that has nothing to do with assembly manufactures as follows:
Health checkup data of examinees (blood pressure, blood sugar level, or the like). Health checkup data of examinees of the same sex and age that are used as comparison objects.
Environmental Load information such as CO2 emission and energy usage during operation of a machine. Machines having the same functions that are used as comparison objects.
It should be further understood by those skilled in the art that although the foregoing description has been made on embodiments of the invention, the invention is not limited thereto and various changes and modifications may be made without departing from the spirit of the invention and the scope of the appended claims.
Number | Date | Country | Kind |
---|---|---|---|
2005-263960 | Sep 2005 | JP | national |