CN1160647C - Information comprehensive service platform - Google Patents

Abstract

An integrated information service platform (ISP). In real-time data access mode, the integrated information service platform of the present invention includes at least an engineering data analysis database (EDB); an area controller database (AC Database); a website server; and client computers and other components. In data access mode at specific intervals, the present invention includes at least an engineering data analysis database; an area controller database; a loader server (Loader); a website server; and client computers and other components. By using the integrated information service platform of the present invention, the user of the client can access the desired data using a browser, and because the data is accessed through a browser, there is no trouble in maintaining the client.

Description

Information Integrated Service Platform

technical field

The present invention relates to an information integrated service platform (Integrated Service Platform; ISP), in particular to an information integrated service platform used in a manufacturing execution system (Manufacturing Execution System; MES) of a wafer factory.

Background technique

Chip manufacturing plants can be divided into three categories according to their main business content. The first category is chip foundries, emphasizing manufacturing technology and customer service orientation. The second category is dynamic random access memory (DRAM) factories, which start by purchasing technology, or although the technology is independent, they still have to rely on the parent company's OEM to avoid business risks. The third category is the comprehensive component manufacturing plant. In order to fill the capacity of their own chip factories, such manufacturers must have a fairly broad product line. That is to say, a lot of money, manpower, and time must be spent on product design, marketing, and improvement of manufacturing technology at the same time, and the management difficulty is quite high. Its strategy will emphasize providing complete solutions for downstream customers, that is, IC groups that meet customer needs at one time, in order to strive for long-term cooperative relationships with customers.

The above-mentioned three types of wafer fabs must go through the process of Computer Integrated Manufacturing (CIM) to make good use of various manufacturing resources by controlling the flow of products and information. The so-called computer-integrated manufacturing refers to a production automation system that uses computers as tools, centers on databases, and quickly sends the data in the databases to users through computer networks or integrates various automation equipment into a whole. Semiconductor International (Semiconductor International) journal once pointed out in January 1997: The introduction of computer integrated manufacturing system is an important task for the establishment of new factories and the continuous development of old factories. And manufacturing execution system is the core of computer integrated manufacturing.

Manufacturing execution system is a real-time online computer system that integrates various relevant information in the production process. It has functions such as data collection, work in process (WIP) tracking, material management, inventory management, exception management, and quality management. IC production steps are complicated, processing equipment is expensive, there are many types of products, and the product life cycle is short. Therefore, for IC manufacturers, a manufacturing execution system is very much needed to manage the production site, so as to meet the ever-changing needs of customers and meet the competition in the e-era with challenges. MES can assist IC manufacturers to collect on-site data, convert the data into useful information, control the production site, and achieve the goal of factory automation management and maximum efficiency.

The manufacturing execution system is a very large software system, which involves a wide range of knowledge fields, and the money and manpower required to develop the manufacturing execution system are even more astonishing. Taking Macronix as an example, its No. 2 wafer factory officially started mass production in March 1997, making its production capacity and manufacturing technology capabilities more in line with market demand. While continuing to expand the factory, we further cooperated with International Business Machine (IBM) to plan a computer integrated manufacturing system, and introduced the world's most advanced information technology and tools - Poseidon Manufacturing Execution System. It can achieve comprehensive and highly computerized, and provide flexible and highly integrated services.

Please refer to Figure 1 for the structure diagram of the existing Poseidon system. Poseidon system 10 includes on-site control (Floor Control) 100, basic data (Basic Record; BR) 110, scheduling and inventory control (Scheduling & Bank Control) 120, machine control system (Tool Control System; TCS) 130, Central Monitor 140, Report System 150, Transfer System 160, Statistical Process Control (SPC) 170, Engineering Data Analysis (EDA) 180, and external interfaces (External Interface) 190 and other subsystems. Among them, the transport system 160 also includes mask storage (Reticle Stocker) 162, inter-aisle transport system (Interbay Transfer System) 164, and in-aisle automatic guided cart system (Intrabay Automated Guided Vehicle System) 166 and other subsystems. In addition, the external interface 190 also includes a corporate information system (Corporation Information System; CIS) 192.

As mentioned above, the Poseidon system includes multiple subsystems, and it is not easy for client users to obtain information about these subsystems. Usually, it is necessary to install a special reporting system on the client, or use manual methods to obtain the data that the user wants. If there is an integrated network information service platform, the above-mentioned shortcoming that the user of the client terminal is not easy to access data can be easily solved.

In view of the above-mentioned background of the invention, it is not easy for the user of the client terminal to obtain the information of each subsystem of Poseidon. Usually, it is necessary to install a special reporting system on the client, or use manual methods to obtain the data that the user wants.

Contents of the invention

In order to overcome the deficiencies of the prior art, the object of the present invention is to provide an integrated information service platform, which can be used as the portal website of each network subsystem. Each network subsystem has its own characteristics and functions.

Another object of the present invention is to provide an integrated information service platform, which can be used to allow users of the client to access the desired data by using a browser, and because the data is accessed through the browser, there is no need to maintain the client. terminal troubles.

In order to achieve the above purpose, the present invention provides an information integrated service platform. The integrated information service platform of the present invention includes two types of data access methods. The first type of data access method is real time (Real Time). In this real-time mode, the integrated information service platform of the present invention at least includes an engineering data analysis database (Engineering Data Analysis Database; EDB); an area controller database (Area Controller Database; AC Database); a web server, and this web server is connected to this an engineering data analysis database and the regional controller database; and a plurality of client computers, connected to the web server. The second type of data access mode is every specific period. In this mode at intervals of a specific period, the integrated information service platform of the present invention at least includes an engineering data analysis database; a regional controller database; a loading server (Loader), which is connected to the engineering data analysis database and the regional controller a server database; a web server having a structured query language database connected to the loading server; and a plurality of client computers connected to the web server.

The present invention has the advantages of multi-person multitasking, search engine, fast execution speed, compatibility with Office software, direct browser access to data, distributed Internet structure, easy maintenance, and three-tier structure. Using the integrated information service platform of the present invention, the user of the client can access the desired data by using the browser, and because the data is accessed through the browser, there is no need to maintain the client.

Description of drawings

Below in conjunction with accompanying drawing and embodiment the present invention is described in detail:

Figure 1 is a structural diagram of the existing Poseidon system;

Fig. 2 is the system structural diagram of the integrated information service platform of a preferred embodiment of the present invention; And

FIG. 3 is a system architecture diagram of an integrated information service platform in another preferred embodiment of the present invention.

Explanation of symbols in the figure:

10 Poseidon system 100 On-site control

110 Basic Information 120 Scheduling and Inventory Control

130 Machine control system 140 Central monitor

150 Reporting System 160 Conveyor System

162 Mask Storage 164 Aisle Conveyor System

166 Automatic guided cart system in the aisle

170 Statistical Manufacturing Control 180 Engineering Data Analysis

190 External Interface 192 Enterprise Information System

200 Engineering data analysis database 210 Regional controller database

220 Web Server 230 Active Server Pages (ASP)

240 Component Object Model + (COM+) 250 First Server

260 second server 270 client computer

280 Client computer 400 Engineering data analysis database

410 Regional Controller Database 420 Web Server

430 Active Server Pages (ASP) 440 Component Object Model + (COM+)

450 First server 460 Second server

470 client computer 480 client computer

490 load server 500 structured query language database

Detailed ways

The invention relates to an information comprehensive service platform. The integrated information service platform of the present invention is used in an enterprise internal network (Intranet). First of all, this information integration service platform uses the concept of COM+, the latest version of Microsoft's Component Object Model (COM), to develop the objects required by the system. COM+ objects are multi-threaded, allowing simultaneous access by many users at the same time. This practice gives the program the benefit of parallel processing and speeds up program execution.

Secondly, the integrated information service platform of the present invention provides a website environment for users to access data, so that users of the client end can access the data they want by using a browser. This browser can be, for example, Microsoft Explorer 5 ( Internet Explorer 5; IE5), but not limited to. And because the data is accessed through the browser, there is no need to maintain the client. In addition, the website server of the integrated information service platform of the present invention has a built-in search engine, which allows the user of the client terminal to find the desired report after inputting keywords on the browser. This search engine uses Microsoft Index Server (Microsoft Index Server) to structure, and places all files in specific places according to their characteristics, so that the index server can find them easily.

Furthermore, the reason for accelerating the program execution speed of the integrated information service platform of the present invention is to adopt the method of "pre-running". The method of "pre-running" is to pre-generate the data needed every day, such as the data needed for management or production.

In addition, the integrated information service platform of the present invention also uses Microsoft's Distributed interNet Architecture (Distributed interNet Architecture; DNA) concept to design the entire system. Collected to the server. This approach can reduce the burden on the server, so that the server has the ability to deal with other work without having to deal with many complicated reports.

In addition, the integrated information service platform of the present invention has a three-tier structure. In this three-tier architecture, objects in the middle layer can participate in different applications and be shared by each application, that is, these objects are reusable. The application program at the bottom layer (client) only communicates with objects in the middle layer, and does not directly communicate with the database server at the top layer (server side), so that the front and back ends can be independent, increasing the flexibility and scalability of the system. In other words, in this three-tier architecture, there is only one connection point to the database server, which is different from the general client-server architecture that has multiple connection points to the database. This three-tier architecture has the following advantages. The first is that the client-side application program will not be affected by the diversity components of the server-side, for example, the client-side application program does not have to consider the database used by the server-side. The second is that the client-side application is no longer tied to the server-side complex network components. The third is to avoid the inconsistency (Inconsistency), lack of reusability (Reusability), and lack of flexibility (Flexibility) caused by the two-tier architecture that focuses too much on the client or server.

The reports and charts obtained on the browser of the client through the integrated information service platform of the present invention can be directly pasted into Word or Excel for further processing by the user.

Furthermore, the integrated information service platform further includes a mechanism for checking the usage times of each function of the integrated information service platform, and this mechanism can be used to query the usage rate of each function.

Please refer to FIG. 2 , which is a system structure diagram of an integrated information service platform in a preferred embodiment of the present invention. The data access mode among Fig. 2 is real-time (Real Time), and the integrated information service platform of the present invention under this real-time mode comprises engineering data analysis database 200, regional controller database 210, website server 220 etc. The web server 220 can be, for example, a cluster web server. The so-called group means that multiple computers are integrated into one. Even if one computer stops, other computers will immediately take over the work of the stopped computer. The website server 220 is connected to the engineering data analysis database 200 and the regional controller database 210 . The website server 220 also has an active server page (Active Server Page; ASP) 230 interface. In addition, the integrated information service platform also includes a plurality of client computers 270 and a plurality of client computers 280 connected to the website server 220 .

Fig. 2 also includes a first server 250, in order to connect the client computer 270 to the website server 220, wherein the first server 250 is used to serve the client in the factory area where the engineering data analysis database 200 and the regional controller database 210 are located computer 270, and the first server 250 judges whether the client computer 270 has the authority to access the data of the first server 250 with an Internet Protocol address (Internet Protocol; IP).

Also include second server 260 in Fig. 2, in order to make client computer 280 connect to this website server 220, wherein this second server 260 is in order to service engineering data analysis database 200 and the multi-site outside the factory area where regional controller database 210 is located. A client computer 280 of a related business group company, and the second server 260 judges whether the client computer 280 has the authority to access the data of the second server 260 by using the user name and password.

Please refer to FIG. 3 , which is a system architecture diagram of an integrated information service platform according to another preferred embodiment of the present invention. Another preferred embodiment of the present invention includes two types of data access methods. The operation of these two types of data access methods will be described in detail below.

The first type of data access mode is real-time. In this real-time mode, the integrated information service platform of the present invention includes engineering data analysis database 400, regional controller database 410, website server 420 and so on. The website server 420 can be, for example, a group server. The website server 420 is connected to the engineering data analysis database 400 and the regional controller database 410 . The web server 420 also has an active server web page 430 interface. In addition, the integrated information service platform also includes a plurality of client computers 470 and a plurality of client computers 480 connected to the website server 420 .

The second type of data access method is every specific period, where every specific period can be, for example, daily, weekly, or monthly. In this mode at intervals of a specific period, the integrated information service platform of the present invention includes an engineering data analysis database 400; a regional controller database 410; a loading server 490, and this loading server 490 is connected to the engineering data analysis database 400 and the regional controller. The server database 410; the website server 420 has a structured query language database 500, and the structured query language database 500 is connected to the loading server 490; and the client computer 470 and the client computer 480 are connected to the website server 420. The web server 420 also has an active server web page 430 interface.

Fig. 3 also includes a first server 450, which is used to connect the client computer 470 to the website server 420, wherein the first server 450 is used to serve the clients in the factory area where the engineering data analysis database 400 and the regional controller database 410 are located computer 470, and the first server 450 judges whether the client computer 470 has the authority to access the data of the first server 450 by an Internet Protocol address (Internet Protocol; IP).

Also included in Fig. 3 is a second server 460, in order to connect the client computer 480 to the website server 420, wherein the second server 460 is used to serve engineering data analysis database 400 and multiple sites outside the factory area where the regional controller database 410 is located. A client computer 480 of a related business group company, and the second server 460 judges whether the client computer 480 has the authority to access the data of the second server 460 with the user name and password.

As those skilled in the art understand, the above descriptions are only preferred embodiments of the present invention, and are not intended to limit the scope of patent protection of the present invention; all other equivalent changes that do not depart from the disclosed spirit of the present invention are completed Or modification, all should be included in the scope of protection of the present invention.

Claims (7)

1. information comprehensive service platform, it is applicable to the manufacturing system of wafer factory, this information comprehensive service platform comprises at least:

One engineering data analyse data-base, it stores the data of this manufacturing system;

One zone controller database; And

One Website server, this Website server are connected to this project Data Analysis Data Base and this zone controller database respectively, but and access this project Data Analysis Data Base and this zone controller data of database, this Website server also comprises at least:

One first server, a plurality of first client computers of on-site in order to service this project Data Analysis Data Base and this zone controller database place, make these first client computers be connected to this Website server, wherein this first server is to judge with Internet protocol address whether these first client computers have authority access first data in server, and this first data in server is from this project Data Analysis Data Base or this zone controller database; And

One second server, a plurality of a plurality of second client computers that concern cause group company in order to service this project Data Analysis Data Base and this zone controller database place plant area, wherein this second server is to judge with user's name and password whether client computer has the data of authority access second server, and the data of this second server are from this project Data Analysis Data Base or this zone controller database.

2. information comprehensive service platform according to claim 1 is characterized in that: this Website server is an a group group network server.

3. information comprehensive service platform according to claim 1 is characterized in that: this website servomechanism has an active server web-page interface.

4. information comprehensive service platform according to claim 1 is characterized in that: this Website server is to use the idea of a Component Object Model to develop a plurality of objects of this information comprehensive service platform.

5. information comprehensive service platform according to claim 1 is characterized in that: this Website server is with real-time mode access this project Data Analysis Data Base and this zone controller data of database.

6. information comprehensive service platform according to claim 1 is characterized in that: also comprise a Search engine, in order to find required data behind input one keyword on the browser of each these client computer.

7. information comprehensive service platform is applicable to the manufacturing execution system of a wafer factory, and this informix server comprises at least:

One engineering data analyse data-base, wherein this project Data Analysis Data Base stores the data of this manufacturing execution system;

One zone controller database;

One load server, this load server are connected to this project Data Analysis Data Base and this zone controller database respectively; And

One Website server, it also comprises at least:

One Structured Query Language (SQL) database, wherein this Structured Query Language (SQL) database is connected to this load server, this load server is in advance data or this zone controller data of database of this project Data Analysis Data Base to be put in order in the mode every between a given period, places this Structured Query Language (SQL) database again;

One first server, a plurality of first client computers in order to service this project Data Analysis Data Base and this zone controller database place on-site, make these first client computers be connected to this Website server, wherein this first server judges with Internet protocol address whether these first client computers have this first data in server of authority access, and this first data in server is from this Structured Query Language (SQL) database, this project Data Analysis Data Base or this zone controller database; And

One second server, a plurality of a plurality of second client computers that concern cause group company in order to service this project Data Analysis Data Base and this zone controller database place off-site, wherein this second server is to judge with user's name and password whether client computer has the data of this second server of authority access, and the data of this second server are from this Structured Query Language (SQL) database, this project Data Analysis Data Base or this zone controller database.

Images