Patent Application
20050120072
The present invention relates to a data exchange system among cooperative companies, in which a plurality of domestic and international different companies partially take charge of a series of manufacturing steps of a product to be manufactured and manufacturing data regarding the product is mutually transmitted and received surely and effectively among the companies in cooperative production.
Conventionally, since semiconductor manufacturing companies each build up their own production management systems so that their O/S, software and database are different from each other, it is difficult that the series of semiconductor manufacturing steps are shared by a plurality of companies in various reasons. However, conventionally, the series of semiconductor manufacturing steps have been shared by ordering to outside factories. In this case, in fact, the production management system is mainly organized by a parent company and the outside factory is forced to follow the production management system of the parent company. In addition, with regard to production management information also, the outside factory only receives it through LAN connection to the parent system.
According to a recent foundry production system (cooperative production system by a plurality of cooperative companies), a merit in bidirectional and rational system is demanded in the conventional method of transmitting and receiving the production management information, and it is found that a production management cost is substantially increased and a profit is not turned when a system where the ordered side is compelled to follow is employed. In addition, according to the conventional sharing of manufacturing steps and manufacturing management system in a company group, data is collected from the outside factory to the parent company in one direction and the information is taken in the database in the parent company and initiatively used by the parent company. This system initiated by the parent company is carried out also when the company has an international base as well as domestic base.
Meanwhile, there is a method in which data is provided on the Web unilaterally, and a person in charge of using the data accesses that data and downloads and takes it in his own database to use it, if necessary. For example, Japanese Unexamined Patent Publication No. 2001-312536 discloses a method in which most recent information from an information provider is disclosed on the Web and the updated information is sent to a specific person in charge by attaching it to e-mail if required.
For example, in a case where an ordering company D orders a company W which is in charge of wafer manufacturing steps and a company A which is in charge of assembling steps, to manufacture a product P, it is necessary to exchange information such as daily in-process information, progress information, yield information and quality information between the company W and the company A in a certain cycle. In addition, it is necessary for the company A which is in charge of the assembling steps to provide information such as quality information, final test data and defective category information every time each assembling step is completed to the company W which is in charge of the wafer manufacturing steps, and also it is necessary for the company W and the company A to sent the completion information to the ordering company D in a certain cycle. The present invention is not limited to the above three companies such as D, W and A, and it is an object of the present invention to enable data to be exchanged effectively and inexpensively over a plurality of companies in two-way direction.
According to the conventional technique, that is, Japanese Unexamined Patent Publication No. 2001-312536, for example, the overseas ODM company has to connect to the internet and download desired information on the Web.
This method of disclosing the information is described hereinafter. For example, when the above company D, W and A each disclose information on the Web, the company D updates data on its own website and sends a fact that the information is updated and URL for accessing the updated information to the companies W and A by e-mail. The companies W and A access the website from the informed URL. Similarly, the companies W and A also update data on their own websites and send the updated information to the other companies.
The person in charge who received the mail has to manually access the website through the informed URL from a terminal which can be connected to the internet. In order to download it in its own database, the person in charge has to manually input the data while referring to the website. Therefore, a lot of labor is needed.
In addition, when a certain company takes a long vacation or the person in charge is absent, the progress information or the shipment information of the product cannot be obtained or the data is not updated sometimes. Accordingly, the data of one's own could not be updated.
According to the present invention, in order to solve the above problems, information items are standardized among companies in which information is exchanged, and information item to be transmitted or received is extracted and determined. In addition, when the description of the common information used among the companies are different, the common information items are specified as identifiers and a corresponding table for the identifiers used in each company is defined. Furthermore, a collecting cycle and an updating cycle of the information is decided using the identifier as a keyword, and the information is transmitted or received among the companies to each other.
In general, lot numbers and product type names cannot be commonly used because they are standardized for convenience of the manufacturing system in each company. The cooperative companies cannot decide to which system the information of the product to be manufactured is downloaded from the product type names or lot numbers in a contracted company. Therefore, it is necessary to convert them to the lot numbers and the product type names for each cooperative company.
At this time, the items can be easily converted to those for each company by providing a conversion master even when the plurality of companies partially take charge of the manufacturing steps. In addition, even when a new contract is completed with a new company, the new company can be easily adapted by adding its items to the conversion master.
Thus, the burden for a person in charge of developing the system is reduced and development period is shortened.
Standardization of the information items comprises a reception information item table for use in a specific company to receive the information and a transmission information item table for use in the company to transmit the information.
The data exchange system among cooperative companies of the present invention exchanges data mutually among the plurality of cooperative companies handling cooperative production, which periodically collects or retrieves at least one of product progress information, quality information and business information of one's own company, standardizes and edits data for transmission to the cooperative companies, exchanges data between one's own company and the other company, outputs transmission data file in a predetermined format as an attached data of e-mail, automatically and periodically transmits the e-mail to the cooperative companies, and receives e-mail corresponding to the above from the cooperative companies.
According to a data exchange system among cooperative companies of the present invention, a conventional function of a data exchange system for a subcontracting company is extended such that each cooperative company may have more even function to enable bidirectional data exchange, and enable the data required for cooperation to be automatically and directly transmitted only to the company which needs the data, in a desired cycle without manual operation. In addition, since a common information web is not used and the data is directly transmitted to the company which needs the information, a security problem among the plurality of cooperative companies can be relieved.
Therefore, according to the present invention, the data exchange system among cooperative companies comprises a mailing system in which production progress information and quality information are standardized and collected in a predetermined cycle in each company of different cooperative companies and automatically and mutually transmitted to the cooperative companies with a file in CSV format, for example, attached to e-mail by a scheduling function of a data exchange server, a production management system, a business management system, and a web system. As a result, a progress condition, a dispatch condition and quality information of the products can be mutually confirmed in each predetermined cycle among cooperative companies.
Hereinafter, embodiments of the present invention are described with reference to FIGS. 1 to 10.
An embodiment 1 of the present invention is described with reference to
In addition, when the data is exchanged among the cooperative companies, it is necessary to convert ID data such as company's names, production names, production lot numbers, inspection lot numbers and overseas time lags among the other companies. Thus, correspondence between data of the others and data of one's own can be understood among the cooperative companies. A conversion master 60 is used in this data conversion.
E-mail is used in the data exchanging among the cooperative companies and the data is exchanged by being attached to the e-mail. The format of the attached data has been previously decided among the cooperative companies (CSV format, for example) so as to be mutually readable. The e-mail is transmitted to a cooperative company's mail server 100 from a mail server 50 in the company through the internet. The data transmitted by e-mail is automatically and periodically taken into a data exchange server 10 in the other company and read and processed. A fire wall is provided between the company and the internet as occasion demands. The intranet is provided in data exchange in the company as occasion demands.
This system is constituted by the following:
A processing program in the data exchange server 10 receives transmission time of each of data 21 and 31 sent from the production management system 20 and the business management system 30 by the scheduling functions thereof into a date table 62 in the data exchange server 10 and compares them with the date of the data taken in the past.
When the data is not new, a predetermined upper limit value is set in the number of retries and waits for the data by repeating the retry. When the retry number exceeds the upper limit value, the fact that the data files 21 and 31 have not arrived (there could be a trouble) is sent to persons in charge of the production management system and the business management system by e-mail. When the fact that the data is new is confirmed, the process is moved to the next step of data editing.
The data exchange sever 10 decides data transmission schedules for the other companies by type of data in view of schedules of the production management system 20 and the business management system 30 and the like in the company, waits for the data as described above if necessary, and transmits the data to the other companies with a periodical schedule.
Since the specific production type names and the lot numbers in a company cannot be used in other companies, the conversion master 60 in the data exchange server is used in that case.
In addition, quality information is retrieved from the quality management system 40 using the lot numbers of data sent from the production management system 20 and the business management system 30, and the retrieved result is written in the file in CSV format.
The file in CSV format is compressed with a password in view of security.
The compressed file is attached to e-mail and sent to persons in charge in the cooperative companies which have been previously registered and to a person in charge in the own company.
A dispatched product is tested in the cooperative companies. The result of the test is output to a text-based file and compressed with a password and attached to e-mail to be transmitted to mail addresses previously registered.
A file reception program retrieves the mail stored in the mail server 50 in the company which is sent with a predetermined subject, and when there is a corresponding mail, takes the attached file into the data exchange server 10 with the body of the mail.
Then, the reception program decompresses the attached file in compressed file format with a password and adds the content of the file in which the test data is written to a quality data table in the data exchange server 10.
The file in which the test data is written is moved to a folder which can be viewed with Web browser so that it can be viewed from a terminal 80 in each section in the company connected to an intranet 85.
When an error is generated in the above processing, a mail indicating that is sent to a person in charge of browsing. Thus, the stored test data can be browsed from the terminal 80 in each section in the company connected to the intranet 85.
The test data can be viewed in a table form (
An embodiment 2 of the present invention is described with reference to
This embodiment shows a method and means for transmitting and receiving data using FTP in the data exchange system among cooperative companies shown in the embodiment 1. In addition, according to an aspect of this embodiment, it is considered that communication protocol in the company is based on HTTP and communication protocol among external cooperative companies is based on FTP.
Referring to
This system is constituted by the following:
A transmission program in the data exchange server 10 receives transmission time information of each of data 21 and 31 sent from the production management system 20 and the business management system 30, respectively by the schedule functions thereof, into a data check table (data table 62) in the data exchange server and compares them with the date of data taken in the past.
When the data is not new, a predetermined upper limit value is set in the number of retries and repeats the retry. When the number of retries exceeds the upper limit value, the fact that the data files 21 and 31 have not arrived (there could be a trouble) is sent to persons in charge of the production management system and the business management system by e-mail.
When the fact that the data is new is confirmed, the process is moved to the next step of data editing.
Since the specific production type names and the lot numbers in a company cannot be used in the other companies, the conversion master 60 (
In addition, quality information is retrieved from a quality management system 40 using the lot numbers of data sent from the production management system 20 and the business management system 30, and the retrieved result is written in the file in CSV format. The file in CSV format is compressed with a password in view of security.
The compressed file with the password is transmitted to the FTP server 110 of a designated cooperative company outside of the fire wall 130, using a proxy server which can pass through the fire wall. As the proxy server, a proxy server software such as Curl can be used.
Normally, in order to perform transmission to the FTP server outside of the fire wall 130, it is necessary to set an FTP server for transmission. However, when this method (proxy server) is used, the transmission can be performed to the FTP server outside of the fire wall 130 without setting the FTP server for transmission.
A dispatched product is tested in the cooperative companies. The result of the test is output to a text-based file and compressed with a password and transmitted to the FTP server 140 in the (own) company.
A file reception program which is periodically carried out is sent with a predetermined subject, retrieves the file stored in the FTP server 140 and when there is a corresponding file, takes the file into the data exchange server.
Then, the reception program decompresses the attached file in compressed file format with the password and adds the content of the file in which the test data is written to a quality data table in the data exchange server 10.
The file in which the test data is written is moved to a folder which can be viewed with Web browser so that it can be viewed from a terminal 80 in each section in the company connected to an intranet 85.
When an error is generated in the above processing, a mail indicating that is sent to a person in charge of browsing. Thus, the stored test data can be browsed from the terminal 80 in each section in the company connected to the intranet 85.
The test data can be viewed in a table form (
As described above, according to the present invention, information required from the cooperative company such as the progress condition, a dispatching condition and quality information of the product to the cooperative companies can be periodically provided. In addition, since the test result can be obtained from the cooperative companies, a yield of a future product can be improved. That is, data can be extracted among the cooperative companies bidirectionally. In addition, since a general-purpose server or a free use software is used, the system can be constituted at low cost.
There is provided a data exchange system among cooperative companies, which standardizes information items among companies in which information is exchanged, and extracts and determines the information item to be transmitted or received, so that information such as the progress condition, a dispatching condition and quality information of a product, which cooperative companies requires can be periodically provided.
| Filing Document | Filing Date | Country | Kind |
|---|---|---|---|
| PCT/JP03/00235 | 1/15/2003 | WO |
