JP2002041465A - Communication system, database server, controller, processing terminal, relay server and manufacturing method of semiconductor device - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a database operation environment, in which security can easily be maintained and database operation can be performed efficiently. SOLUTION: A computer terminal (PC11) transmits an image program (111A) for presenting an image function to a database server (21) via a communication function (114) by using a logic call function. The database server (21) has an operation logic program, corresponding to the image program, starts a designated operation logic, generates an SQL transmission message and accesses a database (211).

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a communication system for performing communication between a database server and a computer terminal, a component thereof, and a method of manufacturing a semiconductor device using the communication system. The present invention relates to a communication system for performing high-speed and efficient communication with a computer terminal while ensuring security. More specifically, the present invention relates to a communication system for a database system that accesses a relational database using a structured query language (SQL language) and a method for manufacturing a semiconductor device using the communication system.

[0002]

2. Description of the Related Art The present invention is effective for general database systems in general. However, in particular,
The present invention is more effective in a relational database (relational database system; RDBS) using a SQL language (structured query language), which has been widely used worldwide, and a system using a personal computer terminal. Therefore, in the following, S
The features of the QL language and the relational database system and a general data manipulation method from a terminal using the same will be described.

[0003] A database is generally an aggregate of data, and a file system is conventionally used for data management. A relational database system is considered as a collection of tables by an end user who operates a computer terminal. The table corresponds to, for example, imaging that a “spreadsheet” is collectively included in the database, and is made up of rows and columns. That is, in this relational database system, when an end user (computer terminal) queries a database for a search, the corresponding result is returned in the form of a table. The SQL language is used to access the relational data bus.
In the SQL language, a data definition language DDL, which is a statement for defining a table for storing data, is stored (or stored) in a database.
A data manipulation language (DML) indicating statements for manipulating data, and a data control language D including statements used for setting authority (security) for database objects and controlling transactions.
CL. The data manipulation language DML is SELE
CT (search for data), UPDATE (update data), INSERT (insert data), and DELE
Four statements of TE (deletion of data) are prepared.

FIG. 28 is a diagram schematically showing a configuration of a conventional large-scale database system. In FIG. 28,
The database system includes a plurality of distributed sites # 1, # 2 and # 3. Sites # 1, # 2, and # 3 have database servers 21, 22, respectively.
And 23 are arranged. Each of these database servers 21 to 23 stores a large amount of data (particularly information content is not specified) in a database DB on a computer and centrally manages the data by the computer.

[0005] In site # 1, computer terminals 11-14 (computer terminals, such as personal computers, which may be a front end, and will be indicated by reference numeral PC hereinafter) for searching data in a database are arranged. Site # 1-
Regarding # 3, there are no restrictions on the size and location of the region, building, office, etc., as well as in Japan and overseas.

At site # 1, all PCs 11-14 included in site # 1 can be connected to database server 21, and all PCs 11-14 can access data in database DB of database server 21. In FIG. 27, the search request is shown as one access content.

[0007] PCs 11-14 of site # 1 and site # 2
And the database servers 22 and 23 of # 3
The connection can be made via the network 4. The network 4 is a network such as the Internet and an intranet, and realizes communication connection between sites.

In order to allow the PC 11-14 included in the site # 1 to be connectable to all the database servers 21, 22 and 23, communication between the database server 21-23 and all the computers of the PC 11-14 is enabled. You need to open connection routes so that
The establishment of this connection route is called routing). For example, PC11-database server 21, PC11-database server 22, PC11-database server 23, PC12-database server 21, PC12-
Database server 22, PC12-database server 23, PC13-database server 21, PC13
It is necessary to permit the connection of the database server 22, the PC 13, the database server 23, the PC 14, the database server 21,. If the connection route is opened to enable communication between all the computers,
There is no problem if C can connect to any database server. However, from the viewpoint of security, i) when it is desired to define security so that only a specific PC can connect to a specific database server, and ii) computers (PC and database server) in a certain site can be freely connected, On the other hand, there is a case where it is desired to define security for communication between sites. When such security is defined, connection authority is given using a unique address (called an IP address in the Internet and an intranet) of each computer (PC and database server). FIG.
In the above, the IP addresses 11-14 are assigned to the PCs 11-14, respectively.
1 is assigned an IP address 21 and the database servers 22 and 23 are assigned an IP address 22
And 23 have been assigned.

For example, a security definition such as "address 1 can be connected to addresses 2, 4, and 5, and address 2 can be connected to addresses 1, 5, and 8" using an IP address is defined. You need to do it. n PCs for m database servers
Is arranged, it is necessary to define an m: n connection. This setting definition work (routing) is set up between a router or a network which is a communication device for interconnecting a plurality of local area networks (LANs) or when the network is connected to the Internet. This is performed on a network device called a firewall for preventing unauthorized access from the outside. These routers or firewalls are provided in the network 4 in FIG.

This setting definition work becomes more complicated as the size of the database system increases. Also,
When the address of the computer (database and PC) is changed and the security definition for permitting the connection is changed, the setting change work is particularly complicated. Such work increases the degree of complexity as the size of the database system increases, and is a major factor that complicates security management in a large-scale database communication system across sites.

FIG. 29 is a diagram schematically showing a configuration of a database search system using the SQL language as a database query language. In FIG. 29, the PC 11 is connected to the database server 21 via the private LAN 412. In the PC 11, a screen program 111 for displaying the operation content on the display screen and SQL communication software (S / S) for performing communication in accordance with the SQL language.
W) 117 are provided. The SQL communication software 117 and the screen program 111 exchange information with each other via an interface (I / F) driver 115. The required parameters are entered in each predetermined box interactively with, for example, a dialog box displayed on the display screen of the PC 11 by the screen program 111,
The operation contents of the screen function 113 are described. The screen program 111 inserts each parameter into an operation logic (program) corresponding to a box or the like on the display screen that is activated and displayed, defines the screen function 113, and converts the set parameters and operation contents into SQL. Change to a message.

The set operation contents of the screen function 113 are sent out in the form of an SQL message via the interface (I / F) driver 115 and the SQL communication software 117 by the operation logic included in the screen program 111. This PC 11 is a database server 21
When accessing the database server 21, the user accesses the database server 21 via the local LAN 412. The database server 21 also has SQL communication software (S / W) 21
2 are provided.

The database server 21 is provided with a relational database (RDB) 211 including tabular information 213, 214, and 215 called a plurality of tables grouped by information type.

Now, the relational database (R)
The table 1 (213) is searched as the screen function 113 for the tables 1 (213), 2 (214), and 3 (215) of the DB) 211, and the table 2 (214) is updated from the search result. An operation content for updating Table 3 (215) is defined. This screen function 113
Are executed under the control of the screen program 111. This operation (search / insert / update /
In the (delete) process, in order to access and operate (search / insert / update / delete) the table 1 (213), the table 2 (211), and the table 3 (215) described by the screen function 113, respectively. A database access command in the form of an SQL message is sent from the SQL communication software 117 to the PC 11 side, the local LAN 412, and the SQL communication software
Is transmitted to the database engine included in the database server 21 via The database engine accesses the relational database 211 according to the SQL message, executes the SQL that searches the table 1 specified in the first step CS1, and executes the SQL of the table 1 (213) indicating the execution result. It is returned to the PC 11 again via the SQL communication software 212, the local LAN 412, and the SQL software 117 (step CS2).

Therefore, one table 1 (213)
First, an SQL access command for instructing a search is transferred in step CS1, and data indicating the search result is transmitted to the PC via the local LAN 412 in step CS2.
11 is transferred.

Thereafter, from step CS3, under the control of the screen program 111, the SQL for updating the table 2 (214) is transferred to the database server 21 via the local LAN 412, and the relational database 21 is updated.
The first table 2 (214) is updated. This update result is returned from the database server 21 to the PC 11 again via step CS4. This step CS4
Is completed, the PC 11 again displays the screen program 11
Under the control of No. 1, the relational database 211 is accessed via the SQL communication software 117, the local LAN 412, and the SQL communication 212, and the table 3
(215) is updated. This updated table 3 (2
The data of 15) is again transferred from the database server 21 to the PC 11 via the local LAN 412.

The screen program 111 displays processing contents such as a dialog box or a window or a wizard, and inputs necessary parameters to the displayed contents or operates on a plurality of tables such as a graphic user interface. Is graphically displayed on the display screen, the screen program 111 converts all of these operation contents into the form of an SQL message. Therefore, the premises LAN 412
Above, only the SQL message is communicated.

When the operation contents of the screen function 113 are complicated, it is necessary to continuously operate (search / update / delete or insert) many tables of the relational database (RDB) 211. Therefore, many SQL messages are issued, and the operation results are returned to the PC 11 via the local LAN 412. Therefore, this SQL
If the transmission of the message and the return of the result are repeated many times, the time required for the communication via the local LAN 412 becomes longer, and it takes much time for one screen function 113 to be completed. In this case, the local LAN 41
2, the amount of traffic increases, and it is necessary to wait for another PC to access the database server 21, which causes a problem that processing efficiency is deteriorated.

FIG. 30 is a diagram schematically showing the configuration of the screen program 111. In FIG. 30, when the database operation program is started on the computer terminal PC, the screen program SP0 is first started as an initial screen in the database operation program, and the initial screen DS0 is displayed on the display screen of the computer terminal. In this display screen (window) DS0,
A menu MN indicating the contents of the operation is displayed, for example, in the form of an icon.

An operator (user) selects a menu MN displayed in a window on the display screen, and selects an operation A to be executed. When the operation A is selected, the corresponding screen logic program SP1 is started, and a dialog box DS1 corresponding to the operation A is displayed. In response to the screen logic program SP1, the logic LP1 in which the processing content is described by the SQL statement is simultaneously activated. The logic LP1 is provided with a logic number LN indicating the processing content, and the screen logic program SP0 is operated by operating the operation menu MN.
The logic LP1 and the corresponding screen logic program SP1 are activated with reference to the corresponding logic number. The dialog box BX of the operation A on the display screen DS1 by the operator
Required parameters are described, and necessary processing is defined by operating the operation button BT. The screen logic program SP1 transmits parameters described for the operation A (parameters such as a database name to be processed and a search item) to the logic LP1, and the logic LP1 is given to the SQL statement corresponding to the box BX. The parameters are inserted, and the processing content described by the operator is converted into a processing program in the form of an SQL statement on the display screen.

Next, for example, when the operator selects the next operation B by operating the button BT on this display screen (or returns to the initial screen and selects the next operation by a new menu). The corresponding screen logic program SP2 is activated, and a dialog box indicating the operation B is displayed on the display screen. The operator again describes necessary information in the box BX or defines necessary processing by operating the operation button BT. The processing content of this screen logic program SP2 is also S
The logic LP2 described by the QL statement is activated. In the logic LP2, a logic number LN indicating the logic and a flag or identifier F indicating the dependency or execution order with respect to the previous logic LP1
G is attached. With the number of the execution flag FG, a time series of the execution order and the processing content of the dependency relationship is stored.

Thereafter, this operation is repeatedly executed until all necessary processes are described. Therefore, in this processing, a plurality of screen logic programs SP1, SO2,...
1, LP2,..., The processing contents using the parameters described by the operator are described in SQL statements.

The screen logic programs SP1, SP
2, the whole is hereinafter referred to as a display screen program DPP,
The entire logic LP1, LP2,... Is hereinafter referred to as an operation logic program MLP. The screen function 113 indicates functions described and defined in the display screens DS0, DS1, DS2,..., And the screen program 111 includes the display screen program DPP and the operation logic program M
Includes both LPs.

Therefore, even if the operator interactively describes the parameters while looking at the dialog box, window or wizard on the display screen, the processing contents are all processed by the operation logic program MLP.
It is described by a QL statement. Logic L
The SQL statements in P1, LP2,.
8 is transmitted to the database server 21 via the SQL communication software 117 shown in FIG.

In the case of a table operation, the operations include search, insert, update, and delete processes. When the contents of the table operation become complicated, the number of SQL statements to be communicated increases, so that the screen function 113 is completed. It takes a lot of time until Therefore, when this network is enlarged, the traffic volume on the network increases, and the communication efficiency deteriorates.

In a single site, when the computer terminal (PC) 11 accesses the database server 21 via the local LAN 412, information is simply communicated through the SQL communication software 117 and 212. Since no logic for identifying a password or an IP address is arranged in the database server 21 (a relay device such as a router or a firewall is not provided), a network security function cannot be provided, and There is a problem from a management point of view.

FIG. 31 is a diagram schematically showing a configuration of a wide area network. In FIG. 31, sites # 1 and # 2, which are located apart from each other, are connected via wide area network 42. The wide area communication network 42 is, for example, a network such as the Internet or an intranet using a dedicated line of a private communication company.

In the site # 1, to connect to the wide area communication network 42, a router 131 provided in the site # 1 for establishing a connection path to a computer terminal (such as the PC 11) and to the wide area communication network 42 A connection device 132 having a security function such as a firewall or a gateway is provided.

At site # 2, the local LAN 412
Is connected to the database server 22. This database server 22 has a relational database RDB
Having. The local LAN 412 is connected to a wide area network via the router 231. This wide area network is connected to the wide area communication network 42 via the connection device 232. The connection device 232 is configured by a device having a security function called a firewall or a gateway. By using devices having these security functions, unnecessary access from other sites is prevented, and information security is ensured.

In each of site # 1 and site # 2, a plurality of private LANs 411 and 412 are often provided. These local LANs 411 and 41
By providing the routers 131 and 231 for each of the two LANs, the router manages communication in units of one local LAN, so that access can be speeded up in units of local LANs. In addition, the router has a function of permitting access to terminals in the corresponding local LAN, and security can be maintained for each local LAN.

Many routers are located in one site,
By making the network independent according to the router, it is possible to improve the communication speed of the network of the entire site (parallel communication by a plurality of routers) and realize security. For example, by arranging PCs with a large amount of traffic in one group and arranging them on the same network, these PCs with a large amount of traffic can perform parallel communication via a corresponding router, and communication within the group can be performed. The speed can be increased, and security for other groups can be established.

As an example of a case where a communication system is constituted by such a private LAN, a database server is used as a central control unit of a semiconductor manufacturing apparatus, and a PC is used to set processing conditions of the semiconductor manufacturing apparatus. Used as Therefore, the processing conditions of the semiconductor manufacturing equipment can be collectively managed by the database server in the central control device, and in each manufacturing equipment, only the necessary processing data can be accessed from the PC. Security such as “know-how” on conditions can be ensured.

In a wide area network connected via a wide area communication network 42 as shown in FIG. 31, for example, a case is considered where the database server 22 of the site # 2 is accessed from the PC 11 of the site # 1. When performing a complicated database operation (search / delete / insert / update) process, a number of SQL commands are transmitted and the result data is returned between the PC 11 and the database server 22, as in the configuration shown in FIG. These information are stored in the PC11
Between the router 131 and the connecting device 132, between the router 131 and the connecting device 132, between the connecting device 132 and the connecting device 232,
32 and the router 231 and between the router 231 and the database server 22. At the time of communication of this information, the whole communication is performed by continuous processing in which the next communication is started after the communication of one communication message is completed, and the information communication becomes extremely inefficient.
In other words, the communication speed in a wide area network decreases as the content of data operation becomes more complicated because the number of SQL messages increases, and as the network becomes larger, it becomes necessary to pass through a greater number of connection devices and routers. And the communication speed decreases. Therefore, the user needs to wait a long time before completing one screen function.

[0034]

As described above, the conventional database operation system using the communication system has various problems as described below.

(1) In the case of arranging terminals and database servers across sites, it is necessary to define a security routing or firewall for each computer terminal. Therefore, the process of maintaining the security of the entire network becomes extremely complicated, and as a result, maintaining the security becomes difficult (because a definition error or the like occurs).

(2) When performing a search on a large-scale database under a complicated operation, a large amount of data communication occurs between the database server and the PC, the search performance deteriorates, and the communication traffic volume decreases. Problems such as increase occur.
This is a significant problem, especially in large-scale wide area network systems.

(3) It is necessary to install SQL communication software for each PC. In large systems,
The cost of purchasing this communication software and the number of man-hours for installation are enormous. In addition, a large amount of work is required to perform the installation work of the communication software, and it is necessary to arrange personnel having skills for the installation.

(4) Every time the SQL communication software or the screen program installed on the PC is upgraded, a large amount of software replacement work occurs. Also, if the version upgrade is neglected even for one terminal, the consistency of the output data between the terminals will be lost, and the data consistency as a database system will be lost. Logic may be used or logic with the same logic number may specify different processing).

Therefore, an object of the present invention is to provide a communication system which can eliminate the above-mentioned problems.

Another object of the present invention is to provide a database communication system which can perform high-speed and efficient communication, can easily secure security, and can easily cope with an upgrade of software. To provide.

Still another object of the present invention is to provide a communication system which does not require middleware (communication software) for performing communication and can easily maintain data consistency of a database.

Still another object of the present invention is to provide a method of manufacturing a semiconductor device using the above-described communication system and a component for constructing the communication system.

[0043]

A communication system according to claim 1 includes a database server and a computer terminal. The computer terminal includes processing means for generating processing information including a logic number for specifying the processing content and parameters required for the processing, and transmitting the generated processing information. The database server includes a logic program unit including a logic specified by a logic number included in the processing information. The logic program means includes means for executing a logic program specified according to the startup processing information, accessing a database, processing the access data, and transmitting data obtained from the execution result to a computer terminal. .

[0044] The communication system according to claim 2 is based on claim 1.
Logic program means includes file format program means for transmitting execution result data in a file format.

The communication system according to claim 3 is based on claim 1
Are provided in plurality. The database server activates one logic program means in response to a connection request from the computer terminal, and thereafter includes means for causing the activated logic program means to perform communication management and monitor itself for another connection request. .

The communication system according to claim 4 is the communication system according to claim 1
Means for logging on to a database server, means for logging on to a database, means for transmitting processing contents in a structured query language (SQL) statement,
And terminating means for logging off from the database server after logging off from the database in accordance with a logoff instruction from the database.

The communication system according to claim 5 is the communication system according to claim 1
Means for the database server to constantly monitor a communication request, and means for causing the computer terminal to specify a connection method from the database server to the computer terminal in response to a connection request from the computer terminal. Means for setting a connection from the database server to the computer terminal according to the designated connection method.

[0048] A communication system according to claim 6 includes a plurality of computer terminals, a relay server provided commonly to the plurality of computer terminals, and at least one database server. Communication between the computer terminal and at least one database is managed centrally by a relay server.

The communication system according to claim 7 is based on claim 6.
Means for relaying and transmitting a communication message between the one computer terminal and the database server permitted to communicate when the communication request from one of the many computer terminals is permitted. .

A communication system according to claim 8 is provided with a first site including a database server having a relay function, provided separately from the first site, (i) at least one computer terminal, and (ii) A second site including at least one computer terminal and a relay server for relaying a communication message between the database server of the first site and a second site.

The communication system according to claim 9 is the communication system according to claim 8
In the communication system, the database server is activated when a communication request is made, and includes logic program means each including a plurality of logics for executing a processing procedure. At least one computer terminal includes means for sending a communication message that activates a specific logic of the logic program means. The database server includes means for accessing the database by the activated logic of the activated logic program means, executing the specified processing, and transmitting information on the execution result to the computer terminal using a relay server.

A communication system according to a tenth aspect includes a plurality of computer terminals and a relay server which is provided in common for the plurality of computer terminals and relays communication messages of the plurality of computer terminals. The relay server includes a storage unit for storing the latest version of the mother program, and a comparison result between the version of the mother program and the version of the program corresponding to the mother program of the activated computer terminal among the plurality of computer terminals. Means for downloading the mother program to the activated computer terminal based on the mother program.

The communication system according to the eleventh aspect is a means for scheduling and executing an inquiry process to be periodically executed, and for registering an inquiry condition to an inquiry process database and managing the registration condition. Means for accessing the database according to the query condition and outputting the query result to a predetermined web server.

According to a twelfth aspect of the present invention, there is provided a communication system, comprising: means for registering a plurality of jobs; execution means for executing a job registered in the registration means in a designated cycle unit; Registration, deletion, reference,
A job management unit for performing change and forced execution is provided.

According to a thirteenth aspect of the present invention, there is provided a communication system, comprising: a database server including a database;
A server, a computer terminal for setting input of query conditions to the database and output of query results in the web server, and transmission means for performing communication between the database server and the web server.

The database server according to claim 14 is:
It comprises a database and logic program means each having a plurality of logics for executing a processing procedure for the database. The logic program means executes the specified logic in accordance with the processing information including the logic number for specifying the logic from the terminal, accesses the database, processes the access data, and stores the data obtained from the execution result in the terminal. Means for transmitting to

A semiconductor device according to a fifteenth aspect includes at least one logic program unit including a plurality of operation logics each representing a processing procedure for a database. The processing information includes a logic number for specifying an operation logic included in the logic program unit, and parameters required for the processing. This program logic means
Means for activating and executing the corresponding operation logic according to the logic number to access the database, processing the accessed data according to the parameters, and transmitting data obtained from the execution result to the computer terminal.

The semiconductor device according to the sixteenth aspect is the first aspect.
The fifth logic program means includes a file format means for transmitting an execution result in a file format.

According to a seventeenth aspect of the present invention, there is provided a semiconductor device according to the first aspect.
5 includes a plurality of logic program means, and further constantly monitors access to the database, and activates one of the plurality of logic program means provided in response to a connection request from a computer terminal. The activated logic program means performs communication management and communication execution, and includes itself a communication request monitoring program means for monitoring a connection request from another terminal.

The semiconductor device according to the eighteenth aspect is the first aspect.
The apparatus of claim 5, further comprising: means for constantly monitoring the communication request; means for responding to the connection request from the computer terminal; and means for causing the computer terminal to specify the connection mode. Responsively establishing a connection to the computer terminal in the designated manner.

The processing terminal according to claim 19 is a processing terminal for accessing a logic program means having a plurality of operation logics and a database server including a data vest, wherein a logic number representing the processing content and a parameter required for the processing are provided. Means for generating processing information including the following, transmitting the processing information to the database server, and receiving a processing execution result from the database server. The process is executed in the database server under the control of the logic specified by the logic number, and the execution result is transmitted from the database server.

The processing terminal according to claim 20 is the processing terminal according to claim 19
Means for logging on to a database server, means for logging on to a database, means for transmitting processing contents in a structured query language (SQL) statement,
After the log-off from the database according to the log-off instruction from the database, an end unit for logging off from the database server is further provided.

A relay server according to a twenty-first aspect is provided in common for a plurality of computer terminals, means for collectively managing communication between the plurality of computer terminals and at least one database server, and a plurality of relay servers. Means for determining whether to permit a connection request from a computer terminal.

The relay server according to claim 22 is claim 2
The relay server further relays and transfers a communication message between the computer terminal and the database requesting the connection in response to the connection permission given from the database requesting the connection when the connection is permitted by the determining means. Including means.

A database server according to claim 23 is
The apparatus according to claim 14 further includes means for relaying a communication message from a computer terminal provided at a site different from the terminal to a relay server.

A relay server according to a twenty-fourth aspect of the present invention is the relay server according to the twenty-first aspect, wherein the relay server monitors a database, logic program means including a plurality of logics each representing a processing procedure for the database, and monitors a communication request. If so, a communication request monitoring unit that determines whether the communication request is a connection request to a database or a connection request to another site, and activates one of the relay transfer unit and the logic program unit according to the determination result. In addition.

A relay server according to a twenty-fifth aspect is provided in common for a plurality of computer terminals, a communication management means for collectively managing the communication of the plurality of computer terminals, and a relay server for storing the latest version of the mother program. The storage unit compares the version of the mother program with the version of the program corresponding to the mother program of the activated computer terminal of the plurality of computer terminals, and the mother program is activated based on the information indicating the comparison result. Means for downloading to a computer terminal.

The relay server according to claim 26 is commonly coupled to a plurality of computer terminals, and relays communication between the plurality of computer terminals. Means for executing, job management means for registering query conditions to the database for query processing and managing the registration conditions, accessing the database according to the registration conditions, and outputting the query results to a predetermined web server Means.

The relay server according to claim 27 is a result file in which a web server is provided in the relay server and can be accessed by a plurality of computer terminals.

According to a twenty-eighth aspect, a relay server determines whether communication of a plurality of computer terminals is permitted or not, and relays the connection request of the computer terminal that has made the connection request according to the determination result. Means for registering a plurality of jobs in accordance with instructions from at least one of the computer terminals.
The job is a process for periodically querying the database.

[0071] The relay server according to claim 28 further includes means for executing a job registered in the registration means in a designated cycle unit, and registration, deletion, reference, change, and registration of the job in the registration means. Job management means for forcibly executing the job.

A relay server according to a twenty-ninth aspect of the present invention is the relay server according to the twenty-eighth aspect, wherein the web server, an action to the database server in accordance with the query conditions set in the web server, and a means for storing the access result in the web server. In addition. Inquiry conditions are set in the web server by a predetermined computer terminal among a plurality of computer terminals.

A database server according to claim 30 is:
A terminal according to claim 14 is a control device for a semiconductor device, and a database stores data including process parameters required for manufacturing the semiconductor device.

In a semiconductor device according to a thirty-first aspect, the computer terminal is a control device of a semiconductor manufacturing apparatus, and the database stores data including process parameters required for manufacturing the semiconductor device.

A processing terminal according to claim 32 is a control device for a semiconductor device manufacturing apparatus, and the database server stores control data for the semiconductor manufacturing apparatus.

A relay server according to a thirty-third aspect is the relay server according to the twenty-fifth aspect, wherein the plurality of computer terminals are control devices for a semiconductor manufacturing apparatus, and the program includes a communication program for accessing a database server. The database server stores control data of the semiconductor manufacturing equipment,
The control data includes data indicating processing conditions of the semiconductor manufacturing apparatus.

A method of manufacturing a semiconductor device according to a thirty-fourth aspect includes a step of accessing, from a terminal, a database server having a logic program including a plurality of operation logics representing processing procedures for a database. Data necessary for manufacturing the semiconductor device is stored in the database, and the operation logic of the logic program is specified by a logic number given from the terminal.

The method of manufacturing a semiconductor device according to claim 34, further comprising: in the database server, executing a process on the database in accordance with the specified operation logic, and transmitting data obtained as a result of the execution to the terminal; Executing a predetermined process according to the data transmitted in the terminal. The predetermined processing includes a processing step of controlling processing conditions for the semiconductor device of the semiconductor manufacturing apparatus.

A method of manufacturing a semiconductor device according to claim 35 is the method according to claim 34, wherein the terminal accesses the database server via the relay server, and the data transmitted from the database server via the relay server. To the terminal. The relay server includes a step of determining permission or non-permission of the communication request from the terminal.

The method of manufacturing a semiconductor device according to claim 36 is a method according to claim 34, wherein the communication request from the terminal is relayed by a relay server, and the data transferred from the database server is stored in a website. And further included.

A method of manufacturing a semiconductor device according to claim 37 is a step of registering a necessary job in a terminal and managing the registration condition, accessing a database server according to the registration condition, and transmitting the access result to a predetermined web site. The method further includes the steps of storing the data on the server and downloading the data of the website to the terminal. The job is an inquiry process for a database periodically executed in the terminal.

An inquiry logic program is prepared in the database server, and a message for activating the logic included in the inquiry logic program is simply sent from the computer terminal.
The processing is executed according to the activated logic. Therefore, between the computer terminal and the database server, the query result data is transmitted from the database server to the computer terminal simply by activating the logic and transmitting the logic specifying information. Therefore,
The communication between the database server and the computer terminal is only twice, starting the logic and returning the query result. There is no need to transmit an SQL message, so that the processing time is shortened and the traffic volume of the network is increased. And an efficient communication system can be constructed. In addition, security in the site can be ensured by the relay server, the table search time is shortened by using the Web server, and the software change time is shortened by downloading the latest version.

Further, by controlling the semiconductor device manufacturing apparatus using this communication system, it is possible to efficiently transmit and receive necessary data between the central control device and the terminal manufacturing apparatus. A monitoring system for a semiconductor manufacturing apparatus can be constructed.

[0084]

[First Embodiment] FIG. 1 schematically shows a communication system of a database operation system according to a first embodiment of the present invention. In FIG. 1, the database operation system includes a PC 11 of a terminal and a database server 21 for centrally managing information. These database server 21 and PC 11 are interconnected via a network 49.

The PC 11 transmits, on the screen, a screen program 111A for describing the operation program and the operation program generated by the screen program 111A to the database server 21 via the network 51. And a communication function 114 for transmitting the result data of the above to the screen program 111A. The screen program 111A transfers to the communication function 114 a logic number for specifying a logic for executing the operation content, a parameter for describing details of the operation content, and an identifier (for example, an IP address and a login ID) for specifying the PC 11 to the communication function 114. . The communication function 114 does not include SQL communication software (S / W), but is simply configured by software for driving a transceiver such as a modem. The screen function 113 is defined by the definition and description of the user's operation content according to the screen program 111A. The conversion of the screen function 113 into an SQL message is not performed in the PC 11.

The database server 21 receives the communication request monitoring program 216 for monitoring the communication request given via the network 49 and the operation processing information given via the communication request monitoring program 216, and It includes an operation logic program 217 for forming logic and generating an SQL message, and a relational database (RDB) 211 for storing information. Table 1 (21) is stored in the relational database 211.
3), Table 2 (214) and Table 3 (21)
Various information is stored in a table format, such as 5).

The operation logic program 217 includes operation logic for searching, updating, inserting, and deleting the relational database 211. The operation logic is a group of programs representing a series of processing procedures, and one operation logic corresponds to one screen logic program.

FIG. 2 shows the screen program 111 shown in FIG.
FIG. 2 is a diagram schematically showing a configuration of A. 2, a screen program 111A includes screen logic programs SP1, SP2,... For displaying operations such as a dialog box on a display screen. Corresponding to these screen logic programs SP1, SP2,..., For example, dialog boxes DS1, DS2,. These dialog boxes DS1, DS2,... Correspond to the operation A and the operation B, respectively, and include a box BX for inputting specific parameters, a button BT for executing various processing contents, and the like.

The screen program 111A is activated by selecting the menu MN on the control panel DS0 displayed on the display screen by the initial screen program SP0. These screen logic programs SP1, SP2,...
Logic number LN indicating the corresponding operation logic
(LN1, LN2,...) And the parameters input in the corresponding dialog boxes are stored in the working buffer memory BUFM. This screen program 111A does not have a function of converting the operation content into an SQL statement. In all cases, only a logic number representing a logic representing a processing procedure and a corresponding parameter are generated and stored in the buffer memory BUFM. Therefore, the screen program 111A does not have a function of executing the screen function 113 described by a dialog box, a window, and a wizard on the display screen. Information such as a logic number and a corresponding parameter stored in the buffer memory BUFM is transmitted to the database server 21 via the communication function 114.

The screen logic program SP
Operations corresponding to 1, SP2,... May be displayed on the display screen in windows or wizards instead of dialog boxes.

In this screen program 111A,
No SQL statement is formed, communication function 1
Only necessary information such as logic numbers and parameters are sent out via. Therefore, first, the procedure call requested by the screen function 113 is once transmitted to the database server 21, and the subsequent processing is executed by the operation logic program 217 provided in the database server 21. This operation logic program 21
7 is again stored in the network 49 and P
Screen program 111 via communication function 114 of C11
A given. The screen program 111A displays the returned result data on the display screen (search (SE
LECT) processing). Therefore, in one process, once the PC 11 makes an access request to the database server 21 and hands over the necessary data information, the network 51 is free until the result data is returned from the database server 21. Occurs, the other P
C has access. Thereby, the traffic volume can be reduced and an efficient database communication system can be constructed.

FIG. 3 is a diagram schematically showing the configuration of the operation logic program 217 shown in FIG.
Operation logic program 217 includes a plurality of operation logics LP # 1-LP # n. These operation logic LP
Logic numbers LN # 1-LN # n for specifying operation logic are assigned to each of {1-LP} n. Each of the operation logics LP # 1-LP # n corresponds to a screen logic program SP (processing contents on one display screen), and one dialog box or one window displayed on the display screen of the PC. Or it corresponds to one wizard. These operation logic LP♯
1-LP @ n describes a processing procedure in an SQL statement, and when a parameter is given at the time of activation, the assigned processing is executed using the parameter as an operation condition.

The operation logic program 217 is parsed by a database engine DBE included in a database server, and is subjected to a relational database (RDB).
The operation to 211 is performed. Therefore, an SQL statement is created only in the database server, and access to the relational database 211 is executed.

A processing procedure called a “stored procedure” is conventionally prepared in the database server 21. In response to an access request to the stored procedure from the PC, access to the relational database is executed only in the database server under the control of the database engine DBE using the stored procedure. However, in the case of this stored procedure, the processing procedure is predetermined, and when changing the processing procedure, the user newly executes the “CREATE PRECEDURE” instruction to create a new processing procedure, It must be sent to the database server and registered with an SQL statement. Therefore, when this stored procedure is used, various operations cannot be performed, which lacks versatility.

By preparing the operation logic program 217 in the database server 21 as in the present invention, the operation logic activated according to this screen program is selected, and the operation described by the user is executed.
Therefore, compared to the conventional method using the stored procedure, all the procedures requested by the user can be created and used, and a more versatile database operation system can be realized. Also, unlike the stored procedure, there is no need to register the procedure in advance, and all operations are described and transmitted in a non-SQL language such as a logic number and a parameter, and SQL communication software is not required. The number of information transmissions from the PC 11 is one at the time of the access request.
Only once, there is no need to transmit SQL messages for all operations, and the occupation time of the network line can be reduced.

FIG. 4 is a diagram schematically showing a communication procedure of the database system shown in FIG. Hereinafter, an operation procedure of the database system according to the first embodiment of the present invention will be briefly described with reference to FIG.

First, in the PC 11, a screen program is started to create a screen function (step S1). Next, a communication command included in the screen program is operated to activate the communication function 114, and the database server 21
(Step S2). The communication request monitoring program 216 monitors an access request sent via the network 51. When an access request is given, the communication request monitoring program 216
Determines whether the PC 11 can access the database server by referring to, for example, an identifier (ID) such as a login (logon) ID and a password, and determines whether the PC 11 can access the database server 21. If registered, the access permission is sent to the PC 11 (step S3).

Under the control of the communication request monitoring program 216, the PC 11 sends the logic number generated by the screen program describing this screen function and the parameters indicating the operation conditions to the operation logic program 217 or the database engine DBE (see FIG. 4). Step S6).
Here, the communication request monitoring program 216 determines in step S
When the access permission is issued in Step 3, the operation logic program 217 is activated (S5). A plurality of operation logic programs 217 are provided, and one PC
In response to an access request from, one operation logic program is activated when this access is permitted. A plurality of operation logic programs can be activated simultaneously.

The operation logic program 217 activates the corresponding operation logic according to the given parameters and logic numbers, hands over the parameters to the activated operation logic, and operates the relational database (RDB) 21 via the database engine DBE. (Step S7).

The contents of the operation performed on the relational database 211 differ depending on the logic started in the operation logic program. When the operation on the relational database 211 is completed, the result information is provided to the operation logic program 217 or the database engine DBE (step S8). When the operation is completed, the result is created in a table format or a file format described later according to the activated logic of the operation logic program 217 (step S9).
The created result information is transmitted to the communication request monitoring program 2
16 or the operation logic program 217
Is returned to the PC 11 via the network 51 (step S10). The PC 11 receives the result information returned via the communication function 114, gives the received information to the screen program, and displays it on the display screen under the control of the screen program (step S1).
1).

As shown in FIG. 4, a procedure or logic call of an access request (step S2), an acknowledgment (OK) message return (step S3), and a transmission of a logic number and parameters (step S4) is performed at the time of access. It is performed once, and after the processing is completed, only the result information is returned (step S10). At the time of operation on the relational database 211, no information transfer between the PC 11 and the database server 21 is performed. Therefore, as before,
Compared to the method of sequentially transferring SQL statements,
The traffic volume can be significantly reduced, the network occupation time can be significantly reduced, and a high-speed and efficient database operation environment can be realized.

FIG. 5 is a diagram schematically showing a configuration of data transmitted from the PC to the database server. In FIG. 5, transmission data includes identifier (ID) information 150 such as a login (logon) ID and a password, a logic number LN @ information 151a for specifying an operation logic,
The operation logic includes parameter information 152a indicating a condition to be operated in the operation logic, a logic number LN # information 151b specifying another operation logic, parameter information 152b indicating a condition to be operated in the operation logic, and the like. Parameter information 152a and 152b are
It merely represents operating conditions. These parameter information 152a and 152b may be separated by, for example, “.”. "." Gives a delimiter for the fields of the SQL statement.

Based on the ID information 150, the communication request monitoring program 216 shown in FIG. By providing the communication request monitoring program 216 with an ID information identification function, security can be ensured and access from unnecessary sites or PCs can be prohibited.

As described above, in the configuration of the first embodiment of the present invention, in order to execute data manipulation (search / update / delete / insert), a table included in the relational database is manipulated. The SQL instruction is
It does not occupy the network 52. Communication is performed only within the database server 21. When the operation (search / update / delete / insert) for the database is completed, the operation result is reported to the PC. Regarding the execution of one function of the screen program 111, the communication of the SQL command and the result information communicated on the network 51 is one round trip, that is, only at the start and end of the communication, and the time for sending the SQL statement sentence by the network. There is no delay, and a high-speed database operation environment can be realized.

[Modification] FIG. 6 schematically shows a structure of a modification of the first embodiment of the present invention. In FIG. 6, a file FL is further provided in the database server 21 in addition to the relational database 211. The file FL includes a file using ASCII code, a file described in a binary format such as an execution program, an image file for storing image data, and the like. The file FL indicates a data string in which character strings are put together. To operate this file FL,
In the operation logic program 217, a file operation logic LP # F is prepared. A logic number LN # F is assigned to the file operation logic LP # F.
Therefore, a file in a normal text format can be stored in the database server 21. When activated, the file operation logic LN # F accesses the file FL via the database engine DBE, and reads out, transmits, or stores the corresponding file.

The file operation logic LP # F may have a function of converting table information stored in the relational database 211 into a file format and outputting the converted information. This file format converter may have a function of creating and transmitting a file in a table, for example, in HTML (Hyper Text Markup Language) format, with the fields of the table separated by ",".

The file transmission function is also provided in the PC, and it is possible to transmit a file from the PC 11 to the database server 21.

As described above, according to the first embodiment of the present invention, the screen function described by the screen program
An operation logic program expressed in QL is provided in the database server.
Because it is configured to be transmitted and received within the QL server, data information communication between the computer terminal and the database server is performed once at the time of access start and at the time of operation completion, respectively, greatly reducing communication time. And a traffic amount can be reduced, and a high-speed and efficient database system can be constructed.

[Second Embodiment] FIG. 7 is a flowchart showing the processing procedure of the interface between the PC 11 and the database server 21. The screen program (111) is an application program corresponding to various tasks.
The screen program 111 is started to describe and define a screen function representing the contents of the database operation. After describing the screen function by this screen program, it is necessary to operate a database in order to realize this screen function. According to the flow shown below, issuance of an SQL instruction, delivery of parameters for operation logic program call, And the acquisition of result data.

When the screen program 111 is started, first, a data acquisition area for storing data received from the database server is secured in a memory such as a hard disk (step S51).

On the screen program 111, communication between the PC and the database server 21 (for example, TCP
A library (for example, in the case of a window-compatible personal computer, a DLL (Dynamic Link Library)) for performing a / IP protocol (transmission control protocol / Internet protocol) socket communication is specified (step S52). The library is an interface for connecting the client to the server. By using the functions prepared by the library, the database server can build a client application.

Next, in order to connect to the database server, the name of the database server (host name and IP
Address) and an OS (operation system) level user name and password for login to the database server (step S53). In step S53, a network connection function for describing a connection route is also described. This completes the connection process between the database server and the PC.

Next, a database level user name and password for logging in (logging on) to the database are set (step S54). Relational database (RDB) in step S54
The user name and the password indicate a user name managed by the relational database. The connection between the PC and the relational database is established by the procedures of steps S51 to S54. Step S5
If the user name and password specified in 3 match the user name and password registered in the communication management program, the PC 11 is permitted to access the database server. Step S
In the logon process at 54, if the user name and password match the user name and password registered in the relational database engine, access to the database table is permitted.

When the connection between PC 11 and database server 21 and relational database 211 is established by the procedure up to step S54,
Next, the PC executes processing for operating the database according to the function of the screen program. For this database operation, two methods are used as needed, depending on the function of the screen program. First, as shown in step S55, a data output area is secured using an SQL message, and the size of each data in a column is all specified, and the SQL message is transmitted to the database server 21. This is a conventional method of directly issuing an SQL, and an SQL message is issued a plurality of times. In the method according to step S55, transmission and reception of the SQL message and the result data occur many times.

Another method is, as shown in step S56, a method in which the operation logic program 217 arranged on the database server 21 is called to send an SQL message and operate the database in the database server. . In this case, as shown in step S56, the operation logic included in the operation logic program is transmitted together with the logic number and the corresponding parameters (1, 2, 3, and 4...), And the corresponding operation logic is called.

The operation logic program can be started by data transfer with only a small number of parameters, and efficient communication can be performed. According to the operation logic program 217, the specifications of the parameters to be passed to the operation logic can be defined. That is,
On the screen program, parameter specifications (data type (eg, integer type), size, etc.) can be defined according to the configuration of the operation logic program prepared on the database server. According to step S56, a complicated search / update / delete /
An operation process such as insertion is performed only in the database server 21, and only the finally obtained operation result is returned to the screen program via the network.

If the search processing is performed in steps S55 and S56, the search result is output to the prepared data acquisition area on the database server side. On the database server side, the final result data stored in the data acquisition area is transferred to the PC via the network (step S57).

The data transferred to the PC 11 is assigned one by one to a table (spreadsheet) or the like and displayed on a screen program (step S58). In order to use the spreadsheet to set the data at the correct and correct positions of the columns and rows on the table, a counter is used to generate a pointer to the position of the column and the data is set. The column is identified by a difference in properties, and table data is transmitted for each column or each row (only at the time of retrieval). Step S55,
S56, S57, and S58 are repeatedly executed a required number of times in accordance with the operation content in which the screen function is described.

All operations (search / update / delete / insert)
When the processing is completed, a step corresponding to step S55, that is, the end of the SQL issuing processing is declared, and the SQL processing is completed (step S59). This step S5
No. 9 is required when step S55 is executed and an SQL message is transmitted. If a logic call is made, a connection termination request
C.

In step S60, in step S54
Is performed, and the end of login is declared. That is, recording in the log that records the progress of access to the database server is completed, and the connection of the PC to the database ends.

Next, in order to release the connection between the database server and the PC, the PC declares release of the connection at the OS level (step S61). In these series of processes, for example, by displaying a dialog box or a wizard on the screen program and clicking a logoff process button and a disconnection button, these logoff processes and disconnection processes are declared.

Note that steps S53 to S57
If an error occurs during access to the database server, the connection to the database server is forcibly released, and the screen program displays on the display screen that the error has occurred. The user sees this error display and executes necessary processing (for example, executes necessary processing by referring to a wizard displayed on the screen at the time of error processing).

The processing of steps S51 to S61 is performed, for example, as follows. Screen program 1
11 is started and the necessary screen functions are described. Then, an operation execution button included in the screen program 111 is clicked, and a dialog box necessary for communication is displayed on the display screen from the screen program 111. Describe the necessary information in the box.

FIG. 8 is a flowchart showing the operation at the time of pasting the data in step S58 shown in FIG. Hereinafter, the data attaching process will be briefly described with reference to FIG.

First, before acquiring data, a counter and a column pointer are initialized (step SS1).
Next, data is acquired one by one (field unit) (S
S1). When one data is obtained, the counter is incremented and the column is incremented, and the column position on the display screen is shifted accordingly (step SS).
2). Next, it is determined whether or not all the data of one row has been acquired (step SS3). If all the data of one row has not been obtained, the process returns to step SS1, and the next data is obtained. In step SS3, if all the data of one row has been acquired, it is determined whether or not the next row still exists (step SS4). If the next row exists, the counter and the column are initialized again for the next row (step SS1). Thereafter, the same operation is performed again, that is, the processing of steps SS1 to SS3 is performed.

In step SS4, data of all rows is obtained, and it is determined whether one table (result data) has been received (step SS5). If another result table still needs to be received, another area is reserved (step SS6), and then step SS6 is performed again.
It returns to 0 and repeats the data output operation for this other result table again. When all the result tables have been obtained in step SS5, the data pasting operation is completed.

In FIG. 8, data is obtained for each row. However, the configuration may be such that data is acquired in units of columns.

By updating the pointer indicating the column position of the table every time data is acquired using the counter,
Accurately, the acquired data can be assigned to the corresponding column position.

As described above, according to the second embodiment of the present invention, in a PC (computer terminal), a screen program is activated, and logic indicating operation contents is changed to only logic numbers and parameters indicating operation conditions. An operator (user) using this computer terminal describes the operation that is easily required without intending to create an SQL statement, as in the related art, by sending it to the database server. Can access the database.

[Embodiment 3] FIG. 9 is a diagram schematically showing a configuration of a communication request monitoring program and an operation logic program included in database server 21. In FIG. 9, a database server 21 has a communication request monitoring program 2 for constantly monitoring a connection request from the PC 11.
16, an operation logic program 217 that is started under the control of the communication request monitoring program 216 and executes a predetermined process in accordance with an operation request from the PC 11, and four definition files 221-2 that define the operating environment of the database server 21. 224.

The connection number definition file 221 defines the number of PCs that can be connected at the same time, and defines a log file that records the connection. The user environment definition file 222 allows the user of a program such as the operation logic program 217 to be connected to the PC 11 to execute.
Defined by level execution user name. Based on the user name defined in the user environment definition file 222, permission / non-permission of access to the database server 21 is determined by the communication request monitoring program 216.

The RDB environment definition file 223 is stored in the PC1
A user of a relational database (RDB) to which the user 1 can connect and operate is defined by a user name at the relational database level, that is, a table owner. That is, there are a plurality of tables in the relational database, and operations on each table are permitted by a user name in the relational database. This ensures the security of the database.

The OS environment definition file 224 includes the communication request monitoring program 216 and the operation logic program 2
17 is a file defining an operating environment, and defines environment variables such as a searchable path name (directory name) and designation of a language to be used. Communication request monitoring program 21
6 is always activated and monitors a connection request from the PC 11. The communication request monitoring program 216 reads information defined in these environment definition files 221-224 at the time of startup. Next, the database server 21
Will be described.

The communication request monitoring program 216 uses a predetermined port number (a number indicating a communication reception port),
It keeps waiting for a connection request from the PC 11. When there is a connection request from the PC 11 (step S231), the communication request monitoring program 216 sends the user environment definition file 22
2 is compared with the user name (login ID) given with this connection request. PC11
Is registered in the user environment definition file 222 via the communication function 114 from
The communication request monitoring program 216 gives the PC 11 an OK message that acknowledges accepting the connection (step S232). This transfer of the OK message establishes a connection between the PC 11 and the database server 21.

The PC 11 executes the communication request monitoring program 21
6 instructs a port number for communicating with the started operation logic program 217 (step S
233). When the port with the port number specified in step S233 is in an idle state, the communication request monitoring program 216 sends an OK message indicating an acknowledgment again to the PC1.
1 (step S234).

After returning the OK message to the PC 11 at step S234, the communication request program 216 activates one operation logic program 217. Here, the communication request monitoring program 216 executes a “fork” instruction in step S250. The “fork” instruction is an instruction for generating another process that can be newly executed in parallel with the process that has been executed. That is, the operation logic program 21
7 are provided in a plurality, and can simultaneously start a plurality of operation logic programs. One operation logic program 2 for one connection request from PC
17 is started. The upper limit of the number of operation logic programs 217 started simultaneously is determined by the number of simultaneously connectable PCs defined in the connection number definition file 221.

After activating the operation logic program 217, the communication request monitoring program 216 waits for a communication request again at a predetermined port number. Subsequent processing is executed between the activated operation logic program 217 and the PC 11.

The started operation logic program 217
Issues a connection request to the PC 11 via the port indicated by the port number specified in step S233 (step S235). PC11
When the connection request is accepted, the OK message is transmitted to the operation logic program 217, indicating an acknowledgment (step S236). Subsequently, the PC 11 sends a relational database (RDB) to the specified port.
(Step S237). In response to the given RDB logon request, the operation logic program 217 determines that the user name included in the logon request is
It is determined whether or not it matches the user name registered for the database requested to be accessed by the user. This R
If the user name given at the time of the DB logon request is registered in the RDB environment definition file 223, the operation logic program 217 accepts the logon request from the PC 11, and stores the log in the log included in the connection number definition file 221. Record access.

When the logon request is accepted, PC 11 issues an SQL message or executes a logic call according to the processing to be executed (step S).
238). If the SQL instruction is correctly processed or the logic control is correctly processed, the operation logic program 217 sends an OK message to the PC1.
1 (step S239). When the logic control is performed, the operation logic program 2
Reference numeral 17 denotes an operation logic program 2 according to a logic number and a parameter included in the logic control.
The operation logic included in 17 is activated, and necessary parameters are handed to the activated operation logic to execute processing.

The user name defined in the RDB environment definition file 223 has been read into the communication request monitoring program 216. When the communication request monitoring program 216 activates the operation logic program 217, the read RDB environment Operation logic program 2 in the definition file
17 may be provided. In addition, the operation logic program 217 executes the RDB environment definition file 22
3 may be configured to be accessed at the time of an RDB logon request to determine whether a user name is registered.

The issuance of the SQL message and the logic call are repeated as necessary according to the screen function described by the screen program. The request from the screen program
In the case of the search process, data obtained by searching the relational database is temporarily stored in a buffer memory (not shown) such as a disk device under the control of the operation logic program 217. PC11 is
When the operation result is obtained in step S239 and the OK message is returned, a data acquisition instruction is issued (step S240). In response to the data acquisition instruction, the operation logic program 217 accesses the relational database and operates the PC1 to store information obtained as a result.
1 (step S211).

When a database operation is designated using an SQL message, necessary processing is executed, and when a series of screen processing is completed, the PC 11
Sets the end of SQL issuance to the operation logic program 217.
(Step S242). The operation logic program 217 issues an OK message indicating approval when the PC 11 is notified of the end of the SQL issuance (step S243). When a logic call is made, only the required number of logic calls are made, and in particular, this SQL issue end declaration is not made.

When receiving the OK message in step S243, PC 11 declares RDB logoff indicating completion of the log-in process for the relational database (step S245). When receiving the RDB logoff declaration, the operation logic program 217 describes necessary information in the log included in the connection number definition file 221 and then completes the log processing (logout). At the time of this RDB logoff declaration, or the operation logic program 217, the log may be configured to describe the log at the OS level of the database server and the log at the relational database level.

When the necessary log-off processing is completed, the operation logic program 217 sends an OK message to the PC 11
(Step S246). When the OK message is returned in step S246, the PC 11 notifies the operation logic program 217 of the disconnection (step S247). When notified of the disconnection, the operation logic program 217 completes a series of processing, declares the processing end to the communication request monitoring program 216, and executes the disconnection processing (Exit) step S251).

When the operation of the operation logic program 217 is completed, the communication request monitoring program 216 recognizes that the operation logic program 217 can be used for another connection request by using, for example, a flag. .

As described above, this database server 2
1, the communication request monitoring program 216
By identifying the user name and login ID of the user who has made the connection request at each of the S level and the relational database level, security for the database server 21 can be easily ensured. There is no need to perform routing using an IP address or the like in a connection device that relays between the database server 21 and the PC 11, and the operation for ensuring security is greatly simplified.

[Modification] FIG. 10 is a diagram schematically showing the configuration of the operation logic program 217 of the database server 21. In FIG. 10, a plurality of operation logic programs 217 a to 217 n are connected to the communication monitoring program 216 in parallel. The communication monitoring program 216 constantly monitors a connection request from a PC via a predetermined port 218. For the communication monitoring program 216, activation flags SFa-SFn provided corresponding to the operation logic programs 217a-217n, respectively.
Is provided.

The communication monitoring program 217
When the connection request is given via the control unit 8, the operation logic program corresponding to the flag indicating the non-activation state is activated with reference to the flag register 219. The communication monitoring program 216 includes one operation logic program 217.
When i (i = an) is activated, the flag register 21
In step 9, the corresponding flag register SFi is set to a state indicating an activated state (a flag is set). When the connection request processing for one operation logic program 217i is completed, the communication monitoring program 216 hands the subsequent processing procedure to the started operation logic program 217i and monitors the connection request from the port 218 again. When activated, the operation logic programs 217a to 217n communicate with a PC via a designated port.
When the processing is completed, the operation logic program 217
i sets the corresponding activation flag SFi in the flag register 219 to a state indicating a non-activation state (resets the flag).

By using the configuration shown in FIG. 10, a plurality of operation logic programs 217a to 217n can be selectively activated using one communication monitoring program 216. This operation logic program 21
The number of 7a-217n corresponds to the number of simultaneously connectable PCs defined in the connection number definition file 221. These operation logic programs 217a to 217n have the same configuration, and can perform search / update / delete / insert processing.

[Modification 2] FIG. 11 is a diagram schematically showing another configuration of the database server 11. FIG.
, A plurality of communication monitoring programs 216 a to 216 n are connected to the port 218 in parallel. Operation logic programs 217a to 217n are provided corresponding to these communication monitoring programs 216a to 216n, respectively. Operation logic programs 217a-217n
Is selectively connected to ports 220a-22 according to the specification of the PC.
0k and communicates with the PC. The ports 220a-220k and the operation logic program 217
The connection route of a-217n is determined by the port number specified by the PC. These ports 220a-220k
Are connected in parallel to a network (different from each other) connecting the PC and the database server. By specifying the port, communication according to the communication characteristics (such as communication speed) of the PC is realized (dedicated line, ISPN line, telephone line, etc.).

Each of the communication monitoring programs 216a to 216n has a priority flag PF. Communication monitoring program 2
16a to 216n, the priorities are determined. For example, the most upstream communication monitoring program 216
a has the highest priority, and the communication monitoring program 216l at the lowest position has the lowest priority. The communication monitoring program 216a-261n monitors a connection request from the port 218 when the priority flag PF is set. When one communication monitoring program 216i receives the connection request and starts the corresponding operation logic program 217i, it sets the priority flag of the next downstream communication monitoring program 216j. Therefore, the next connection request is monitored by the next downstream communication monitoring program 216j. When the communication monitoring program 216i completes one processing operation, the activation of the corresponding operation logic program 217i is completed, and the connection is released, the communication monitoring program resets all downstream priority flags, and Set the priority flag for. Therefore, the communication monitoring program 216a-
216n, when there is a connection request from the port 218,
Only responds to connection requests when its own priority flag is set. Communication monitoring program 216
When all of a-216l are in the active state, no response is made to the connection request. When the PC 11 does not receive a response to the connection request within a predetermined time,
The display of access failure is displayed on the display screen of the PC, for example.

In the case of the configuration shown in FIG. 11, the communication monitoring flags 216a to 216n need only manage one corresponding operation logic program 217a to 217n, and a plurality of operation logic programs 217a to 217n are required.
Communication monitoring program 21 compared to managing all
The load on 6a-216n is reduced.

As described above, according to the third embodiment of the present invention, the database server is provided with the communication request monitoring program, and is configured to monitor login to the database server and the database. There is no need to perform this, and security can be easily ensured.

Further, since a plurality of operation logic programs are provided and each operation logic program is adapted to respond to a connection request from a computer terminal, connection requests from a plurality of terminals are simultaneously processed in parallel. And an efficient database system can be constructed.

[Fourth Embodiment] FIG. 12 schematically shows a configuration of a communication system according to a fourth embodiment of the present invention. In FIG. 12, this communication system includes three sites # 1, # 2 and # 3. In site # 1, a plurality of computer terminals (PCs) 11-13,
It includes a relay server 51 provided commonly to these PCs 11-13. This relay server 51 manages communication between PCs 11-13 provided in site # 1 and other sites # 2 and # 3. The relay server 51 includes an access log 251 for recording the access history of the PCs 11 to 13 and a connection permission list 261 for registering PCs that can access other sites # 2 and # 3 via the relay server 51. And a relay function 511 that simply relays the contents of the communication during communication. As will be described later in detail, a plurality of relay functions 511 are provided.
When one relay function accepts a connection request, it activates another relay function, relays communication according to the connection request from this PC, and continues monitoring another connection request from the PC again. Therefore, in this relay server 51, relay function 511 is provided in P # provided in site # 1.
One more PC is provided than the number of PCs that can be simultaneously connected in C11-13. The relay function 511 is realized by a program similar to the operation logic program in the first embodiment and the like. The access log 251 includes the PC 11-1.
At the time of communication between Site No. 3 and sites # 2 and # 3, a connection record is recorded irrespective of whether the connection was successful or rejected. The information recorded in the access log 251 includes information such as which PC has made a connection request to which server and when, and when the connection has been completed or the connection attempt has failed.

Site # 2 has database server 22
Is arranged, and a database server 23 is arranged at the site # 3. In the database server 22, a relational database (RDB) 211, a connection permission list 262, and an access log 252 are provided. The database server 23 also includes a relational database 212, a connection permission list 263, and an access log 253. Connection permission list 26
2 and 263 issue the connection permission for each relay server. Therefore, addresses or IDs specifying relay server 51 are registered in connection permission lists 262 and 263. Access logs 252 and 253
Records permission / rejection of a connection request from a relay server, a source relay server, and a connection status (including time information).

In connection device 41 between site # 1, site # 2 and site # 3, the routing of connection between relay server 51 and database server 22 is defined in connection device 41a, and connection device 41b In
The routing between the relay server 51 and the database server 23 is defined.

The PCs 11-13 in the site # 1 cannot directly access the database servers 22 and 23 in the sites # 2 and # 3. Therefore, it is not necessary to perform security management for communication between the sites for each PC, but only for security management between the database server and the relay server provided at site # 1. Can be greatly reduced, and the workload can be greatly limited.

FIG. 13 is a diagram schematically showing another configuration of site # 1. In FIG. 13, the private LAN 412
a and 412b are provided. PCs 11a to 13a are connected to the premises LAN 412a.
PCs 11b to 13b are arranged in 12b. Campus L
A relay server 51a is provided for the AN 412a, and a relay server 51b is provided for the LAN 412b. These relay servers 51a and 51b are connected to a network connection device, for example, a router.
The configuration of relay servers 51a and 51b is similar to that of relay server 51 shown in FIG. 12, and includes relay function 511, connection permission list 261 and access log 25, respectively.
Including 1. Therefore, as shown in FIG. 13, when site # 1 is divided into a plurality of networks, permission / refusal of access to and connection to the database server is managed in units of relay servers.

FIG. 14 shows relay servers 51a and 51
FIG. 13 is a diagram schematically illustrating an example of a configuration of a connection permission list 261 included in b. In FIG. 14, connection permission list 2
Reference numeral 61 stores in the form of a list the names of PCs that can be permitted to connect in the corresponding network. In FIG. 14, the numbers “11”,
“13” is registered. So, for example, PC
11 and the PC 13 via the corresponding relay server,
Can access the database server.

FIG. 15 is a diagram schematically showing the configuration of connection permission lists 262 and 263 included in the database server shown in FIG. In FIG. 15, this connection permission list 262 (and 263) is a relay server name list 262a (263a) storing a relay server name for managing permission / non-permission at the OS level.
And a relay server name list 262b (263b) storing the names of relay servers that are permitted to access the database at the RDB level. The relay server name list 262b (263b) is provided corresponding to each type of table included in the relational database of the database server.

FIG. 15 shows that the relay servers 51a and 51b are permitted to access and connect at the OS level, while the relay server name list 2
62b, at the RDB level, the relay server 5
1a is allowed to access the corresponding database table.

Thus, as compared with a configuration in which security management is performed in units of PCs, it is only necessary to perform security management in units of relay servers, and the workload for maintaining security is greatly reduced.

The relay servers 51, 51a and 5
In each case, if there is a connection request from a PC that is not registered in the connection permission list 261, the connection request is rejected.

FIG. 16 shows the relay server 51 shown in FIG.
FIG. 3 is a diagram schematically showing a configuration of a relay function 511 included in the relay function. In FIG. 16, a relay function 511 is a communication request monitoring program 541 for monitoring a connection request from a PC.
And a relay function relay program 542a-542n that is started under the control of the communication request monitoring program 541 and relays (repeats) a signal between the PC requesting the connection at the time of startup and the database of the connection destination. A plurality of these relay function relay programs 542a to 542n can be started at the same time (the same as the case where a plurality of operation logic programs can be started at the same time).

This communication request monitoring program 541 is
At the time of the connection request from C, the PC name included in the connection request is compared with the PC name included in the connection permission list 261, and when the PC requesting the connection is registered in the connection permission list 261, the permission for the connection permission is given. (OK) is issued. After transmitting the OK message, the communication request monitoring program 541 executes one relay function relay program 5
42i (i = an) is activated, and the subsequent communication is executed by the activated relay function relay program 542i. The communication request monitoring program 541 again transmits to another PC
Monitor connection requests from. Therefore, at the time of establishing the connection between the communication request monitoring program 541 and the relay function relay programs 542a to 542n, FIG.
The operation similar to the operation performed at the time of the connection request shown in FIG. However, the relay function relay program 542a-
542n differs only in that it simply relays the communication between the PC and the database server. Therefore, in the relay function 511, the same number of relay function relay programs and communication request monitoring programs as the number of relaying PCs are simultaneously executed.

The communication request monitoring program 541 is started when the operation of the relay server 51 starts, and operates constantly to monitor a connection request from the PC. When a connection request is made from a PC, the communication request monitoring program 541 records the name of the PC making the connection request in the access log 251 and sends a pointer indicating the recording position of the access log to the relay function relay program 542i that newly starts up. Hand over. Thereafter, the relay function relay program 542i records the connection status with the database server in the access log 251 when the PC is connected.

Next, FIGS. 17 and 18 (A)-(C)
The operation of the relay server according to the fourth embodiment of the present invention will be briefly described with reference to FIG.

In FIG. 17, connection request step 251 is performed.
In, a connection request is issued from the PC 11 to the relay server 51. As shown in FIG. 18 (A), the relay server 51, under the control of the communication request monitoring program 541,
When the connection request from the PC 11 is accepted, the relay program 542 is started. The activated relay function relay program 542 receives a connection request given from the PC 11 and sends it to the database server 22. The database server 22 executes the relay function relay program 54 by the same operation as described in the first embodiment.
It is determined whether the connection request given from 2 is acceptable or not, and if the ID of the relay server 51 is registered, an acknowledgment message (OK) for accepting the connection is returned.
The relay function relay program 542 transmits the OK message returned from the database server 22 to the PC 11
Return to. Through this processing, a communication connection between the PC 11, the relay server 51, and the database server 22 is established. After activating the relay function relay program 542, the communication request monitoring program 541 hands all subsequent processing to the relay function relay program 542, and simply monitors a connection request from another PC.

The PC 11 executes the search request step 25
Execute Step 2. That is, when the OK message is given from the database server via the relay server 51, the PC 11 responds to a connection request from the activated operation logic program (217) included in the database server 22, as in the first embodiment. Log on to the relational database included in the database server 22 and issue necessary search conditions (SQL statement or logic call). As shown in FIG. 18B, the relay server 51 relays the search condition issued in the search request step 252 and transfers it to the database server 22 as it is. Thereafter, communication between the PC 11 and the database server 22 is executed via the relay function relay program 542. In the database server 22, after performing a search according to the search condition,
The search result is returned to the PC 11 via the relay server 51. This process is repeated until a series of processes of the screen function described by the screen program is completed.

When the search request step 252 shown in FIG. 17 is completed, the PC 11 disconnects the connection to the database server 22 by a disconnection request step 2.
Execute 53. At this time, similar to the first embodiment,
As shown in FIG. 18C, first, an RDB logoff indicating a disconnection request is issued from the PC 11 to the database server 22 via the relay server 51, and then the disconnection request from the database server 22 is acknowledged.
An acknowledgment message (OK message) for closing the corresponding database is sent to the PC via the relay server 51.
Return to 11. Thereby, the database server 22
The connection path between PC 11 and PC 11 is disconnected, and the connection between PC 11 and relay server 51 is also disconnected. The relay function relay program 542 is a communication request monitoring program 5
It is in a state of waiting for the next activation from 41.

In the relay server 51, the relay function 5
11, a plurality of relay function relay programs 542 are provided, and these relay function relay programs 542a-5 are provided.
42n can be executed at the same time, so that even when managing the communication of a plurality of PCs using one relay server 51, the processing can be executed in parallel.
A system for performing a high-speed database operation is realized.

Note that the relay function relay program 542
Has only a function of relaying communication and does not have a function of processing received information. The communication request monitoring program 541 may be provided corresponding to each of the relay function relay programs 542a to 542n.

As described above, according to the fourth embodiment of the present invention, a relay server is provided in common for a plurality of computer terminals (PCs), and security is ensured between the relay server and the database server. Since the routing is defined, the trouble of routing for security is greatly reduced. In addition, the relay server performs security routing for connection with a corresponding PC (computer terminal).
Since there are many connections, the routing work for security is greatly simplified.

[Fifth Embodiment] FIG. 19 schematically shows a configuration of a communication system according to a fifth embodiment of the present invention. In FIG. 19, sites # 1, # 2, and # 3
Are interconnected by a wide area network 41. In the site # 1, a DB server / relay server 51 having functions of a database (DB) server and a relay server
Is arranged. The PC 11 is connected to the DB server / relay server 51 via a private LAN 411.
The DB server / relay server 51 is a wide area LAN.
421 and the wide area network 4 via the router 231
1

In site # 2, a DB server / relay server 52 is provided. The DB server / relay server 52 is connected to the PC 12 via the private LAN 412. Also, it is connected to the wide area LAN 422. Wide area L
The AN 422 is connected to the wide area network 41 via the wide area connection router 232.

In the site # 3, the relay server 53
Is arranged. The relay server 53 is connected to the local LAN 4
13 is connected to the PC 13 and the wide area LAN 42
3 is connected to the router 233. The wide area LAN 423 is connected to the wide area network 41 by the router 233.

The DB server / relay server 51 has a relay function 511 and a relational database 211.
21 and a relational database 212. These DB server / relay servers 51 and 52
Has a communication monitoring program and an operation logic program as a DB server, can perform a database operation by a logic call, and has a relay function 51
1 and 521, premises LANs 411 and 412
Of the PCs 11 and 12 located in the other site can be connected to other sites.

The relay function 511 of the DB server / relay server 51 manages connection of the PC 11 connected to the local LAN 411 to another site, and the relay function 521 of the DB server / relay server 52 controls the PC 12 connected to the local LAN 412. Manage connections to other sites.

The relay server 53 manages connection of the PC 13 connected to the private LAN 413 to another site, as in the fourth embodiment.

The routing of the connection between the sites # 1, # 2 and # 3 via the wide area network 41 is executed between the relay server and the DB server / relay server. For example, in the DB server / relay server 51, compliance at the time of the connection request is executed for each relay server. That is, in routing to the DB server / relay server 51, routing for ensuring security is defined for each of the DB server / relay server 52 and the relay server 53.

For the DB server / relay server 52, a routing for ensuring security is defined so as to allow the connection between the DB server / relay server 51 and the relay server 53. The relay function 511 of the DB server / relay server 51 manages the connection of the PC 11 connected to the local LAN 411. That is, DB
In the server / relay server 51, the local LAN 41
1 and IDs of the relay server 53 and the DB server / relay server 52 for permitting connection from the sites # 2 and # 3.
Is kept in the connection allowed list.

Therefore, for example, the PC at site # 3
13 via the relay server 53 and the routers 233, 231, and 232 for wide area connection,
Establishing connections to DB / relay servers 51 and 52 at site # 1 and site # 2 and their relational databases (RDB) 211 and 21
2 (search / update / delete / insert).

PC 11 provided at site # 1 can connect to DB server / relay server 51 provided at site # 11, access relational database 211, and perform data operations. Also,
This DB server / relay server 51 also operates as a relay server, and the relay function 511 causes the DB server / relay server 52 included in the site # 2 to send a PC1
1 is a relay function 511, a wide area LAN 421, a router 2
31, the wide area network 41, the router 232, and the wide area LAN 422, and can execute data operations on the relational database 212 of the site # 2.

Similarly, PC 12 included in site # 2 also
Relational database 21 included in site # 1
1 can be accessed. Therefore, site ♯
1, # 2 and # 3 each have a relay function 51
By providing 1, 521 and 531, PCs included in each site can access a desired database. Routing is defined for each relay server-database server (DB server), and P
There is no need to define the routing in C units, and even if the number of PCs is greatly increased in a wide area connection, the routing work for ensuring security does not become complicated and security can be easily maintained.

FIG. 20 is a diagram schematically showing the configuration of DB server / relay server 51 shown in FIG. 20, a DB server (database server) / relay server 51 includes a local LAN 511 and a wide area LAN 421.
Request monitoring program 51a for monitoring communication requests to
And a relay function relay program 51b which is started under the control of the communication request monitoring program 51a and relays communication, and which is started under the control of the communication request monitoring program 51a and has a relational database (RDB) 2
11 includes an operation logic program 51c for performing data operations on the data 11.

The relay function relay program 51b has a function similar to that of the relay function relay program in the fourth embodiment, and relays communication with a PC connected to the local LAN 411. Operation logic program 51c
Is the same as the operation logic program in the first embodiment, activates the start-time operation logic, accesses the relational database 211, and executes the specified data operation.

This DB server / relay server 51 further includes its own site connection permission list 51d, another site connection permission list 51e, and a relational database (R).
DB) includes a connection permission list 51f. The own site connection permission list 51d stores information that specifies a PC that is connected to the local LAN 411 and can access the database of another site or the relational database 211 of the own site. Other site connection permission list 51
“e” stores information that specifies a relay server that is permitted to access the database server from another site.
The RDB connection permission list 51f stores information for specifying a relay server that can access the relational database 211.

The communication request monitoring program 51a refers to the own site connection permission list 51d and the other site connection permission list 51e when a communication request is given, and determines whether or not to accept the communication request. At the time of this communication request, the communication request monitoring program 51a determines whether the connection request destination from the PC is the relational database 211 of its own site or the database server of another site, and is issued from the PC at the time of this connection request. Then, the relay function relay program 51b or the operation logic program 51c is started by referring to the host name. When the operation logic program 51c is activated, the RDB
With reference to the connection permission list 51f, the communication is performed with the relay server or the PC (in the own site) which has requested the connection. In this communication, the operation logic program 51c may activate the relay function relay program 51b and communicate with the other party using the relay function.

This communication request monitoring program 51a constantly monitors communication requests on the local LAN 411 and the wide area LAN 421. This communication request monitoring program 51a
May be separately provided for each of the relay function and the operation logic program. Further, the user name of the PC of the own site may be registered in the RDB connection permission list 51f.

As described above, according to the fifth embodiment of the present invention, since a relay function is provided in each site, it is possible to easily access necessary database servers and perform data operations. it can. Further, by providing the relay function, the routing of the connection between the sites can be performed on a relay server basis, and the work load and the amount of personnel for routing for ensuring security are reduced.

[Sixth Embodiment] FIG. 21 is a diagram schematically showing a configuration of a communication system according to a sixth embodiment of the present invention. 21, in each of sites # 2- # 4, a database server (DB server) 22-24 is provided.
Is arranged. In the site # 1, a PC 11-13 having a database operation function, a PC 14 used by all users, a PC 15 used by a system administrator, and a relay server 51 provided commonly to these PCs 11-15 are arranged. Is done. The relay server 51 includes a relay function 511, a file transmission function 512 for transmitting a file, and a web (Web), as in the fourth embodiment.
File 560 storing the information of PC 1 and PC 1
A version management function 550 for managing the software (S / W) version in 1-14 is included.

For site # 2- # 4 and site # 1, routing for ensuring security is defined for each relay server. The relay function 511 and the version management function 550 can operate in parallel.
In the configuration shown in FIG. 21, an automatic download function is realized by relay server 51 of site # 1. That is, the latest version of the program introduced to the PC 11-15 is managed by the version management function 550 provided in the relay server 51. The latest version of the program is uploaded from the PC 15 used by the system administrator to a file in the version management function 550, and the latest version of the program is downloaded to the PC 14 used by all users. This P
The latest version of the program is downloaded to the C14 when the PC 14 starts the automatic download menu screen. The program on the PC 14 accesses the version management function 550 mounted on the relay server 51. As a result, this download is executed.

The PC 11-13 also downloads the latest version of the screen program.
At this time, the PC 11-13 may also download the latest version of software uploaded from the PC 15 for the system administrator when the PC is started or when the automatic download menu screen is started.

The program uploaded from the system administrator PC 15 may be the communication function 114 shown in FIG.
All the programs located at -14 are to be downloaded.

By providing this automatic download function, all of the PCs 11 to 14 within the site # 1 can use the same version of software. , And a highly reliable database operation environment can be realized.

The automatic download function is available at the site
-It can be introduced to each of the database (DB) servers 22 to 24 arranged in each of # 4. According to the version upgrade of the screen program for database operation, the operation logic program can be changed to the operation logic program matched to the latest version. Next, the automatic download operation will be described with reference to FIG. 22 showing the procedure of automatic download.

For the version management function 550, a latest source code file 551 for storing the latest source code (the latest version of the program) and a version management file 552 for managing the software version are provided.

First, the system administrator introduces the latest version of the software 555 to the PC 15 (step S71). Next, the system administrator drives the upload tool 553 on the PC 15. The upload tool 553 is used to update the latest version of the software 55 set in the PC 15 and the version management file 55 provided in the relay server 51.
2 is compared with the latest source code 551 version stored in the relay server 51 (step S72). In this case, the version management function 550
In response to a comparison request from the upload tool 553, the version management file 552 and the corresponding version information are read, or both versions are compared, and the comparison result is transmitted to the PC.
Give to 15. If the version recorded in the version management file 552 is older than the version of the latest version software 555, the upload tool 553 sends the source code 5 to the version management function 550.
It notifies that 51 is rewritten.

[0200] The version management function 550
5, the latest version software 555 transmitted
The contents of the latest source code file 551 are rewritten. At the time of uploading the latest version software, the file transmission function 512 shown in FIG.
55 is transmitted in a file format, and the latest source code file 551 is rewritten. At this time, the version information of the corresponding software is updated in the version management file 552 (step S73).
The upload tool 553 records this update date in the version management file 552. The version management file 552 manages the latest version of software that can be used at the site # 1 at all times. The latest version of the software is therefore always kept in the storage location of the latest source code 551 on the relay server 51.

When a general user activates a menu screen 554 for activating an application for performing a task on the PC 14 (step S74), the latest version of application software is confirmed (step S75). That is, when menu screen 554 is activated in step S74, PC1
4 is a version management function 550 on the relay server 51.
, The version management file 552 is accessed. At this time, the version comparison may be performed for all application software on the menu screen 554, or when one application software is designated, the version comparison of the designated application software may be performed. The version of the application software stored in the version management file 552 is compared with the version of the application software 556 installed on the PC 14. This comparison is made using the version control function 5
It may be performed at 50 or may be performed at PC 14. The comparison using the version management function 550 is preferable for reducing the load on the software of the PC. Application software 556 on PC 14
If the version is older, the PC 14 issues a download request to the version management function 550. To issue the download request, the latest version software is downloaded using the download tool displayed on the menu screen 554 (step S7).
6). Even at the time of this download, the transmission source code 5 using the file transfer function 512 shown in FIG.
51, under the management of the version management function 550, P
Downloaded to C14. After this download,
The user can use the latest version of the application software on the PC 14, and starts the application software (step S77).

The download of the latest version of the software is similarly executed in the other PCs 11-13. Therefore, in this site # 1, PC11
With any one of -14, the latest version of application software can be started, processing can be performed according to the same version of application software, and data consistency is maintained. Further, the system administrator simply uploads the latest version of the software to the relay server 51, and does not need to install the latest version of the software on all the PCs in this site # 1. PC application software version can be unified to the latest version.

The application software includes a communication function 114 by a screen program 111.
Software and an OS for realizing (see FIG. 1) are also download targets. Therefore, the PC 11-14 can access the database system using the latest version of the application software and operate data.

[0204] This download function is provided on site {2-}.
The operation logic programs corresponding to these application programs can be easily changed to the latest version by providing them also in each of the 4 database servers (DB servers) 22-24. Also,
When PCs are arranged in sites # 2 to # 4, the version of application software of these PCs can be easily updated using the version management function 550 provided in the database server / relay server 51 in one site. And run it.

As described above, according to the sixth embodiment of the present invention, the version management function is provided on the relay server and / or the database server. Software can be downloaded, and the system administrator can easily update the application software of all PCs to the latest version.
Can use the same version of application software.

[Seventh Embodiment] FIG. 23 schematically shows a configuration of a communication system according to a seventh embodiment of the present invention. In the configuration shown in FIG. 23, site # 1
The relay server 51 arranged above is provided with a batch job execution function 591, a batch job management function 592, and a web (Web) result file 560. This configuration is the same as the configuration shown in FIG. The batch job function is a process that is performed periodically (daily, weekly, monthly, etc.) in a typical database search process, etc., by defining it in a condition file called batch job and registering it in the system. This function automatically executes this process and outputs the result. This is an effective method for automating routine work to access a database.

A batch job management function 592 schedules and manages the registered jobs.
A database search is executed according to a condition specified in advance, and the search result is output to a viewable file (Web homepage). This batch job management function 592
Manages registration, change and deletion of batch jobs.

The batch job execution function 591 executes the registered batch job. The web (Web) result file 560 serves as a platform (homepage) for outputting a database access result. This web (Web) result file 560 is a so-called homepage, and can be easily browsed from the PC 11-14 by designating the homepage address. In addition, these PCs 11 to 14 are connected to a web (We
b) The result file 560 can be downloaded. Therefore, by uploading frequently used search results to the web (Web) result file 560 of the homepage, the user can easily and quickly browse required search results from the PC 11-14. .

The operation conditions of the database and the execution conditions of the batch job are uploaded from the PC 15 for the system administrator to the relay server 51 and managed by the batch job management function 592. Under the control of the batch job management function 592, the batch job execution function 591 is activated according to the scheduling, and the site # 2
-Access any one of the database servers 22-24 provided in # 4, operate the database, and output and store the operation result to the Web result file 560.

[0210] The Web result file 560 is a file, and thus the data transmitted from the database is not a table format but a comma-enclosed format (CSV format) file in ASCII format. In this case, as the operation logic of the batch job execution function 591, instead of the table operation logic, the logic of a command output as a CSV-format data file using “comma” may be used. In the batch job execution function 591, the table format data is
For example, the file may be converted into an HTML format file and stored in a web (Web) result file 560 (for example, there is software called an SQL server Web assistant).

Next, a batch job function according to the seventh embodiment of the present invention will be described with reference to a flowchart shown in FIG.

A condition for searching (or operating) a database in the PC 15 for the system administrator is created as a search condition file 563. This search condition file 56
The definition content of 3 depends on the logic of the operation program 562 existing on the relay server 51, and is defined in a parameter format necessary for executing the logic of the operation program 562. For example, this search condition file 5
The parameters defined in 63 include the type of data to be searched, the items and values to be searched, the search range, and the like. The search condition file 563 created on the system administrator PC 15 is installed on the relay server 51 using the upload tool 553 used in the automatic download function described in the sixth embodiment.
Step S82 for uploading the search condition file 563 is executed as follows. First,
Access the batch job management function 592 (step S
81), confirm the registration status of this batch job. By checking the registration status, it is determined whether the same job has already been defined. If the same job has already been registered, the search condition is newly defined for the registered job. If a new batch job has not been registered, it is determined that a new batch job has been created,
The batch job management function 592 secures an area for registering a new batch job, and waits for transmission of the search condition file 563. Next, using the upload tool 553 from the PC 15 for the system administrator, the batch job management function 5
The search condition file 563 is transmitted to the file 92 using the file transmission function. As a result, in the batch job management function 592, the search conditions are stored and managed in a file format (step S82).

The batch job execution function 591 executes time management using a clock provided in the relay server 51, and is activated when the execution time of the job registered in the batch job management function 592 comes (step S84). The operation program 562 is executed (Step S85).

In the batch job execution function 591, execution time information of each job is given by scheduling of the batch job management function 592, and the given batch job execution time is monitored by its clock.

The operation program 562 has the same configuration as the screen program 611, and defines the database access logic. Therefore, this operation program 562 makes a logic call to activate the operation logic program in the designated database server (DB server) 22. The operation program 562 is
At the time of activation, access is made to the relational database 211 of the database server 22 via the relay function 511 (step S86). This operation program 562 is
At the time of startup, referring to the batch job search (operation) conditions registered in the batch job management function 592, access the relational database of the database server 22 and execute data operations (search / update / insert / delete). .

The result information transmitted from the database server 22 is output as a result file 560 on a Web in a file format by a file transmission function. Web) The user can browse the result file 560 (step S87). As described above, the Web result file 560 contains the AS
This is a comma-separated value (CSV) file in the CII format. The user who wants to view the result file 560 has P
In either the C14 or the PC 11-13, the browser 564, which is a browsing program, is started to access and browse the Web (Web) result file 560. At this time, the user can start the spreadsheet software 565 using the browser 564 to download the web (Web) result file 560 and download the search result file in a table format (step S89). ).

The spreadsheet software 565 is used to convert an ASCII comma-separated value (CSV) file into a table that can be operated by SQL.

Therefore, by storing frequently used search results in the Web result file 560, the user (PC operator) can access the database server of another site via the network. Required information can be easily obtained.

As described above, according to the seventh embodiment of the present invention, since the database operation result is output to the homepage of the Web site on the relay server, the user can easily output the homepage of the homepage. The user can browse the Web result file by specifying an address, and can search for required information at high speed.

FIG. 25A is a diagram schematically showing the configuration of the batch job execution function. Batch job execution function 5
Reference numeral 91 is realized by software and starts a job at a specified time at a specified cycle. This time is measured by monitoring the current time by the clock of the computer in the relay server 51. The batch job execution cycle is specified by the type (job ID) of the batch job.

The types of jobs that can be scheduled by the batch job management function 592 include a schedule 591a to be executed at a designated time every day, a schedule 591b to be executed at a designated time every week, a schedule 591c to be executed at a designated time every month, and a designated Schedule 591d to be executed only once at the specified date and time, and schedule 591e only to register the job without specifying execution.

The batch job execution function 591 executes a job according to the scheduling set when the job is registered in the job file. When the batch job execution function 591 is executed, a job I for specifying a job to be executed
D and functions 591a-591e representing the cycle are linked and held, and time monitoring is performed. Schedule 591
The job executed by d which is started only once at the designated date and time is usually used when executing a job that requires a long time for operation processing, such as at midnight when the load on the computer is low. When the job is executed and the processing is completed normally, the job is automatically deleted under the control of the batch job management function 592.

In the schedule 591e in which registration is performed without designating execution, only a job is registered, and is mainly used for recording a job condition so as not to forget it. These schedules 591a-59
In 1e, at the time of job registration, the time at which the job should be started and the job start interval are designated by the user via the PC 15.

FIG. 25B shows the batch job management function 5
FIG. 2 is a diagram schematically showing a configuration of a second embodiment. The batch job management function 592 includes a batch job registration function 592a,
Batch job deletion function 592b, search (operation) condition reference / change function 592c, batch job start condition change function 592d, and batch job forced execution function 5
92e. When a batch job is newly registered in a job file by the batch job registration function 592a, a job ID is generated and held in a linked state with a start time cycle scheduled by the batch job execution function 591. The batch job execution function 591 is changed by the batch job start condition change function 592d.
, The job execution time is changed. The search condition reference / change function 592c is operated by the operation condition (search / insert /
(Deletion / change) is referred to at the time of job execution, or is changed by an operation condition change instruction from the user.

The forced execution function 592e of the batch job is
In the scheduling, the registered job is forcibly executed according to the job schedule 591e of only registering without specifying execution. The batch job forced execution function 592e can be used to immediately execute another type of job.

The functions performed by the batch job management function 592 are specified by the system administrator by activating the upload tool 553 using the PC 15 for the system administrator.

The operation result of this batch job is displayed on the web (W
eb) By outputting and holding the result file 560, the latest data can always be easily browsed.

[Eighth Embodiment] FIG. 26 schematically shows a configuration of a communication system according to an eighth embodiment of the present invention. In the configuration shown in FIG. 26, a web (Web) search site function is mounted on relay server 51. In the relay server 51, the web (We
b) Result file 560 and homepage screen 609
And an operation program 562 are arranged. This homepage screen 609 includes a search condition input screen 610 and a result output screen 611, and transfers the specified homepage screen to the user according to a user command when the user accesses.

This Web (Web) search site function
It is configured by combining the above-described relay function 511 and the batch job search function, and the like.
W) A function for inputting search conditions from a search condition input screen 610 on the server, executing the operation program 562 to search the database, and displaying the search results on the result output screen 611. The web server is a relay server 5
1 is built. As the operation program 562 and the relay function 511, those used in the above embodiment are used. Next, an operation of searching the relational database 211 of the database (DB) server 22 using the Web (Web) search site function will be described.

The user operates the Web (Web) on the PC 14.
b) Move the browser 564 which is viewing software (step S91). The browser 564 accesses the homepage screen 609 of the relay server / web server 51 and browses the search condition input screen 610 included therein. The user inputs search conditions on this search condition input screen 610, which is, for example, a dialog box (step S92). When the input of the search condition on the search condition input screen 610 is completed, the operation program 562 is started by the search condition input completion instruction and the execution instruction (step S93). The activation of the operation program 562 is performed by the relay server / web (We
b) It is executed by a computer (processing device) provided in the server 51. Operation program 562 includes a logic number indicating each logic of an operation logic program for performing the search operation, and a parameter indicating the input search condition. When the operation program 562 is started, a database (DB) is transmitted via the relay function 511.
This operation information is transferred to the server 22 by a logic call procedure, and a search for a corresponding database is performed in the relational database 211 (step S9).
4).

When the search operation is completed, the search result is returned from the database server 22 (operation logic program) via the relay function 511 again. The returned search result is output on a result output screen 611 or is output as a web result file 560 on the web. Which one to output
It is defined when a search condition is input on the search condition input screen 610. The file output on this Web is
As described above, it is usually a comma-wrapped (CSV) format in ASCII format. The data output on the result output screen 611 can be viewed by the user with the browser 560 (step S96). The web (W
The result file 560 output on eb) can be downloaded onto the PC 14 by the browser 560.

At the time of this database search operation, the operation program 562 uses a normal SQL message to
The server 22 may be accessed. Therefore, at this time, the database server 22 has the same configuration as the conventional database server, and may be configured to execute an operation according to an SQL message. It is only necessary that the relay server 51 has a Web search site function.

The above-mentioned method is called a client / server / server method, and is composed of three layers: a client called PC, a database server, and an application server called Web. By separating the database server and the application server, it is possible to avoid concentration of the load on the computer of the database server, and to realize high-speed database access by reducing the load on the computer.

[Ninth Embodiment] FIG. 27 schematically shows a configuration of a communication system according to a ninth embodiment of the present invention. In the system shown in FIG. 27, semiconductor manufacturing apparatuses 641 to 643 are provided at site # 1. In order to control the processing steps of these semiconductor manufacturing devices 641 to 643, control devices (PC) 611 to 613 with a communication function are arranged as terminals. These control devices 611-613 are connected to the DB server 622 provided at the site # 2-site # 4 via the relay server 51.
624 can be searched. These D
In the corresponding databases DB # 1-DB # 3 of the B servers 622-624, the semiconductor manufacturing device 6
Data necessary for semiconductor device manufacturing processing such as manufacturing parameters (processing temperature / time, dose amount, etc.) of 41-643 are stored. Communication between the control devices 611-613 and the DB servers 622-624 via the relay server 51 uses the method described in the first to eighth embodiments.

In the DB servers 622-624, control data such as manufacturing parameters required in each step of manufacturing the semiconductor device is stored in the database DB # 1-DB # 3, and the manufacturing process of the semiconductor device by the semiconductor manufacturing apparatus is collectively performed. to manage. The processing device 611-613 downloads parameter data necessary for the manufacturing process stored in the DB server 622-624, and according to the downloaded data, sets each parameter (processing temperature, implanted ion concentration, (Etching gas concentration, etc.).

In the DB servers 622-624, processing parameters of different manufacturing steps may be stored. Also in site # 2 to site # 4, semiconductor manufacturing devices may be provided, and these may be configured to access the DB servers 622-624 by a corresponding processing control device and search for data. In the case of this configuration, it is possible to perform processing such as communication between the semiconductor manufacturing apparatuses to obtain consistency of the processing parameters.

By collectively storing the data necessary for the manufacturing process such as the processing parameters in the database, the parameters of the respective manufacturing apparatuses 641 to 643 can be easily reset even when the processing parameters are changed when a defect occurs, for example. Can do it.

Control devices 611-613 monitor the setting of operation parameters, operation control and operation status of corresponding manufacturing device 641-43 based on these transferred data (manufacturing parameters).

In the version management function 550, these control devices 611 to 613 have communication function programs, and manage the latest versions of these communication function programs. Also, a web (Web) result file 5
In 60, for example, these control devices 611-6
13 stores data commonly used or a manufacturing process management list (recording of manufacturing processes). The control devices 611-613 manage the manufacturing process using the management list stored in the web result file 560. In this way, even when a defect occurs, the cause of the defect can be easily specified.

The job management function (592) executes processing such as backup of control data.

The PC 15 for the system administrator manages the overall processing steps of the semiconductor manufacturing apparatuses 641 to 643 under this control, monitors the operation status of the control apparatuses 611 to 613, and controls the operation of the control apparatuses 611 to 613. Monitors the version of programs such as communication programs.

In the communication system shown in FIG.
By storing data such as manufacturing parameters in the databases DB # 1-DB # 3, semiconductor manufacturing processes can be centrally managed, for example, centrally, and it is necessary to install data for each control device individually. And the monitoring of the manufacturing process is simplified.

In the ninth embodiment, the communication modes of the first to eighth embodiments can be used. When these control devices 611-613 need to access the databases DB # 1-DB # 3 via the relay server 51, for example, in the production process management, the actual operation status of the production devices 641-643 It may be performed to perform collation with data to be set.

The type of semiconductor device manufactured in the semiconductor manufacturing apparatus is arbitrary. Site # 2-
Also in # 4, a semiconductor manufacturing apparatus may be provided.

Also, unlike Embodiment 1, a relay server may not be provided. As described above, according to the ninth embodiment of the present invention, a management system for a semiconductor manufacturing apparatus is constructed using the communication systems of the first to eighth embodiments, and efficient management of a semiconductor manufacturing process is achieved. A management system for a semiconductor manufacturing apparatus that can be performed can be constructed.

[Other Configurations] In the communication systems of the first to ninth embodiments, each component such as a PC, a relay server, and a database server is generally formed of a semiconductor device. Further, each software and each tool for realizing each function also run on the semiconductor device to realize a predetermined function. Therefore, the communication system according to each of the embodiments is generally a communication system configured by a semiconductor device to realize each predetermined function.

[0247]

As described above, according to the present invention, it is possible to construct a database communication system capable of performing database operations at high speed and efficiently while ensuring security.

That is, according to the first aspect of the present invention,
An operation logic for operating the database is arranged in the database server, and a logic call is made from the computer terminal, so that the communication amount between the database server and the computer terminal can be reduced, and Operation performance can be greatly improved.

According to the second aspect of the present invention, since the database server is provided with a file transmission function, the user can use both table format data and file data as file format information.

According to the third aspect of the present invention, the communication management is performed by activating the operation logic program in response to each connection request from the terminal, and a plurality of connection requests can be received in parallel. It is possible to construct an efficient database communication system.

According to the fourth aspect of the present invention, since the system is configured to log on to the database server and the database and log off from the database server after logging off to the database, the logic call function can be used. The operation of the database can be performed by the same access procedure as in the conventional case.

According to the invention of claim 5, the database server responds to the connection request with a means for designating a connection method to the computer terminal, and the database server makes a connection to the computer terminal in accordance with the designated connection method. The connection between the database server and the computer terminal can be realized according to the communication method of the computer terminal that has made the connection request (for example, a dedicated line, an ISDN line, a normal telephone line, etc.).

According to the invention of claim 6, a relay server that manages communication between the plurality of computer terminals and the database server is provided between the plurality of computer terminals and the database server. Network security is maintained only by the definition between the database server / relay server, it is not necessary to define security routing and firewall for each computer terminal, and wide area security is easily maintained. can do.

According to the invention of claim 7, this relay server merely relays the given communication information, and this relay server simply functions as a repeater,
High-speed communication can be realized.

According to the eighth aspect of the present invention, the database server is provided with a relay function, and the relay server and the computer terminal are arranged at a site different from the database and the server. It is only necessary to define a routing for maintaining security on a relay server basis, and security can be easily maintained.

According to the ninth aspect of the present invention, the database server includes operation logic program means, and the computer terminal is configured to have a logic call function, so that high-speed data communication can be realized.

According to the tenth aspect, the latest version of the mother program is stored in the relay server,
Since the configuration is such that the mother program is downloaded when the computer terminal is started, various business application software and SQL communication software (including middleware) used in the computer terminal can be automatically upgraded. Software replacement for software, OS, and communication software version upgrades can be performed automatically, software versions on the site can be matched, and the time and effort for software replacement can be reduced.

According to the eleventh aspect of the present invention, since the inquiry processing that is periodically executed is scheduled and the result of the inquiry processing is output to the web server, the routine database access business is performed. Can be automatically processed, and routine tasks can be simplified.

According to the twelfth aspect of the present invention, the registered job is executed in a designated cycle unit,
Since the operation for the registered job is enabled, the required job can be automatically executed easily, and the routine work can be greatly simplified.

According to the thirteenth aspect, since the input of the query condition of the database of the database server and the output of the query result are performed on the Web, the client / server / server 3 A hierarchical model can be realized, the load on the computer is distributed, and high-speed database access can be realized. According to the invention of claim 8, further, by managing the computer terminals on a relay server basis, there is no need to install SQL communication software (middleware) for each computer terminal, and the amount of work and personnel required for this installation are reduced. Are all unnecessary.

According to the fourteenth aspect of the present invention, the database server is provided with logic program means, the logic of the logic program means is specified by the logic number, the database is accessed, and the processing result is transferred to the terminal. With this configuration, the communication efficiency between the terminal and the database server can be significantly improved.

According to the fifteenth aspect of the present invention, a logic program means including a plurality of operation logics is provided so that this logic call is made from a computer terminal.
The traffic can be significantly reduced, and the database operation performance can be greatly improved.

According to the sixteenth aspect of the present invention, the logic program means of the fifteenth aspect is provided with a file format means for transmitting the execution progress in a file format. Information can be presented.

According to the seventeenth aspect of the present invention, when a plurality of logic program means are provided, and one of the logic program means is activated by the communication request monitoring program means, the communication management is performed by the activated logic program means. And communication execution, can receive a plurality of connection requests in parallel,
An efficient database communication system can be constructed.

According to the eighteenth aspect, according to the first aspect,
In response to the connection request from the computer terminal, the computer device specifies the connection mode with the computer terminal, establishes a connection with the computer terminal in the specified connection mode, In the communication method, a connection between the database server and the computer terminal can be made.

According to the nineteenth aspect, the configuration is such that the logic included in the logic program means of the database server is taken into consideration, and the communication traffic at the time of accessing the database server can be greatly reduced.

According to the twentieth aspect, after sequentially logging on to the database server and the database, the processing contents are transmitted in SQL, and after logging off to the database, the user is logged off from the database server. Therefore, even when the logic call function is used, the database can be operated in the same access procedure as in the conventional communication system.

According to the twenty-first aspect of the present invention, the relay server is provided with a function of managing the communication between the plurality of computer terminals. Is only required to be managed, and wide-area security can be easily maintained.

According to the invention of claim 22, the communication message is relayed in response to the connection permission from the database, and this relay server can function as a repeater, and high-speed communication can be performed. Can be realized.

According to the twenty-third aspect of the present invention, the database server is provided with a relay function, security can be defined for each relay server, and the security of the system can be easily maintained.

According to the invention of claim 24, both the database server site and the computer terminal site require only a routing procedure for maintaining security on a relay server basis.
Security can be easily maintained.

According to the twenty-fifth aspect of the invention, the latest version of the mother program is stored in the relay server, and the latest version of the mother program is always downloaded. According to this, the relay server is provided with a job management function, and is configured to output a query result of the job to the web server, so that a typical database access operation can be automatically processed, and a routine operation can be performed. It can be simplified.

According to the twenty-seventh aspect of the present invention, the web server is provided in the relay server so that the computer terminal can easily access the web server. It can be used, and an efficient database server operation environment can be realized.

According to the twenty-eighth aspect of the present invention, a function for registering, executing, and managing jobs is provided in the relay server, so that routine work can be greatly simplified.

According to the twenty-ninth aspect, a database query condition is set in the web server, the database is accessed according to the query condition, and the result is stored in the web server. Can be performed collectively, and a three-tier model of client / server / server is realized, the load on the computer is distributed, and high-speed database access can be realized.

According to the invention of claim 30, according to claim 1,
4 uses a control device of a semiconductor manufacturing apparatus, stores data including a manufacturing process parameter in a database, and can perform batch management of the semiconductor manufacturing apparatus, thus efficiently managing the semiconductor device. A system can be built.

According to the invention of claims 31 to 33, the data necessary for the semiconductor manufacturing apparatus is stored in this database server, and an efficient management system for the semiconductor manufacturing apparatus can be constructed.

According to the thirty-fourth aspect, a logic call is made to the database, the data is processed by the logic in the database, the processing result is transmitted to the terminal, and the processing conditions of the semiconductor manufacturing apparatus are set on the terminal. This makes it possible to construct an efficient semiconductor manufacturing apparatus management system.

According to the invention of claim 35, the terminal is configured to communicate with the database server via the relay server, and the relay server determines whether the communication request is permitted or not. Therefore, it is only necessary to define the security of the communication system for each relay server, and an efficient management system for semiconductor manufacturing equipment can be constructed.

According to the invention of claim 36, claim 3
In the method 4, the data is stored in the website of the relay server, and frequently used data can be easily accessed by the terminal.

According to the thirty-seventh aspect, the execution result of the job is stored in the web server and downloaded to the terminal, so that frequently used data can be stored without accessing the database. It can be used, and an efficient management system of a semiconductor manufacturing apparatus can be constructed.

[Brief description of the drawings]

FIG. 1 is a diagram schematically showing a configuration of a communication system according to a first embodiment of the present invention.

FIG. 2 is a diagram schematically showing a configuration of a screen program shown in FIG.

FIG. 3 is a diagram schematically showing a configuration of an operation logic program shown in FIG. 1;

FIG. 4 is a sequence diagram showing a communication operation of the communication system shown in FIG.

FIG. 5 is a diagram schematically showing a configuration of information transferred from a computer terminal to a database server according to the first embodiment of the present invention.

FIG. 6 is a diagram schematically showing a configuration of a modification of the first embodiment of the present invention.

FIG. 7 is a flowchart showing an operation of a computer terminal in the communication system according to the second embodiment of the present invention.

FIG. 8 is a flowchart showing the data pasting flow shown in FIG. 7 in more detail;

FIG. 9 shows a configuration and an operation sequence of a database server according to a third embodiment of the present invention.

FIG. 10 is a diagram schematically showing a configuration of an operation logic program shown in FIG. 9;

FIG. 11 is a diagram showing a modification of the third embodiment of the present invention.

FIG. 12 is a diagram schematically showing a configuration of a communication system according to a fourth embodiment of the present invention.

FIG. 13 schematically shows a modification of the fourth embodiment of the present invention.

14 is a diagram schematically showing a configuration of a connection permission list of the relay server shown in FIG.

15 is a diagram schematically showing a configuration of a connection permission list of the database server shown in FIG.

FIG. 16 is a diagram schematically showing a configuration of a relay function shown in FIG. 12;

FIG. 17 is a sequence diagram showing a communication procedure of the communication system according to the fourth embodiment of the present invention.

18 is a diagram showing a connection state in each step in the sequence diagram shown in FIG.

FIG. 19 is a diagram schematically showing a configuration of a communication system according to Embodiment 5 of the present invention.

FIG. 20 is a diagram schematically showing a configuration of a database server shown in FIG. 19;

FIG. 21 schematically shows a configuration of a communication system according to a sixth embodiment of the present invention.

FIG. 22 is a flowchart showing an operation of the communication system according to the sixth embodiment of the present invention.

FIG. 23 schematically shows a configuration of a communication system according to a seventh embodiment of the present invention.

FIG. 24 is a diagram showing a communication procedure according to the seventh embodiment of the present invention.

FIG. 25 is a diagram schematically showing a configuration of a batch job execution function and a management function shown in FIG. 24;

FIG. 26 schematically shows a configuration of a communication system according to an eighth embodiment of the present invention.

FIG. 27 is a diagram schematically showing a configuration of a communication system according to Embodiment 9 of the present invention.

FIG. 28 is a diagram schematically showing a configuration of a conventional database operation communication system.

FIG. 29 is a diagram schematically showing a database operation procedure of a conventional database operation communication system.

FIG. 30 is a diagram schematically showing a configuration of a conventional screen program.

FIG. 31 is a diagram schematically showing a configuration of a conventional wide area communication system.

[Description of Signs] 11-15 PC, 21-24 Database server (DB server), 211, 211, 231 Relational database, 111A screen program, 114
Communication function, 216 Communication request monitoring program, 217
Operation logic program, LP @ -LP @ n operation logic, LN @ F file operation logic, 221 connection number definition file, 222 user management definition file, 223RDB environment definition file, 224 OS environment definition file, 218, 220a-220k port ,
51 relay server, 511 relay function, 251-2
53 access log, 261-263 connection permission list,
541 Communication request monitoring program, 542a-542n
Relay function relay program, 521, 531 relay function, 41 wide area network, 231-233 router, 512 file transmission function, 550 version management function, 560 web (Web) result file, 591
Batch job execution function, 592 Batch job management function, 562 operation program, 609 homepage screen, 610 search condition input screen, 611 result output screen, 622-624 database server (DB server), 631-33 control device (PC), 641 −64
3 Semiconductor manufacturing equipment.

Claims (37)

[Claims] 1. A communication system including a database server and a computer terminal, wherein the computer terminal generates processing information including a logic number specifying processing content and parameters required for the processing, and generates the generated processing information. The database server includes a database, and a logic program unit, wherein the process information specifies a logic included in the logic program unit by the logic number, and the logic program unit further includes a logic program unit. Executing the logic specified in accordance with the processing information, accessing the database, processing the access data, and transmitting the data obtained from the execution result to the computer terminal when the computer is started by being specified by the processing information A communication system that includes means for: 2. The communication system according to claim 1, wherein said logic program means includes a file format program means for transmitting execution result data in a file format. 3. A plurality of logic program units are provided, and the database server activates one of the plurality of logic program units provided in response to a connection request from the computer terminal, and is subsequently activated. 2. The logic program means for performing communication management and communication execution, further comprising means for monitoring another connection request.
A communication system as described. 4. The computer terminal, means for logging on to the database server, means for logging on to the database, means for transmitting the processing content in a structured query language (SQL) statement, and logoff from the database The communication system according to claim 1, further comprising: an end unit configured to log off from the database server after logging off from the database according to an instruction. 5. The database server includes means for constantly monitoring a communication request; and responding to the connection request from the computer terminal, causing the computer terminal to specify a connection method from the database server to the computer terminal. The communication system according to claim 1, further comprising: means for setting up a connection from the database server to the computer terminal according to the specified connection method. 6. A plurality of computer terminals, at least one database server, and communication provided between the plurality of computer terminals and being centralized between each of the computer terminals and the at least one database server. A communication system, comprising: a relay server for centrally managing. 7. The relay server permits communication with the one computer terminal when a communication request from one of the plurality of computer terminals to the database server on the at least one is permitted. 7. The communication system according to claim 6, further comprising means for relaying and transmitting a communication message with the database server. 8. A first site including a database server having a function of relaying communication information, and a first site provided separately from the first site, wherein (i) at least one
A communication including at least one computer terminal and a second site including: (ii) a relay server for relaying a communication message between the at least one computer terminal and the database server at the first site. system. 9. The database server includes a plurality of logics each of which executes a processing procedure and includes logic program means activated when a communication request is made, and the at least one computer terminal includes a specific logic program of the logic program means. Means for sending a communication message for activating logic, wherein the database server accesses the database by the activated logic of the activated logic program means, executes a process specified by the logic, and executes the execution result. 9. The communication system according to claim 8, further comprising: means for sending information obtained from the computer terminal to the computer terminal using the relay server. 10. A computer system, comprising: a plurality of computer terminals; and a relay server provided in common with the plurality of computer terminals, for relaying communication messages of the plurality of computer terminals. Storage means for storing a mother program, based on information indicating a comparison result of a version of a program corresponding to the mother program of the activated computer terminal of the plurality of computer terminals, Means for downloading to the activated computer terminal. 11. A means for scheduling and executing an inquiry process periodically executed, a management unit for registering an inquiry condition to the database of the inquiry process and managing the registration condition, and the inquiry Access the database according to the conditions,
Means for outputting the inquiry result on a predetermined Web (Web) server. 12. A means for registering a plurality of jobs, an execution means for executing a job registered in the registration means in a designated cycle unit, and registration, deletion, and reference of a job in the registration means And a job management unit for performing change and forced execution. 13. A database server including a database; a web server; a computer terminal for setting input of query conditions for the database and output of the query result in the web server; A communication system comprising communication means for performing communication with a web server. 14. A database comprising: a database; and logic program means each having a plurality of logics for executing a processing procedure for the database, wherein the logic program means includes a logic number specifying a logic from a terminal. A database server comprising means for executing the specified logic according to information, accessing the database, processing access data, and transmitting data obtained from the execution result to the terminal. 15. A control device for accessing a database in accordance with processing information from a computer terminal, wherein the control device includes at least one logic program unit including a plurality of operation logics each representing a processing procedure for the database. Includes a logic number specifying an operation logic included in the logic program unit and a parameter required for the processing, wherein the program logic unit starts and executes a corresponding operation logic according to the logic number, and executes the operation logic. Means for accessing a database, processing the accessed data according to the parameters, and transmitting data obtained from the execution result to the computer terminal.
Control device. 16. The control device according to claim 15, wherein said logic program means includes a file format means for transmitting said execution result in a file format. 17. The at least one logic program unit includes a plurality of logic program units, the control device further constantly monitors access to the database, and responds to a connection request from a computer terminal. A communication request monitoring program means for activating one of a plurality of logic program means provided, causing the subsequently activated logic program means to perform communication management and communication, and monitoring a connection request from another terminal. The control device according to claim 15, comprising: 18. A means for constantly monitoring a communication request, a means for responding to a connection request from the computer terminal, and causing the computer terminal to specify the connection mode, and a connection mode specification from the computer terminal. In response to
Means for establishing a connection with said computer terminal in said designated manner. 19. A terminal device for accessing a database server including a database, wherein the database server is provided with at least one logic program unit having a plurality of operation logics, wherein the operation logics are processing procedures. Means for generating processing information including a logic number representing the processing content and parameters necessary for the processing, transmitting the processing information to the database server, and receiving a processing execution result from the database server; Is a processing terminal that is executed under the control of the logic specified by the logic number in the database server, and the execution result is transmitted from the database server. 20. A means for logging on to the database server, a means for logging on to the database, a means for transmitting the processing contents in a structured query language (SQL) sentence, 20. The processing terminal according to claim 19, further comprising: an end unit configured to log off from the database server after the log off. 21. A means provided in common to a plurality of computer terminals for collectively managing communication between said plurality of computer terminals and at least one database server, and a connection request from said plurality of computer terminals. Means for determining whether to permit the connection request with respect to
Relay server. 22. When a connection is permitted by the determination means, a communication message is relayed and transferred between the computer terminal requesting the connection and the database in response to the connection permission given from the database requesting the connection. 22. The relay server according to claim 21, further comprising means. 23. The database according to claim 14, wherein said database server further includes means for relaying a communication message from a computer terminal provided at a site different from said terminal to a relay server. server. 24. A database, logic program means including a plurality of logics each representing a processing procedure for the database, monitoring a communication request, and when there is a communication request, the communication request is a connection request to the database. 23. The relay server according to claim 22, further comprising: a communication request monitoring unit that determines whether the request is a connection request to another site, and activates one of the relay transfer unit and the logic program unit according to the determination result. 25. A communication server which is provided in common for a plurality of computer terminals and relays communication messages of said plurality of computer terminals, wherein said communication server manages communication of said plurality of computer terminals collectively. Means, storing means for storing the latest version of the mother program, and comparing the version of the mother program with the version of the program corresponding to the mother program of the activated computer terminal of the plurality of computer terminals. Means for downloading the mother program to the activated computer terminal based on the information indicating the comparison result. 26. A relay server that is commonly coupled to a plurality of computer terminals and relays communication between the plurality of computer terminals, wherein a relay server periodically executes an inquiry process to a database. Means for registering query conditions to the database of the query process and managing the registration conditions; and accessing the database according to the registration conditions;
A relay server comprising: means for outputting the inquiry result to a predetermined Web server. 27. The relay server according to claim 26, wherein the web server is a web result file accessible by the plurality of computer terminals and provided in the relay server. 28. A relay server for relaying communication between a plurality of computer terminals, wherein permission / non-permission of communication of the plurality of computer terminals is determined, and a connection request of the computer terminal requesting connection is made according to the determination result. And means for registering a plurality of jobs in accordance with an instruction from at least one of the plurality of computer terminals, wherein the jobs are executed on a database periodically. Means for executing a job registered in the registration means in a specified cycle unit; and means for registering, deleting, referencing, changing, and forcibly executing a job in the registration means. A relay server comprising: a job management unit. 29. A web server, further comprising: means for accessing a database server according to an inquiry condition set in the web server, and storing the access result in the web server. The relay server according to claim 28, wherein the inquiry condition is set by a predetermined computer terminal among the computer terminals. 30. The database server according to claim 14, wherein the terminal is a control device of a semiconductor device manufacturing apparatus, and wherein the database stores data including process parameters required for manufacturing the semiconductor device. 31. The computer terminal according to claim 15, wherein the computer terminal is a control device of a semiconductor manufacturing apparatus, and the database stores data including process parameters required for manufacturing the semiconductor device in the semiconductor manufacturing apparatus. Control device. 32. The processing terminal according to claim 19, wherein the processing terminal is a control device of a semiconductor device manufacturing apparatus, and the database server stores control data of the manufacturing apparatus. 33. The plurality of computer terminals are control devices of a semiconductor manufacturing device, wherein the program includes a communication program for accessing a database server, and the database server has control data of the semiconductor manufacturing device. 3. The control data includes data indicating processing conditions of the semiconductor manufacturing apparatus.
5. The relay server according to 5. 34. Accessing from a terminal to a database server having a database and a logic program including a plurality of operation logics representing a processing procedure for the database, wherein the database contains data necessary for manufacturing a semiconductor device. The stored operation logic of the logic program is specified by a logic number given from the terminal, and the database server accesses the database according to the specified operation logic, executes processing of the accessed data, Transmitting data obtained as a result of the execution to the terminal, comprising, at the terminal, executing a predetermined process according to the transmitted data, wherein the predetermined process includes:
Including processing for controlling the manufacturing processing conditions of the semiconductor device,
A method for manufacturing a semiconductor device. 35. The relay server, further comprising: a step of accessing the database server from the terminal via a relay server; and a step of relaying data transmitted from the database server to the terminal via the relay server. 35. A step of determining whether to permit or disallow a communication request from the terminal.
The manufacturing method of the semiconductor device described in the above. 36. The semiconductor device according to claim 34, further comprising: a step of relaying a communication request from the terminal by a relay server; and a step of storing data transferred from the database server in a web site. Manufacturing method. 37. A step of registering a necessary job in the terminal and managing the registration condition, wherein the job indicates an inquiry processing to the database server that is periodically executed, and the database is in accordance with the registration condition. 35. The method of manufacturing a semiconductor device according to claim 34, further comprising: accessing a server, storing the access result in a predetermined web server, and downloading data of the website to the terminal.