TW479172B - Communication system, database server, control unit, processing terminal, relay server, and method of manufacturing a semiconductor - Google Patents

Communication system, database server, control unit, processing terminal, relay server, and method of manufacturing a semiconductor Download PDF

Info

Publication number
TW479172B
TW479172B TW089124554A TW89124554A TW479172B TW 479172 B TW479172 B TW 479172B TW 089124554 A TW089124554 A TW 089124554A TW 89124554 A TW89124554 A TW 89124554A TW 479172 B TW479172 B TW 479172B
Authority
TW
Taiwan
Prior art keywords
database
server
program
logic
communication
Prior art date
Application number
TW089124554A
Other languages
Chinese (zh)
Inventor
Hajime Matsumoto
Original Assignee
Mitsubishi Electric Corp
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Mitsubishi Electric Corp filed Critical Mitsubishi Electric Corp
Application granted granted Critical
Publication of TW479172B publication Critical patent/TW479172B/en

Links

Classifications

    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04LTRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L67/00Network arrangements or protocols for supporting network services or applications
    • H04L67/01Protocols
    • H04L67/10Protocols in which an application is distributed across nodes in the network
    • H04L67/1097Protocols in which an application is distributed across nodes in the network for distributed storage of data in networks, e.g. transport arrangements for network file system [NFS], storage area networks [SAN] or network attached storage [NAS]

Landscapes

  • Engineering & Computer Science (AREA)
  • Computer Networks & Wireless Communication (AREA)
  • Signal Processing (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

A computer terminal sends out a screen program representing a screen function via a communication function to a database server using a logic call function. The database server has a manipulation logic program corresponding to the screen program, starts a designated manipulation logic, and generates a message in structured query language, SQL, for access to a database. Thus, a database manipulation environment capable of readily maintaining security and efficiently performing database manipulation is provided.

Description

479172 五、發明說明(l) " 【發明所屬之技術領域】 本么明/步及進行資料庫伺服器與電腦終端通信的通信系 統及,=成要素和使用該通信系統的半導體裝置之製造方 t^ 步及確保安全且高速、高效進行具有關聯資料庫 白、二;:,、、饲服為'輿電腦終端之間通信用的通信系統。具體 而:/歩及私=結構化詢問語言(SQL語言)對關聯資料 庫進^存取的貪料庫系統用的通信系統以及使用該通信系 統的半導體裝置之製造方法。 【習知之技術】 總1來說’本發明對一般資料庫系統都有效。然而,特 ^ ^採用利用世界上已廣泛使用的SQL語言(結構化詢問 π σ )的關耳外資料庫: Reiati〇nai Data Base Sysjejn )和個人電腦終端的系統,則更為有效。因此,以 下說明SQL語言和關聯資料庫系統的特徵以及利用該語言 和^,的終端的〜般資料操作方式。 貧料庫:,是資料的集合體,習知在資料管理中利用檔 案系統。從操作電腦終端的終端用戶的角度,可將關聯資 料庫系一統看作表的集合體,冑應於例如資料庫内成批包含 1子貧料表”映射,按行和列構成表。即,該關聯資料 系統中,、終端用戶(電腦終端)向資料庫詢問某檢索時,以 表的升y式回其對應的結果。進入關聯資料庫進行 時,採用SQL語言。此SQL語言包括作為定義資料 用的語句的資料定義語言瓢、表示操作資料庫所存子放^表 料的浯句的貧料操作語言(DML),以及包含用於對資料庫479172 V. Description of the invention (l) " [Technical field to which the invention belongs] This communication / step and communication system for database server and computer terminal communication and manufacturing of components and semiconductor devices using the communication system Party t ^ step and ensure the safe, high-speed, and efficient execution of the communication system with the associated database white, two; ,,, and clothing are used for communication between computer terminals. Specifically: / 歩 和 私 = Structured query language (SQL language) access to a related database, a communication system for a corrupt database system, and a method of manufacturing a semiconductor device using the communication system. [Known Technology] Generally speaking, the present invention is effective for general database systems. However, it is more effective to use a system that uses a foreign language database (Structured Query π σ) that is widely used in the world: ReiatiOni Data Base Sysjejn and a personal computer terminal. Therefore, the following describes the characteristics of the SQL language and the associated database system, as well as the general data operation methods of terminals using the language and SQL. Poor material library: It is a collection of data. It is customary to use a file system in data management. From the perspective of the end user operating the computer terminal, the related database system can be regarded as a collection of tables. It should be mapped in the database, for example, in batches containing 1 sub-lean material table, and the table is composed of rows and columns. In the related data system, when the end user (computer terminal) asks the database for a search, the corresponding result is returned in ascending form of the table. When entering the related database, the SQL language is used. This SQL language is included as Data definition language scoops for defining data sentences, lean operation language (DML) representing haikus that store ^ tables stored in the operating database, and contain

mm

Η 第5頁 C:\2D-CODE\90-02\89124554.ptd 479172 五、發明說明(2) 物件設定許可權(安全性)和控制事物處理的語句的資料控 制語言DCL。作為資料操作語言DML,備有SELECT (資料檢 索)、UPDATE(資料更新)、insert(資料插入)和delete (資料刪除)等4種語句。 圖2 8為習知大規模資料庫系統結構的概略說明圖。圖2 8 中,資料庫系統包括多個分散配置的現場#丨、# 2和# 3。現場# 1、# 2和# 3中,分別配置資料庫伺服器2 j、2 2 和23。這些資料庫伺服器21〜23在電腦上保持有g料庫⑽5 Page 5 C: \ 2D-CODE \ 90-02 \ 89124554.ptd 479172 V. Description of the invention (2) Data control language DCL for setting permissions (security) of objects and statements that control things processing. As the data operation language DML, there are 4 kinds of statements: SELECT (data retrieval), UPDATE (data update), insert (data insertion), and delete (data deletion). FIG. 28 is a schematic explanatory diagram of a conventional large-scale database system structure. In Figure 2-8, the database system includes a plurality of distributed configuration sites # 丨, # 2, and # 3. In the scenes # 1, # 2, and # 3, the database servers 2j, 22, and 23 are respectively configured. These database servers 21 to 23 maintain a g library on the computer.

的許多資料(特別是,其資訊内容無具體規定),並由該 電腦集中管理。 ° /現場#1中配置檢索資料庫資料的電腦終端(個人電腦 等,只要是前端設備即可,以下用符號pc表示)丨丨〜1 4。 現場#1〜#3與地區、建築物、辦事處等場所以及 等規模和位置無關。 現% #1中,貧料庫伺服器2丨可連接該現場#1所 全部PC11〜14 ’這些pC11〜14能存取資料庫伺服器2 =庫DB的全部資料。圖27中,將檢索請求作為—個存取戸 容不出。Many of the data (especially, its information content is not specified), and is centrally managed by this computer. ° / Site # 1 is configured with a computer terminal (personal computer, etc., as long as it is a front-end device, which is indicated by the symbol pc) to retrieve the database materials. Sites # 1 to # 3 have nothing to do with areas, buildings, offices, etc., and their size and location. In the current% 1, the lean material library server 2 丨 can be connected to the site # 1. All PC11 ~ 14 'These pC11 ~ 14 can access the database server 2 = all the data of the library DB. In Figure 27, the retrieval request is not considered as an access.

現場# 1的PC11〜14與現場#2和#3的資料庫伺服哭22 和23可通過網路4連接。該網路4為互聯網和内部 路’實現現場間的通信連接。 、” 伺 21 為了使現場# 1所包含的p C丨i〜丨4能連接所有 服器21、22和23 ’需要開放連接路由,使資料庫貝伺枓服庫哭 〜23和PCI 1〜14的全部電腦間可通信(此連接路由的建。PC11 ~ 14 on site # 1 and database servos 22 and 23 on site # 2 and # 3 can be connected via network 4. This network 4 realizes a communication connection between the site for the Internet and the internal circuit '. "" 21 In order to make all the servers 21, 22, and 23 included in the scene # 1 can be connected to the server 21, 22, and 23 'Open connection routing is required to enable the database to serve the server ~ 23 and PCI 1 ~ All 14 computers can communicate with each other.

五、發明說明(3) 立一般稱為選路)。例如,+ 21 ’ PCI 1與資料庫而,允許pcn與資料庫伺服器 PC12與資料庫甸服m2,PC11與資料庫伺服器23, 資料庫伺服器23,P;3盘資料庫飼服器22,PC12與 伺服器22,PCl3i^U^貝料庫飼服器21,pC13與資料庫 21 相互之以:庫Γ服器23、’PC14與資料庫飼服器 間可通信肖,哪個pc:都° =放連接路由’使所有電腦 有問題'然而,Γ安料庫伺服器’沒 望規定安全性,使得僅特定以連=2二情 =)希望某現場内的電腦= 由連接,♦對現場之間 a貝W庫錢為)此自 性時,用各雷ΓΡΓ 4 -、仏規疋女全性。如此規定安全 pm〜ul)授予連接許可權。圖27中,對 IP位址21 ::::::位址11〜14,對資料庫伺服器21分配 23。 、貝料庫伺服器22和23分別分配IP位址22和 从H,、·需要用IP位址進行^立址1可連接位址2、4和5, wo "、接地址1、5和8 Π的安全性規定。對m個資料庫伺 ,二配、置/康時’需要規定m :n個連接。在使多局域網 ^收&相互連接用的通信設備(即路由器)上或稱為防 火牆的網路設備上進行這種設定的規定作# (選路),該 防火牆用來在網路連接互聯網時,設置在該網路和互聯網 設:::::内不正當存取。圖28中’這些路由器或防 _ 第7頁 C:\2D-C0DE\90-02\89124554.ptd I! 479172 五、發明說明(4) 資料庫糸統的規模愈大,這種規定 腦(資料庫和PC)位址改變和連接&權%,j I雜。進行電 又々逆接杈榷而改變安令柹枴宙 打,改變原設定的規定,苴作業,1 見疋 規模愈大,這種作業的繁雜程in。資料庫系統的 < 1王,卜示糸雊柱度愈咼, 資料庫通信系統中安全性管理繁雜的重大原因。 、杈 圖29為將SQL言吾言用作資料庫詢問語言的資料庫檢索 略結Ϊ說明圖。圖29中,PC11通過專用LAN412連接資 =服态21。PCI 1中,言史有在顯示t面上顯示操作内容 用的畫面程式111和按照SQL語言進行通信用SQL通信軟體 (S/W) 117。此fQL通信軟體117與晝面程式ln通過連介 面(I/F )驅動器115相互收發資訊。利用晝面程式丨丨工將 在PC1 1的顯示晝面上顯示的例如與對話方塊對話所需 ,記錄在各規定的框内,並記述晝面功能113的操作内多 容。此晝面程式111在啟動並顯示的顯示晝面的框等 應的操作邏輯(程式)插入各參數,對晝面功能丨丨3進行 定義,而且將設定的參數和操作内容改變為S q L文本。 此畫面功能1 1 3所設定的操作内容由晝面程式丨丨丨所包 的刼作邏輯,以SQL文本的形式通過介面(I/F )驅動器 115和SQL通信軟體117送出。此PC11在對資料庫伺服器°21 進行存取時’通過專用LAN4 1 2存取資料庫伺服器2 1。該祠 月艮器21中還設有SQL通信軟體(S/W ) 212。 資料庫伺服器2 1中又設有關聯資料庫() 2 1 1,其中 包含按資訊類別分組的稱為多個表的表格形式資訊2 1 3、 2 1 4 和 2 1 5。V. Description of the invention (3) Legislation is generally called routing). For example, + 21 'PCI 1 and database, but PCN and database server PC12 and database server m2, PC11 and database server 23, database server 23, P; 3 disk database feeder 22, PC12 and server 22, PCl3i ^ U ^ shell feeder feeder 21, pC13 and database 21 mutually: library Γ server 23, 'PC14 and database feeder can communicate with each other, which pc : Both ° = Put the connection route 'Making all computers problematic' However, the Γ 安 料 库 SERVER 'is not expected to specify security, so that only specific connections = 2 two emotions =) hope that computers in a certain site = connection, ♦ For the nature of the money between the site and the site) For this self, use the individual ΓΡΓ 4-and the rules to determine the female's holistic nature. This stipulates the security (pm ~ ul) to grant the connection permission. In FIG. 27, the IP address 21 :::::: addresses 11 to 14 are assigned to the database server 21 23. , The shell server 22 and 23 respectively assign IP address 22 and slave H, · · need to use IP address ^ address 1 can connect to addresses 2, 4, and 5, wo ", access addresses 1, 5 And 8 Π security regulations. For m databases, two allocations, settings / common times' need to specify m: n connections. This setting is made on a communication device (ie, a router) for multi-local network reception and interconnection or a network device called a firewall (routing), which is used to connect the Internet to the Internet. When set in the network and Internet settings ::::: incorrect access. Figure 28: These routers or defenses_ Page 7 C: \ 2D-C0DE \ 90-02 \ 89124554.ptd I! 479172 V. Description of the invention (4) The larger the size of the database system, the more this kind of rules ( (Database and PC) Address change and connection & right%, j I miscellaneous. Conducting electricity and reversing the problems will change the order of the police, change the original set of regulations, and change the original set of rules. 1 See the larger the scale, the more complicated the process is. The < 1 King of the database system, the greater the importance of the column, the more complicated the security management in the database communication system is. Figure 29 is an explanatory diagram of a database search using SQL language as the database query language. In Figure 29, PC11 is connected to the server via dedicated LAN412. In PCI 1, there are screen programs 111 for displaying the operation contents on the display t surface, and SQL communication software (S / W) 117 for communication in accordance with the SQL language. The fQL communication software 117 and the day program ln send and receive information to and from each other through an interface interface (I / F) driver 115. Using the daytime program, the workers will record, for example, a dialog box displayed on the display daytime of the PC1 1 in each prescribed frame, and describe the operation content of the daytime function 113. This day-to-day program 111 inserts various parameters in the operating logic (program) corresponding to the box that displays and displays the day-to-day, and defines the day-and-day functions 丨 3, and changes the set parameters and operation content to S q L text. The operation content set by this screen function 1 1 3 is sent by the operation logic included in the day-side program 丨 丨 丨 in the form of SQL text through the interface (I / F) driver 115 and SQL communication software 117. When this PC11 accesses the database server ° 21 ', it accesses the database server 2 1 through a dedicated LAN 4 1 2. SQL communication software (S / W) 212 is also provided in the temple moon generator 21. The database server 21 also has an associated database () 2 1 1 which contains information in the form of tables called multiple tables grouped by information type 2 1 3, 2 1 4 and 2 1 5.

479172 五、發明說明(5) π晝二H1:3定義操作内容。該内容包括對關聯資料庫 _)211 的表 i (213)、2 (214)和 3 (215)檢索表 i (213),根據該檢索結果更新表2(214),並更新表3 (215) 此旦面功能11 3所定義的操作内容在晝面程式 111的控制下執行。此操作(檢索/插入/更新/刪除)處理 中,為了分別存取晝面功能丨丨3所記述的表i ( 2丨3 )、表2 (214 )和表3 (215 ),從SQL通信軟體1 17 #SqL文本形能 將資料庫存取命令經”丨丨端、專用LAN412、資料庫伺服^ 2,1内的SQLjt信軟體212傳送到資料庫伺服器21所包含的資 料庫機。資料庫機按照此SQL文本存取關聯資料庫2丨工,執 行檢索第1步驟CS1中指定的表1的SQL,並將表示該執行結 果的表1 ( 213 )的資料再次通過SQL通信軟體212、專用 LAN412 和 SQL 軟體 117,送回 PC11 (步驟CS2)。 因此,檢索1個表1 (213)時,首先在步驟CS1傳送指示 檢索的SQL存取命令,並由步驟CS2將表示該檢索結果的資 料通過專用LAN41 2傳給PCI 1。 然後’由步驟C S 3,在畫面程式1 11控制下,通過專用 L A N 41 2將更新表2 ( 2 1 4 )的S Q L傳給資料庫祠服器2 1,對 關聯資料庫21 1的表2 (214 )進行更新。再通過步驟CS4, 將遺更新結果從資料庫伺服器2 1送回給pci 1。此步驟以4 結束時’ PCI 1又在晝面程式111的控制下,通過糾乙通信軟 體11 7、專用LAN41 2和SQL通信軟體21 2,存取關聯資料庫 2 11,對表3 ( 2 1 5 )進行更新。再將此更新後的表3 ( 2 i 5 )的資料從資料庫伺服器21經專用LAN412再次傳給PC11。479172 V. Description of the invention (5) π Day 2 H1: 3 defines the operation content. This content includes searching tables i (213), 2 (214), and 3 (215) for tables i (213) of the related database_) 211, updating table 2 (214) based on the search results, and updating table 3 (215 ) The operation content defined by the surface function 11 3 is executed under the control of the day surface program 111. In this operation (retrieve / insert / update / delete), in order to access the daytime function 丨 丨 3, the table i (2 丨 3), table 2 (214), and table 3 (215) are communicated from SQL. Software 1 17 #SqL text form can transfer the data library fetch command via the terminal, the dedicated LAN412, the database server ^ 2, and the SQLjt software 212 in 2,1 to the database server included in the database server 21. Data The library machine accesses the related database 2 according to the SQL text, executes the SQL of searching the table 1 specified in step 1 of CS1, and passes the data of table 1 (213) indicating the execution result again through the SQL communication software 212, The dedicated LAN412 and SQL software 117 are sent back to PC11 (step CS2). Therefore, when searching for a table 1 (213), the SQL access command instructing the search is first transmitted in step CS1, and step CS2 will display the result of the search result. The data is transmitted to the PCI 1 through the dedicated LAN 41 2. Then, 'in step CS 3, under the control of the screen program 1 11, the SQL updating the table 2 (2 1 4) is transmitted to the database server 2 1 through the dedicated LAN 41 2 To update Table 2 (214) of the related database 21 1. Then through step CS4, The update result is sent back from the database server 2 1 to the PCI 1. At the end of this step, the PCI 1 is under the control of the day-and-day program 111 through the correction software 11 7, the dedicated LAN 41 2 and the SQL communication software 21 2. Access the related database 2 11 and update the table 3 (2 1 5). The updated table 3 (2 i 5) data is then transmitted from the database server 21 to the PC 11 via the dedicated LAN 412 again.

C:\2D-CODE\90-02\89124554.ptd 第9頁 479172 五、發明說明(6) 66 ^由晝面程式1 1 1顯示例如對話方塊、視窗或範例之類 蚩^里内合,並對該顯示内容輸入必要參數時,或在顯示 ^日士上Ϊ圖形的形式顯示圖形用戶介面之類對多個表的操 了晝面程式1 1 1將這些操作内容全部變換為SQL文本的 y 。因此’在專用LAN412上只進行文本通信。 二面功能1 1 3的操作内容複雜時,需要連續操作(檢 林。更新、刪除或插入)關聯資料庫(RDB ) 211的多個表 ^因此,發出許多SQL·文本,通過專用LAN412向?(:11送 :各:的操作結果。於是,若大量反復進行此舉文本的 結果的回送,則通過專用LAN412進行的通信所需 皇:B 、,70成一項晝面功能11 3需要大量時間。這時, # jN412中通^業務量增大,其他PC需要等待存取此資 枓庫伺服器21,產生處理效率差的問題。 、 狄:程式111的結構概略說明圖。圖 弁=ΐ貧料庫操作程式時,在此資料庫操作程式中首 程式SP0,作為初始畫面,並將初始晝面喝 端的顯示晝面上。在此顯示畫φ (視窗)DS0 〇 σ圖不的形式顯不該操作内容的功能表MN。 r ί Ϊ m戶)選擇顯示畫面上視窗内顯示的功能表ΜΝ, 二= 執行的操作Α。一選擇操作Α,就啟動對應的書 =輯秋式SP1,_示操作W對應的對話 ― J畫面邏輯程式SP1同時啟動以SQL語句記述該處理内上 Π:邏輯Lpi帶有表示該處理内容的邏輯編號,書 面邏輯程式SPO則利用操作功能表MN的操作,參照對應的- C:\2D-CODE\90-02\89124554.ptd 第10頁 479172 五、發明說明(7) 邏輯編號,啟動邏輯LP1和對應的晝面邏輯 者在顯示晝面DS1上操作A的對 'SP1 °知作 戍利用摔作餹RT Μ π 1 , 7古万塊。己述所需的參數, 車安乂 t乍記述的參數(將處理物件資料庫名、檢索 專尔寺芩數)傳給邏輯Lpi,邏輯Lpi插入框Μ所 ,、 ;1 "#"—----接著,例如操作者利用此顯示晝面上 ”B (或返回初始晝面,利用新功能表選擇下又”作下) 时,啟動對應的畫面邏輯程式sp2,在顯示 示操作B的對話方塊。操作者又在此框βχ記述所表 鍵βτ的操作規定需要的處理。對此晝面邏輯程 =,2”=讥語句記述其處理内容的邏輯LP2。此 ㉞軏LP2中τ有表示此邏輯的邏輯編號u以及表示對前一 邏輯LP1的從屬關係或執行順序的標諸或識別字元%。按 照^標言志FG的編號,保存執行順序和從屬關制^ 内谷的時間序列。 其後,反復執行此操作,直到全部記述需要的處理。因 此,此處理中,根據處理内容,啟動多個畫面邏輯程式 SPl 'SP2…,在對應的落力LP1、LP2〜,用SQL語句記述 採用操作者所記述參數的處理内容。 以下將此晝面邏輯程式SP1、Sp2…總稱為顯示畫面程式 ,將邏輯LP1、LP2 ···總稱為操作邏輯程式MLp。晝面功 能113表示此顯示晝面的〇、DS1、DS2…中記述、定義的功 C:\2D-C0DE\90-02\89124554.ptd 第11頁 479172 五、發明說明(8) 能,畫面程式1 1 1則包含此顯示晝面程式DPP和操作邏輯程 式MLP。 因此’即使操作者觀察顯示晝面上的對話方塊、視窗或 範例,以對話的形式進行參數記述等,也由操作邏輯程式 MLP將其全部處理内容用Sql語句記述。邏輯LP1、lP2 ···中 的SQL語句通過圖28所示SQL通信軟體117傳給資料庫伺服 器21 。 表操作時’操作中具有檢索、插入、更新和刪除等處 理。表操作内容複雜時,通信的SQL語句數量多,因而到 和麵功月b 11 3元畢,需要很多時間。因此,上述網路規模 大’網路上的通信業務量增大,通信效率下降。 單一現場内,從電腦終端(PC ) 11通過專用LAN412對資 料庫伺服裔2 1進行存取時,僅通過s q l通信軟體11 7和2 1 2 ' 進行資訊通信,資料庫伺服器2 1内未配置通信字元或丨p位 址識別用的邏輯(未設置路由器或防火牆等中繼裝置), 因而不能設置網路安全性功能,從資訊管理的角度看,存 在問題。 圖31為適應廣域通信的網路的結構概略示意圖。此圖31 中,分開配置的現場# 1和現場# 2通過廣域通信網42連 接。此廣域通信網42是例如互聯網或採用民間通信公司專 用線路等的内部網等網路。 σ 現場#1中,為了連接廣域通信網4 2,設有建立對現場 #1所設計電腦終端(PC11等)的連接路由的路由器131以 及具有連接廣域通信網4 2用的防火牆或閘道等安全性功能C: \ 2D-CODE \ 90-02 \ 89124554.ptd Page 9 479172 V. Description of the invention (6) 66 ^ Displayed by day program 1 1 1 such as dialog box, window or example, etc. When inputting necessary parameters for this display content, or displaying graphic user interface such as graphical user interface in the form of a display on the display, the operation of multiple tables is performed. 1 1 1 All these operations are converted into SQL text. y. Therefore, only text communication is performed on the dedicated LAN 412. When the operation content of the two-sided function 1 1 3 is complicated, continuous operations (inspection, update, delete, or insert) of multiple tables in the relational database (RDB) 211 are required. ^ Therefore, a lot of SQL and text are sent out through the dedicated LAN412? (: 11: Result of each: Operation. Therefore, if a large number of results of this text are sent back repeatedly, the communication required through the dedicated LAN412: B, 70% of a day-to-day function 11 3 requires a lot of time. At this time, # jN412 Zhongtong ^ business volume increases, other PCs need to wait for access to this resource database server 21, resulting in a problem of poor processing efficiency. Di: The schematic diagram of the structure of the program 111. Figure 弁 = ΐ poverty When the library operation program, the first program SP0 in this database operation program is used as the initial screen, and the initial day surface is displayed on the day surface. Here, the form of φ (window) DS0 is not displayed. The function table MN of the operation content (r ί Ϊ m)) select the function table MN displayed in the window on the display screen, two = operation A performed. As soon as the operation A is selected, the corresponding book is started. = Qiuqi SP1, _ shows the dialogue corresponding to the operation W-J screen logic program SP1 is started at the same time. The SQL statement is used to describe the process. Π: The logical Lpi contains Logic number, the written logic program SPO uses the operation function table MN operation, refer to the corresponding-C: \ 2D-CODE \ 90-02 \ 89124554.ptd Page 10 479172 5. Description of the invention (7) Logic number, start logic LP1 and the corresponding diurnal logic person operated A on the diurnal surface DS1 to know 'SP1 °', and used the fall to make RT Μ π 1, 7 million. The required parameters have been described, and the parameters described at the beginning of the procedure (the name of the database of the processing object and the number of the searched temples) are passed to the logical Lpi, and the logical Lpi is inserted into the frame M, 1; ""# " —---- Then, for example, when the operator uses this display to display "B" (or return to the original day, use the new menu to select "Down" and "Down"), start the corresponding screen logic program sp2, and display the operation on the display. B dialog box. In this box βχ, the operator describes the processing required for the operation of the table key βτ. For this day, the logical sequence =, 2 "= 讥 statement describes the logic LP2 of its processing content. In τLP2, τ has a logic number u indicating this logic and a subordinate relationship or execution order to the previous logic LP1. All or identification characters%. The execution sequence and the time series of the subordinate control system ^ Uchiya are stored in accordance with the number of the ^ tagline FG. Thereafter, this operation is repeatedly performed until all necessary processes are described. Therefore, in this process, According to the processing content, a plurality of screen logic programs SP1 'SP2 ... are started, and the corresponding content of the drop force LP1, LP2 ~ is used to describe the processing content using the parameters described by the operator. The day-to-day logic programs SP1 and Sp2 are described below. … Collectively referred to as the display screen program, and the logic LP1, LP2 ... is collectively referred to as the operation logic program MLp. The day surface function 113 indicates the work described in the display of the day surface 0, DS1, DS2 ... C: \ 2D-C0DE \ 90-02 \ 89124554.ptd Page 11 479172 V. Description of the invention (8) Yes, the screen program 1 1 1 contains this display day surface program DPP and operation logic program MLP. So 'even if the operator observes the display day surface Dialog box , Window or example, parameter description in the form of dialogue, etc., and the entire processing content of the operation logic program MLP is described in Sql statements. The SQL statements in the logic LP1, lP2 ... are shown in the SQL communication software 117 shown in FIG. 28 It is transmitted to the database server 21. During the table operation, operations such as retrieval, insert, update, and delete are included in the operation. When the content of the table operation is complex, the number of SQL statements communicated is large. It takes a lot of time. Therefore, the above-mentioned large-scale network's communication traffic on the network increases and communication efficiency decreases. In a single site, when a database terminal 2 1 is accessed from a computer terminal (PC) 11 through a dedicated LAN 412 For information communication only through sql communication software 11 7 and 2 1 2 ', no communication characters or logic for address recognition are configured in database server 2 1 (no relay device such as router or firewall is set), Therefore, the network security function cannot be set. From the perspective of information management, there are problems. Figure 31 is a schematic diagram of the structure of a network adapted to wide area communication. In this figure 31, Site # 1 and Site # 2 are connected through a wide area communication network 42. This wide area communication network 42 is a network such as the Internet or an internal network using a private line of a private communications company. Σ In the scene # 1, to connect to a wide area Communication network 42, equipped with a router 131 that establishes a connection route to the computer terminal (PC11, etc.) designed on site # 1, and has security functions such as a firewall or gateway for connecting to the wide area communication network 42

479172 五、發明說明(9) 的連接裝置1 3 2。 廑中’專用UN4i2連接資料庫飼服器22。此資料 庫伺服為22具有關聯資料庫RDB。專用lan4 山" 231連接廣域用網路。此廣域用網 ^之路由器 域通信網4 2。該連接f置2 3 2 | 、,二 、置2 3 2連接廣 安全性功能的二ΐίί Γ具有稱為防火牆或_ ,王r力此的,又備構成。通過利用這些具有安全 设備,防止不需要的# ?目4曰& 力月b的 mu 场接入,確保資訊安全性。 現% # 1和現場# 2中,;H:分^ , ^it^LAN4n;4 2 /^Λ"™11^412 ° ^ μ丄0 Ζ刀別叹有路由器131和231 ,你品 路由态以一個專用LAN為單位進其 而 用LAN為單位使存取古、#仆 5吕里,所以能以專 ,夂使存取问速化。路由器還具有對專用LAN内的 ς,進仃存取授權的功能’能以專用“Ν為單位保持安全勺 -個現場内配置多個路由器,按該路由器 #總的網路通信速⑨(由多個路由器並行通 t i ΐ二全性。例將通信量多的PC彙集為- 4 置在同一、、·罔路上,從而這些通信量多-己 由的進仃並仃通化,使組内通信高速路 組的安全性。 I此運立對其他 作為用這種專用LAN構成通信時一個例子 服斋用作半導體製造裝置的中央控制裝置,並將代' 司 行半導體製造裝置處理條件設定等的控制裝置。因此乍j 由中央控制裝置内的資料庫伺服器統管半能 處理條件,各势造梦詈φ可p ΡΓ ^望六π 衣知Ά置的 合衣k衣置中可攸PC僅存取所需的處理資料, C:\2D-C0DE\90-02\89124554.ptd 第13頁 479172479172 V. Connection device of invention description (9) 1 3 2. Langzhong 'special UN4i2 is connected to the database feeder 22. This database server is 22 with an associated database RDB. Dedicated lan4 mountain " 231 connects wide area network. This wide area network router is a domain communication network 4 2. The connection f 2 2 2 |, 2, 2 2 2 and 2 2 2 with a wide security function has a so-called firewall or _, which can be configured by another. By using these security devices, it is possible to prevent unwanted access to mu fields and ensure information security. In current% # 1 and site # 2, H: points ^, ^ it ^ LAN4n; 4 2 / ^ Λ " ™ 11 ^ 412 ° ^ μ 丄 0 别 Do not sigh there are routers 131 and 231, your product routing status It is accessed by a dedicated LAN unit, and the access unit is accessed by the LAN unit, so it is possible to speed up the access process by a dedicated unit. The router also has the function of granting access authorization to the dedicated LAN. It can maintain security in units of dedicated "N-multiple routers can be deployed in the field. According to the total network communication speed of the router # (by Multiple routers communicate in parallel with each other. For example, the PCs with a large amount of traffic are aggregated into -4 and placed on the same road, so that these traffics are large-freely entered and communicated, so that the communication within the group The safety of the expressway group. I This is an example of the use of the dedicated LAN as a central control device for semiconductor manufacturing equipment, and will be used to set processing conditions for the semiconductor manufacturing equipment. The control device. Therefore, the database server in the central control device controls the semi-energy processing conditions. The dreams of each situation φ 可 p ΡΓ ^ 望 六 π The combination of clothing and clothing can be installed on the PC. Access required processing data, C: \ 2D-C0DE \ 90-02 \ 89124554.ptd Page 13 479172

C:\2D-C0DE\90-02\89124554.ptd 479172 五、發明說明(11)C: \ 2D-C0DE \ 90-02 \ 89124554.ptd 479172 V. Description of the invention (11)

通信業務量大等問題。尤其是大規模廣域網系統中 題更顯著。 ’此問 (3)需要每一PC導入SQL·通信軟體。大規模系統中 此通信軟體的費用和導入作業的工時都很龐大。為 鱗入 此通信軟體的安裝作業,還需要很大的作業量,v 7進行 備具有這種安裝技術的人員。 而要酉己 (4)對PC所裝SQL通信軟體或晝面程式等進行版本 產生大量軟體更換作業。即使一個終端疏忽版本更 7時 · 終端間也會喪失輸出資料的連續性,使資料庫系統失^ ’ 料一致性(不同版本間存在使用未定義邏輯編號的、羅^貪 情況或相同邏輯編號的邏輯指定不同的處理)。&輯的 因此本發明的目的在於提供能消除上述問題的通作系 ’能高 易適應 本發明的另一目的在於提供一種資料庫通信系統 速、有效地進行通信,能容易確保安全性而且能容 元件版本更新。 本發明的再一目的在於提供一種通信系統,不需要 通信用的中間件(通信軟體),而且能容易維持資料廉= 料一致性。 寅Communication traffic is large. This is especially true in large-scale WAN systems. "This question (3) SQL / communication software needs to be imported into each PC. The cost of this communication software and the time required to implement it in large-scale systems are substantial. In order to install this communication software, a large amount of work is required, and v 7 is prepared by personnel with this installation technology. (4) The SQL communication software or day-to-day program installed on the PC generates a large number of software replacement operations. Even if a terminal negligent version is more than seven, the continuity of the output data will be lost between the terminals, which will cause the database system to lose the consistency of the data (there is an undefined logical number between the different versions, the situation is similar, or the same logical number exists) Logic specifies different processing). It is therefore an object of the present invention to provide a universal system capable of eliminating the above-mentioned problems. It is highly adaptable to the present invention. Another object of the present invention is to provide a database communication system that can communicate quickly and efficiently, and can easily ensure security. Capacitive component version update. Another object of the present invention is to provide a communication system, which does not require communication middleware (communication software), and can easily maintain data integrity = data consistency. Yin

本發明的又一目的在於提供建立採用上述通信系统 導體裝置之製仏方法及相關通信系統用的組成要素。、^ 第1觀點的通彳'系統包含資料庫伺服器和電腦終端。 腦終端包含生^含有指定處理内容的邏輯編號和該處理: 需參數的處理貝矾,並發送該生成的處理資訊的機構。=It is still another object of the present invention to provide a method for manufacturing a conductor device using the above-mentioned communication system and a constituent element for a related communication system. ^ The general information system of the first aspect includes a database server and a computer terminal. The brain terminal contains a logical number containing the specified processing content and the processing: a parameter-based processing unit, and sends the generated processing information. =

C:\2D-C0DE\90-02\89124554.ptd 第15頁 479172 五、發明說明(12) 料庫伺服器包括含有由 邏輯程式機構。該邏輯=讯所含邏輯編號指定邏輯的 訊,執行所指定邏輯程^式彳t構包含按照啟動時的處理資 存取資料並將該執行結:::貧料庫予以存取’處理該 構。 果所付的賢料傳送給電腦終端的機 第2觀點的通信系统|古夕 m ^ # m 、,、有夕個電腦終端、對這些多個電 ,, 、伺服杰和至少一個資料庫伺服哭。 由中繼伺服哭隼中營王吏蕾抑从山 干u服口口 通俨。 。巿T "理電恥終端與至少一個資料庫之間的 第3^觀點的通信系統至少包括含有帶中繼功能的資料 伺服盗的第1現場和與該第丨現場分開設置的第2現場。該 第2現場包含(i )至少一個電腦終端,以及(i i )對至: 一個電腦終端與第1現場的資料庫伺服器之間的通信文/ 進行中繼用的中繼伺服器。 不 第4觀點的通信系統具有多個電腦終端,以及對此夕 個電腦終端共同設置,以中繼多個電腦終端的通α二夕 ::繼飼服器。該中繼伺服器具有存放最新版“ 2 的存放機構,以及根據多個電腦終端中啟動 =式用 % 母程式所對應程式的版本與母程式版本比較的結】 '、’,;端内 程式下載到啟動的電腦終端用的機構。 'α ’將母 第5觀點的通信系統具有調度並執行定期執〜 ^ 理用的機構、登記詢問處理對資料庫的詢問條仃的、,詢#問處 記條件用的機構,以及按照詢問條件進入資料亚官理登 取’並將詢問結果輸出到規定的伺服哭〃 予以存 N服為上的機構。C: \ 2D-C0DE \ 90-02 \ 89124554.ptd Page 15 479172 V. Description of the invention (12) The library server includes a logic program mechanism. The logic = the logic number contained in the message specifies the logic and executes the specified logic procedure. The structure includes accessing data according to the processing data at startup and executing the execution: ::: The poor library accesses the processing of the structure. . The communication system of the second point of view of the materials transmitted to the computer terminal | Gu Xi m ^ # m, there are a computer terminal, a plurality of these, a servo server, and at least one database server cry. Crying by the relay servo, the prince of the camp Ying Lei Yi from Congshan, u service mouth pass. .巿 T " The communication system of the third aspect between the terminal and at least one database includes at least a first site containing a data servo thief with a relay function and a second site separately from the first site . The second site includes (i) at least one computer terminal, and (i i) to: a communication between the computer terminal and the database server of the first site / a relay server for relaying. The communication system of the fourth aspect has a plurality of computer terminals, and the computer terminal is provided in common with the computer terminal to relay the communication of multiple computer terminals. The relay server has a storage mechanism for storing the latest version "2, and the comparison between the version of the program corresponding to the% parent program and the version of the parent program based on the start-up% method used in multiple computer terminals] ',', Download to the mechanism for starting the computer terminal. 'Α' The communication system of the fifth aspect has a schedule and execution of regular execution ~ ^ Management mechanism, registration inquiry processing, inquiry database inquiry, ## 问Institutions for processing conditions, and institutions that enter the data according to the inquiry conditions, and then output the inquiry results to a specified servo.

C:\2D-CODE\90-02\89124554.ptd 479172 五、發明說明(13) 第6觀點的通信系处 定的周期單元執行;;先/有登記多個作業用的機構、以指 進仃對此登記機構的作 ]轨仃枝構,以及 制,行用的作業管理’ :|的登…m、參照、更改和強 w h第/觀’』的通仏系統具有包含資料庫的資料座η Web., t,Web ^ ^ ^ ^ ' 和她果輸出的電腦終端,以 J =件輸入C: \ 2D-CODE \ 90-02 \ 89124554.ptd 479172 V. Description of the invention (13) Periodical unit execution of the communication system of the sixth aspect;的 The work of this registration agency] track management system, as well as the operation management of system and operation ': |' s registration ... m, reference, change and strong wh / view '"has a database containing data Block η Web., T, Web ^ ^ ^ ^ 'and a computer terminal output by her fruit, input with J = pieces

Web伺服器之間通信用的傳送機構。、枓庫伺服器與 根據本發明的第8觀點,组 素可具體用於半導體裝置之制1 糸統的組成要 進行半導體裝置的製造。衣以彳17,利用通信系統 根據本發明的第9 _鞔,2r t丄 伺服器、中繼伺服哭和声乂夂建上述通信系統的資料庫 求。 τ _服a和處理終端的具體結構分別提出要 在資料庫飼服器準備詢問邏輯程 :該詢問邏輯程式所含邏輯的啟動資訊,在ί ; = ; 飼服器之間只要僅送出邏輯啟動和識別指=庫 ,,詢^果資料就從資料庫飼服器發送到電腦終 器與電腦終端之間的通信只進行邏輯啟動 U問、,,。果的2 :人回送’不需要傳送SQL文本,可縮短處理 %間,並抑制網路通信業務量的增大,能建立有效的通传 糸統。又,可由中繼伺服器確保現場内的安全性。而且: 借助利用Web伺服器,可縮短查表時間,並利用最近版本Transmission mechanism for communication between Web servers. Library server and the eighth aspect of the present invention, the component can be specifically used in the manufacture of semiconductor devices. The composition of a system is used to manufacture semiconductor devices. According to the invention, using the communication system according to the ninth embodiment of the present invention, a 2r t server, a relay server, and a voice server are used to build a database of the communication system. The specific structure of τ _ server a and the processing terminal proposes to prepare the query logic routine in the database feeder: the query startup information contained in the logic program is only required to send logic startup between ί; =; And the identification means = library, and the inquiry data is sent from the database feeder to the computer terminal and the communication between the computer terminal is only logically started. Result 2: People send back 'does not need to transmit SQL text, which can shorten the processing time, and suppress the increase in network communication traffic, and can establish an effective communication system. In addition, the security in the field can be ensured by the relay server. And: By using a web server, you can shorten the lookup time and use the latest version

C:\2D-C0DE\90-02\89124554.ptd 479172 五、發明說明(14) 的下載縮短軟體更新時間。 此=二借助使用此通信系統控制半導體裝置的製造裝 —:在中央控制裝置與終端的製造裝置之間有效進行所 “的接收和發送,可建立有效的半導體製造裝置的監 視糸統。 【發明之實施形態】 (實施形態1 ) 圖1為顯示本發明實施形態」的資料庫作業系統通信方式 的概!圖二m中」此資料庫作業系統包含終端咐⑴和 pf 1 1理貝Λ的貝料庫伺服益2 1。這些資料庫伺服器2 1和 P C11通過網路4 9相互連接。 ▲ PC11包含在畫面上記述操作程式用的晝面程式111Α和通 信功能114。該通信功能通過網路49,將此晝面程式丨丨i Α 士成的操作程式傳送給資料庫伺服器21,並將資料庫伺服 益21的結果數據傳給晝面程式111Α。畫面程式ιηΑ將識別 執行其操作内容的邏輯的邏輯編號、記述操作内容細節的 參數,以及識別此PC11的識別字元(例如Ιρ位址、登記pD 等)傳送給通信功能1 1 4。通信功能1丨4不包含SQL通信軟 體(S/W),僅用驅動例如數據機之類收發信機的軟^組 成。利用按照晝面程式1ΠΑ對用戶操作内容進行的定義和 記述,規定晝面功能113。此PC11中不進行將晝面功能113 變換為SQL文本。 資料庫伺服器21包含監視通過網路49提供的通信要求用 的通彳έ要求&視程式2 1 6、接收通信要求監視程式2 1 6提供 C:\2D-CODE\90-02\89124554.ptd 第18頁 479172C: \ 2D-C0DE \ 90-02 \ 89124554.ptd 479172 V. Download the description of invention (14) to shorten the software update time. This = Second, the use of this communication system to control the manufacturing of semiconductor devices—effectively performing "receiving and sending" between the central control device and the terminal's manufacturing device can establish an effective monitoring system for the semiconductor manufacturing device. [Invention (Embodiment 1) (Embodiment 1) Fig. 1 shows the outline of the communication method of the database operation system according to the embodiment of the present invention! In Figure 2m, this database operating system includes the terminal's command and pf 1 1 and the shell material servo 21 of the shell. These database servers 21 and PC11 are connected to each other via a network 4-9. ▲ PC11 includes a daytime program 111A and a communication function 114 for describing the operation program on the screen. This communication function transmits the operation program of this day-to-day program 丨 丨 Α Shicheng to the database server 21 through the network 49, and transmits the result data of the database servo benefit 21 to the day-to-day program 111Α. The screen program ιηΑ transmits to the communication function 1 1 4 a logical number that identifies the logic that executes its operation content, parameters that describe the details of the operation content, and identification characters (such as Ip address, registered pD, etc.) that identify this PC11. The communication functions 1 and 4 do not include SQL communication software (S / W), and are only composed of software that drives a transceiver such as a modem. The day-to-day function 113 is defined by the definition and description of the user operation content according to the day-to-day program 1IIA. This PC11 does not convert the daytime function 113 into SQL text. The database server 21 includes a general request for monitoring communication requests provided via the network 49 & video program 2 1 6. Receive communication request monitoring program 2 1 6 provides C: \ 2D-CODE \ 90-02 \ 89124554 .ptd Page 18 479172

五、發明說明(15) " B 的操作處理資訊以形成回應的操作邏輯並生成SQL文本的 刼作邏輯程式2 1 7,對資訊進行存儲的關聯資料庫(RDB ) 211。關聯資料庫211按照表! (213 )、表2 (214 )和表3 (2 1 5 )等方式’用表的形式存放各種資訊。 才呆作邏輯程式2 1 7包含操作邏輯,用於進行對關聯資料 庫2 1 1的檢索、更新、插入和刪除。此操作邏輯是表示一 系列處理程式的程式群,一個操作邏輯相當於一個晝面邏 輯程式。 圖2為顯不圖1所示晝面程式丨丨丨A的結構的概略圖。圖2 中’晝面程式1 1 1 A包含晝面邏輯程式SP1、SP2…,用於在 顯不畫面上顯示例如對話方塊等的操作。對應於這些晝面 邏輯私式SP1、SP2…,在畫面上顯示表示回應操作内容的 例如對話方塊DS1、DS2…。這些對話方塊DS1、DS2…分別 相當於操作A和操作B,分別包含輸入特定參數用的框和 執行各種處理内容用的鍵ΒΤ等。 此畫面程式1 1 1 Α利用初始晝面程式sp〇選擇顯示晝面上 顯示的控制面板DSO上的功能表MN,從而啟動回應的畫面 邏輯程式。這些畫面邏輯程式SP1、SP2…分別將其表示回 應操作邏輯的邏輯編號LN (LN1、LN2…)和回應對話方塊 中輸入的參數存放到各自作業暫存器BUFM。此晝面程式 11 1 A不具備將操作内容變換為SqL語句功能。其全部只是 生成表示代表處理程式的邏輯的邏輯編號和對應的參數, 並存放到暫存器B U F Μ。因此,此晝面程式111 A沒有執行對 5舌方塊、視窗和範例等在顯示晝面上記述的畫面功能11 3Fifth, the invention description (15) " B's operation processing information to form a response operation logic and generate SQL text operation logic program 2 1 7, the associated database (RDB) 211 to store the information. Related database 211 according to the table! (213), Table 2 (214), and Table 3 (2 1 5) and other methods' use a table to store various information. The lingering logic program 2 1 7 contains operation logic for searching, updating, inserting and deleting the related database 2 1 1. This operation logic is a program group representing a series of processing programs, and an operation logic is equivalent to a day-to-day logic program. FIG. 2 is a schematic diagram showing a structure of a day-time program 丨 丨 丨 A shown in FIG. 1. FIG. In Fig. 2, 'Day-surface program 1 1 1 A contains day-surface logic programs SP1, SP2, ..., for displaying operations such as dialog boxes on the display screen. Corresponding to these daytime logical private SP1, SP2 ..., dialog boxes DS1, DS2, ... are displayed on the screen to indicate the contents of the response operation. These dialog boxes DS1, DS2, etc. correspond to operations A and B, respectively, and contain boxes for inputting specific parameters and keys BTT for performing various processing contents, and the like. This screen program 1 1 1 Α uses the initial day-to-day program sp0 to select and display the function table MN on the control panel DSO displayed on the day-to-day screen, thereby activating the screen logic program that responds. These screen logic programs SP1, SP2, etc. respectively store the logic numbers LN (LN1, LN2, ...) representing the response operation logic, and the parameters entered in the response dialog box to the respective job register BUFM. This day-to-day program 11 1 A does not have the function of converting the operation content into SqL statements. All of them only generate a logical number and corresponding parameters representing the logic representing the processing program, and store them in the register B U F M. Therefore, this day-to-day program 111 A does not perform the screen functions described on the day-to-day display of 5 tongue boxes, windows, and examples. 11 3

milmil

C:\2D-CODE\90-Q2\89124554.ptd 第19頁 479172C: \ 2D-CODE \ 90-Q2 \ 89124554.ptd Page 19 479172

的功能。存放在該暫存器bufm的邏輯編號和對應的參數等 資訊,通過通信功能11 4傳給資料庫伺服器2 1。 上述畫面邏輯程式SP1、SP2…等對應的操作可不用對話 方塊而代之以視窗或範例在顯示畫面上顯示。 A此晝面程式11 1A中,不形成SQL語句,僅將邏輯編號和 參數等需要的資訊通過通信功能丨丨4送出。因此,首先將 晝面功能11 3要求的程序呼叫暫時傳送到資料庫伺服器 2 1,其後的處理由資料庫伺服器2丨所設的操作邏輯程式 2 1 7執行。再將此操作邏輯程式2丨7操作結果的資料通過網 路4 9和PCI 1的通信功能丨14提供給晝面程式丨丨1A。晝面程 式111A在顯示晝面上顯示該送回的結果資料(檢索 (SELECT )處理時)。因此,一個處理中,從pci j對資料 庫伺服器2 1進行一次存取要求並遞交所需資訊後,在從資 料庫飼服器2 1送回結果資料前,此網路5 1空閒,其他pc能 接入。如此,能減少通信業務量,可建立高效資料庫通信 系統。 ° 圖3為顯示圖1所示操作邏輯程式2丨7的結構的概略圖。 圖3中’操作邏輯程式217包含多個操作邏輯LP # 1〜Lp # η。對這些操作邏輯lp #ι〜Lp #n分別分配識別操作邏輯 用的邏輯編號LN # 1〜LN #n。操作邏輯LP # 1〜LP #n分別 相當於晝面邏輯程式Sp (一個顯示晝面上的處理内容), 相當於在PC顯示晝面上顯示的一個對話方塊、一個視窗或 一個範例。這些操作邏輯“ #1〜Lp # η分別用SQL語句記 述處理程式,啟動時若提供參數,則將該參數作為操作條Functions. Information such as the logical number and corresponding parameters stored in the buffer bufm is transmitted to the database server 21 through the communication function 11 4. The corresponding operations of the above screen logic programs SP1, SP2, etc. can be displayed on the display screen without a dialog box or a window. A In this day-to-day program 11 1A, no SQL statement is formed, and only necessary information such as logical numbers and parameters are sent through the communication function 丨 丨 4. Therefore, the program call required by the day and night function 11 3 is first temporarily transmitted to the database server 21, and the subsequent processing is performed by the operation logic program 2 1 7 set in the database server 2 丨. The data of the operation result of this operation logic program 2 丨 7 is provided to the daytime program 丨 1A through the communication function of the network 4 9 and PCI 1 14. Daytime schedule type 111A displays the returned result data on the daytime display (during SELECT processing). Therefore, in one process, after making an access request to the database server 21 from pci j and submitting the required information, before returning the result data from the database feeder 2 1, this network 5 1 is idle. Other pcs can access. In this way, the communication traffic can be reduced, and an efficient database communication system can be established. ° FIG. 3 is a schematic diagram showing the structure of the operation logic program 2 丨 7 shown in FIG. 1. The 'operation logic program 217 in FIG. 3 includes a plurality of operation logics LP # 1 to Lp # η. These operation logics lp # ι to Lp #n are assigned logic numbers LN # 1 to LN #n for identifying the operation logic, respectively. The operating logics LP # 1 to LP #n are equivalent to the diurnal logic program Sp (a display of the processing content on the diurnal surface), equivalent to a dialog box, a window, or an example displayed on the PC's diurnal surface. These operation logics "# 1 ~ Lp # η describe the processing program with SQL statements respectively. If a parameter is provided at startup, the parameter is used as the operation bar.

:\2D-CODE\90-02\89124554.ptd 第20頁 479!72 五、發明說明(17) 件,執行所分配的處理。 操作邏輯程式21 7用資料廑句服〜a人 分Μ扭、去,if Μ 十η二庫伺服态所包含的資料庫機DBE 刀析D。法3Σ執仃對關聯資料庫(_ ) 2 此,僅在資料庫伺服器内編制 行 資料庫211的存取。 J立執仃進入關聯 資料庫飼服器21内,向來備有稱為,,存儲步驟,,的處理步 驟。根據來自PC的對存儲步驟的存: \ 2D-CODE \ 90-02 \ 89124554.ptd Page 20 479! 72 V. Description of the invention (17), execute the assigned processing. The operating logic program 21 7 uses data haiku to serve ~ a person. Twist and go, if the database machine DBE included in the servo state of the two database server analyzes D. Method 3Σ performs access to the associated database (_) 2 Therefore, access to the database 211 is performed only in the database server. J Li enters the feeder 21 of the related database, and there are always processing steps called ", storage steps,". According to the storage steps from the PC,

驟,並僅在資料庫飼服器内,在資料庫=D B 行進2聯:料庫的存取、然而,在此存儲步驟二兄 下’其處理步驟已預定,改變該處理步 ^ 新執行"CREATE PR0CEDURE"("建立步驟" 戶而要重 編制處理步驟,用SQL語句送到資料庫祠服器進行登記’。 因此’採用此存儲步驟時’不能進行各種操作,缺乏通用 性。 如本發明如此,在資料庫祠服器21内備有操作邏輯程式 217 ’、故能„選擇根據此畫面程式啟動的操作邏#,執行用 戶記述的操作。因此’與習知採用存儲步驟的 相比, 可全部編制用戶要求的步驟並加以利用,能實現通用性較 高的貧枓庫作業系統。而且,不需像存儲步驟那樣預先登 記步驟。僅將全部操作用邏輯編號和參數等用非語言 記述後發送’不需要SQL通信軟體。從PC11送回資訊二: 數僅為要求存取時的一次,全部操作都不需要發送sql文 本,可減少網路線路佔用時間。 圖4為顯示圖1所示資料庫系統的通信步驟的概略圖。下 C:\2D-C0DE\90-02\89124554.ptd 第21頁 479172 五、發明說明(18) 面’參照圖4簡單說明本發明實施形態1的資料庫系統的掎 作步驟。 ^ 首先’在P C1 1啟動晝面程式,編制畫面功能(步驟§ 1 ) 其次’操作晝面套裝程式含的通信命令啟動通信功如 1 1 λ "月b i4 ’對資料庫伺服器21發送存取要求(步驟S2 )。通信 要求監視程式2 1 6監視通過此網路5 1送出的存取要求。提 出存取要求時,通信監視程式2 1 6參照例如登記(註冊) 1 D和通行字元等識別字元(I D ),判斷是否能進入資料庫 =服裔予以存取,並在可進入pC丨丨資料庫伺服器2丨存取指 令破登記時,才將允許存取的資訊送給PC1丨(步驟S3 )。曰 在通彳s要求監視程式2 1 6的控制下,P C1 1將記述此書面 f能的畫面程式所生成的邏輯編號和表示操作條件的一參數 餐送到操作邏輯程式2 1 7或資料庫機d B E (步驟s 6 )。在 此,在步驟S3發出允許存取時,通信要求監視程式2丨6啟 邏輯程式217 (S5)。設有多個操作邏輯程式217, 出的—個存取要求,在該存取得到允許時啟動一個 木建軏程式。能使多個操作邏輯程式同時為啟動狀能。 库式217按照所提供的參數和邏輯編號啟動: 料庫機DBE操作關聯資料庫(rdb)2i (步^)並通過貝 的資料庫211的操作内容因操作邏輯程式内啟動 資此關聯資料庫211的操作結束時,將結果 = :作邏輯程式217或資料庫細(步驟so。 才木作、,Ό束符,按照操作邏輯程式217啟動的邏輯,以表Step, and only in the database feeder, in the database = DB travel 2 links: access to the library, however, in this storage step under the second brother 'its processing step is scheduled, change the processing step ^ new execution " CREATE PR0CEDURE " (" Creating steps " The user must reprogram the processing steps and send them to the database server for registration with SQL statements. Therefore, 'when this storage step is used', various operations cannot be performed, and there is no generality As in the present invention, an operation logic program 217 is provided in the database server 21, so it is possible to select an operation logic # started according to this screen program to perform the operation described by the user. Therefore, the storage steps are used with the conventional method. In contrast, all the steps required by the user can be compiled and used, and a poorly-used warehouse operation system with high versatility can be realized. Moreover, there is no need to register steps in advance like storage steps. Only logical operations and parameters are used for all operations. Send in non-language description and send 'no SQL communication software required. Information returned from PC11: The number is only one time when access is required, and no sql text is required for all operations Can reduce network line occupation time. Figure 4 is a schematic diagram showing the communication steps of the database system shown in Figure 1. The following C: \ 2D-C0DE \ 90-02 \ 89124554.ptd Page 21 479172 5. Description of the invention ( 18) The operation steps of the database system according to the first embodiment of the present invention will be described briefly with reference to FIG. 4. ^ First, start the day-and-day program at P C1 1 and program the screen function (step § 1). Next, operate the day-and-day set program. Contains a communication command to start a communication function such as 1 1 λ " month b i4 'to send an access request to the database server 21 (step S2). The communication request monitoring program 2 1 6 monitors the access sent through this network 5 1 Request. When making an access request, the communication monitoring program 2 1 6 refers to identification characters (ID) such as registration (registration) 1 D and a pass character, and determines whether it can enter the database = server to access, and Enter pC 丨 丨 Database server 2 丨 The access information is only sent to PC1 when the access command is broken (step S3). Under the control of the communication program 2 1 6 requested by PC, P C1 1 Write the logical number and A parameter meal representing the operating conditions is sent to the operation logic program 2 1 7 or the database machine d BE (step s 6). Here, when the access is issued in step S3, the communication request monitors the program 2 丨 6 to start the logic program 217 (S5). There are multiple operation logic programs 217, and an access request is issued. When the access is allowed, a wooden frame program is started. Multiple operation logic programs can be activated at the same time. 217 Start according to the provided parameters and logical numbers: The database machine DBE operates the associated database (rdb) 2i (step ^) and the operation content of the database 211 through the shell database is activated by the operation logic program. At the end of the operation, set the result =: Make a logic program 217 or a database (step so. Caimu Zuo, Ό bundle symbol, according to the logic initiated by the operating logic program 217,

五、發明說明(19) 5 ί ί ^ ::明的檔案形式編制其結果資訊(步驟S”。 法二,'豪:^視程式216的控制下或操作邏輯程式217的控 slo / irU路51將此編制成的結果資訊傳回PCU (步驟 ,接收通過通信功能114送回的結果資訊, :接:的:訊提供給晝面程式,並在該晝面程式的控制 下頌不在顯示畫面上(步驟§ 1 1 )。 ί 1二广圖4所不’僅在存取時進行-次發送存取要求 號和蒼數(步驟S4)如此的步驟或邏輯呼叫,處理結束後 视结果資訊(步驟sl〇)。對關聯資料庫2ιι進行操 I,牯,不進仃任何PCI 1與資料庫伺服器2丨之間的資訊傳 达:因此、,與習知那樣依次傳送SQL語句的方式相比,可 ^里減少通信業務量,也能大量減少網路佔用時間,實現 高速且有效的資料庫操作環境。、 圖5為顯示從PC發送到資料庫飼服器的資料的結構的概 f ® 中,發送資料具有登記(註冊)I D和通行字元 等f別字元(1 D )貧訊1 50、識別操作邏輯的邏輯編號LN #貝成1 5 1 a、表不該操作邏輯中操作條件的參數資訊 152^、識別另一操作邏輯的邏輯編號u #資訊i5ib、表示 該操作邏輯中操作條件的參數資訊丨52b等。這些參數資訊 152a和152b僅表示操作條件。這些參數資訊^。和^以可 用例如” 分開。利用”"提供SQL語句段的劃分。 圖1所示通信要求監視程式216根據上述1]}資訊15〇,判 決是否允許存取。使該通信要求監視程式216具有ID資訊V. Description of the invention (19) 5 ί ^ :: Ming compiles the result information (step S). Method two, 'Hao: ^ under the control of the program 216 or the control logic 217 control slo / irU road 51 returns the prepared result information to the PCU (step, receiving the result information sent back via the communication function 114, ::::: provides the daytime program, and the song is not displayed under the control of the daytime program On the screen (step § 1 1). Ί 1 Erguang Figure 4 does not only perform the access request number and number (step S4) during access, such as a step or logical call, and the result is viewed after the process is completed. Information (step sl10). Perform operations on the related database 2m without any information transmission between PCI 1 and database server 2: Therefore, the SQL statements are sequentially transmitted in the same way as the conventional ones. Compared with this method, the communication traffic can be reduced, and the network occupancy time can be greatly reduced to achieve a high-speed and effective database operating environment. Figure 5 shows the structure of the data sent from the PC to the database feeder. In profile f ®, the information sent has a registration (registration) ID and communication Characters such as f characters (1 D) Poor information 1 50, The logical number to identify the operating logic LN # 贝 成 1 5 1 a, Parameter information indicating the operating conditions in the operating logic 152 ^, identifying another operating logic The logical number u # 信息 i5ib, parameter information indicating the operating conditions in the operating logic, 52b, etc. These parameter information 152a and 152b only indicate the operating conditions. These parameter information ^. And ^ can be separated by, for example, "utilization" " Provides segmentation of SQL statements. The communication request monitoring program 216 shown in FIG. 1 determines whether access is allowed based on the above 1]} information 15. The communication request monitoring program 216 has ID information.

第23頁 C:\2D-C0DE\90-02\89124554.ptd ---- 五、發明說明(20) ;別功能’可確保安全性’能禁止非所需現場或。C來的: 操更本新發::施㈣ 表格用的SQL命人/插入)’心作此關聯資料庫所含 進行通4 Λ網路52/僅在資料庫飼服器21内 的處理時庫操作(檢索/更新/刪除/插入) 111的-個功:/乍、、、°果報告pc方。涉及執行晝面程式 通信僅往=51/通信的SQL命令和結果資訊,其 因而沒有網路發送S0L么通::1始:寺和通信結束時進行’ 速資料庫操作環:;QD句文本而產生的遲延,能實現高 (變更例) 圖6圖中6為;;if明實施形態1的更改例的結構的概略圖。 二進位形式印匕3用Asc 11碼的檔案,以執行程式等 案FL示出i :二、:案和存放圖像資料的圖像檔案等。槽 邏輯程式^tV有ν?Λ%為了操作該樓案FL ’操作 時,通過資# & =式的祂案等。檔案操作邏輯LN # F啟動 才通過貝枓庫機DBE存取栲安 出、傳送或檔案存放。田木叮,執行回應的檔案讀 該樓案操作邏輯Lp # j? π H + 表格形式的資訊變換為文、二具關聯資料庫21⑽ 巧文本形式加以輸出的功能。此文本 第24頁 C:\2D-C0DE\90-02\89l24554.ptd 479172Page 23 C: \ 2D-C0DE \ 90-02 \ 89124554.ptd ---- V. Description of the invention (20); Other functions ‘ensure safety’ can prohibit undesired sites or. Coming from C: Update this new issue :: Shi 的 SQL for forms / inserts in the form) 'Mind to be included in this relational database for communication 4 ΛNet 52 / Only processed in the database feeder 21 Time library operation (retrieve / update / delete / insert)-a function of 111: / first, ,, ° report to the pc side. Involving the execution of day-to-day program communication only = 51 / communication SQL commands and result information, so there is no network to send S0L Mody :: 1 start: Temple and communication at the end of the 'speed database operation ring :; QD sentence text The resulting delay can be high (modified example). Figure 6 and Figure 6 are; if shows a schematic diagram of a modified example of the first embodiment. Binary form dagger 3 uses Asc 11-code files to execute programs, etc. Case FL shows i: II ,: case and image files storing image data, etc. Slot logic program ^ tV has ν? Λ% When operating FL ′ for the operation of the building, it is passed the case of the asset type. The file operation logic LN # F is activated, and it can be accessed, saved, transferred, or stored in the file through the DBE library machine DBE. Tian Muding, execute the response to read the file. The operation logic of this building is Lp # j? Π H + The information in the form of table is converted into text and two related databases. This text Page 24 C: \ 2D-C0DE \ 90-02 \ 89l24554.ptd 479172

,式變換器中’也可具有用、"劃分表的爛位,例如以 HTML (超文本標記語言)形式編制檔案並送出的功能。 也可在PC設置此檔案傳送功能,從pc丨丨對資料庫伺服器 2 1傳送檔案。 、、如上所述,根據本發明實施形態丨,結構上可做成在資 ,庫伺服态内設置用SQL表現晝面程式所記述畫面功能的 操作邏輯程式,SQL語句全部在SQL伺服器内進行接收和發 达。因此,電腦終端與資料庫伺服器之間的資料資訊通信 僅在存取開始時和操作結束時分別進行一次,可大幅度減In the converter, it can also have the function of dividing tables into bits, such as the function of compiling and sending files in the form of HTML (Hypertext Markup Language). This file transfer function can also be set on the PC to transfer files from the database to the database server 2 1. As mentioned above, according to the embodiment of the present invention, the structure can be made into an operation logic program that uses SQL to express the screen function described in the daytime program in the database server state. All SQL statements are performed in the SQL server. Received and developed. Therefore, the data communication between the computer terminal and the database server is performed only once at the beginning of the access and at the end of the operation, which can greatly reduce

v通k時間,並減少通信業務量,從而能建立高速且高效 的資料庫系統。 (實施形態2 ) 圖7為顯示PCI 1與資料庫伺服器2丨的介面部分的處理步 称的流程圖。晝面程式1 Π是與各種業務對應的應用程 ,、。啟動该晝面程式111對表示資料庫操作内容的晝面功 能進行記述和定義。由晝面程式記述晝面功能後,為了實 現該晝面功能’需要操作資料庫,並按照以下所示的流 程,執行用於發佈SQL命令、操作邏輯程式呼叫的參數提 交,並取得其結果資料。 啟動晝面程式1 1 1 ’則首先在例如硬碟等記憶體内 存放資料耗服器所接收資料用的資料獲取區(步驟S51 )° ( #.] ^TCP/IP ^1 Γιΐ ί )11It can reduce the communication time and reduce the communication traffic, so that a high-speed and efficient database system can be established. (Embodiment 2) FIG. 7 is a flowchart showing a processing procedure of an interface portion between the PCI 1 and the database server 2. The daytime program 1 Π is an application program corresponding to various services. This day-and-day program 111 is started to describe and define day-and-day functions that indicate the contents of database operations. After describing the day-to-day function by a day-to-day program, in order to realize the day-to-day function, a database needs to be operated, and according to the procedure shown below, the parameter submission for issuing SQL commands and operating logic program calls is executed, and the result data is obtained. . Start the day-and-day program 1 1 1 ’, then first store the data acquisition area for the data received by the data consumer in a memory such as a hard disk (step S51) ° (#.] ^ TCP / IP ^ 1 Γιΐ ί) 11

五 發明說明(22) —__ 介面通信)用的程式座^ 、 DLL (動態鏈結程式座)列如適應視窗的個人電腦時的 ⑴brary)是從客以::叫。這裏,程式庫 用該程式庫準備的ώ皇 司服斋用的介面。通過利 用程式。備的函數’可使資料庫伺服器建立客戶機應 稱^機Ϊ:ΓΡ:#料庫伺服器連接’設定資料庫飼服以 系祐、/ ρ位址)、鎖定育料庫伺服器用的0S (作澤 還:己fi用戶名和通行字元(步驟S53) °此步驟S53中,V. Description of the invention (22) — The program socket for communication with __ interface ^, DLL (dynamic link program socket), such as the 适应 brary when the PC is adapted to the window, are from the client :: called. Here, the library uses the interface prepared by the library for the fighters' service. Through the use of programs. Prepared function 'allows the database server to establish the client's name ^ machine': ΓΡ: # Material server connection 'to set the database server to the system, (/ ρ address), lock the breeder server 0S (Sakuzawa: your fi username and password (step S53) ° In this step S53,

己述用於記述連接路由的網路連接函數。如 飼服器與PC的連接處理就結束。 貝枓肩Describes the network connection functions used to describe connection routes. For example, the connection between the feeder and the PC ends. Beckon shoulder

接著,設定登記(註冊)到資料庫用的資料庫級用戶名 和通行字元(步驟S54)。步驟S54中的關聯資料庫(rdb )用戶名和通行字元表示關聯資料庫管理下的用戶名。利 用這些步驟S51〜S54的步驟,建立PC與關聯資料庫之間的 連接。步驟S53中指定的用戶名和通行字元與通信管理程 式中登記的用戶名和通行字元一致時,PCu被允許對資料 庫伺服器進行存取。步驟S54的註冊處理中,用戶名和通 行字元與關聯資料庫機登記的用戶名和通行字元一致時, 允許存取該資料庫的表。 利用上述到步驟S 5 4為止的步驟,建立p c 11與資料庫伺 服Is 2 1和關聯資料庫2 11之間的連接時,接著,在p c端根 據晝面程式功能執行操作資料庫用的處理。為了進行此資 料庫操作,根據晝面程式的功能,按需要使用2種方法。 一種是如步驟S55中所示,利用SQL文本,確保資料輸出Next, a database-level user name and password for registering (registering) to the database are set (step S54). The username and password of the associated database (rdb) in step S54 indicate the username under the management of the associated database. Use these steps S51 to S54 to establish a connection between the PC and the associated database. When the user name and password specified in step S53 match the user name and password registered in the communication management program, PCu is allowed to access the database server. In the registration process of step S54, when the user name and the password are consistent with the user name and password registered by the associated database machine, access to the database table is allowed. When the connection between the PC 11 and the database servo Is 2 1 and the related database 2 11 is established by using the steps up to step S 5 4 described above, then the processing for operating the database is performed on the PC side according to the daytime program function. . In order to carry out this database operation, two methods are used as required according to the function of the day and night program. One is to use SQL text as shown in step S55 to ensure data output

C:\2D-CODE\90-02\89124554.ptd 第26頁 呻/ 7丄/厶 五、發明說明(23) ^— ---- - ---- 區’並指定全部列的 庫祠服器2 1。這是習矣与料規模’將S Q L文本傳送到資料 發佈SQL文本。按照W的方法,稱為SQL直接發佈,多次 本和結果資料的收'''、發步,S55的方法中,發生多次SQL文 另一種方法如步驟s ^ ° 器21上配置的操作邏 中所示,該方法呼叫資料庫伺服 SQL文本的發送和資料耳複式217,在資料庫伺服器由進行 所示,將操作邏輯程' 庳的操作。這種情況下,如步驟S56 參數(1、2、3和4二含操作邏輯與邏輯編號和回應的 輯。 〜起送出,以呼叫回應的操作邏C: \ 2D-CODE \ 90-02 \ 89124554.ptd Page 26 呻 / 7 丄 / 厶 V. Description of the invention (23) ^ — --------- Area 'and specify all columns of Kuci器 器 2 1. This is Xi'an and the material scale ’to transfer SQL text to data and publish SQL text. According to the W method, it is called SQL direct release, and multiple copies of the text and result data are received, and sent. In the method of S55, multiple SQL texts are generated. Another method is to perform operations configured on step 21. As shown in the logic, the method calls the database server to send the SQL text and the data ear complex 217, and the database server will perform the operations shown in the logic procedure '庳. In this case, as in step S56, the parameters (1, 2, 3, and 4) include the operation logic and logic number and the response series. ~ Send out to call the operation logic of the response

操作邏輯程式能利〃 ^ 啟動,可進行有效、s堇傳送少量參數自變數的資料進七 交給操作邏輯的;=二。,依據操作邏輯程式2 1 7定義遞 料庫伺服器上準備的辑規範。即,能在晝面程式上根據1 (資料類型(整數型1乍邏輯程式的結構,定義參數規襄 僅呼叫一次邏輯程 等規模專)。彳女知、此步驟S 5 6 ’ 的檢索/更新/刪除/插?尤/、在貝料庫伺服态2 1内實施複铜 的操作結果經網路送回晝之:程的:。作處理’僅將最後得到The operation logic program can be easily activated. It can be effective. It can send a small amount of data of parameter independent variables into the seven to the operation logic; = two. According to the operation logic program 2 1 7, the compilation specifications prepared on the server of the depot are defined. That is, the day-time program can be based on 1 (data type (the structure of the integer type 1 logic program, the parameter definition is called only once, such as the logic process). The girl knows that this step S 5 6 'search / Update / delete / insert? Especially /, the results of the operation of copper recovery in the servo state 2 1 of the shell material warehouse are sent back to the network via the network at the day: Cheng:.

到二:S】5:S5!在檢索處理的;青況下’將該檢索結果輸d 哭踹,將眘祖僅甘二Γ 枓獲取區内。在該資料庫伺用 上(步驟S57 )。 文的取終結果貧料經網路傳送到Ρ( 傳送給P C11的資料分西? $ | — 晝面程式上顯* (步;s 8到、母-表(電子資料表)等’名 乂驟358 )。為了用此電子資料表將資To two: S] 5: S5! In the search process; in the green case, the search result is input to d, and the ancestor will be only willing to get in the area. Serve on this database (step S57). The final result of the text is sent to P via the network. (The data sent to P C11 is divided? $ | — The day-time program is displayed * (step; s 8 to, mother-table (electronic data table), etc. Step 358). In order to use this spreadsheet

479172479172

料準確設置在表上行和列的正確 示列的位置的指標,對資料進…數器產生表 r進行識別後,將表資或 )。步驟S55、S56、S57和S58可根攄~、f佥僅在松索 内容,重復執行需要的次數根據5己述晝面功能的操作 :部操作(檢索/更新/刪除/插入)處 畢 與步驟S55對應的步驟,即宣告發佈處理結Y,結一佈 S』L處理(步驟S59 )。在執行步驟咖傳送观文本時,需The material is accurately set on the upper row and the column of the index to show the correct position of the column. After identifying the data into the table r, the table r or) is used. Steps S55, S56, S57, and S58 can only be performed on the content of the cable, and repeated as many times as necessary. According to the operation of the day-and-day function described in Section 5, the operation (retrieve / update / delete / insert) is completed The step corresponding to step S55, that is, the announcement process Y is announced, and the processing is completed (step S59). When performing steps to send the text, you need to

二?/于邏輯呼叫時,從資料庫飼服器端_ 徒出連接結束要求。 在步驟S60,執行步驟S54對應的登出處理,並宣土登纪 結^。即’結束記錄進人資料庫伺服器的存取經過的登記 A錄,從而PC對資料庫的連接結束。 接著,為了解除資料庫伺服器與PC的連接,從Pc宣告os 級的連接解除(步驟S6 i )。在這一系列的處理中,例如 在所有畫面程式上顯示對話方塊或示範,點擊登出處理和 連接解除鍵’從而宣告這些登出處理和連接解除處理。two? / At the logical call, from the database feeder side_, the connection end request is displayed. In step S60, the logout process corresponding to step S54 is performed, and the log on to the land is concluded. That is, the end of the record of access to the database server is recorded, and the connection of the PC to the database is ended. Next, in order to release the connection between the database server and the PC, an os-level connection is announced from Pc (step S6 i). In this series of processes, for example, a dialog box or a demonstration is displayed on all screen programs, and the logout process and connection release button are clicked to announce these logout processes and connection release processes.

主在步驟S53到步驟S57的資料庫伺服器存取時發生差錯的 情況了,強制解除與資料庫伺服器的連接,並且畫面程式 在顯不晝面上顯示發生差錯的資訊。用於觀察此出錯顯 不,執行必要的處理(例如,參照出錯處理時顯示在畫面 上的範例,執行必要的處理)。 步驟S5 1到S6 1的處理,例如可按下面那樣進行,啟動畫 面程式1 1 1記述所需晝面功能後,點擊晝面程式111上包含The master has encountered an error when accessing the database server from step S53 to step S57, and forcibly releases the connection to the database server, and the screen program displays the information of the error on the display screen. It is used to observe the error display and perform necessary processing (for example, refer to the example displayed on the screen during error processing and perform necessary processing). The processing in steps S5 1 to S6 1 can be performed, for example, as follows. After starting the picture program 1 1 1 and describing the required day and day functions, click on the day and day program 111 to include

五、發明說明(25) _ 的知作執行鍵,由畫面 需的對話方揷 :# Slu在顯示晝面上顯示通信所 圖8二 且用戶在框内記述所需資訊。 為:員圖7所示步驟⑽中資料添加時 :面’茶照圖8簡單說明此資料添加處理。 SS1 )。取知,貝’將計數器和列指標初始化(步驟 一個次‘、广二逐個ί以欄位為單位)取得資料(SS1)。取得 的位:移2 ’:數器遞增,列也遞增,因而顯示晝面上列 全:置:動(步驟SS2)。接著,判決是否取得-行資料的 王邛(步驟SS3 )。為未全部取得一&次料日车,、β '科的 SS1取下—次Μ ^木王邛取传一仃貝枓日守,返回步驟 η ^ ,貝枓。在v驟%3,取得全部一行資料時,判氺 子ί下-行(步驟叫。存在下-行時,為了: ^ ^ 行,將計數器和列初始化(步驟SS1 )。其後, 次進行相同操作,即執行步驟SS1到SS3的處理。 f步驟SS4 ’取得全部行的資料後,判決是否接收到一 本:格(結果資料)(步驟SS5)。還需要接收其他結構 ^蚪,確保其他區(步驟SS6 ),接著,再次返回步驟 0 /再次重復對此其他結果表的資料輸出操作。在步驟 5對所有的結果表取得資料時,此資料添加操作結束。 。。此圖8中’按每一行取得資料。然而,也可做成以列為 單位取得資料。 標 利用δ十數益在每次取得資料時更新表示表中列位置的指 ’從而能將取得的資料正確分配到回應的列位置。 如上所述’根據本發明實施形態2,結構上做成在pc (電腦終端)啟動晝面程式,僅將表示操作内容的邏輯的V. Description of the invention (25) _ is known as the execution key, and the dialogue required by the screen 需: # Slu displays the communication station on the display day. Figure 82. The user describes the required information in the box. For: when the data is added in step 所示 shown in FIG. 7: noodles, tea, and the process of adding this data is briefly described in FIG. 8. SS1). To learn, Bay 'initializes the counters and column indicators (one step at a time, and Guang Er uses the field as a unit) to obtain data (SS1). The obtained bit: shift 2 ': The counter is incremented, and the column is also incremented, so the column on the day is displayed. Full: Set: Move (step SS2). Next, it is judged whether or not Wang Ye who has obtained the line data (step SS3). In order to obtain all the < < yellow   day car >, the SS1 of the β 'section is taken down-the second M ^ wood king 邛 takes a pass 仃 枓 守, and returns to step η ^, 枓 枓. In v %% 3, when all the rows of data are obtained, the subordinate is judged next-row (the step is called. When there is a next-row, in order to: ^ ^ row, initialize the counter and column (step SS1). The same operation, that is, the processing of steps SS1 to SS3 is performed. FStep SS4 'After obtaining the data of all the rows, determine whether a copy of the: case (result data) has been received (step SS5). You need to receive other structures ^ 蚪 to ensure other Area (step SS6), and then return to step 0 again / repeat the data output operation for this other result table again. When obtaining data for all the result tables in step 5, this data addition operation is finished .... This figure 8 ' Obtain the data for each row. However, it can also be made to obtain the data in units of columns. The target uses δ ten benefits to update the indication indicating the position of the column in the table each time the data is obtained, so that the obtained data can be correctly allocated to the response. As described above, according to the embodiment 2 of the present invention, it is structured to start the day-and-day program on the PC (computer terminal), and only the logic indicating the operation content will be

C:\2D-roDE\90-02\89124554.ptd 第29頁 479172 五、發明說明(26) 邏輯編號和表示操作條件的參數發送給資料庫伺服器,因 而使用此電腦終端的操作者(用戶)不必像習知那樣試圖 編制SQL語句,能方便地記述需要的操作,進入資料庫予 以存取。 (實施形態3) 圖9。為顯示資料庫伺服器2丨所含通信要求監視程式和操 作邏#專程式的結構的概略圖。圖9中,資料庫伺服器2 1包 含經常監視PC 1 1提出的連接要求的通信要求監視程式 2 1 6,在通信要求監視程式2丨6控制下啟動並按照pc丨丨操作C: \ 2D-roDE \ 90-02 \ 89124554.ptd Page 29 479172 V. Description of the invention (26) The logical number and the parameters representing the operating conditions are sent to the database server, so the operator (user) using this computer terminal ) It is not necessary to try to compile SQL statements as in the past, it can easily describe the required operations and enter the database to access them. (Embodiment 3) FIG. A schematic diagram showing the structure of the communication request monitor program and the operation logic #program included in the database server 2 丨. In FIG. 9, the database server 2 1 includes a communication request monitoring program 2 1 6 that constantly monitors the connection request made by the PC 1 1. It is started under the control of the communication request monitoring program 2 丨 6 and operates in accordance with the pc 丨 丨

要求執行規定處理的操作邏輯程式2丨7,以及對資料庫伺 服為2 1的細作環境進行定義的4個定義檔案2 2 1〜2 2 4。 連接數定義檔案221規定能同時連接的PC數,並規定記 錄該連接的登記檔案。用戶環境定義檔案222根據〇s級執 行用戶名規定PC 1 1連接並執行的操作邏輯程式2丨7等程式 的用=。利用此用戶環境定義檔案222定義的用戶名,按 照通#要求監視程式2 1 6確定是否允許進入資料庫伺服 2 1予以存取。 命 RDB %境定義檔案223利用關聯資料庫級的用戶名,即The operation logic program 2 丨 7 required to execute the prescribed processing, and the four definition files 2 2 1 to 2 2 4 which define the detailed working environment of the database server 2 1. The connection number definition file 221 specifies the number of PCs that can be connected at the same time, and specifies a registration file for recording the connection. The user environment definition file 222 executes the user name according to the 0s-level execution user name, and the operation logic programs 2 and 7 used by the PC 1 1 are connected and executed. Using the user name defined in this user environment definition file 222, determine whether to allow access to the database server 2 1 according to the request of monitoring program 2 1 6 according to Tongtong #. Command RDB% Context Definition File 223 to use the username of the associated database level, ie

的所有者,規定PCI 1能連接並操作的關聯資料庫(RDB )、 的用戶。即,關聯資料庫中存在多個纟,根據關聯資 中的用戶名批准對各表的操作。由此,確保資料庫的 全。 0S環境定義檔案224為規定通信要求監視程式21 6和 邏輯程式217的工作環境的槽案,進行可檢索路徑名(曰作Owner, the user of the associated database (RDB), which can be connected and operated by PCI 1. That is, there are multiple frames in the association database, and operations on each table are approved based on the user name in the association data. This ensures the completeness of the database. The OS environment definition file 224 is a slot that specifies the working environment of the communication request monitoring program 21 6 and the logic program 217, and performs searchable path names (say

479172 五、發明說明(27) 錄名)和使用語言的指定等環境變數的定義。經常啟動通 "ί吕要求監視程式2 1 6 ’監視P C11提出的連接要求。此通信 要求監視程式2 1 6啟動時,讀取這些環境定義檔案2 2 1〜 2 2 4定義的資訊。下面,說明此資料庫伺服器2 1的運作。479172 V. Definition of invention (27) Record name) and definition of environmental variables such as the use of language. Frequently activated communication " Lv request monitoring program 2 1 6 'monitors the connection request made by PC11. This communication requires that when monitoring program 2 1 6 is started, the information defined in these environment definition files 2 2 1 to 2 2 4 is read. The operation of the database server 21 will be described below.

通信要求監視程式2 1 6在預定的埠號(表示通信接收口 的號碼)連續等待P C1 1的連接要求。有來自p c 1 1的連接要 求時(步驟S 2 3 1 )’通信要求監視程式2 1 6將用戶環境定 義檔案222規定的用戶名與該連接要求所同時提供的用戶 名(登記I D )比較。從PC 11通過通信功能11 4提供的用戶 名登記在用戶環境定義檔案2 2 2中時,通信要求監視程式 21 6對該PCI 1提供瞭解受理連接事項的,’ 〇κ”資訊(步驟 S 2 3 2 )。利用傳送此〇 κ資訊,pc 11與資料庫伺服器2 1之間 建立連接。 PC11對通信要求監視程式216指出與所啟動操作邏輯程 式217進行通信用的埠號(步驟S23 3 )。通信要求監視程 式2 1 6在步驟S2 3 3所指定埠號的璋為空間狀態時,再次將 表示瞭解的0K資訊傳回PC11 (步驟S234 )。 通h要求監視程式21 6由步驟S23 4將0K資訊送回PCI 1 後,啟動一個操作邏輯程式2丨7。這裏,通信要求監視程 式216在步驟S25 0執行” F0RK”(”分叉”)命令。此” F〇RK,,命 _ 令疋一種生成能與當前所執行處理並行地重新執行的另一 處理的^令。即,設置多個操作邏輯程式21 7,能同時啟 、 動=個刼作邏輯程式。對pc提出的一個連接要求啟動一個.. 邏輯刼作程式217。根據連接數定義檔案221規定的可同時·The communication request monitoring program 2 1 6 continuously waits for a connection request of P C1 1 at a predetermined port number (indicating a communication receiving port number). When there is a connection request from p c 1 1 (step S 2 3 1) ', the communication request monitoring program 2 1 6 compares the user name specified in the user environment definition file 222 with the user name (registration ID) provided simultaneously with the connection request. When the user name provided from the PC 11 through the communication function 11 4 is registered in the user environment definition file 2 2 2, the communication request monitoring program 21 6 provides the PCI 1 with the information of “〇κ” to understand the acceptance of the connection matters (step S 2 3 2). By transmitting this 〇κ information, a connection is established between the PC 11 and the database server 21 1. The PC 11 indicates to the communication request monitoring program 216 a port number for communication with the activated operation logic program 217 (step S23 3 ). When the communication request monitoring program 2 1 6 is in the space state at the port number specified in step S2 3 3, the 0K information indicating the understanding is returned to PC11 again (step S234). The communication request monitoring program 21 6 is performed by step S23. 4 After returning the 0K information to PCI 1, start an operation logic program 2 丨 7. Here, the communication requires the monitoring program 216 to execute the "F0RK" ("fork") command at step S25. This "F0RK," command _ Order An order that generates another process that can be re-executed in parallel with the currently executing process. That is, a plurality of operation logic programs 21 7 can be set to start and operate simultaneously. A connection request to the pc initiated a .. logic program 217. According to the number of connections defines the simultaneous

479172 五、發明說明(28) 連接的PC數,確定同時啟動的操作邏輯程式2 1 7數量的上 限。 通信要求監視程式2 1 6啟動該操作邏輯程式2 1 7後,再次 在預定的谭號寺待接受通信要求。此後的處理,在所啟動 的操作邏輯程式21 7與PCI 1之間執行。 所啟動的操作邏輯程式217通過步驟S23 3指定的埠號所 表示的埠,對PCI 1發佈連接要求(步驟S235 ) 。PCI 1 —旦479172 V. Description of the invention (28) The number of connected PCs determines the upper limit of the number of operating logic programs 2 1 7 to be started at the same time. The communication request monitoring program 2 1 6 starts the operation logic program 2 1 7 and waits to receive the communication request at the predetermined Tanhao Temple again. Subsequent processing is executed between the activated operation logic program 21 7 and PCI 1. The activated operation logic program 217 issues a connection request to the PCI 1 through the port indicated by the port number specified in step S23 3 (step S235). PCI 1-once

受理此連接要求,則對操作邏輯程式2 1 7發送表示瞭解的 0K資訊(步驟S236 )。接著,PC11對此指定的埠發佈對關 聯資料庫(RDB )註冊(登記後執行處理)要求(步驟 S2 3 7 )。标作邏輯程式2 1 7對此提出的RDB註冊要求判決該 註冊要求所含用戶名是否與對PC1丨要求存取的資料庫登記 白!用戶岑一致。該RDB註冊要求時提供的用戶名登記在RDB 锿境定義檔案223中時,操作邏輯程式217受理此PC11的註 冊么’,、◊在連接數定義檔案2 21所含記錄中記錄該存取。 sot女二理勃此'主冊要求時,#著,按照要執行的處理發佈 給PCI 1 (步驟S239 ^戈正確卢理订Λ輯呼叫(步驟S23 8 )。在正確處理SQL命 2 ί ΐ邏輯控制時,操作邏輯程式m傳送〇κ資訊 進行邏輯控制時,操作邏輯程式Accepting this connection request, it sends 0K information indicating the understanding to the operation logic program 2 17 (step S236). Then, the PC 11 issues a registration (related processing after registration) request to the associated database (RDB) for this designated port (step S2 3 7). It is marked as a logic program 2 1 7 The RDB registration request proposed in this judgment determines whether the user name contained in the registration request is the same as the database registration required for access to PC1 丨 White! User Cen agrees. When the user name provided at the time of the RDB registration request is registered in the RDB environment definition file 223, does the operation logic program 217 accept the registration of this PC11 ', and the access is recorded in the record contained in the connection number definition file 2 21? Sot female Er Libo asked for this 'Master Book', # 着, issued to PCI 1 in accordance with the processing to be performed (step S239 ^ Go correctly Lu Liding Λ series call (step S23 8). In the correct processing SQL command 2 ί ΐ During logic control, the operation logic program m transmits 〇κ information for logic control.

217按照邏輯控制所 n 1休丨f峰科征八 217所含操作邏輯°參數啟動操作邏輯程式 執行處理。 W對啟動的細作邏輯提交所需參數後 也可做成通信要灰鈐 223定義的用戶名,^視=式216讀取_環境定義檔案 並在啟動知作邏輯程式2丨7時,將該讀217 starts the operation logic program according to the operation logic ° parameter contained in the logic control station n 1 and f peak section levy 8. The processing is performed. After submitting the required parameters for the detailed logic of the startup, it can also be made into a user name to be defined in communication 223, ^ == Formula 216 reads the _environment definition file and when the known logic program 2 丨 7 is started, read

479172 五、發明說明(29) --- 取的RDB環境定義檔案交給操作邏輯程式217。還可做成操 作邏輯程式217在要求RDB”時,存取_環境定義槽案 2 2 3,判斷是否登記用戶名。 根據畫面程式記述的畫面功能重復進行上述SQL文本發 佈和邏輯呼叫需要的次數。晝面程式的要求在檢索處理 時’在操作邏輯程式217的控制下,將檢索關聯資料庫所 得的貧料暫時存放到圖中未示出的例如磁片裝置等暫存哭 =。/^11在步驟S239取得操作結果並送回〇κ資訊時,發^ 貧料獲取指示(步驟240 )。操作邏輯程式217回應此資料 獲取私不,存取關聯資料庫,並將操作所得結果的資訊 送給PCI 1 (步驟S21 1 ) 〇 、 又 利用SQL文本指定資料庫操作時,進行所需處理,並完 成一系列晝面程式的操作處理時,PC1丨對操作邏輯程 217提供SQL發佈結束的資訊(步驟S242 )。操作邏輯 2 1 7狁知PCI 1旦告SQL發佈結束時,發佈表示瞭解的⑽資訊 (步驟S243 )。進行邏輯啤叫時,只進行所需次數的邏輯 呼叫’尤其是不宣告SQL發佈結束。 PC11在步驟S243接收〇κ資訊時,宣告表示對關聯資料 的登記處理結束的RDB登出(步驟S 245 )。操作邏輯程式 2 1 7收到此RDB登出宣告時,在連接數定義檔案2 2 i所含記 錄中記述需要的資訊,接著,結束記錄處理(登出)。宣 fRDB登出時,也可做成操作邏輯程式217對記錄分別記^ 資料庫伺服器的〇S級記錄和關聯資料庫級記錄。 所需登出處理結束時,操作邏輯程式21 7對?(::1丨發佈⑽479172 V. Description of the invention (29) --- Take the RDB environment definition file to the operation logic program 217. It can also be made that the operation logic program 217 accesses the _environment definition slot case 2 2 3 to determine whether to register the user name when the RDB is required. The number of times required for the above-mentioned SQL text release and logic call is repeated according to the screen function described by the screen program. Requirement of the daytime program during the search process' Under the control of the operation logic program 217, temporarily store the lean material obtained from the search of the related database to a temporary storage such as a magnetic disk device not shown in the figure. 11 When the operation result is obtained in step S239 and the κ information is returned, a ^ lean material acquisition instruction is sent (step 240). The operation logic program 217 responds to this data to obtain private information, accesses the associated database, and sends information about the operation result. Sent to PCI 1 (step S21 1) 〇 When using SQL text to specify database operations, perform the required processing, and complete a series of day-to-day program operation processing, PC1 丨 provides the operation logic program 217 with the SQL release end Information (step S242). The operating logic 2 1 7 knows that PCI 1 reports the end of the SQL release when the SQL is released (step S243). When performing a logical beer call, only the required In particular, the number of logical calls does not announce the end of the SQL release. When PC11 receives the κ information in step S243, it announces an RDB logout indicating that the registration processing of the related data is completed (step S245). The operation logic program 2 1 7 receives When the RDB is logged out, the required information is described in the records contained in the connection number definition file 2 2 i, and then the record processing (logout) is ended. When the fRDB is logged out, the operation logic program 217 can be made to the records Record the ^ level records of the database server and the related database level records separately. When the required logout processing ends, the operation logic program 21 7 pairs? (:: 1 丨 posted⑽)

479172 五、發明說明(30) ' · -- ^訊(步驟S246 ) cPCll在步驟S246送回〇κ資訊時,則接 著對操作邏輯程式21 7通告解除連接(步驟S247 )。摔作 邏輯程式217接到此解除連接通告時’結束一系列的處 理,對通信要求監視程式216宣告處理結束,同時執行連 接角午除處理(EXIT:退出)(步驟S251)。 此操作邏輯程式21 7的操作完成時,通信要求監視程式 2 1 6使用例如標誌等識別該操作邏輯程式2丨7對且他 求可利用。 疋牧文 、=上所述,在上述資料庫伺服器21内,利用通信要求監 視程式2 1 6,分別以OS級和關聯資料庫級識別進行連接要 _ 求的用戶的用戶名和登記丨D,從而能容易確保對該資料庫 伺服器21的安全性。不需要在對資料庫伺服器21與%^進 仃中繼的連接裝置内使用丨p位址等選擇路由,可大量簡化 確保安全性的作用。 (變更例) 圖10為顯示資料庫伺服器21的操作邏輯程式217的結構 的概略圖。圖10中,多個操作邏輯程式217a〜2i7n與通信 要求監視程式2 16並聯連接。通信要求監視程式216通過預 定的埠218經常監視PC提出的連接要求。 視程式設置標諸寄存器219,該寄存器存放輯 程式2^173〜21711分別對應設置的啟動標誌31^〜31?11。 通信要求監視程式2 1 6通過埠2 1 8收到連接要求時,參照 標諸寄存器2 1 9 ’啟動與表示非啟動狀態的標諸對應的操 作邏輯程式。通信要求監視程式21 6在啟動一個操作邏輯479172 V. Description of the invention (30) '^ (step S246) When the cPCll returns κ information in step S246, it then announces the disconnection to the operating logic program 21 7 (step S247). When the fallback logic program 217 receives this disconnection notification, it ends a series of processing, announces the end of the processing to the communication request monitoring program 216, and simultaneously executes the connection corner noon processing (EXIT: exit) (step S251). When the operation of the operation logic program 21 7 is completed, the communication request monitoring program 2 1 6 uses, for example, a mark or the like to identify the operation logic program 2 丨 7 pair and other requirements are available.疋 Muwen, = As mentioned above, in the above database server 21, the communication request monitoring program 2 1 6 is used to identify the connection requirements of the user at the OS level and the associated database level. _D So that the security of the database server 21 can be easily ensured. There is no need to select a route using a p address or the like in a connection device that relays the database server 21 and the% ^, which can greatly simplify the role of ensuring security. (Modification) Fig. 10 is a schematic diagram showing the configuration of the operation logic program 217 of the database server 21. In FIG. 10, a plurality of operation logic programs 217a to 2i7n are connected in parallel with the communication request monitoring programs 2-16. The communication request monitoring program 216 frequently monitors the connection request made by the PC through a predetermined port 218. Registers 219 are set according to the program. This register stores the start flags 31 ^ ~ 31? 11 corresponding to the program 2 ^ 173 ~ 21711 respectively. When the communication request monitoring program 2 1 6 receives a connection request through the port 2 1 8, it refers to the flag register 2 1 9 ′ to start the operation logic program corresponding to the flag indicating a non-start state. Communication requires monitor program 21 6 to start an operating logic

479172 五、發明說明(31) 程式217i ( i =a〜η )時,在標誌寄存器219將回應的標誌 寄存器SF i設定為啟動狀態(建立標誌)。對一個操作邏 輯程式2 1 7 i的連接要求處理完成時,通信要求監視程式 2 1 6將後面的處理步驟轉交給該啟動的操作邏輯程式2丨7 i 後’又監視埠2 1 8發來的連接要求。操作邏輯程式2 1 7a〜 2 1 7 η在啟動時經指定的埠與p c進行通信。處理一結束,此 操作邏輯程式2 1 7 i就將標誌寄存器2 1 9中對應的啟動標誌 SF i設定為表示非啟動狀態的狀態(標誌復原)。 借助利用圖1 0所示的結構,可用一個通信要求監視程式 2 1 6有選擇地啟動多個操作邏輯程式2 1 7 a〜2 1 7 η。此操作 邏輯程式21 7a〜21 7η的數量與連接數定義檔案221規定的 可同時連接的P C數量對應。這些操作邏輯程式2 1 7 a〜2 1 7 η 具有相同的結構,能進行檢索/更新/刪除/插入處理。 (變更例2 ) 圖11為顯示資料庫伺服器2 1另一結構的概略圖。圖】j 中’對埠2 1 8並聯連接多個通信要求監視程式2 i β a〜2 i 6 η 。分別對應於這些通信要求監視程式216a〜216η,設置操 作邏輯程式2 17a〜217η。操作邏輯程式2 na〜2 17η按照PC 的指定,有選擇地連接埠22 0a〜22 Ok中的一個,與pc進行 通信。埠220a〜220k與操作邏輯程式2i7a〜21711的連接路 由,用P C指定的璋號確定。在連接p c和資料庫伺服器的網 路(相互間線路不通)上並聯連接這些璋2 2 〇 a〜2 2 〇 k。利 用對埠進行指定,實現適應PC通信特性(通信速度等)的 通信(專用線路、I S D N線路、電話線路等)。479172 V. Description of the invention (31) When the program 217i (i = a to η), the response register SF i is set to the start state (build flag) in the flag register 219. When the connection request processing for an operation logic program 2 1 7 i is completed, the communication request monitoring program 2 1 6 transfers the subsequent processing steps to the activated operation logic program 2 丨 7 i and then monitors port 2 1 8 Connection requirements. The operation logic program 2 1 7a ~ 2 1 7 η communicates with pc through the designated port at startup. As soon as the processing is completed, the operation logic program 2 1 7 i sets the corresponding start flag SF i in the flag register 2 1 9 to a state indicating a non-start state (flag restoration). By using the structure shown in FIG. 10, a communication request monitoring program 2 1 6 can selectively start a plurality of operation logic programs 2 1 7 a to 2 1 7 η. This operation corresponds to the number of logic programs 21 7a to 21 7η corresponding to the number of PCs that can be connected at the same time as defined in the connection number definition file 221. These operation logic programs 2 1 7 a to 2 1 7 η have the same structure and can perform retrieval / update / deletion / insert processing. (Modification 2) FIG. 11 is a schematic diagram showing another configuration of the database server 21. Figure] In j ', multiple communication request monitoring programs 2 i β a to 2 i 6 η are connected in parallel to port 2 1 8. Corresponding to these communication request monitoring programs 216a to 216η, operation logic programs 2 17a to 217η are set. The operation logic program 2 na ~ 2 17η is selectively connected to one of the ports 22 0a ~ 22 Ok according to the designation of the PC to communicate with the pc. The connection routes between the ports 220a to 220k and the operation logic programs 2i7a to 21711 are determined by the 璋 number designated by PC. These 璋 2 2 0 a ~ 2 2 0k are connected in parallel on the network (the lines are not connected to each other) connecting the PC and the database server. By designating the port, communication (dedicated line, I S D N line, telephone line, etc.) suitable for PC communication characteristics (communication speed, etc.) is realized.

C:\2D-C0DE\90-02\89124554.ptd 第35頁 479172 五、發明說明(32) 通佗要求監視程式2 16a〜2 16η分別具有優先權標誌pF在 通信要求監視程式2 16a〜2 16η中,規定優先順序,例如上 行隶同$而的通#要求監視程式21 6 a優先順序最高,下行最 低端的通信要求監視程式21 61優先順序最低。通信要求監 視程式2 1 6 a〜2 1 6 η在建立此優先標諸p 時,監視琿2 1 8發 來的連接要求。一個通信要求監視程式2丨6 i收到接收要 求,並啟動對應的操作邏輯程式2丨7丨時,位於其下行的下 一個通信要求監視程式216 j建立優先標誌。因此,該下一 個通#要求監視程式2 1 6 j監視下一個連接要求。通信要求 監視程式2 1 6 1完成一個處理操作,對應的操作邏輯程式 2 1 7 i的啟動也完成,並進行完解除連接時,通信要求監視 程式將下行端的優先標誌全部復原後,建立本身的優先標 誌、。因此’通信要求監視程式2 1 6 a〜2 1 6 η在有來自埠2 1 8 的連接要求的情況下,僅在建立本身的優先標誌時,執行 對連接要求的應答。通信要求監視程式2 16a〜216丨全部為 啟動狀態時,不對任何連接要求進行應答。pc丨1中,在規 定時間内沒有對連接要求應答時,在pc的例如顯示晝面上 顯示存取不成功。C: \ 2D-C0DE \ 90-02 \ 89124554.ptd Page 35 479172 V. Description of the invention (32) General request monitoring program 2 16a ~ 2 16η has priority flag pF in communication request monitoring program 2 16a ~ 2 In 16n, the order of priority is specified. For example, the communication link ## on the uplink requires the monitoring program 21 6 a to have the highest priority, and the communication on the lowest end of the downlink requires the monitoring program 21 61 to have the lowest priority. The communication request monitoring program 2 1 6 a to 2 1 6 η monitors the connection request sent by 珲 2 1 8 when establishing this priority flag p. When a communication request monitoring program 2 丨 6i receives a reception request and starts the corresponding operation logic program 2 丨 7 丨, the next communication request monitoring program 216j on its downstream establishes a priority flag. Therefore, the next communication request monitoring program 2 1 6 j monitors the next connection request. The communication request monitoring program 2 1 6 1 completes a processing operation, the corresponding operation logic program 2 1 7 i is also completed, and when the connection is disconnected, the communication request monitoring program restores all downstream priority signs and establishes its own Priority sign ,. Therefore, when the communication request monitoring program 2 1 6 a to 2 1 6 η has a connection request from port 2 1 8, it only responds to the connection request when it establishes its own priority flag. When the communication request monitor programs 16a to 216 丨 are all activated, no connection request is responded. In pc1, if there is no response to the connection request within a predetermined time, for example, on the display of the pc, the access is not successful.

在圖11所示結構的情況下,通信要求監視程式216a〜 216η只要經常管理一個對應的操作邏輯程式217a 〜217n即 可。與全部管理多個操作邏輯程式2丨7a〜2丨7n時相比,可 減輕通信要求監視程式216a〜216n的負荷。 如上所述’根據本發明實施形態3,結構上做成在資料 庫伺服器設置通信要求監視程式,對該資料庫伺服器和資In the case of the structure shown in FIG. 11, the communication request monitoring programs 216a to 216n only need to constantly manage a corresponding operation logic program 217a to 217n. Compared with the case where all the operation logic programs 2 丨 7a to 2 丨 7n are managed, the load of the communication request monitoring programs 216a to 216n can be reduced. As described above, according to the third embodiment of the present invention, a communication request monitoring program is set up in the database server, and the database server and the information are configured.

C:\2D-mDE\90-02\89124554.ptd 第36頁 479172 五、發明說明(33) 料庫的登記進行監視,因而不需進行選路,就能方便地確 保安全性。 又由於結構上做成設置多個操作邏輯程式,使各操作邏 輯程式處理電腦終端的連接要求’能同時並行處理多個終 端的連接要求,可建立高效的資料庫系統。 (實施形態4 ) 圖1 2為顯示本發明實施形態4的通信系統的結構的概略C: \ 2D-mDE \ 90-02 \ 89124554.ptd Page 36 479172 V. Description of the invention (33) The registration of the material warehouse is monitored, so it is convenient to ensure the safety without routing. Also, because the structure is provided with a plurality of operation logic programs, each operation logic program can process the connection requirements of the computer terminal, and can simultaneously process the connection requirements of multiple terminals at the same time, thereby establishing an efficient database system. (Embodiment 4) FIG. 12 is a schematic diagram showing a configuration of a communication system according to Embodiment 4 of the present invention.

圖。圖1 2中’此通信系統包含現場# 1、# 2和# 3等3個現 場。現場# 1中包含多個電腦終端(PC ) 11〜1 3和對這些 P C11〜1 3共同設置的中繼伺服器5 1。中繼伺服器5 1管理現 場# 1内設置的PC 11〜1 3與其他現場# 2和# 3之間的通 信。中繼伺服器5 1包含記錄這些PC 11〜1 3的存取歷史的存 取記錄2 5 1、登記能通過中繼伺服器5 1存取其他現場# 2和 # 3的PC的連接許可列表2 6 1,以及僅在通信時中繼其内容 的中繼功能5 1 1。設置多個中繼功能5 1 1,後文詳細說明。Illustration. 'This communication system in FIG. 12 includes 3 sites including site # 1, # 2, and # 3. The site # 1 includes a plurality of computer terminals (PCs) 11 to 13 and a relay server 5 1 provided in common with these PC11 to 13. The relay server 5 1 manages communication between the PCs 11 to 1 3 installed in the site # 1 and other sites # 2 and # 3. The relay server 5 1 contains an access record 2 5 which records the access history of these PCs 11 to 1 3. 1. Registers the connection permission list of PCs that can access other sites # 2 and # 3 through the relay server 5 1. 2 6 1 and the relay function 5 1 1 which relays its content only during communication. Setting multiple relay functions 5 1 1 will be described in detail later.

一個中繼功能收到連接要求時,啟動其他中繼功能,對言 pc連接要求所對應的通信進行中繼,而且又繼續監視白 其他連接要求。因此,中繼伺服器5丨中,比現場#丨内設 置的PC11〜13中可同時連接的PC數量多設置j個中繼功;: 511。可用與先前實施形態丨等中的操作邏輯程式相同 式,實現中繼功能511。存取記錄251記錄pcn〜13盥 #2和#3通信時的連接情$兄,不論連接是否成功。:存』 e錄251記錄的資訊為哪—Pc何時對哪―伺服器提出連 要求,而且何時完成或連接失敗等。When a relay function receives a connection request, it starts other relay functions, relays the communication corresponding to the PC connection request, and continues to monitor other connection requests. Therefore, in relay server 5 丨, j relay functions are set more than the number of PCs that can be connected simultaneously in PC11 ~ 13 set in field # 丨: 511. The relay function 511 can be implemented with the same operation logic program as in the previous embodiment. The access record 251 records pcn ~ 13. # 2 and # 3 communicate the connection between brothers, regardless of whether the connection is successful. "Save" eRecord 251 What is the information recorded—Pc when to which—the server made a connection request, and when it was completed or the connection failed.

479172479172

^ % # 2和現場# 3分別配置資料庫伺服器2 2和資料庫伺 服益2 3。貧料庫伺服器22中,設置關聯資料庫(rdb ) 2 11、連接终可列表2 β 2和存取記錄2 5 2。資料庫伺服器2 3 中’也設置關聯資料庫2丨2、連接許可列表2 6 3和存取記錄 2 5 3。連接許可列表2 6 2和2 6 3以中繼伺服器為單位,發佈 . 其連接允許資訊。因此連接許可列表2 62和263中,登記識 別中繼祠服裔5 1的位址或I d。存取記錄2 5 2和2 5 3對中繼伺 · 服器的連接要求是否允許、源中繼伺服器和連接狀況(包-括時間資訊)進行記錄。 現場# 1、現場# 2和現場# 3之間的連接裝置4 1中,分 . 別在連接器4 1 a和連接器4 1 b規定中繼伺服器5 1與資料庫伺 服為2 2的連接路由和中繼伺服器5丨與資料庫伺服器2 3的連 接路由。 現場# 1的PC 11〜1 3不能直接存取現場# 2和# 3的資料 庫伺服器2 2和2 3。因此,有關現場間通信的安全管理,不 需要每一PC進行,只需進行資料庫伺服器與現場# 1設置 的中繼伺服器之間的安全性管理即可,能大幅度減少網路 安全性管理物件的電腦數量,可大量節制工作負荷。 圖1 3為現場# 1的其他結構概略說明圖。圖丨3中,設置 專用LAN412a和412b。專用LAN412a連接PClla〜13a,專用 LAN412b配置PCllb〜13b。對專用LAN412a配置中繼伺服器 518,對1^\4121)配置中繼伺服器511^。這些中繼伺服器513 和5 1 b連接例如路由器,即連接網路連接裝置。中繼伺服 器5 1 a和5 1 b的結構與圖1 2所示中繼伺服器5 1相同,分別包^% # 2 and Site # 3 configure the database server 2 2 and the database server 23 respectively. In the lean library server 22, an associated database (rdb) 2 11 is set, and a connection-endable list 2 β 2 and an access record 2 5 2 are set. In the database server 2 3 ′, an associated database 2 丨 2, a connection permission list 2 6 3 and an access record 2 5 3 are also set. The connection permission lists 2 6 2 and 2 6 3 are published in units of relay servers. The connection permission information is published. Therefore, in the connection permission lists 2 62 and 263, the address or ID of the relay temple server 51 is registered to be identified. Access records 2 5 2 and 2 5 3 record whether the connection requirements of the relay server are allowed, the source relay server and the connection status (including time information). In the connection device 4 1 between on-site # 1, on-site # 2 and on-site # 3, they are divided into connector 4 1 a and connector 4 1 b. The relay server 5 1 and the database server are 2 2 Connection routing and relay server 5 丨 connection routing with database server 2 3. PCs 11 to 1 3 on site # 1 cannot directly access the database servers 2 2 and 2 3 on site # 2 and # 3. Therefore, the security management of inter-site communication does not need to be performed by each PC. It is only necessary to perform security management between the database server and the relay server set on site # 1, which can greatly reduce network security. The number of computers for sexual management objects can greatly reduce the workload. FIG. 13 is a schematic explanatory diagram of another structure of the scene # 1. In Figure 3, dedicated LANs 412a and 412b are provided. The dedicated LAN 412a is connected to PC11a to 13a, and the dedicated LAN412b is configured to PC11b to 13b. A relay server 518 is provided for the dedicated LAN 412a, and a relay server 511 ^ is provided for 1 ^ \ 4121). These relay servers 513 and 51b are connected to, for example, a router, that is, to a network connection device. The structures of the relay servers 5 1 a and 5 1 b are the same as those of the relay server 5 1 shown in FIG. 12.

C:\2D-CODE\90-02\89124554.ptd 第38頁 479172 五、發明說明(35) 含中繼功能5 1 1、連接今 如圖13所示,現場#1;=列表261和存取記錄⑸。因此 繼伺服器為單位管理對H^/庙個網路的情況下’以中 否允許。 里對進入貧料庫伺服器的存取和連接是 圖1 4為顯不·一例中繼約tm C , 261 ^ Μ „ „ ; / ; ;〇51b ^ ^ ^ ^ ^ ^ ^ ^ 形式存健各回應網路中圖Ανπ 作為pc名稱,登::二接的㈣ PC13可通過回庫的中:a 、 13 。因此,例如PCI 1和 取。 應的中繼飼服器進入資料庫祠服器予以存 圖1 5為顯不圖1 2所千咨斗立產y —3的結構的概略圖 (和263 )包含存放管理〇s存 , 义 名的中_=: C 3b )刀別對應於貧料庫伺服器的關聯資料座 格的種類設置中繼伺服器名列表26 2b ( 263b)科庫所各表 圖15中,示出允許以中繼伺服器5U和5ib 存取連接;中繼飼服器、名列表2咖中 ^進仃 51a以RDB級存取回應的資料庫的表格。午中▲构服為 因此,與按PC為單位進行安全性管 以中繼伺服器為單位進行安全性管:理目比,可僅 少維持安全性用的工作負荷。 因而能夠大幅度減 各中繼飼服器51、51“〇5lb中,連接許可列表261沒有 1 C:\2D-C0DE\90-02\89124554.ptd 第39頁 479172 五、發明說明(36) 登記的PG有連接要求時,拒絕其連接要求。 圖1 6為顯示圖1 2所示中繼伺服器5 1包含的中繼功能5 11 的結構的概略圖。圖1 6中,中繼功能5 11包含監視PC提出 的連接要求的通信要求監視程式5 4 1和中繼功能中繼程式 542a〜54 2η,該中繼程式在通信要求監視程式541的控制 下啟動,對啟動時提出連接要求的PC和連接目的方的資料 庫之間的信號進行中繼。這些中繼功能中繼程式542a〜 5 4 2 η可多個同時啟動(與操作邏輯程式可多個同時啟動相 同)。C: \ 2D-CODE \ 90-02 \ 89124554.ptd Page 38 479172 V. Description of the invention (35) Including relay function 5 1 1. The connection is as shown in Figure 13, scene # 1; = list 261 and storage Take the record ⑸. Therefore, following the server management for the case of H ^ / miao network, it is allowed in the middle. The access and connection of the server into the lean library is shown in Figure 14. An example of the relay is tm C, 261 ^ Μ „„ / /; 〇51b ^ ^ ^ ^ ^ ^ ^ ^ ^ Figure Ανπ in each response network is the name of the PC. Log in: 13 PC13 can be returned to the library by: a, 13. So for example PCI 1 and fetch. The corresponding relay feeders are stored in the database and stored in the temple server. Figure 15 is a schematic diagram showing the structure of the two thousand thousand y-3 products (and 263) containing storage management. Name of the name _ =: C 3b) The knife type corresponds to the type of the related data grid of the lean library server. Set the relay server name list. 26 2b (263b) Tables of the library. The relay server 5U and 5ib access the connection; the relay server, the name list 2 and the server 51a access the database table of the response at the RDB level. Noon ▲ Construction Service Therefore, security management is performed in units of PCs. Security management is performed in units of relay servers: the ratio of objectives and objectives can only reduce the workload for security. Therefore, it is possible to greatly reduce each of the relay feeders 51, 51 "〇5lb, and the connection permission list 261 does not have 1 C: \ 2D-C0DE \ 90-02 \ 89124554.ptd page 39 479172 5. Description of the invention (36) When a registered PG has a connection request, the connection request is rejected. Fig. 16 is a schematic diagram showing the configuration of the relay function 5 11 included in the relay server 51 shown in Fig. 12. In Fig. 16, the relay function 5 11 The communication request monitor program including the connection request from the monitoring PC 5 4 1 and the relay function relay programs 542a to 54 2η, which are started under the control of the communication request monitor program 541 and make a connection request at startup The signals between the PC and the database of the connection destination are relayed. These relay function relay programs 542a to 5 4 2 η can be started at the same time (the same as the operation logic program can be started at the same time).

通信要求監視程式5 4 1在P C提出連接要求時,將該連接 要求包含的PC名與連接許可列表261包含的pc名進行比 較’連接許可列表2 6 1中登記提出連接要求的p c時,發佈 允許連接(〇 k )的資訊。發出該〇 k資訊後,通信要求監視 程式541啟動一個中繼功能中繼程式542 i ( i = a〜η ),其 後的通信由啟動的中繼功能中繼程式542 i執行。通信要求 監視程式5 4 1又監視其他pc的連接要求。因此建立此通信 要求監視程式541和中繼功能中繼程式542a 〜542n的連& 時’進行與前面圖9所示提出連接要求時進行的操作 ㈣作。但是,中繼功能中繼程式542a〜542n僅;Communication request monitoring program 5 4 1 When a PC requests a connection, the PC name included in the connection request is compared with the PC name included in the connection permission list 261. 'Public connection request list 2 6 1 is issued when a PC requesting a connection is registered. Information about allowed connections (〇k). After sending out the 0 k message, the communication request monitoring program 541 starts a relay function relay program 542 i (i = a ~ η), and subsequent communication is executed by the started relay function relay program 542 i. Communication requirements The monitor program 5 4 1 monitors the connection requirements of other PCs. Therefore, the establishment of this communication request monitoring program 541 and the relay function relay programs 542a to 542n & 'performs an operation performed when a connection request is made as shown in FIG. 9 above. However, the relay function relay program 542a ~ 542n only;

貧料庫伺服恭之間的通信,這點與上文所述不同。因此, 中繼功能511中,同時執行與正在中繼的pc的數量相同的 中繼功能中繼程式和通信要求監視程式。 通信要求監視程式541在中繼伺服器51開始運轉時啟 動,經常運作,監視PC提出的連接要求。通信要求監視程The communication between lean magazine servos is different from the above. Therefore, in the relay function 511, the same number of relay function relay programs and communication request monitoring programs as the number of pcs being relayed are simultaneously executed. The communication request monitoring program 541 is started when the relay server 51 starts to operate, and often operates to monitor the connection request made by the PC. Communication requirements monitoring process

479172 五、發明說明(37) 式5 4 1在P C提出連接要求時,將提出連接要求的p c名記錄 到存取記錄2 5 1中,將表示存取記錄的記錄位置的指標交 給新啟動的中繼功能中繼程式542 i。其後,中繼功能中繼 程式5 4 2 1在連接此PC時,將與資料庫伺服器的連接狀況記 錄到存取記錄251中。 下面,參照圖17和圖ι8(Α)〜(〇簡單說明本發明實施形 態4的中繼伺服器的運作。 ; 圖17中,在連接要求的步驟251從pcii將連接要求發給 -中繼伺服器5 1。中繼伺服器5 1如圖1 8 ( A )所示,在通信 要求監視程式54 1的控制下,如果接收此PC丨丨的連接要 求,則啟動中繼程式5 4 2。所啟動的中繼功能中繼程式5 4 2 接收P C11提出的連接要求,並發送到資料庫飼服器2 2。資 料庫飼服器2 2利用與前面實施形態}中所說明相同的操 作’判斷是否可受理此中繼功能中繼程式5 4 2提出的連接 要求,在登記中繼伺服器5 1的I D時,送回接受連接用的瞭 解資訊(ok )。中繼功能中繼程式542將此資料伺服器22 送回的〇 k為訊送回到p c 11。利用如此的處理,建立p ◦ 11、 中繼飼服器5 1和資料庫伺服器2 2之間的通信連接。通信要 求監視程式541啟動此中繼功能中繼程式542後,將其後的 處理全部交給該中繼功能中繼程式542,僅監視其他pc的 _ 連接要求。 PCI 1執行檢索請求步驟252。即,PC1丨通過中繼伺服器 51從資料庫伺服器獲得〇k資訊時,與前面的實施形態1相 同,按照資料庫伺服器2 2所含已啟動的操作邏輯程式479172 V. Description of the invention (37) Formula 5 4 1 When the PC makes a connection request, the PC name of the connection request is recorded in the access record 2 51, and the index indicating the record position of the access record is given to the new startup. Relay function relay program 542i. Thereafter, the relay function relay program 5 4 2 1 records the connection status with the database server to the access record 251 when the PC is connected. Next, the operation of the relay server according to the fourth embodiment of the present invention will be briefly described with reference to FIG. 17 and FIGS. 8 (A) to (0). In FIG. 17, in step 251 of the connection request, a connection request is sent from the pcii to the-relay. Server 5 1. The relay server 5 1 is shown in FIG. 1 8 (A). Under the control of the communication request monitoring program 54 1, if it receives the connection request from this PC, the relay program 5 4 2 is started. The activated relay function relay program 5 4 2 receives the connection request from P C11 and sends it to the database feeder 2 2. The database feeder 2 2 uses the same as described in the previous embodiment} Operation 'Judge whether the connection request made by this relay function relay program 5 4 2 can be accepted. When the ID of the relay server 51 is registered, it returns the information (ok) for accepting the connection. The relay function relay Program 542 sends 0k returned by this data server 22 to PC 11. With this processing, a communication connection between p ◦ 11, relay feeder 51, and database server 22 is established. The communication request monitor program 541 activates this relay function after the relay program 542, The relay function is completely handed to the relay function relay program 542, and only monitors the connection request of other PCs. PCI 1 executes the search request step 252. That is, when PC1 receives the information from the database server through the relay server 51 , Same as the previous embodiment 1, according to the operation logic program started in the database server 2 2

五、發明說明(38) (2 1 7 )發來的連接要求,二 " 關聯資料庫,並發出必要的主冊到資料庫伺服器2 2包含的 叫)。如圖1 8 ( B )所示,、索條件(SQL語句或邏輯呼 2 5 2中發出的檢索條件按其中繼伺服器5 1對檢索請求步驟 伺服器2 2。其後,通過* 中、㈣原樣^進行中繼,並傳給資料庫 資料庫伺服器22之間的通,功能中繼程式542執行PCI 1與 條件進行檢索後,通過^ ^ °在資料庫伺服器22按照檢索 PC11。重復進行上述處理、、1飼服器51將該檢索結果送回到 的一系列處理完畢。 直到晝面程式所記述晝面功能Fifth, the description of the invention (38) (2 1 7) The connection request sent from the second "associate the database, and send the necessary master book to the database server 2 2 called). As shown in Figure 18 (B), the search conditions (SQL statements or logical calls 2 5 2) are issued according to the relay server 51 1 to the search request step server 2 2. Then, by * middle,中继 It relays as it is, and passes it to the database database server 22. After the function relay program 542 executes PCI 1 and the conditions are retrieved, it searches PC11 on the database server 22 according to ^^ °. The above-mentioned process is repeated, and a series of processes in which the feeder 51 returns the search result is completed. Until the day-surface function described in the day-surface program

圖17所示檢索請求步驟2 一 έ士 資料庫伺服器22的連接的、、'束,PC11就執行切斷對 面的實施形態丨相同接:圖= 過中繼伺服器51對資料庫\ 所不,百先,攸PCU通 pm狄山拉“ /十庫切服裔22發佈表示要求切斷的 广士。、、者,在瞭解資料庫伺服器22發來的切斷要求 的同日:通過中Μ伺服器5 i將進行關閉回應資料庫處理的 瞭解資訊(ok資訊)送回到pcn。“匕,切斷資料庫伺服 裔22與PCI 1之間的連接路由,也切斷%〗丨與中繼伺服器51 之間的連接。中繼功能中繼程式5 4 2變成等待通信要求監 視程式541來的下次啟動的狀態。The search request step 2 shown in FIG. 17 is the embodiment in which the database server 22 is connected, and the connection is executed by the PC11. The same connection is performed: Figure = The database is accessed by the relay server 51 No, Baixian, You PCU through pm Dishanla "/ Shikuqie service 22 issued the Guangshi who expressed the request to cut off. ,,,,, On the same day that I understood the cutoff request from the database server 22: Passed The server 5i will send back the knowledge information (ok information) that was processed by the response database to the PCN. "Dagger, cut off the connection route between the database server 22 and PCI 1, and also cut off%〗 丨 丨Connection to the relay server 51. The relay function relay program 5 4 2 is in a state of waiting for the next start of the communication request monitor program 541.

中繼飼服Is 5 1内,作為中繼功能5丨1,設置多個中繼功 能中繼程式542 ’可同時執行這些中繼功能中繼程式542a 〜54 2η ’從而在利用一個中繼伺服器51管理多個pC的通信 時’也能執行並行處理,實現進行高速資料庫操作的系 統0In relay feeding service Is 51, multiple relay function relay programs 542 are provided as relay function 5 丨 1. These relay function relay programs 542a to 54 2η can be executed at the same time to use a relay server. When the server 51 manages the communication of multiple PCs, it can also perform parallel processing to implement a system for high-speed database operations.

C:\2D-C0DE\90-02\89124554.ptd 第42頁 479172C: \ 2D-C0DE \ 90-02 \ 89124554.ptd Page 42 479172

五、發明說明(40) D B伺月艮器/中繼伺月p哭只1 21 1 ^DB ^ m HV t Μ 1 'σ 1 ^ # ^ 資料庫212。這峨伺服^Λ2 f有中繼功能521和關聯 服哭且右、畜拉亞一七^、服的/中龜伺服器51和52,作為^伺 叫:資5二1監視程式和操作邏輯程式,可用邏輯呼 LAN41 ^ 41 9 % ,並可利用中繼功能51 1和521使專用 σ时配置的Pc 11和1 2連接到其他現場。 二Π /斜中甘繼伺服器51的中繼功能511管理專用LAN411 、/、他現場的連接,DB伺服器/中繼伺服器5 2 =繼功能521管理專用議12所連接ρπ2對其他現場的 與刖面的貝施形態4相同,中繼伺專 LAN413所連接PC13對其他現場的連接。 里專用 立日ίΛ?,器細飼月艮器/中繼,服器之間進行通過現 杓昍〜由口 # 3之間的廣域網41的連接選路。例如,.在 β Β飼服裔/中繼祠月g哭ς 1 士幽抑 接要求時的應答。即對:中二服 :保二^^ 器/中繼飼服器52和中繼飼服器53規定 確保女全性的路由。 服中繼飼服器52規定確保安全性的路由, ° °°中繼伺服器5 1和中繼伺服器5 3可連接。DB伺V. Description of the invention (40) DB server / relay server P1 only 1 21 1 ^ DB ^ m HV t Μ 1 'σ 1 ^ # ^ Database 212. This e-servo ^ Λ2 f has relay function 521 and the associated server is crying, right, the animal is one ^^, and the server of the server / middle tortoise 51 and 52, as ^ server: 521 monitor program and operation logic The program can use the logic call LAN41 ^ 41 9%, and can use the relay function 51 1 and 521 to connect Pc 11 and 12 configured in the special σ to other sites. Ⅱ / The relay function of the sloping center Ganji server 51 manages the dedicated LAN411 and / or the connection of other sites, the DB server / relay server 5 2 = the relay function 521 manages the dedicated protocol 12 connected to ρπ2 to other sites It is the same as Bess Form 4 of the noodles, and the PC 13 connected to the relay server LAN 413 is connected to other sites. It is dedicated to the Ri-Li, which feeds the moon / generators / relays, and routes between the servers through the connection of the wide area network 41 between port # 3. For example, the response at the time of β Βfeeding / relay ancestral g crying 1 stunned to answer the request. That is to say: the second service: Baoer ^^ device / relay feeder 52 and relay feeder 53 stipulate a route to ensure women's comprehensive sex. The relay feeder 52 provides a route to ensure security, and the relay server 51 and the relay server 5 3 can be connected. DB server

服器/中繼伺服哭R ]从士德4ς,,— 疋牧 J 时51的中龜功此511官理專用LAN4U所連接 1的連接。即,DB伺服器/中繼伺服器51中,在連接許 I列表内保持批准專用LAN411提出的連接用的連接許可列 、^隹見~ # 2和# 3提出的連接用的中繼飼服器5 3和Server / Relay Servo Cry R] From Shide 4 ,, — 疋 牧 J J 51 Nakame Gong This 511 official management LAN4U connection 1 connection. In other words, in the DB server / relay server 51, the connection permission list approved by the dedicated LAN411 for connection, and the relay feed for connection proposed by # 2 and # 3 are maintained in the connection permission list. Device 5 3 and

第44頁 C:\2D-CODE\90-02\89124554.ptd 479172 五、發明說明(41) DB伺服器/中繼伺服器5 2的丨D。 因此,例如現場#3的PC13經中繼祠服器53 接用的路由器23 3、231和232的選路,從而建二J = 和現場# 2的DB伺服器/中繼伺服器51和52的連接, =單續聯資料庫(RDB)211和212的 丁對 索/更新/刪除/插入)。 V Μ 現場中設置的PC11連接該現場#1内設置的⑽伺服哭 /中繼伺服器51,可進入關聯資料庫211予以存取,進行次 料操作。DB伺服器/中繼伺服器51還作為中繼伺服哭運貝 作。利用其中繼功能511,?(:11可通過中繼功能51厂、廣域 LAN421、路由器231、廣域網41、路由器23 2和廣域 L A N 4 2 2、’進入現場# 2包含的D B伺服器/中繼伺服器$ 2進行 _ 存取,並能執行對現場# 2中關聯資料庫21 2的資料操作。 一同樣,現場# 2包含的PC1 2也能進入現場# j包含的關聯 資料庫2 11予以存取。因此,通過分別在現場# }、# 2和 #3設置中繼中繼功能5U、521、531,各現場所包含的pc 可進入所希望的資料庫予以存取。以中繼伺服器資料庫伺 服器(DB伺服器)為單位規定路由,不需要以pc為單位規定 路由’因而即使廣域連接中pc的數量大量增加,也能容易 維持安全性,確保安全性的選路作業沒有任何麻煩。 圖2 0為顯示圖1 9所示DB伺服器/中繼伺服器5 1的結構的 概略圖。圖2 0中,DB伺服器(資料庫伺服器)/中繼伺服器 51包含監視對專用LAN511和廣域LAN421的通信要求的通信 要求監視程式5 1 a、在通信要求監視程式5 1 a控制下啟動並Page 44 C: \ 2D-CODE \ 90-02 \ 89124554.ptd 479172 V. Description of the invention (41) DB server / relay server 5 2D. Therefore, for example, PC13 on site # 3 is routed via routers 23 3, 231, and 232 connected to relay server 53 to build J = and DB server / relay server 51 and 52 on site # 2. Connection, = single continuation database (RDB) 211 and 212 for Ding / Update / Delete / Insert). The PC11 set in the V Μ site is connected to the ⑽serving cry / relay server 51 set in the site # 1, and can enter the associated database 211 for access and perform secondary data operations. The DB server / relay server 51 also functions as a relay server. Using its relay function 511? (: 11 can be done through the relay function 51 factory, wide area LAN421, router 231, wide area network 41, router 23 2 and wide area LAN 4 2 2, 'entry site # 2 included DB server / relay server $ 2 _ Access, and can perform data operations on the associated database 21 2 in the scene # 2. Similarly, the PC1 2 included in the scene # 2 can also access the associated database 2 11 in the scene # j to access. Therefore, By setting up relay relay functions 5U, 521, and 531 at the site #}, # 2 and # 3 respectively, pcs included in each site can enter the desired database for access. The relay server database server (DB server) specifies the route for each unit, and it is not necessary to specify the route in units of pc '. Therefore, even if the number of pcs in a wide-area connection increases significantly, security can be easily maintained, and routing work to ensure security is not troublesome. 20 is a schematic diagram showing the structure of the DB server / relay server 51 shown in FIG. 19. In FIG. 20, the DB server (database server) / relay server 51 includes a monitoring pair dedicated LAN 511. Communication request monitor program for communication request with wide area LAN421 5 1 a. Start under communication control monitoring program 5 1 a and

C:\2D-CODE\90-02\89124554.ptd 第45頁 479172 五、發明說明(42) 繼的中繼功能中繼程式51b,以及在通信要 求孤視私式51a控制下啟動並進行對關聯資料 2 1 1的資料操作用的操作邏輯程式5〗◦。 中繼功能中繼程式51b具有與前面實施形態4的中繼功能 中繼程式相同的功能,中繼對專用LAN4n所連接的% 信。操作邏輯程式51c與實施形態j的操作邏輯程式相同, 啟動時啟動操作邏輯,進入關聯資料庫 執行指定的資料操作。 卞以存取,並 DB伺服器/中繼伺服器5〗還包含本現場連接許可 51d、其他現場連接許可列表51e和關聯資料 許可列表51f。本現場連接許可列表51d上μ ,亚存儲識別能㈣其他現場資料冑或本現場關聯資料庫 2"U/Z見的/接訊。其他現場連接許可列表51e存儲識別允許 仗〃、他現%接入到資料庫伺服器的中繼伺服器的資訊。 RDB連接許可列表51 f %存放識別能存取關冑資料庫 中繼伺服器的資訊。 旱Z 1 i的 、通信要求監視程式51a在收到通信要求時,參 連接許可列表5 1 d和其他現場連接許可列表5 i e 二理該通信要求。在提出該通信要求時,通信要 式51a參照提出該要求時PC發佈的蟑名,判決pc提出皿的連 接要求目ί方是本現場關聯資料庫211還是其他現場的資 ,庫伺服益’並啟動中繼功能中繼程式51b或輯程 式51c。操作邏輯程式51c在啟動時,參照_連U = 表51 f ’與要求連接的中繼飼服器或pc (本現場内)進行 第46頁 C:\2D-CODE\90-02\89124554.ptd 479172C: \ 2D-CODE \ 90-02 \ 89124554.ptd Page 45 479172 V. Description of the invention (42) Relay function relay program 51b, as well as start and perform control under the control of communication request ignoring 51a Operation logic program 5 for data operation of related data 2 1 1. The relay function relay program 51b has the same function as the relay function relay program of the fourth embodiment described above, and relays% messages connected to the dedicated LAN 4n. The operation logic program 51c is the same as the operation logic program of the embodiment j. When the operation logic program 51c is started, the operation logic is activated to enter the associated database to perform a specified data operation. In order to access it, the DB server / relay server 5 also contains the on-site connection permission 51d, other on-site connection permission list 51e, and related information permission list 51f. On the site connection permission list 51d, the sub-storage can identify other site data or the site related database 2 " U / Z see / receive. The other on-site connection permission list 51e stores information identifying a relay server that is allowed to access the database server. The RDB connection permission list 51 f% stores information identifying relay servers that can access the related database. When the communication request monitoring program 51a of Z 1 i receives the communication request, it refers to the connection permission list 5 1 d and other on-site connection permission lists 5 i e to handle the communication request. When the communication request is made, the communication requirement 51a refers to the name of the cockroach issued by the PC when the request is made, and determines whether the PC proposes the connection request of the server whether it is the on-site related database 211 or other on-site resources. The relay function relay program 51b or program 51c is activated. When the operation logic program 51c is started, refer to _Link U = Table 51 f 'to perform the connection with the relay feeder or PC (in this site) that is required to be connected. Page 46 C: \ 2D-CODE \ 90-02 \ 89124554. ptd 479172

通信。在該通信中,操作邏輯程式5丨c也可啟動令繼功叫 中繼程式5 1 b,利用中繼功能與對方通信。 此 通信要求監視程式51a經常監視專用LAN41 1和廣域用 LAN42 1上的通信要求。可分別對中繼功能和操作邏輯程 各自设置通信要求監視程式5 1 a。還可在RDB連接許可、 5 1 f内登記本現場的PC用戶名。 1表 功能 如上所述,根據本發明實施形態5在各現場内設置中繼 因而可容易進入需要的資料庫伺服器予以存取,'减 行資料操作。又設置中繼功能,從而能以中繼伺服器^Communication. In this communication, the operation logic program 5 丨 c can also start to make the relay call 5 1 b, and use the relay function to communicate with the other party. This communication request monitoring program 51a constantly monitors communication requirements on the dedicated LAN 41 1 and the wide area LAN 42 1. The relay function and operation logic can be individually set for communication request monitoring program 5 1 a. It is also possible to register the PC user name of this site in RDB connection permission, 5 1 f. Table 1 Function As described above, according to the fifth embodiment of the present invention, relays are installed in each site, so that it can be easily accessed by the required database server for access, and data operations are reduced. It also sets up a relay function so that it can use a relay server ^

位進行現場間的連接選路,減少確保安全性所需選路的耳 作負荷和人員數量。 ' 9 = (實施形態6 )Position routing between sites to reduce the workload and personnel required for routing required to ensure safety. '9 = (Embodiment 6)

圖21為顯示本發明實施形態6的通信系統的結構的概略 圖。圖2 1中,分別在現場# 2〜# 4配置資料庫伺服器 伺服裔)2 2〜2 4。在現場# 1配置具有資料庫操作功能的 PC11〜13、全部用戶使用的PC14、系統管理者使用的% 、 PC15,以及對這些PC11〜15共同設置的中繼伺服器51。^ 前面的實施形態4相同,中繼伺服器51包含中繼功能’ 傳迗檔案用的檔案傳送功能512、存放Web資訊的Web結 檔案5 6 0,以及管理PC11〜14中軟體(S/W )的版太用沾 本管理功能550。 + π的 現場# 2〜# 4和現場# 1以中繼伺服器為單位規定保μ 其安全性的路由。中繼功能511和版本管理功能55〇可' 運作。在圖21所示的結構中’由現場#1的中繼伺服器5ιFig. 21 is a schematic diagram showing a configuration of a communication system according to a sixth embodiment of the present invention. In Figure 21, the database server is configured at the scenes # 2 to # 4 respectively) 2 2 to 2 4. At the scene # 1, PCs 11 to 13 having a database operation function, PCs 14 used by all users,% and PC 15 used by a system administrator, and a relay server 51 commonly provided for these PCs 11 to 15 are arranged. ^ Same as in the previous embodiment 4, the relay server 51 includes a relay function, a file transfer function 512 for transmitting files, a web file 5600 for storing Web information, and software (S / W for managing PC11 to 14). ) 'S version uses the management function 550 too. + π Site # 2 to # 4 and Site # 1 specify the route that guarantees μ's security in units of relay servers. The relay function 511 and the version management function 55 can be operated. In the structure shown in FIG. 21 ', the relay server 5 of the scene # 1

479172 五、發明說明(44) 實現自動下載功能。即…㈣服器51所設置―: 理功能55 0管理導入Pcn〜15的程式的 置的《版本管 管理者使用的PC15將最新版本的程式上本攸系統 5 5 0内的檔案後,將此最新版本程式下/到到全版本官理功能 的PC14。對PC14下载最新版本程式的時刻為pCH 使士用 自動下載功能表畫面啟動的時刻。由pc上的蚪使 :J載:版本管理功能55〇,從而執〜二取载中繼 時,PCU〜13中 行該晝面程式的最新版本下載。這 打,PC11〜13中,也可在pc啟動時或自動 = 啟動時,將系統管理者用的PC15 =,旦面 下載。 1寻的取新版本軟體加以 系統管理者用PC15所上傳的程式除應 圖1所示的通信功能丨14。PC11〜14 二二夕卜$可為 下載物件。 斤-置的红式全部都是 通過設置上述自動下載功能,在現場 使用全部相同版本的軟體, 了广 貧料庫,能維持資料的一致性,;存取 操作環境。 、了罪性问的賢料庫 运可分別對現場# 2〜現場# 4各 伺服器22〜24導入白叙丁普上处 直的貝枓庫(DB ) 晝面程式的版本更新,將根據資料庫操作用的 版本的操作邏輯mi :式更改為符合最新 抓 科f式。下面,參照圖2 2所示白叙丁蕾丰 驟’說明自動下載操作。 α戶厅不自動下載步 1版本e理功旎55。設置存放最新原始碼(最新版本的 1 第48頁 C:\2D-C0DE\90-02\89l24554.ptd 479172 五、發明說明(45) 程式)用的最新原始碼檔案551和 管理檔案5 5 2。 吕里孝人脰版本用的版本 首先,系統管理者將最新版本^ ^ ^ ^ ^ ^ ^ ^ ^ ^ (步驟S71 )。接著〆w田+土的叙脰555導入到pC15 553 ^5:3 , ^ ^ ^ 版本與中繼伺服器51所π w ^ ^置的最新版本軟體555的 ^ - .51 „ ^ # ^ ^ " 11 時,版本管理功能55。根據馬上;:;5t^^ 办叱丄μ 低佩上我工具5 5 3的比較要求,讀φ 與版本管理檔案552對應的版本資訊,或者比=出 較結果提供給Ρ(:15。上裝工具如在版^ 宰 本吕理功月匕5 5 0改寫原始碼5 5 1。 版本管理功能550將最新原始碼檔案551 ,所傳送的最新版本軟體555。在上裝此最二文本寫軟為體 τ啟動圖21所不的檔案傳送功能512,以檔案的形式從 PC15,,最新版本軟體555,進行最新原始碼播案551的改 罵二廷柃,在版本管理檔案552更新對應的軟體版本資訊 /驟373 )。上裝工具553對版本管理檔案552記錄此更 新的曰期。利用版本管理檔案552,經常管理現場# 1中能 利用的軟體的最新版本。因此,經常在中 最新原始碼551保管處料該最新版本的軟體。^上勺 用戶為了在PC14進行業務,通常啟動功能表晝面554, 以便啟動應用程式(步驟S74 )。這時,進行應用程式軟 體最新版本的確認(步驟S75 )。即,在步驟S74啟動功能479172 V. Description of the invention (44) Realize automatic download function. That is, the server 51 is set to:-management function 55 0 manages the settings of the programs imported from Pcn ~ 15 "PC15 used by the version management manager will upload the latest version of the program to the file in this system 5 50" This latest version of the program downloads to the full version of the official PC14 function. The time to download the latest version of the program to PC14 is the time when the pCH ambassador's automatic download menu screen is activated. Instructed by the PC: J load: version management function 55, so when executing the second load relay, PCU ~ 13 will download the latest version of the day and night program. In this case, in PC11 ~ 13, you can also download PC15 = used by the system administrator at the time of pc startup or automatic = startup. Take a new version of the software and add it to the system manager's PC15 to remove the communication functions shown in Figure 1-14. PC11 ~ 14 Er Er Xi Bu $ can be downloaded. The red type of Jin-Zhi is all set by the automatic download function mentioned above, using all the same version of software on the site, which can save the material library, maintain the consistency of the data, and access the operating environment. Sin materials warehouses that have sinful questions can be imported to the scene # 2 ~ scene # 4 each server 22 ~ 24 into the Bai Sudingpu's upright Behring Library (DB) day and night program version update, will be based on The operation logic mi: style of the version for database operation has been changed to conform to the latest f style. Next, the automatic downloading operation will be described with reference to the step "Bai Xu Ding Lei Feng" shown in FIG. Alpha households do not automatically download step 1 e-learning function 55. Set to store the latest source code file 551 and management file for the latest source code (latest version 1 page 48 C: \ 2D-C0DE \ 90-02 \ 89l24554.ptd 479172 5. Invention Description (45) program) 5 5 2 . The version used for the Lü Xiaoxiaoren version First, the system administrator updates the latest version ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ (step S71). Then 田田 + 土 的 脰 脰 555 was imported into pC15 553 ^ 5: 3, ^ ^ ^ version and the latest version of software 555 installed by the relay server 51 ^-.51 ^ ^ # ^ ^ " 11 hours, version management function 55. According to the immediate;:; 5t ^^ Do 叱 丄 μ Low comparison requirements of my tool 5 5 3, read the version information corresponding to φ and version management file 552, or ratio = out The comparison result is provided to P (: 15. Uploading tools such as in-line version ^ Zaiben Rigong Yuejian 5 5 0 rewrite the original code 5 5 1. The version management function 550 will upload the latest source code file 551 to the latest version of the software 555. On the top, you can start the file transfer function 512 not shown in Figure 21 by uploading this second-most text writing software to the file from PC15, the latest version of software 555, and rewrite the latest source code broadcast case 551. The corresponding software version information is updated in the version management file 552 / step 373). The upload tool 553 records the date of this update to the version management file 552. With the version management file 552, the latest software that can be used on site # 1 is often managed. Version. Therefore, it is often expected that New version of the software. ^ In order to conduct business on PC14, the user usually activates the menu day 554 to start the application (step S74). At this time, the latest version of the application software is confirmed (step S75). That is, in Step S74 start function

V.WV.W

I 第49頁 C:\2D-C0DE\90-02\89124554.ptd 479172 五、發明說明(46) ^畫面554時,PC14通過中繼伺服器51上的版本管理功能 550^取版本管理標案552。這時,可對功能表書面5 54上 :王:應用J體進行版本比較,也可在指定一個應用軟體 可,進灯所拓定應用軟體的版本比較。對版本管理檔荦 552所存放應用軟體的版本和ρπ4上所裝應用軟體556的版 本進仃比杈。此比較可在版本管理功能5 5〇執行,也可在 PC14上進行。在版本管理功能55〇上進行比較,則在減輕 PC軟體負荷方面較佳。PC14上的應用軟體556版本舊時, PC14對版本管理功能55〇發佈下載要求。此下载要求的發 佈利用功能表畫面5 54顯示的下載工具,執行最新版本軟 體下載、(步驟S76)。進行此下載時,還利用圖21所示的 檔案傳送功能5 1 2,在版本管理功能5 5 〇管理下,將發送的 原,碼551下載到PC14。如此下載後,用戶可在pci4上利 用最新版本的應用軟體,啟動應用軟體(步驟S77 )。 在其他PCI 1〜13上,也同樣執行該最新版本軟體的下 載。因此,現場# 1中,可用pC丨丨〜丨4中的任何一個啟動 最新版本應用軟體,能按照相同版本的應用軟體執行處 理,保持資料的一貫性。系統管理者僅在中繼伺服器5丨上 進行最新版本軟體的上裝,不需要在現場# 1内全部pc上 裝設最新版本軟體,可方便地將全部pc應用軟體版本統一 為最新版本。 作為應用軟體,由晝面程式1 1 1實現通信功能i 1 4 (參閱 圖1 )的軟體和0S都成為下載物件。因此,在pci 1〜η 中,可利用最新版本的應用軟體進入資料庫系統予以存I Page 49 C: \ 2D-C0DE \ 90-02 \ 89124554.ptd 479172 V. Description of the invention (46) ^ When the screen is 554, PC14 obtains the version management project through the version management function 550 on the relay server 51 ^ 552. At this time, you can write on the function table 5 54: Wang: Application J body for version comparison, or you can specify an application software. You can compare the version of the application software. Compare the version of the application software stored in the version management file 荦 552 with the version of the application software 556 installed on ρπ4. This comparison can be performed on the version management function 550 or on the PC14. Compared with the version management function 55, it is better in reducing the PC software load. When the version of the application software 556 on PC14 is old, PC14 issues a download request for version management function 55. The download request is issued using the download tool displayed on menu screen 5 54 to download the latest software version (step S76). When performing this download, the file transmission function 5 1 2 shown in FIG. 21 is also used to download the original code 551 sent to the PC 14 under the management of the version management function 5 50. After downloading in this way, the user can use the latest version of the application software on pci4 to start the application software (step S77). The download of the latest software is also performed on other PCIs 1 to 13. Therefore, in site # 1, you can use any of pC 丨 丨 ~ 丨 4 to launch the latest version of the application software, which can perform processing according to the same version of the application software and maintain the consistency of the data. The system administrator only uploads the latest version of software on the relay server 5 丨, and does not need to install the latest version of software on all pcs on site # 1, which can easily unify all pc application software versions to the latest version. As application software, both the software that implements the communication function i 1 4 (see FIG. 1) by the day-and-day program 1 1 1 (see FIG. 1) and the OS become download objects. Therefore, in pci 1 ~ η, the latest version of application software can be used to enter the database system for storage.

C:\2D-C0DE\90-02\89124554.ptd 第50頁 479172 五、發明說明(47) ---一^ 取,並進行資料操作。 也分別在現場# 2〜# 4的資料庫伺服器(DB伺服器)22 〜34設置下栽功能,因而這些現場的應用程式所對應的操 作邏輯程式也能容易更改為最新版本。在現場# 2〜# 4内 配置PC時,也能方便地利用一個現場内資料庫伺服器/中 繼祠服器51所設置的版本管理功能5 5 0,執行這些%的應 用軟體版本更新。 一 ^ 如上所述,根據本發明實施形態6,由於在中繼伺服哭 和/或資料庫伺服器上設置版本管理功能,pc中,在全^ 應,軟體啟動時,可下載最新版本的應用軟體。因此王,°系 ΐ! ΐ 2 ί易地將所有PC的應用軟體更新為最新版本? 並且王4PC中能使用同一版本的應用軟體。 (實施形態7 ) 圖23為顯示本發明實施形g7的通信 示的結構中,現場#1上配置的中== 中,设有分批作業執行功能591、分批作 二C: \ 2D-C0DE \ 90-02 \ 89124554.ptd Page 50 479172 V. Description of the invention (47) --- ^ Take and perform data operations. The download function is also set in the database server (DB server) 22 to 34 in the field # 2 to # 4 respectively, so the operation logic programs corresponding to these field applications can be easily changed to the latest version. When a PC is configured in the field # 2 to # 4, the version management function 5 50 provided by a database server / intermediate server 51 in the field can also be conveniently used to perform these% application software version updates. As described above, according to Embodiment 6 of the present invention, since the version management function is set on the relay server and / or the database server, the latest version of the application can be downloaded on the PC during full application and software startup. software. So Wang, 系! Ϊ́ 2 易 Easily update all PC application software to the latest version? And Wang 4PC can use the same version of application software. (Embodiment 7) FIG. 23 is a diagram showing a structure of communication shown in Embodiment g7 of the present invention. In the field # 1, the medium == medium is provided, and a batch job execution function 591 and a batch job are provided.

Web結果檔案5 60。此結構與圖21所 力此592 功能是-種利用分批作業二期,作 每周2月等)執行的典型資料庫檢索曰 理,並登記到系統中,户品—# Α 吊才力寺中進仃的 結果的功能。對存取資:庫$二動執仃該處理並輸出 效的方法。貝#庫的例行卫作的自動化,此為. 分批作業官理功能5 9 2調度並管理a 的日期,按照預先指定的條件執行:/料庫檢乍索業,並在將^ 五、發明說明(48) 管理5 H到&可瀏覽的檔案(Web的主頁)。此分批作業 八此92管理分批作業的登記、更改和刪除。 ” 果二:二業Λ行功能591執行上述登記的分批作冑。Web妹 庫存取結果的平臺(主頁)。‘ 地從ρπΙ Γ 的1 ’通過指定主1地址’可方便 ^,fin〜14進仃瀏覽。這些PCI 1〜14能下載Web結果_ w:果;;56Γ用頻度高祕 覽所需檢\^1而用戶卿〜14能方便且高速地劇 條的PC15對中繼祠服器51上傳資料庫操作 這此停:逸:ί 丁條件,並由分批作業管理功能592對 拍二條件仃官理。在分批作業管理功能592的控制下, 二,,度啟動分批作業執行功能591 =資料庫飼服器22〜24中的任一個予二 =進行操作’其操作結果輸出到㈣結果槽案5 ^ 存放。 。 料』Ό本果」田案_+5 6 0疋一種4當案,因此,從資料庫傳送的資 ^sv^; :品5二,為分批*業執行功能591的操作邏輯,不 疋、二璉耳,可用輸出為利用,,逗號歸納π的CSV形式資 料檔案的命令邏輯。分批作業執行功能591二 述表型資料變換為例如HTML形式的檔案,存放到Web =果 棺案560中(例如存在稱為SQL饲服器㈣助理器的軟體Web Results Archive 5 60. This structure and the 592 function shown in Figure 21 are a typical database search using a batch of jobs in two phases, such as February every week, etc., and registered in the system, household product — # Α 才力The function of the result of entering the temple. For access to funds: The library $ 2 action implements the method that processes and outputs the effect. The automation of the routine work of the Beiku library, this is. Batch job management function 5 9 2 Schedule and manage the date of a, execute in accordance with the pre-specified conditions: 、 Explanation (48) Manage 5H to & browseable files (Web homepage). This batch job Eighty 92 manages the registration, modification and deletion of batch jobs. "Result two: The second industry Λ line function 591 performs the batch operation of the above registration. The platform (homepage) for Web girl inventory fetching results. 'Ground Slave ρπΙ Γ 1' By specifying the main 1 address', it is convenient ^, fin ~ 14 to browse. These PCI 1 ~ 14 can download Web results_ w: fruit; 56Γ used frequently to check the necessary inspection \ ^ 1 and user Qing ~ 14 can easily and quickly play the PC15 to the relay temple The server 51 uploads the database operation and stops here: Yi: ί Ding conditions, and the batch job management function 592 to take two official conditions. Under the control of the batch job management function 592, Batch job execution function 591 = any one of the database feeders 22 to 24 = perform an operation 'its operation result is output to the ㈣ result tank case 5 ^ storage. 』Ό 本 果》 田 案 _ + 5 6 0 疋 A kind of 4 cases, therefore, the data transferred from the database ^ sv ^;: Product 52, which is the operation logic of the batch * industry to perform the function 591, not 疋, Er Er, the available output is used, comma Induction of the command logic of a CSV-format data file. Batch job execution function 591 Second, the phenotypic data is transformed into files in the form of HTML, for example, and stored in Web = Fruit Case 560 (for example, there is software called SQL Feeder ㈣ Assistant).

五、發明說明(49) 分::業圖24所示流程圖,說明本發明實施形態7的 的: :ρπ 5中’編制成檢索(或操作)資料庫 办忭仵作為檢索條件檔案5 6 3。 :厚 合取決於中繼伺’條件祂案5 6 3的疋義内 需要的參數形式進';51 土存在的操作程式562的邏輯,用 輯。例如,此二Ϊ = 便執行該操作程式562的邏 物件的資料的類型、要於“二疋/的,數有稱為檢索 等。用前面的實 裝工呈553形恶6中§兄明的自動下載功能所用的上 ’在中繼伺服器51上 上 編制的檢索條件檔荦56m屑B理者用PC15上 驟S82執行如下。昔春^進订上傳杈索條件檔案563的步 S81 ),禮句八 ,,存取分批作業管理功能5 92 (步驟 決是否已定:?作作業章登記狀f。:用確認登記狀況,判 斷為新編制新的分批作業時,判 著,檢索條件標案5心 官理功能592用;^ At & 各、5 5 3,對分批作業 _ 此,在分批作查 运功能傳运檢索條件槽案⑽。由 條件(步驟S82Λ理功能592以槽案形式存放並管理檢索 作業執行時㈣,則進行啟動―力)== 第53頁 C:\2D-C0DE\90-02\89124554.ptdV. Explanation of the invention (49) Points: The flow chart shown in FIG. 24 illustrates the seventh embodiment of the present invention:: ρπ 5 is compiled into a search (or operation) database office as a search condition file 5 6 3. : The concordance depends on the relay parameters 'conditional meaning of the case 5 6 3 required parameter form'; 51 the logic of the operation program 562 of the existence of the earth. For example, if this two Ϊ = then the type of data of the logical object that executes the operation program 562, it should be called "two 疋 / 's, and the number is called retrieval, etc .. Using the previous installer, it was 553. 6 The search condition file prepared on the relay server 51 used by the automatic download function (56m chips) is executed by the PC15 on step S82 as follows. Xichun ^ Enter step S81 of uploading the condition file 563) , Etiquette eight, access to batch job management function 5 92 (Is the step determined ?: Make the job chapter registration f .: When confirming the registration status, judging that a new batch job is newly prepared, judge, Retrieval condition standard case 5 mental function 592; At & 5, 5 3, for batch operations _ This is the case where the search and transportation function is transmitted in batches to retrieve the retrieval condition slot case. By the condition (step S82) Function 592 stores and manages the execution time of the search job in the form of a slot file, and then starts up-force) == page 53 C: \ 2D-C0DE \ 90-02 \ 89124554.ptd

式5 62 (步驟S85 )。 上述分批作業執行功能5 9 i中, ^ ^ ^ ^ ^ ^ 592的調度,提供個作堂沾批^ J用刀才作業&理功能 Μ二二v 業的執行時間資訊並由上述時鐘龄Equation 5 62 (step S85). In the above-mentioned batch job execution function 5 9 i, ^ ^ ^ ^ ^ ^ 592 schedules, providing a job as a team ^ J with a knife job & management function M 22 two v industry execution time information and the above clock age

視所k供的分批作業執行時間。 里I ,作,式562具有與晝面程式611相同的 存取邏輯進行定義。因此,此操作程式562進行V ,呼^動指定的資料庫伺服器⑽伺服器)22内丁的、 =邏輯耘式。操作程式562在啟動時通過中繼功能5丨】進又 貧料庫伺服器22的關聯資料庫211予以存取(步驟S86卜 此操作程式562在啟動時,參照分批作業管理功能592所登 記的^批作業檢索(操作)條件,進入f料庫伺服器^的 關聯貧料庫予以存#,執行資料操檢索/更新/插人/ 刪除)。 ,從資料庫伺服器22傳送的結果資訊,由檔案傳送功能以 檔案形式輸出到Web上,作為結果檔案5 6 〇。用戶通過指定 主頁地址,可瀏覽此Web結果檔案5 6 0 (步驟S87 )。此Web 結果檔案56 0,如上所述,也是ASCI {形式的逗號歸納型 (C S V )的樓案。希望劇覽結果樓案$ β 〇的用戶可在p [ 14或 PC 11〜1 3中的任一個上啟動瀏覽程式的瀏覽器5 64,存取 W e b結果棺案5 6 0,進行劉覽。這時,用戶利用劉覽器$ β $ _ 啟動表計算軟體56 5,下載Web結果檔案5 6 0,用表形式下 載檢索結果檔案(步驟S89 )。 利用表計异軟體5 6 5 ’是為了將A S C I I形式的逗號歸納型 (CSV )的檔案變換成能用SQL操作的表。Depending on the execution time of the batch job provided. Here I, operation, equation 562 has the same access logic as the day-surface program 611 for definition. Therefore, this operation program 562 performs V, and calls the designated database server (server) (22), which is logical logic. The operation program 562 is accessed through the relay function 5 at the time of startup into the associated database 211 of the poor storage server 22 (step S86). When the operation program 562 is started, it is registered with reference to the batch operation management function 592 Search (operation) conditions of the batch operation, enter the associated poor material library of the database server and save it, and perform data operation retrieval / update / insertion / deletion). The result information transmitted from the database server 22 is output to the Web as a file by the file transmission function as a result file 56. The user can browse this Web result file 560 by specifying the homepage address (step S87). This Web results archive 560, as mentioned above, is also a case of ASCI {comma inductive (CSV) form. Users who want to see the result of the show case $ β 〇 can launch the browser 5 64 of the browser on p [14 or any of PC 11 ~ 13, and access the Web result case 5 6 0 for Liu Lan . At this time, the user uses the Liu browser $ β $ _ to start the table calculation software 56 5, downloads the web result file 5 60, and downloads the search result file in a table format (step S89). The table calculation software 5 6 5 ′ is used to convert a comma-inductive (CSV) file in the form of A S C I I into a table that can be operated by SQL.

C:\2D-C0DE\90-02\89124554.ptd 第54頁 479172 五、發明說明(51) 因此,借助在此Web結果檔案5 6 〇存放頻繁利用的檢索結 果’用戶(P C操作者)不必通過網存取其他現場的資料伺 服态’能方便地取得所需要的資訊。 如上所述,根據本發明實施形態7,在中繼伺服器上, 使資料庫操作結果輸出到ψ e b現場的主頁,因而用戶能方 便地指定該主頁的地址,瀏覽Web結果檔案,可高速檢索 所需要的資訊。 圖2 5 (A )為顯示分批作業執行功能的結構的概略圖。用 軟體貫現分批作業執行功能5 9 i,在規定的時刻按指定的 周期啟動作業。該時刻由中繼伺服器5丨内的電腦時鐘監视 當前的時刻,對其進行計時。分批作業執行周期則由分抵 作業類型(作業I D )指定。 能調度分批作業管理功能5 92的作業有5種:在每天指定 的時刻執行的調度591a,在每周指定時刻執行的調度 591b,在每月指定的時刻執行的調度591c,在指定的日期 和時間僅執行一次的調度591d,及僅登記不指定作 業的調度591e。 乍 分批作業執行功能591按照對作業檔案登記作業時設定 的調度執行作業。此分批作業執行功能591在執行時, 識別要執行的作業的作業ID與表示周期的功能59u〜59ie 加以鏈結並保持,以執行時間監視。通常在電腦負荷低 深夜等執行操作處理需要長時間的作業時,採用調度59ι 所執行的在指定日期、時間僅啟動一次的作業。執彳^該 業並正常完成處理時,則在分批作業管理功能5 92的控制C: \ 2D-C0DE \ 90-02 \ 89124554.ptd Page 54 479172 V. Description of the invention (51) Therefore, by using this Web results file 5 6 〇 to store frequently used search results' users (PC operators) do not have to Accessing the data servo status of other sites through the network can easily obtain the required information. As described above, according to Embodiment 7 of the present invention, on the relay server, the database operation result is output to the home page of the ψ eb site, so the user can easily specify the address of the home page, browse the Web results file, and search at high speed. Required information. FIG. 25 (A) is a schematic diagram showing a configuration of a batch job execution function. The batch job execution function 5 9 i is realized by software, and the job is started at a predetermined cycle at a specified time. This time is monitored by the computer clock in the relay server 5 and the current time is counted. The batch job execution cycle is specified by the offset job type (job ID). Can schedule batch job management function 5 92 There are 5 kinds of jobs: schedule 591a executed at a specified time every day, schedule 591b executed at a specified time every week, schedule 591c executed at a specified time every month, and on a specified date Schedule 591d that is executed only once and time, and schedule 591e that only registers unspecified jobs. The batch job execution function 591 executes jobs in accordance with the schedule set when the job is registered in the job file. When this batch job execution function 591 is executed, the job ID that identifies the job to be executed and the functions 59u to 59ie indicating the cycle are linked and held for execution time monitoring. Normally, when a computer has a low load and a job that requires a long time to perform operation processing, such as a night, a job that is executed only once at a specified date and time is executed by schedule 59m. When the job is executed and processing is normally completed, the control of the batch job management function 5 92

479172 五、發明說明(52) 下,自動刪除該作業。 不指疋執行、僅進行登記的調度5 9 1 e中,僅登記作業, 主要用於記錄,以免忘記作業條件。這些調度591a 〜591e 在登記作業時,用戶通過PC 1 5指定作業要啟動的時刻和作 業的啟動間隔。 圖25(B)為顯示分批作業管理功能5 92的結構的概略圖。 此分批作業管理功能5 92包含分批作業登記功能5 92&、分 批作業刪除功能5 9 2 b、檢索(操作)條件參照/更改功能 5 92c、分批作業啟動條件更改功能5 9 2d和分批作業強制執 行功能5 92e。由分批作業登記功能59 2a在作業檔案新登記 有分批作業時,生成作業ID,與分批作業執行功能59ι f的啟動日守刻周期鏈結並加以保持。由分批作業啟動 更改功能5 92d,對此分批作業執行功能591中進行作業^ =的更改。檢索條件參照/更改功能5 92(:在執行作業時= ,操作條件(檢索/插入/刪除/更改),或者按照用戶ς 來的操作條件更改指示進行更改。 Λ /分批作業強制執行功能5 92e強制執行調度中由不指 進行登記的作業調度591e登記的作業。此分批作ί 強能592e還可用於即時執行其他類型的作業。業 利=1=作業管理功能592的功能,由系統管理者 利用其PC15啟動上裝工具553進行指定。 考 以:作業操作結果輪出到Web結果槽案56。加 以保持,旎方便地經常瀏覽最新資料。 加 (實施形態8) ' C:\2D-00DE\90.\89124554.ptd 第56頁 479172 五、發明說明(53) 圖2 6為顯示本發明具加形悲8的通^fg糸統的結構的概略 圖。圖26所示的結構中,中繼伺服器51上裝載Web檢索現 場功能。該中繼祠服斋5 1中’配置W e b結果槽案5 6 〇、主頁 晝面609和操作程式562。主頁晝面609包含檢索條件輸入 晝面6 1 0和結果輸出畫面611。從用戶端存取時,按照用戶 的命令將指定的主頁晝面傳送給用戶。479172 V. Description of Invention (52), the job is automatically deleted. In the schedule that does not refer to execution and only registration, 5 9 1 e only registers jobs, which are mainly used for recording to avoid forgetting the conditions of the job. In these schedules 591a to 591e, when a job is registered, the user specifies the time at which the job is to be started and the job start interval through the PC 15. FIG. 25 (B) is a schematic diagram showing the configuration of the batch job management function 592. This batch job management function 5 92 includes batch job registration function 5 92 & batch job deletion function 5 9 2 b, search (operation) condition reference / change function 5 92c, batch job start condition change function 5 9 2d And batch job enforcement function 5 92e. The batch job registration function 59 2a newly registers a job file in the job file, and generates a job ID, which is linked to and maintained by the start date of the batch job execution function 59mf. Started by a batch job. Change function 5 92d changes the job ^ = in this batch job execution function 591. Search condition reference / change function 5 92 (: during job execution =, operation conditions (search / insert / delete / change), or change according to the operation condition change instructions from the user. Λ / batch job enforcement function 5 92e compulsory execution schedules the jobs registered by 591e, which does not refer to registration. This batch job ί Qiang energy 592e can also be used to execute other types of jobs in real time. Yield = 1 = Job management function 592 function, controlled by the system The administrator uses his PC15 to launch the uploading tool 553 to make the designation. The test is: the operation operation result is rotated to the Web result slot case 56. Keep it, and browse the latest information conveniently and conveniently. Plus (Embodiment 8) 'C: \ 2D -00DE \ 90. \ 89124554.ptd Page 56 479172 V. Description of the invention (53) Fig. 26 is a schematic diagram showing the structure of the communication system of the present invention with a shape-adding system. The structure shown in Fig. 26 In the relay server 51, a web search site function is loaded. The relay temple server 51 is configured with a Web result slot case 5 6 〇, a homepage 609 and an operation program 562. The homepage 609 contains search conditions. Enter day and day 6 1 0 and result Screen 611. When access from the UE according to a user's command to the specified page to the user plane day.

上述Web檢索現場功能由前面說明的中繼功能5 1 1和分扭 作業檢索功能等組合而成,從Web ( WWW )伺服器上的檢索 條件輸入晝面6 1 0輸入檢索條件,執行操作程式$ 6 2,對資 料庫進行檢索後,在結果輸出晝面6 u顯示檢索結果。在 中繼伺服器51建立Web伺服器。操作程式562和中繼功能 511採用先前實施形態中所用的。下面,說明利用—檢索 現資料庫(DB)伺服器22的關聯資料庫211進 仃檢索的操作。 用戶在PC14上移動 S91 )。利用兮、叫^ 到兄秋篮的瀏覽器564 (步The above-mentioned Web search site function is a combination of the relay function 5 11 described above and the split-work search function, and the search conditions are input from the Web (WWW) server. $ 6 2. After searching the database, the search results will be displayed on the day 6 u in the result output. A web server is established on the relay server 51. The operation program 562 and the relay function 511 are used in the previous embodiment. Next, a search operation using the related database 211 of the existing database (DB) server 22 will be described. The user moves S91 on PC14). Use Xi, call ^ to brother autumn basket browser 564 (step

Ml )。利用该瀏覽器564存取中Ml). Accessed using this browser 564

主頁晝面609,劉覽其中包含的中=司你服^eb伺服器51 戶在例如作為對話方塊的該檢的技索條件輸入晝面61〇。 索條件(步驟S92 )。在檢索條、U件輸入晝面61 0輸入; 索條件時’利用檢索條件欢輸、」二件輪入晝面610上輸入完 操作程式562 (步驟S93 )。 凡畢指示和執行指示,啟 設置的電腦(處理裝置)執彳_ t繼伺服器/Web伺服器51 程式562包含進行檢~索操作用^作_程式5 6 2的啟動。操> 輯的邏輯職以及表示輸 作邏輯程式中各: 京條件的參數。操作程式The home page 609, Liu Lan, which contains the middle = company service eb server 51, enters the day surface 61 in the technical conditions of the inspection as a dialog box, for example. Search conditions (step S92). In the search bar, the U-piece enters the day surface 61 0 input; when the search condition is used, the search conditions are used to enter, and the two-piece turn-in day surface 610 is inputted and the operation program 562 is completed (step S93). After completing the instructions and executing the instructions, the set computer (processing device) executes the _ t server / web server 51. Program 562 includes the start-up of program 5 6 2 for checking and searching operations. The logical position of the > series and the parameters representing the conditions in the input logic program. Operating procedure

五、發明說明(54) 5 6 2啟動日t,用邏輯。乎叫+ 資訊傳送給資料庫(DB)二鉍,通過中繼功能511將此操作 行回應的資料庫檢索(步:&器22,纟關聯資料庫211執 完成檢索操作時,又從 4 )。 )通過中繼功能511送回於貝去抖庫飼服器22 (操作邏輯程式 出到結果輸出晝面61丨上^宗結果。該送回的檢索結果輪 出到Web上。在檢索條仕认或者作為Web結果檔案5 6 0,輸 規定輸出到上述二者中勒入晝面6 1 〇上輸入檢索條件時, 到Web上的擋案通常一個。如前面說明的那樣輪出 用戶可利用劉覽器560二形^^^ 料(步驟S96)。還可利=、、”果輸出纟面611上輸出的資 Web的結果檔案560 /利用β覽器5 60在PC14上下載輸出到V. Description of the invention (54) 5 6 2 Start date t, using logic. The information + is sent to the database (DB) dibismuth, and the database responding to this operation line is retrieved through the relay function 511 (step: & device 22, when the associated database 211 performs the retrieval operation, and then returns from 4 ). ) Return to Yu Bei De shake library feeder 22 through relay function 511 (Operational logic program is output to the result output 61 on the day surface ^ results. The returned search results are turned out on the Web. In the search section It is recognized or used as the Web results file 5 60, and the specified output is output to both of the above. When the search conditions are entered on the day surface 6 1 0, there is usually one file on the Web. As explained above, users can use this information by rotation. Liu browser 560 two-form ^^^ data (step S96). You can also use the web results file 560 output on the output page 611 / use the browser 5 60 to download and output on PC14 to

々士 ί貝τΓ庫祆索刼作時’操作程式5 6 2也可用通常的SCH η- ^ ^ - 1因此,這時,資料庫伺服器22的牡 二也知的貧料庫伺服器相同,按。 作。可在中繼伺服器51上建立Web檢索現場功能。執仃“ 述方式稱為客戶機/伺服器/飼服器方 機、資料庫祠服哭说l 田F L客戶 座伺ί r 1 的應用伺服器等3層構成。將資料 °态人應用伺服器分開,從而可避免負荇隹φ $丨二 伺服哭的雷聪』贤尤貞何集中到資料 存取: ,此利用減輕電腦負荷實現高速之資料庫 (實施形態9 ) 圖圖示ΐ發明實施形態9的通信系統的結構的概略 Θ圖27所不的糸統中在現場# 1設置半導體製造裝置641In the case of the search engine, the operation program 5 6 2 can also use the normal SCH η ^ ^ -1. Therefore, at this time, the lean library server that is also known by the database server 22 is the same. press. Make. A web search site function can be established on the relay server 51. The execution method described above is called a client / server / feeder machine, a database server, a server, and an application server consisting of three FL servers. The data server is applied to the person The device is separated, so as to avoid the negative 荇 隹 荇 隹 $ 丨 two crying servos Lei Cong 』Xian Youzhen He focused on data access: This is to reduce the load on the computer to achieve a high-speed database (Embodiment 9) Outline of the configuration of the communication system of the ninth embodiment Θ In the system shown in FIG. 27, a semiconductor manufacturing apparatus 641 is installed on site # 1

479172479172

〜643。為了控制這些半導體製造裝置641〜643的處理步 驟,配置帶通信功能的控制裝置(pc ) 6丨丨〜6丨3,作為終 食而。沒些控制裝置6 11〜6 1 3可通過中繼伺服器5丨對現場# 2〜現場#4所設置的DB伺服器622〜624進行檢索。這些汕 飼服器622〜624各自對應的資料庫DB # j〜DB # 3中,存放 半導體製造裝置641〜643的製造參數(處理溫度/時間、 劑ϊ等)半導體裝置製造處理所需的資料。控制裝置6工工 〜6 1 3與DB伺服器6 2 2〜6 24之間通過中繼伺服器5丨的通信 利用如面貫施形態1到8中說明的方法進行。~ 643. In order to control the processing steps of these semiconductor manufacturing devices 641 to 643, a control device (pc) 6 丨 丨 ~ 6 丨 3 with a communication function is provided as a final food. Each of the control devices 6 11 to 6 1 3 can search the DB servers 622 to 624 set in the scene # 2 to scene # 4 through the relay server 5 丨. Databases DB # j to DB # 3 corresponding to these Shan feeders 622 to 624 respectively store manufacturing parameters (processing temperature / time, agent volume, etc.) of semiconductor manufacturing devices 641 to 643, which are necessary for semiconductor device manufacturing processing. . The control device 6 workers ~ 6 1 3 and the DB server 6 2 2 ~ 6 24 communicate with each other through the relay server 5 丨 using the method described in the first through eighth embodiment.

資料庫6 22〜624中在資料庫別#1〜!^#3存放半導體裝 置各製造步驟所需製造參數等控制資料,並統一管理半導 體製造裝置的半導體裝置的製造步驟。處理裝置6丨j〜6工3 中,下載DB伺服器622〜624中存放的製造步驟所需參數資 料’並按照該下載的資料控制半導體製造裝置641〜643的 各參數(處理溫度、注入離子濃度、蝕刻氣體濃度等)。In database 6 22 to 624, control data such as manufacturing parameters required for each manufacturing step of the semiconductor device are stored in database types # 1 to! ^ # 3, and the semiconductor device manufacturing steps are uniformly managed in the semiconductor manufacturing device. In the processing device 6 丨 j ~ 6, the parameter data required for the manufacturing steps stored in the DB servers 622 to 624 is downloaded, and the parameters of the semiconductor manufacturing devices 641 to 643 (processing temperature, ion implantation) are controlled according to the downloaded data. Concentration, etching gas concentration, etc.).

DB伺服器622〜624中,也可存放不同製造步驟的處理參 數。現場# 2〜# 4中,結構上也可做成設置半導體製造裝 置,這些裝置利用回應的處理控制裝置存取DB伺服器622 〜6 2 4,進行資料檢索。做成這種結構時,可在半導體製 造裝置之間進行通信,並執行取得處理參數一致性等的處 理。 、处 在資料庫成批統一存放處理參數等製造步驟所需的資 料’從而即使在例如發生欠妥時更改處理參數的情況下, 也能方便地重新設定各製造裝置641〜643的參數。The DB servers 622 to 624 can also store processing parameters for different manufacturing steps. In the scenes # 2 to # 4, a semiconductor manufacturing device can also be provided in the structure. These devices use the response processing control device to access the DB servers 622 to 6 2 4 for data retrieval. With such a structure, it is possible to perform communication between semiconductor manufacturing apparatuses and perform processing such as obtaining processing parameter consistency. In the database, batches are stored in a unified manner to store the processing parameters and other necessary data, so that even if the processing parameters are changed when a defect occurs, the parameters of each manufacturing device 641 to 643 can be easily reset.

479172 五、發明說明(56) 控制裴置611〜613根據這些傳送的資料(製造參數), 你=應製造裝置641〜643的工作參數設定、操作控制 作狀況進行監視。 T連 版,官理功能5 5 〇對這些控制裝置6 1工〜6丨3所具有的通 :功忐程式的最新版本進行管理。-以結果檔案5 6 〇中, =口這些控制裝置61 i〜613中共同利用的資料或製造步 田/ κ理列表(製造步驟記錄)°在控制裝置6 1 1〜6 1 3,利 e結果檔案5 6 〇所存放的管理列表,管理製造步驟。如 ☆ +在,生欠女等情況下,也能方便地識別其原因。 备i f官理功能(5 92 )執行例如控制資料後援等處理。 ί 管理者用的PC15管理上述控制的半導體製造裝置641 壯〜的、全部處理步驟,並進行控制裝置611〜613的運作 的視二視和這些控制裝置6 1 1〜6 1 3中例如通信程式等版本 放f 2J所:的通信系統中,在資料庫DB #1〜DB #3預先存 、ί :: 等資料,從而能在例如中央統-管理半導體製 :ί:簡:需要在各控制裝置分別裝資料,使製造步驟中479172 V. Description of the invention (56) Control Pei 611 ~ 613 According to these transmitted data (manufacturing parameters), you = should monitor the operating parameters setting and operation control of the manufacturing devices 641 ~ 643. T-connection version, official management function 5 5 0 manages the latest version of the communication function programs of these control devices 61 1 to 6 3. -In the result file 5 6 〇, = the data commonly used in these control devices 61 i ~ 613 or the manufacturing step / κ list (manufacturing step records) ° in the control device 6 1 1 ~ 6 1 3, profit e The management list stored in the result file 560 manages the manufacturing steps. Such as ☆ + in the case of giving birth to women, etc., can also easily identify the cause. The standby function (5 92) performs processing such as controlling data backup. ί PC15 for the manager manages the semiconductor manufacturing device 641 controlled by the above, and performs all the processing steps, and performs the operations of the control devices 611 to 613, and the control devices 6 1 1 to 6 1 3 are communication programs, for example. In the communication system of F 2J, etc., the data is stored in the database DB # 1 ~ DB # 3 in advance, such as ί ::, so that it can be used in, for example, central management-management semiconductor systems: ί: simplified: need to be controlled in each The device is loaded with materials separately, so that during the manufacturing process

控:態9利用實施形態1到8的通信形態。這些 : : 〜613在需要通過中繼伺服器51進入資料庫DB 二二二3 ,進打製造裝置641〜643的實際運作狀況和要 故疋的資料的詢問等。 半導體製造裂置中製造的半導體裝置,其種類是任意 第60頁 C:\2D-OODE\90-O2\89124554.ptd 479172 五、發明說明(57) --- 的。也可在現場#2〜#4設置半導體製造裝置。 還可如實施形態1那樣,不設置中繼伺服器。 士上所述根據本發明實施形悲9,利用實施形雜1到8 ,通信系統建立半導體製造裝置的管理系統',可建"·立能進 行有效半導體製造步驟管理的半導體製造裝置的管理系 、统0 y、 【其他結構】 # 貫施形恶1到9的通信系統中,pc、中繼伺服器和資料庫 伺服器等各組成要素一般用半導體裝置構成。實現各功能 的各軟體和各工具等也在半導體裝置上運行,以實&規定 的功能。,此,各實施形態的通信系統一般是由半導體裝 置構成以貫現各規定功能的通信系統。 綜上所述,根據本發明,能建立確保安全性,同時可高 速且有效進行資料庫操作的資料庫通信系統。 、。 【元件編號之說明】 #1、#2 和 #3 現場;i (213 ) 、2 (214 )和3 (215 ) 表;4網路;1 1〜1 4電腦終端;1 1〜;i 4,丨p位址;丨丨a〜 13a,PC,1 lb 〜13b,PC ; 21、22 和23 資料庫伺服器;Control: State 9 uses the communication forms of Embodiments 1 to 8. These:: ~ 613 need to enter the database DB 2223 through the relay server 51, enter the actual operating status of the manufacturing equipment 641 ~ 643, and inquire about the information to be saved. Semiconductor device manufactured in split semiconductor manufacturing, its type is arbitrary Page 60 C: \ 2D-OODE \ 90-O2 \ 89124554.ptd 479172 V. Description of the invention (57) ---. Semiconductor manufacturing equipment can also be installed on site # 2 ~ # 4. As in the first embodiment, a relay server may not be provided. According to the above description, according to the present invention, Embodiment 9 is used, and the implementation of Embodiments 1 to 8 is used to establish a management system of a semiconductor manufacturing device in a communication system. The management of a semiconductor manufacturing device capable of performing effective semiconductor manufacturing process management can be established. Department, Department 0 y, [Other Structures] # In the communication systems of Guan Shi Xing Xie 1 to 9, each component such as a pc, a relay server, and a database server is generally constituted by a semiconductor device. The software and tools that implement each function also run on the semiconductor device to implement the & specified functions. Here, the communication system of each embodiment is generally a communication system composed of a semiconductor device to implement each predetermined function. In summary, according to the present invention, it is possible to establish a database communication system that can ensure database security and can perform database operations at high speed and efficiency. . [Description of component numbers] # 1, # 2 and # 3 on-site; i (213), 2 (214) and 3 (215) tables; 4 networks; 1 1 ~ 1 4 computer terminals; 1 1 ~; i 4 , 丨 p address; 丨 丨 a ~ 13a, PC, 1 lb ~ 13b, PC; 21, 22, and 23 database servers;

21、22和23,IP位址;41連接裝置;41a、41b連接器;“ 廣域通信網;49網路;51中繼伺服器;51a中繼伺服器; 5 1 b中Ύ司服裔;5 1 d 、5 1 e、5 1 f許可列表;5 2網路;111 晝面程式,1 11 A畫面程式;1 1 3晝面功能;1丨4通信功能; 1 15驅動器;1 17通信用SQL通信軟體(S/W ); 131路由 器;132連接裝置;15〇資訊;151a、151b資訊;152a、21, 22, and 23, IP addresses; 41 connecting devices; 41a, 41b connectors; "Wide Area Communication Network; 49 network; 51 relay server; 51a relay server; 5 1 b ; 5 1 d, 5 1 e, 5 1 f permission list; 5 2 network; 111 diurnal program, 1 11 A screen program; 1 1 3 diurnal function; 1 丨 4 communication function; 1 15 driver; 1 17 SQL communication software (S / W) for communication; 131 router; 132 connection device; 150 information; 151a, 151b information; 152a,

C:\2D-C0DE\90-02\89124554.ptd 第61頁 479172 五、發明說明(58) 1 5 2b參數資訊;21 1關聯資料庫(rDb ); 21 2,SQL通信軟 體(S/W ); 213、214和215表格形式資訊;216通信要求 監視程式;2 1 6 a〜21 6 η通信要求監視程式;2 1 7操作邏輯 程式;2 1 7 i ( i = a〜η )操作邏輯程式;2 1 8埠;2 1 9標誌 寄存器;220a〜220k埠;221〜224定義檔案;231路由 器;232連接裝置;251存取記錄;261、2 6 2及263許可列 表,262a (263a)中繼伺服器名列表;262b (263b)中繼 伺服器名列表;412專用LAN ; 412a和4 12b專用LAN ; 511中 繼功能;51 2標案傳送功能;541通信要求監視程式;542a 〜542η中繼功能中繼程式;542 i ( i =a〜n )中繼功能中 繼程式;5 5 0版本管理功能;5 5 1原始碼;5 5 2版本管理檔 案,5 5 3上裝工具;5 5 4功能表晝面;5 5 5軟體;5 9 1分批作 業執行功能;5 9 1 a〜5 9 1 e調度;5 9 2分批作業管理功能; 592a $批作業登記功能;592b分批作業刪除功能;59^檢 索(操作)條件參照/更改功能;5 9 2d分批作業啟動條件 更改功能;592e分批作業強制執行功能;56〇Web結果檔 案;562操作程式;5 63檢索條件檔案;564劉f哭°曰 計算軟體;6 0 9主頁晝面;610檢索條件輸入晝面· 611二 613控制裝置(PC) ;611結果輸出晝面;622二624’,汕祠 服器;641〜643半導體製造裝置;A操作;βχ對話方塊·C: \ 2D-C0DE \ 90-02 \ 89124554.ptd Page 61 479172 V. Description of the invention (58) 1 5 2b Parameter information; 21 1 Association database (rDb); 21 2. SQL communication software (S / W ); Information in the form of tables 213, 214, and 215; 216 communication request monitoring program; 2 1 6 a to 21 6 η communication request monitoring program; 2 1 7 operation logic program; 2 1 7 i (i = a to η) operation logic Program; 2 1 8 port; 2 1 9 flag register; 220a ~ 220k port; 221 ~ 224 definition file; 231 router; 232 connection device; 251 access record; 261, 2 6 2 and 263 permission list, 262a (263a) Relay server name list; 262b (263b) relay server name list; 412 dedicated LAN; 412a and 4 12b dedicated LAN; 511 relay function; 51 2 project transmission function; 541 communication request monitoring program; 542a to 542η Relay function relay program; 542 i (i = a ~ n) relay function relay program; 5 50 version management function; 5 5 1 source code; 5 5 2 version management file, 5 5 3 upload tool; 5 5 4 function table daytime; 5 5 5 software; 5 9 1 batch job execution function; 5 9 1 a ~ 5 9 1 e scheduling; 5 9 2 batch job management function; 592a $ batch Job registration function; 592b batch job delete function; 59 ^ search (operation) condition reference / change function; 5 9 2d batch job start condition change function; 592e batch job execution function; 56 Web results file; 562 operations Program; 5 63 search condition files; 564 Liu f cry ° calculation software; 609 homepage daytime surface; 610 search condition input daytime surface · 611 two 613 control device (PC); 611 result output daylight surface; 622 two 624 ' , Shanci server; 641 ~ 643 semiconductor manufacturing equipment; A operation; βχ dialogue box ·

ΒΤ操作鍵;mfm暫存器;DBE資料庫機;Dpp顯示7書面程’ 式;DSO、DS1、DS2…顯示畫面;FG標誌或識別字"元 權案;LN邏輯編號;LP1、LP2…邏輯;LP#1〜Lp#n^i 邏輯;LNWMNh邏輯編號;“討檔案操作邏輯;LBT operation key; mfm register; DBE database machine; Dpp display 7 written procedures; DSO, DS1, DS2 ... display screen; FG logo or identification word " yuan right case; LN logical number; LP1, LP2 ... Logic; LP # 1 ~ Lp # n ^ i logic; LNWMNh logic number; "Discuss file operation logic; L

C:\2D-OODE\90-02\89124554.ptdC: \ 2D-OODE \ 90-02 \ 89124554.ptd

第62頁 479172 五、發明說明(59) #F邏輯編號;MLP操作邏輯程式;MN操作功能表;RDB關 聯資料庫;SPO晝面邏輯程式;SP1、SP2…邏輯程式;SP 晝面邏輯程式;S F a〜S F η啟動標諸;S F i標誌、寄存器;。Page 62 479172 V. Description of the invention (59) #F logic number; MLP operation logic program; MN operation function table; RDB related database; SPO day logic program; SP1, SP2 ... logic program; SP day logic program; SF a ~ SF η start standard; SF i flag, register ;.

C:\2D-C0DE\90-02\89124554.ptd 第63頁 圖式簡單說明 圖 圖1為_系 — 。 务明貫施形態1的通信系統的結構的概略 圖2為顯禾 _ 圖3為_冷同所示晝面程式的結構的概略圖。 圖4為顯示^1所示操作邏輯程式的結構的概略圖。 圖5為顯禾二所不上述通信系統的通信運作的順序 庫伺服器的資^康本發明實施形態1從電腦終端傳送到次 圖6為顯条、成的結構的概略圖。 貝科 圖7為顯系t =明實施形態1的變更例的結構的概略圖。 作流程圖。★明實施形態2的通信系統中電腦終端二 _ 圖8為具賤_厂一 … 、 圖9為顯系=猎由圖7所不資料添加流程的流程 作順序圖。 务明實施形態3的資料庫伺服哭的处姐 口口 W V、口稱和谨 圖10為_禾 圖11顯示1^9所示操作邏輯程式的結構的概略圖。 圖1 2為顯Λ ★明實施形態3的變更例的圖。 圖, 不本發明實施形態4的通信系統的結構的概略 圖1 3為|負一 圖1 4為續:本發明實施形悲4的變更例的概略圖。 认恤^门·不圖1 2所示中繼伺服器的連接啐 的概略圖。 逆接许可列表的結構 圖1 5為顯示圖12所示資料庫伺服器 構的概略圖。 連接許可列表的結 圖16為顯示圖12所示中繼功能的結構的 圖1 7為顯示本發明實施形態4的通信系統的通@ ° σ少驟的C: \ 2D-C0DE \ 90-02 \ 89124554.ptd page 63 Brief description of the drawing Fig. 1 is _ series —. The outline of the structure of the communication system in the first embodiment is shown in Fig. 2. Fig. 2 is a schematic diagram of the structure of the diurnal program shown by Leng Tong. FIG. 4 is a schematic diagram showing the structure of the operation logic program shown in ^ 1. Fig. 5 is a sequence of communication operation of the above-mentioned communication system by Xianhe No. 2 Institute. The embodiment 1 of the present invention transmits data from a computer terminal to the server. Fig. 6 is a schematic diagram of the structure of the display bar. Beco Fig. 7 is a schematic diagram showing the configuration of a modified example of t = Ming Embodiment 1. Make a flow chart. ★ The second computer terminal in the communication system of the second embodiment _ Fig. 8 is a low-level _ factory one ......, Fig. 9 is a flow chart showing the process of adding data not shown in Fig. 7 The maiden who cries in the database of the third embodiment of the present invention. Mouth W V, mouth name and sincerity. Fig. 10 is a schematic diagram showing the structure of an operation logic program shown in Fig. 11. Fig. 12 is a diagram showing a modification of the third embodiment. FIG. 14 is a schematic diagram showing a configuration of a communication system according to the fourth embodiment of the present invention. FIG. 13 is a negative figure. FIG. 14 is a schematic view of a modified example of the fourth embodiment of the present invention. Schematic diagram of the connection of the relay server shown in Figure 12 and Figure 12. Structure of reverse permission list Fig. 15 is a schematic diagram showing a database server structure shown in Fig. 12. Conclusion of the connection permission list Fig. 16 is a diagram showing the structure of the relay function shown in Fig. 12 Fig. 17 is a diagram showing the communication of the communication system according to the fourth embodiment of the present invention.

ww

C:\2D-CODE\90-02\89124554.ptd 第64頁 479172C: \ 2D-CODE \ 90-02 \ 89124554.ptd Page 64 479172

Claims (1)

'申請專利範圍 •:二重通信系、统,係為具有資 ^ 其包含有: 早1 j服裔和電腦終端 上述電腦終端,且借4 Λ、人+ ,處理所需參數處理内容的邏輯編號 的送信機構; 、 並舍运该生成的處理資訊 这寅料庫伺服器,| 上述處理資訊,利用+枓庫和邏輯程式機構; 構所包含的邏輯;及 述邏輯編號識別上述邏輯程式機 t述邏輯程式機構,具備在 文動時,執行按照上述處 述處=資訊識別並予以 、、,予以存取,處理存取資料,'將y的邏輯,並進入資料 适2到上述電腦終端的送信機構。订結果所得的資料傳 式機利範圍第1項之通信系統,其中上述邏輯程 上述資料庫伺服器, J要求’啟動設置有多個邏輯程2述電腦終端發來的連 動的邏輯程式機構進行通 H 2構中的—個後,使啟 視其他連接要求的監視機構:里並執行通信’其本身則監 3.如申請專利範圍第1項之 伺服器,又具備 糸統’其中上述資料庫 經常監視通信要求的監視機構; 回應來自上述電腦終端的 端’指定由上述資料庫伺服用以在上述電腦終 的指定機構;及 ° 上返電腦終端的連接方法 C:\2D-CODE\90-02\89124554.ptd 第66頁 479172 六、申請專利範圍 按照上述指定的連接方法,設定從上述資料庫伺服器向 上述電腦終端的連接的設定機構。 4. 一種通信系統,其包含有: 多個電腦終端; 至少一個資料庫伺服器;及 共同設置於上述多個電腦終端的中繼伺服器,係用於 集中管理各上述電腦終端與上述至少一個資料庫伺服器之 間的通信。 5. 如申請專利範圍第4項之通信系統,其中上述中繼伺 服器,具有在允許從上述多個電腦終端中的一個電腦終端 對上述至少一個以上的資料庫伺服器的通信要求時,對上 述一個電腦終端與允許通信的資料庫伺服器之間的通信文 本進行中繼並傳送的傳送機構。 6. —種通信系統,其至少包含有: 包括具有通信資訊中繼功能的資料庫伺服器的第1現 場, 第2現場,與上述第1現場分開設置,其中包含(i )至少 一個電腦終端,(i i)對上述至少一個電腦終端與上述第1 現場資料庫伺服器之間的通信文本進行中繼用的中繼伺服 器。 7. 如申請專利範圍第6項之通信系統,其中上述資料庫 伺服器,包括分別執行處理步驟的多個邏輯,而且在要求 通信時予以啟動的邏輯程式機構; 上述至少一個電腦終端,包括送出啟動上述邏輯程式機'Scope of patent application •: Dual communication system and system, which are qualified ^ It includes: early 1j server and computer terminal The above computer terminal, and 4 Λ, person +, logic to process the required parameters and processing content The number of sending organizations; and the logistics server that generates the processing information; | The processing information above uses the + library and the logic programming mechanism; the logic contained in the structure; and the logic number identifies the logic programming machine. The above-mentioned logic program mechanism has the following functions: When the document is in motion, it executes according to the above description = information identification and access, processing, and accessing data, and the logic of "y" and access to the data is suitable for the above computer terminal. Delivery agencies. The communication system of item 1 of the data transmission machine benefit range obtained from the order result, wherein the above-mentioned logic process is the above-mentioned database server, and J requests' to start a linkage logic program mechanism provided with a plurality of logic processes and the computer terminal sends the After communicating with one of the H 2 structures, the monitoring organization that enables other connection requirements: to perform communication and monitor itself. 3. If the server in the scope of patent application No. 1 is equipped with the system, the above information is included. The monitoring mechanism that the library often monitors the communication request; responds to the terminal from the above-mentioned computer terminal, and designates the designated mechanism used by the above-mentioned database server to terminate the above-mentioned computer; and the connection method of the returning computer terminal C: \ 2D-CODE \ 90 -02 \ 89124554.ptd Page 66 479172 6. Scope of patent application The setting mechanism for setting the connection from the database server to the computer terminal according to the connection method specified above. 4. A communication system comprising: a plurality of computer terminals; at least one database server; and a relay server co-located in the plurality of computer terminals, which is used to centrally manage each of the computer terminals and the at least one Communication between database servers. 5. The communication system according to item 4 of the scope of patent application, wherein the relay server has the following requirements when allowing communication requests from one computer terminal of the plurality of computer terminals to the at least one or more database servers. A transmission mechanism that relays and transmits a communication text between the computer terminal and a database server that allows communication. 6. A communication system including at least: a first site and a second site including a database server having a communication information relay function, which are separately provided from the first site, and include (i) at least one computer terminal (Ii) a relay server for relaying a communication text between the at least one computer terminal and the first field database server. 7. For the communication system of the sixth scope of the application for patent, wherein the above-mentioned database server includes a logic program mechanism that executes a plurality of logics of processing steps and is activated when communication is required; the at least one computer terminal, including Start the above logic program machine C:\2D-CODE\90-02\89124554.ptd 第67頁 479172 — 六、申請專利範圍 ____ 構的規f邏輯的通信文本的送出機構;及 上述貝料庫伺服器,包括利用啟動的邏輯 動的邏輯,進入資料庫予以六η ^ 飞钱構所啟 理後,用上述中行邏輯指定的處 j服裔將該執行結果所得的脊〜々,a 上述電腦終端的發送機構。 貝祝發送給 8 · —種通信系統,其包含有: 多個電腦終端; · 中^服H,係共同設置於上述多 上述多個電腦終端的通信 玉細〜鸲,用於對 上述中繼飼服器,又ί;本進订中繼者;及 存放最新版本母程式用的存放 多個電腦終端中啟動的電腦終端内盥以及根據表示上述 式的版本的比較結果的資訊,將;^述母程式所對應程 動電腦終端用的下載機構。 处母裎式下载到上述啟 9. 一種通信系統,其包含有. 登記多個作業用的登記機構;.及 按指定的周期單位執行 行機構; 且。己社構登記的作業用的執 進行對上述登記機構的作人 強制執行用的作業管理機構:、且…刪⑨、參照、更改和 10. —種通信系統,其包含 含有資料庫的資料庫伺服哭· Web伺服器; α ’ 對上述Web伺服器設定 _ 抖庫的詢問條件輪入和 圓纖 C:\2D-CODE\90-O2\89124554.ptd 第68頁 4/VI —— 六、申請專利範圍 一 Ί:結果輸出用的電腦終端;及 通信;U述貧料庫伺服器與上述Web伺服器之間通信用的 ]ί· 一種資料庫旬服器, 貢料庫;及 ,、3再 邏輯程式機構,呈右 用的多個邏輯,八有刀别執行對上述資料庫的處理步驟 的邏輯又:備按照包含識別來自終端邏輯 料庫予以存取,卢二,,執行該識別的邏輯,進入上述資 傳送給上述終端“;料並將該執行結果所得的資料 寸皁于以存取者,其包含有: 資料=邏輯程式機構,係具備分別表示對上述 貝車的處理步驟的多個操作邏輯者; ^ 上述處理貧訊,具備識別上述邏輯程式機槿%人4„ 輯的邏輯編號以及該處理所需的參:口; ^構所含知作邏 上述程式邏輯機構,具備按照上 對應的操作"4,進人上述㈣料;;動亚執行 數處理該存取的資料 , .^ 存取,按照上述參 上述電腦終端用的傳送機構。 果所传的育料傳送給 1 3 ·如申凊專利範圍第丨2項之控制裝置, 一個邏輯程式機構包括多個邏輯程式機構/、上述至シ 上述控制裳置,又具有通信要求監視程式機構,該機構 11 第69頁 參 C:\2D-CODE\90-02\89124554.ptd 479172 六、申請專利範圍 經常監視對上述資料庫的存取,並回應來自電腦終端的連 接要求,啟動設置多個的邏輯程式機構中的一個後,使啟 動的邏輯程式機構進行通信管理並執行通信,其本身則監 視來自其他終端的連接要求。 1 4.如申請專利範圍第1 2項之控制裝置,其中該裝置具 . 備經常監視通信要求的監視機構; _ 回應來自上述電腦終端的連接要求,在上述電腦終端指 ' _ 定該連接狀態用的指定機構;及 ~ 回應來自上述電腦終端的連接狀態指定,以該指定狀態 建立與上述電腦終端連接的確立機構。 1 5. —種處理終端,用來對含有資料庫的資料庫伺服器 進行存取,其包含有: 上述資料庫伺服器中至少設置一個具有多個操作邏輯的 邏輯程式機構,上述操作邏輯用以表示處理之步驟; 具備表示處理内容的邏輯編號,與將含有該處理所需參 數的處理資訊生成後發送給上述資料庫伺服器,並接受來 自上述資料庫伺服器的處理執行結果的受信機構;及 上述處理,係在上述資料庫伺服器中識別上述邏輯編號 的邏輯控制下執行,並從上述資料庫伺服器發送該執行結 | 果。 1 6.如申請專利範圍第1 5項之處理終端,其中該處理終 端又具備 · 向上述資料庫伺服器註冊的註冊機構; : 向上述資料庫註冊的註冊機構; -C: \ 2D-CODE \ 90-02 \ 89124554.ptd Page 67 479172 — VI. Patent application scope ____ The structure of the communication text sending mechanism; and the shellfish server mentioned above, including The logic of the logic moves into the database and gives six ^ ^ flying money structure, and uses the service designated by the Bank of China logic to obtain the ridge ~ 々, a sending mechanism of the computer terminal. Bezhu sent to 8 · a communication system, which includes: multiple computer terminals; · server H, which is a communication device set in the above multiple computer terminals, and is used to relay to the relay Feeder, again; this order repeater; and the latest version of the parent program stored in a computer terminal activated in multiple computer terminals and according to the information showing the results of the comparison of the above version of the formula; ^ The download mechanism for the program computer terminal corresponding to the parent program is described. The download is downloaded to the above mentioned 9. A communication system comprising: a registration agency for registering a plurality of operations; and an execution agency at a specified cycle unit; and. The operation management agency for the enforcement of the operations registered by the social organization against the registrants of the above-mentioned registration agencies: and delete, reference, change, and 10. A communication system including a database containing a database Servo cry · Web server; α 'Set the query conditions for the above-mentioned Web server _ Jitter library round and round fiber C: \ 2D-CODE \ 90-O2 \ 89124554.ptd Page 68 4 / VI —— VI 、 The scope of the patent application is as follows: a computer terminal for outputting results; and communication; used for communication between the lean database server and the above-mentioned Web server] ί a database server, a tribute database; and ,,, 3 is a logic program mechanism, which presents multiple logics used on the right. There is a tool to perform the logic of the processing steps of the above database. It is also prepared to access from the terminal logic library according to the identification. Lu Er, execute the identification. The logic of entering the above-mentioned information is transmitted to the above-mentioned terminal; and the data obtained by the execution result are used to save the accessor, which includes: Data = logic program mechanism, which has the processing steps respectively indicating the above-mentioned car. A plurality of operation logics; ^ The above-mentioned processing poor information has a logic number identifying the above-mentioned logical program mechanism and the parameters required for the processing: port; ^ The knowledge of the structure to logic the above-mentioned program logic mechanism, having Follow the corresponding operation "4" to enter the above-mentioned data ;; Actuator performs processing of the accessed data,. ^ Access, as described above, refer to the transmission mechanism for the computer terminal. The transferred breeding material is transmitted to the control device as described in the patent application No. 丨 2, a logic program mechanism includes a plurality of logic program mechanisms /, the above to the above control clothes, and a communication request monitoring program Institution, the institution 11 Page 69 See C: \ 2D-CODE \ 90-02 \ 89124554.ptd 479172 6. The scope of patent application often monitors the access to the above database, and responds to the connection request from the computer terminal, and starts the setting After one of the plurality of logic program mechanisms, the activated logic program mechanism performs communication management and performs communication, and itself monitors connection requests from other terminals. 1 4. If the control device in the scope of patent application No. 12 is used, the device is equipped with a monitoring mechanism that constantly monitors communication requirements; _ Respond to the connection request from the above computer terminal, and specify '_ the connection status at the above computer terminal And a designation mechanism for establishing a connection with the computer terminal in response to the designation of the connection status from the computer terminal. 1 5. A processing terminal for accessing a database server containing a database, which includes: At least one logic program mechanism having a plurality of operation logics is set in the database server, and the operation logic is used for Indicates processing steps; has a logical number indicating the processing content, and a trusted institution that generates processing information containing parameters required for the processing and sends it to the database server, and accepts the processing execution results from the database server ; And the above processing is performed under the logical control of identifying the above-mentioned logical number in the database server, and sending the execution result from the database server | 1 6. If the processing terminal of the scope of application for patent No. 15 is provided, the processing terminal has: a registration agency registered with the above database server; a registration agency registered with the above database;- C:\2D-CODE\90-02\891245M.ptd 第70頁 479172 申請專利範圍 傳口化詢問語言(SQL)的語句傳送上述處理内容的 後,x從二i ^二料庫的登出指示’從上述資料庫登出 17 —Λ料庫伺服器登出的結束機構。 • 種中繼伺服器,其包含有: 對多個電腦終端共同置 · 少一個資料康彳η π门置、、先官上述多個電腦終端與至 對來自之間通信的管理機構; 連接要求腦終端的連接要求,収是否允許該 資料庫二'專利又\圍備〜:1二資料:伺, 端和另-現場所設電腦終端的通=::2來自上述終 構。 又本用的中繼傳送機 用 19. 一種中繼伺服器,係在多個 於中繼上述多個電腦終端的通信文笔如,〜端共同設置 統一管理上述多個電腦終端通信的通f,含有: 存放最新版本母程式用的存放機構彳5官理機構; ,上述多個電腦終端中啟動的電腦終: 鲁 :應的程式的版本與上述母程式的版上述母程式所 該比較結果的資訊’用以下载到 ),並根據表示 腦終端的下載機構。 V %式的上述啟動電 20. —種中繼飼服器,係用於中繼多 ” 者,其包含有: a腦終端的通作 判決是否允终上述多個電腦終端 ______ 、 k,並根據該判決結C: \ 2D-CODE \ 90-02 \ 891245M.ptd Page 70 479172 After applying the above-mentioned statements in the scope of the patent-applicable verbalized query language (SQL), x indicates the logout instruction from the second database. 'Log out from the above database 17 — The ending mechanism for logout of the Λ library server. • A relay server, which includes: a common arrangement for multiple computer terminals, a lesser data center, a π gate, a management agency that communicates between the aforementioned multiple computer terminals and the peer pair; connection requirements The connection requirements of the brain terminal, whether to accept the database 2 'patents and prepare ~~ 1: 2 materials: server, terminal and another-on-site computer terminal ==: 2 from the above terminal structure. A relay server for the present use 19. A relay server is provided in a plurality of communication lines for relaying the plurality of computer terminals, for example, a communication terminal which collectively manages the communication of the plurality of computer terminals is set up at Contains: the storage mechanism for storing the latest version of the parent program (5 official agencies); the computer started in the above multiple computer terminals: Lu: the version of the corresponding program should be compared with the version of the above parent program. Information 'to download to), and according to the download mechanism representing the brain terminal. The above-mentioned start-up power of the V% type is 20. A relay feeder, which is used for relaying multiple ", which includes: a brain terminal's general decision whether to allow the above multiple computer terminals ______, k, And end according to the judgment C:\2D-mDE\90-02\89124554.ptd $ 71頁 479172 六、申請專利範圍 果中繼提出連接要求的電腦終端的連接要求用機構; 按照上述多個電腦終端中的至少一個電腦終端的指示, 登記多個作業的登記機構,上述作業指明定期對資料庫執 行的詢問處理; 以指定的周期單位執行上述登記機構登記的作業用的執 行機構;及 進行對上述登記機構的作業登記、刪除、參照、更改和 強制執行用的作業管理機構。 2 1.如申請專利範圍第2 0項之中繼伺服器,其包含有: Φ Web伺服器; 按照上述Web伺服器設定的詢問條件,進入資料庫伺服 器予以存取,並將該存取結果放入到上述Web伺服器的存 取機構;及 上述Web伺服器中,利用多個電腦終端中規定的電腦終 端設定上述詢問條件。 2 2.如申請專利範圍第1 1項之資料庫伺服器,其中上述 終端,是半導體裝置之製造裝置的控制裝置;上述資料 庫,存放包含上述半導體裝置之製造所需的步驟參數的資 料。 2 3.如申請專利範圍第1 2項之控制裝置,其中上述電腦 終端,是半導體製造裝置的控制裝置;上述資料庫,存放 包含上述半導體裝置中半導體裝置之製造所需的步驟參數 的資料。 2 4.如申請專利範圍第1 5項之處理終端,其中上述處理C: \ 2D-mDE \ 90-02 \ 89124554.ptd $ 71, page 479172 VI. Patent application scope: The connection requesting agency of the computer terminal that requested the connection; according to at least one of the multiple computer terminals Instructions for registering a plurality of operations, the above operations specify a query process to be performed periodically on the database; an execution agency for performing the operations registered by the registration agency in a specified cycle unit; and performing job registration for the registration agencies, Job management agencies for deletion, reference, change, and enforcement. 2 1. The relay server according to item 20 of the scope of patent application, which includes: Φ Web server; Enter the database server to access according to the query conditions set by the above Web server, and access the access As a result, it is put in the access mechanism of the Web server; and in the Web server, the inquiry condition is set using a predetermined computer terminal among a plurality of computer terminals. 2 2. The database server according to item 11 of the scope of patent application, wherein the above terminal is a control device of a semiconductor device manufacturing device; the above database stores data including step parameters required for the manufacturing of the above semiconductor device. 2 3. The control device according to item 12 of the scope of the patent application, wherein the computer terminal is a control device of a semiconductor manufacturing device; the above-mentioned database stores data including step parameters required for the manufacturing of the semiconductor device in the above semiconductor device. 2 4. The processing terminal according to item 15 of the scope of patent application, wherein the above processing C:\2D-CODE\90-02\89124554.ptd 第72頁 479172 六、申請專利範圍 終端,是半導體裝置之製造裝置的控制裝置;上述資料庫 伺服器,存放上述製造裝置的控制資料。 2 5.如申請專利範圍第1 9項之中繼伺服器,其中上述多 個電腦終端,是半導體製造裝置的控制裝置;上述套裝程 式,含存取資料庫伺服器用的通信程式;上述資料庫伺服 器,存放上述半導體製造裝置的控制資料;上述控制資 料,包含表明上述半導體製造裝置的處理條件的資料。 26. —種半導體裝置之製造方法,其包含有: 具備從終端進入含有包括資料庫和表明對上述資料庫的 處理步驟的多個操作邏輯的邏輯程式的資料庫伺服器進行 存取的步驟,上述資料庫存放半導體裝置製造所需的資 料,上述邏輯程式的操作邏輯,係由上述終端提供的邏輯 編號予以識別; 又具備在上述資料庫伺服器中,按照識別的操作邏輯對 上述資料庫進行存取,執行存取所得資料的處理,並將該 執行結果所得的資料傳送給上述終端的傳送步驟;及 在上述終端中,按照該傳送的資料,執行規定的處理的 執行步驟,上述規定的處理,係包含控制上述半導體裝置 之製造處理條件的處理。 2 7.如申請專利範圍第2 6項之半導體裝置之製造方法, 其中還具有以下步驟: 從上述終端,通過中繼伺服器進入上述資料庫伺服器予 以存取之步驟; 通過上述中繼伺服器,將上述資料庫伺服器傳送來的資C: \ 2D-CODE \ 90-02 \ 89124554.ptd Page 72 479172 6. Scope of patent application The terminal is the control device of the manufacturing device of the semiconductor device; the above-mentioned database server stores the control data of the above-mentioned manufacturing device. 2 5. The relay server according to item 19 of the scope of patent application, wherein the plurality of computer terminals are control devices of a semiconductor manufacturing device; the above-mentioned package program includes a communication program for accessing a database server; the above-mentioned data The library server stores control data of the semiconductor manufacturing apparatus; the control data includes data indicating processing conditions of the semiconductor manufacturing apparatus. 26. A method for manufacturing a semiconductor device, comprising: a step of accessing a database server including a logic program including a database and a plurality of operation logics indicating processing steps of the database from a terminal, and accessing the database server; The above-mentioned database stores the data required for the manufacture of the semiconductor device, and the operation logic of the above-mentioned logic program is identified by the logical number provided by the terminal; and it is also provided in the above-mentioned database server to perform the above-mentioned database according to the identified operation logic. And accessing, performing the processing of accessing the obtained data, and transmitting the data obtained by the execution result to the above-mentioned terminal; and in the above-mentioned terminal, performing the prescribed processing execution step in accordance with the transmitted data, the above-mentioned prescribed The processing includes processing for controlling the manufacturing processing conditions of the semiconductor device. 2 7. The method for manufacturing a semiconductor device according to item 26 of the patent application scope, further comprising the following steps: a step of accessing the database server from the terminal through the relay server to access the database server; and Server that sends the information from the database server C:\2D-CODE\90-02\89124554.ptd 第73頁 479172 六、申請專利範圍 料中繼到上述終端之步驟;及 上述中繼伺服器具有判決上述終端的通信要求是否允許 的步驟。 2 8.如申請專利範圍第2 6項之半導體裝置之製造方法, 其中還具有以下步驟: 由中繼伺服器中繼上述終端發來的通信要求之步驟; 將上述資料庫伺服器傳來的資料存放到Web現場之步 ’ 驟。 * 2 9.如申請專利範圍第2 6項之半導體裝置之製造方法, 其中具備在上述終端登記所需作業並管理該登記條件的步 驟,上述作業表明定期執行的對上述資料庫伺服器的詢問 處理; 該製造方法還具有以下步驟·· 按照上述登記條件,進入上述資料庫予以存取伺服器, 並將該存取結果存放到規定的Web伺服器之步驟;及 將上述Web現場的資料下載到上述終端之步驟。C: \ 2D-CODE \ 90-02 \ 89124554.ptd Page 73 479172 VI. Patent application step of relaying to the above terminal; and the above relay server has the step of judging whether the communication requirements of the above terminal are allowed. 2 8. The method of manufacturing a semiconductor device according to item 26 of the patent application scope, further comprising the following steps: a step of relaying a communication request from the terminal by a relay server; and transmitting the data from the database server Steps for storing data on the Web site. * 2 9. The method of manufacturing a semiconductor device according to item 26 of the scope of patent application, which includes the steps of registering a required job at the above terminal and managing the registration conditions. The above job indicates a query of the database server that is performed regularly. Processing; The manufacturing method also has the following steps: · The steps of entering the database to access the server and storing the access result to a prescribed Web server in accordance with the above registration conditions; and downloading the data on the Web site Steps to the above terminal. C:\2D-C0DE\90-02\89124554.ptd 第74頁C: \ 2D-C0DE \ 90-02 \ 89124554.ptd Page 74
TW089124554A 1999-11-22 2000-11-20 Communication system, database server, control unit, processing terminal, relay server, and method of manufacturing a semiconductor TW479172B (en)

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
JP33108699 1999-11-22
JP2000144412 2000-05-17
JP2000278611A JP2002041465A (en) 1999-11-22 2000-09-13 Communication system, database server, controller, processing terminal, relay server and manufacturing method of semiconductor device

Publications (1)

Publication Number Publication Date
TW479172B true TW479172B (en) 2002-03-11

Family

ID=27340455

Family Applications (1)

Application Number Title Priority Date Filing Date
TW089124554A TW479172B (en) 1999-11-22 2000-11-20 Communication system, database server, control unit, processing terminal, relay server, and method of manufacturing a semiconductor

Country Status (4)

Country Link
JP (1) JP2002041465A (en)
CN (1) CN1297202A (en)
DE (1) DE10057010A1 (en)
TW (1) TW479172B (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
TWI663493B (en) * 2017-11-08 2019-06-21 日商三菱電機股份有限公司 Work evaluation system and work evaluation method

Families Citing this family (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7272795B2 (en) * 2003-06-27 2007-09-18 Microsoft Corporation Micro-monitor to monitor database environments
JP4568150B2 (en) * 2005-03-30 2010-10-27 株式会社日立ハイテクノロジーズ Processing device and processing device system
JP2007004222A (en) * 2005-06-21 2007-01-11 Nomura Research Institute Ltd Data retrieval system and data retrieval program
JP2010117975A (en) * 2008-11-14 2010-05-27 Kyocera Mita Corp Image forming system, terminal device, server, image forming device, and image forming method
JP2012160049A (en) * 2011-02-01 2012-08-23 Nec Corp Database management system and master data management method of database
JP7367312B2 (en) * 2019-03-06 2023-10-24 富士電機株式会社 Program distribution device and program distribution method
CN111787091A (en) * 2020-06-28 2020-10-16 上海电力大学 Fan blade state monitoring method and system based on wireless Internet of things
CN112272190B (en) * 2020-11-10 2022-05-31 网易(杭州)网络有限公司 Data access method and device
CN115633107B (en) * 2022-11-21 2024-09-10 烟台东方威思顿电气有限公司 DL/T719 protocol analysis method and electric quantity acquisition terminal

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
TWI663493B (en) * 2017-11-08 2019-06-21 日商三菱電機股份有限公司 Work evaluation system and work evaluation method

Also Published As

Publication number Publication date
JP2002041465A (en) 2002-02-08
CN1297202A (en) 2001-05-30
DE10057010A1 (en) 2001-07-19

Similar Documents

Publication Publication Date Title
CN111913734B (en) Online development platform based on micro-service technology system
CN111831269A (en) Application development system, operation method, equipment and storage medium
US20160335293A1 (en) Remote data object publishing/subscribing system having a multicast key-value protocol
CN104094234A (en) Virtual channel for embedded process communication
CN110134494B (en) Container automatic management method based on Docker container
TW479172B (en) Communication system, database server, control unit, processing terminal, relay server, and method of manufacturing a semiconductor
TW202105336A (en) Development method, system and computer equipment for course package and storage medium thereof
US20110283284A1 (en) Distributed business process management system with local resource utilization
CN113037891B (en) Access method and device for stateful application in edge computing system and electronic equipment
CN116982029A (en) Hosting event-based applications
CN113486095A (en) Civil aviation air traffic control cross-network safety data exchange management platform
CN101861581A (en) Network operating system
CN103763325B (en) Method for building IP security product development environment
CN116150540B (en) System and method for realizing one-key switching of exhibition item content based on meta universe and cloud platform
CN111970192A (en) Information editing method and device based on session group
CN116048517A (en) API (application program interface) generating method, system and device based on B/S (browser/Server) architecture application system
CN110855562A (en) Internet of things data distribution management method and system, storage medium and management terminal
US12093705B2 (en) System and method for simple object access protocol (SOAP) interface creation
CN113064987B (en) Data processing method, apparatus, electronic device, medium, and program product
CN104378411A (en) Service exchange system
CN113542323B (en) Service processing method, device, equipment and computer readable storage medium
JP2006309697A (en) Computer system, program for computer system, and program generating application program based on spreadsheet program among the programs
Hirvonen Design and implementation of Andon system for Lean manufacturing
JP3632845B2 (en) File exchange device
JP2005258937A (en) Collaboration system

Legal Events

Date Code Title Description
GD4A Issue of patent certificate for granted invention patent
MM4A Annulment or lapse of patent due to non-payment of fees