546570 A7 B7 五、發明說明（ 經濟部智慧財產局員工消費合作社印製 發明背景： 本發明係一種更新各用戶端之資料庫應用程式之畫面資料之方法，尤指—用 戶端在更新一伺服端內某一資料庫之資料時，可將所更新之資料，傳送至其它用 戶端，以更新其它用戶端之應用程式之畫面上對應欄位內之資料，達成同步更新 各用戶端之資料庫應用程式之畫面資料之目的。 先前技藝： 近年來，由於網路技術之不斷倉撕，及網路軟硬體建構成本之大幅降低，許 多企業均能以較諸以往更爲低廉之費用，在其企業內部，或與其相關之上下游廠 商間，建立起企業網路，並結合資料庫系統之應用，以利用網路收集各項資訊， 並加以整理，進行各項統計及分析，俾便隨時掌握最新之資訊。尤其是各跨國企 業，在對各項商品之設計、開發、製造及行銷之全球化整合過程中，爲能根據各 區域內市場之不同需求，迅速設計及製作出符合市場需求之商品，並快速地行銷 至世界各地，除積極利用區域網路系統，不斷提昇其企業體內部之資訊溝通效率 外，亦更進一步利用網際網路，與其上下游配合廠商連線，以迅速且正確地獲$ 市場資訊，俾其能正確地掌握市場需求、迅速地完成貨品流通及大幅地縮減庫存 成本，令所製作出之商品，不僅能符合消費者之需求，且其價格亦具備市場之競 爭性。 一般言，現今各企業體內所建構之網路系統中，均包含有一網路伺服端 (Servo)及複數個用戶端(Client)，該伺服端中均設有一龐大之資料庫系統，該資 料庫系統包括複數個資料庫，用以儲存各企業體正常運作所需之各種記錄 (Record)，而各該記錄又依其特性，規劃有各個不同之欄位(Field)，例如：—般 製造商之產品訂單資料庫中，包括有訂單號碼、類型、零件名稱、單價…等欄位， 本紙張尺度適用中國國家標準（CNS)A4規格（210 X 297公爱） (請先閱讀背面之注意事項再填寫本頁) Φ ϋ I ·ϋ ϋ «1^ ϋ- ϋ an tmi tmte 訂 -----線. 546570 A7 B7 五546570 A7 B7 V. Description of the invention (Printed by the Consumer Cooperative of the Intellectual Property Bureau of the Ministry of Economics Background of the Invention: The present invention is a method for updating the screen data of database applications of each client, especially the client is updating a server When the data in a certain database is stored, the updated data can be transmitted to other clients to update the data in the corresponding fields on the screen of the other client's application to achieve the synchronous update of the database application of each client. The purpose of the program's screen data. Previous skills: In recent years, due to the continuous ripping of network technology and the significant reduction in the cost of network software and hardware construction, many companies have been able to reduce Within the enterprise, or with related upstream and downstream manufacturers, establish an enterprise network and combine the application of the database system to use the network to collect various information, organize it, perform various statistics and analysis, and then grasp it at any time The latest information, especially the multinational companies, in the global integration of the design, development, manufacturing and marketing of various commodities In order to be able to quickly design and produce products that meet market needs according to the different needs of the markets in each region, and quickly sell them to the world, in addition to actively using regional network systems, continuously improving the efficiency of information communication within its corporate body , And further use the Internet to connect with its upstream and downstream manufacturers in order to quickly and accurately obtain $ market information, which can correctly grasp market demand, quickly complete the circulation of goods and greatly reduce inventory costs, so that The manufactured products can not only meet the needs of consumers, but also have a competitive price in the market. Generally speaking, the network systems constructed in various enterprises today include a network server (Servo) and a plurality of Clients, each of which has a huge database system, the database system includes a plurality of databases for storing various records required for the normal operation of each enterprise, and each According to its characteristics, the records are planned with different fields, for example:-the general manufacturer's product order database, including the order Number, type, part name, unit price, etc. The dimensions of this paper are applicable to China National Standard (CNS) A4 (210 X 297 public love) (Please read the precautions on the back before filling this page) Φ ϋ I · ϋ «« 1 ^ ϋ- ϋ an tmi tmte order ----- line. 546570 A7 B7 five
、發明說明（9 /V 該等欄位即形成該資料庫內之一筆記錄；該複數個用戶端係分別與該伺服端相連 線，且分!e脷用一資料庫應用程式之畫面，令使用者可透過各該用戶端，進入該 伺服端之資料庫系統，以將資料輸入至該資料庫之記錄內，或至該資料庫之記錄 內查詢所儲存之資料。在此種網路系統中，由於任一用戶端在對該伺服端之資料 庫系統中之資料，進行更新時，該筆被更新之資料並無法同步傳送至其它用戶端， 故無法同步更新其它用戶端之資料庫應用程式之畫面資料。有鑒於此一缺失’許 多企業體在設計該等網路資料庫系統時，爲使各用戶端之資料庫應用程式之畫 面能隨時呈現最新之資料，均在該等網路資料庫系統中設計了一種可定時令各用 戶端至伺服端讀取異動資料之機制，俾使用者能隨時在各該用戶端之資料庫應用 程式之畫面上，檢視到最新之資料，此一作法，雖可有效解決前述缺失，惟卻大 幅增加了各用戶端進入伺服端讀取異動資料之頻率’而對伺服端造成極大之負 荷。 (請先閱讀背面之注意事項再填寫本頁) ·--------訂 經濟部智慧財產局員工消費合作社印製 發明綱要： 有鑑於傳統網路系統中，爲使各用戶端之資料庫應用程式之畫面能隨時呈現 最新之資料，各用戶端必須定時進入伺服端，讀取資料庫系統中之異動資料，而 造成對伺服端產生極大之負荷，發明人乃經過長久努力硏究與實驗，開發設計出 一種可令網路上各用戶端之資料庫應用程式之畫面資料同步更新之方法，俾藉由 該方法令一用戶端對伺服端內某一資料庫之資料進行更新時，可同步更新各用戶 端之資料庫應用程式之畫面資料，有效降低各用戶端進入伺服端讀取異動資料之 頻率，大幅減緩因此對伺服端所造成之負荷。 本發明之主要目的，係在一資料庫系統之伺服端內裝設一對照表’以藉該對 照表記錄複數個網路用戶端在該伺服端內之一資料庫系統中所開啓之資料庫檔 -----線' 本紙張尺度適用中國國家標準（CNS)A4規格（210 X 297公釐） 546570、 Explanation of the invention (9 / V These fields form a record in the database; the multiple client terminals are connected to the server respectively, and they are divided into two groups! E 脷 Use a database application screen, Allows users to access the database system of the server through each of the clients to enter data into the records of the database or to query the stored data in the records of the database. In such networks In the system, when any client updates the data in the server's database system, the updated data cannot be synchronized to other clients, so the databases of other clients cannot be updated simultaneously. Application screen data. In view of this lack, many enterprises are designing such network database systems in order to enable the database application screens of each client to present the latest information at any time. In the database system, a mechanism is designed to allow each client to read the transaction data from time to time. The user can check the database application screen of each client at any time. According to the latest information, this method can effectively solve the aforementioned shortcomings, but it significantly increases the frequency of each client entering the server to read the changed data ', which causes a great load on the server. Please fill in this page again for the matters needing attention) Order the printed invention outline of the consumer cooperative of the Intellectual Property Bureau of the Ministry of Economic Affairs: In view of the traditional network system, the screen of the database application for each client The latest information can be presented at any time. Each client must enter the server regularly to read the changed data in the database system, which causes a great load on the server. The inventor has developed and designed after long-term research and experiment. A method for synchronously updating the screen data of database applications of each client on the network. When this method is used, a client can update the data of a database in the server, and can simultaneously update each client. The screen data of the database application program effectively reduces the frequency of each client entering the server to read the transaction data, which greatly slows down the damage caused to the server. The main purpose of the present invention is to install a comparison table in the server end of a database system to record a plurality of network clients in a database system in the server end by the comparison table Opened database file ----- line 'This paper size applies to China National Standard (CNS) A4 (210 X 297 mm) 546570
N發明說明 名，俾任一用戶端更新該伺服端內某一資料庫之資料時，該用戶端可藉讀取該對 照表，辨識出其它用戶端所開啓之資料庫檔名，並將該用戶端所更新之資料，傳 送至其它用戶端，以更新其它用戶端之資料庫應用程式之畫面上對應欄位內之資 料，達成同步更新各用戶端之資料庫應用程式之畫面資料之目的。 爲便貴審查委員能對本發明之目的、形狀、構造裝置特徵及其功效，做更 進一步之認識與瞭解，兹舉實施例配合圖示，詳細說明如下： 圖示說明： 第1圖乃本發明之網路系統中伺服端與複數個用戶端之連線示意圖。 第2圖乃本發明之對照表之示意圖。 第3圖乃本發明之網路系統中伺服端之處理流程示意圖。 第4圖乃本發明之網路系統中用戶端之處理流程示意圖。 主要元件編號： 網路系統..........10 伺服端............11 用戶端.............12 對照表.............20 詳細說明： 按，在現今之網路系統中，伺服端與各用戶端之電腦設備間，係透過其上所 安裝之網路應用程式，依所設定之網路通訊協定，進行彼此間訊息之交換與溝通， 以利用TCP/IP通訊協定進行訊息傳輸之網路系統爲例，該網路系統之伺服端及 各用戶端之電腦設備，必須先透過其上所安裝之網路應用程式，設定一組IP位 址及通訊埠號碼(PORT)，該IP位址及通訊埠號碼之組合，即一般所謂之 本紙張尺度適用中國國家標準（CNS)A4規格（210 X 297公^ ) (請先閱讀背面之注意事項再填寫本頁) Φ--------訂 ----線- 經濟部智慧財產局員工消費合作社印製 546570 A7 B7 五、發明說明（4 ) 「Socket」，因此，右網路系統中任一*電腦設備欲進行訊息之交換與溝通，該二 電腦設備即必需具備一對相匹配之「Socket」，且需透過其上所安裝之網路應用 程式，設定TCP通訊協定，如此，網路系統中任~〜電腦設備在傳送訊息前，即 會g利用TCP通訊協定，先建立起與其它電腦設備間相連接之通訊管道，並在完 成訊息之傳送後，關閉該通訊管道。 本發明即利用則述網路系統中各電腦設備間，可彼此交換與溝通訊息之特 性，在網路系統之一伺服端內裝設一對照表，以藉該對照表記錄複數個網路用戶 端在該伺服端內之一資料庫系統中所開啓之資料庫槽名，俾任一用戶端更新該伺 服端內某一資料庫之資料時，該用戶端可藉讀取該對照表，辨識出其它用戶端所 開啓之資料庫檔名，並將該用戶端所更新之資料，傳送至其它用戶端，以更新其 它用戶端之資料庫應用程式之畫面上對應欄位內之資料，達成同步更新各用戶端 之資料庫應用程式之畫面資料之目的。 在本發明之一最佳實施例中，該網路系統10包含至少一伺服端11，及與該 伺服端相連接之複數個用戶端12，參閱第1圖所示，各該伺服端11及用戶端12 間係透過其上所安裝之網路應用程式，依所設定之網路通訊協定(可爲TCP/IP通 訊協定’但不侷限於此），進行彼此間訊息之交換與溝通。在本發明中，該伺服 端11中另裝設有一資料庫系統，該資料庫系統包含至少一個以上之資料庫，各 該資料庫係用以儲存所需之各種記錄，而各該用戶端12中貝盼別裝設有一可進 入該資料庫系統之資料庫應用程式，俾使用者可透過各該用戶端之資料庫應用程 式之畫面，進入該伺服端之資料庫系統，將資料輸入至該資料庫之記錄內，或至 該資料庫之記錄內查詢所儲存之麵。 該伺服端內並設有一對照表20，參閱第2圖所示，該對照表20設有複數個 欄位21、22、23，各該欄位21、22、23至少係用以儲存與該伺服端相連接之各 ------ s 冬紙張尺度過用中國國家標準（CNS)A4規格（21〇 X 297公爱） (請先閱讀背面之注意事項再填寫本頁) ίφ--------訂 -----線· 經濟部智慧財產局員工消費合作社印製 546570 A7N Invention description name: When any client updates the data of a database in the server, the client can read the comparison table to identify the database file name opened by other clients, and The data updated by the client is sent to other clients to update the data in the corresponding fields on the screen of the database application of the other client to achieve the purpose of synchronously updating the screen data of the database application of each client. In order that the review committee can further understand and understand the purpose, shape, structural device features and functions of the present invention, the embodiments are illustrated in detail with the illustrations as follows: Illustrations: Figure 1 is the present invention Schematic diagram of the connection between the server and multiple clients in the network system. FIG. 2 is a schematic diagram of a comparison table of the present invention. FIG. 3 is a schematic diagram of a server-side processing flow in the network system of the present invention. FIG. 4 is a schematic diagram of a processing flow of a client in the network system of the present invention. Number of main components: Network system ............ 10 Server end ............ 11 Client end ............ 12 Table ............. 20 Detailed description: Press, in the current network system, the server and the client computer equipment are connected through the network application program installed on it. According to the set network communication protocol, exchange and communication of information between each other. Take the network system that uses TCP / IP communication protocol for message transmission as an example. The server end of the network system and the computer equipment of each client end , You must first set a set of IP address and communication port number (PORT) through the network application installed on it. The combination of the IP address and communication port number, which is generally referred to as the Chinese paper standard (CNS) A4 specification (210 X 297 public ^) (Please read the precautions on the back before filling out this page) Φ -------- Order ---- Line-Printed by the Employees' Cooperatives of the Intellectual Property Bureau of the Ministry of Economic Affairs System 546570 A7 B7 V. Description of the invention (4) "Socket", therefore, if any * computer equipment in the right network system needs to exchange and communicate information, the two computer equipment are necessary Have a pair of matching "Socket", and need to set the TCP communication protocol through the network application installed on it, so any computer in the network system will use TCP communication before sending the message Agreement, first establish a communication channel with other computer equipment, and close the communication channel after completing the transmission of the message. The present invention utilizes the feature that computer devices in the network system can exchange and communicate with each other. A comparison table is installed in a server end of the network system to record a plurality of network users by using the comparison table. The name of the database slot opened by the client in a database system in the server. When any client updates the data of a database in the server, the client can read the comparison table to identify Name the database file opened by other clients, and send the data updated by the client to other clients to update the data in the corresponding fields on the screen of the database application of other clients to achieve synchronization Purpose of updating the screen data of the database application of each client. In a preferred embodiment of the present invention, the network system 10 includes at least one server 11 and a plurality of clients 12 connected to the server. As shown in FIG. 1, each of the servers 11 and 11 The 12 clients use the network application installed on them to exchange and communicate with each other according to the set network communication protocol (which can be TCP / IP communication protocol, but not limited to this). In the present invention, a database system is additionally installed in the server end 11. The database system includes at least one or more databases, each of the databases is used to store various records required, and each of the clients 12 Sinopec is not equipped with a database application that can enter the database system. Users can enter the database system of the server through the screen of the database application of each client to enter data into the database. In the database records, or go to the records in the database to check the stored faces. A matching table 20 is also provided in the server, as shown in FIG. 2. The comparison table 20 is provided with a plurality of fields 21, 22, and 23. Each of the fields 21, 22, and 23 is used to store at least Each of the servo terminals connected ------ s Winter paper scale used Chinese National Standard (CNS) A4 specification (21〇X 297 public love) (Please read the precautions on the back before filling this page) ίφ-- ------ Order ----- Line · Printed by the Consumer Cooperatives of the Intellectual Property Bureau of the Ministry of Economic Affairs 546570 A7
經濟部智慧財產局員工消費合作社印製 用戶端之IP位址及通訊瑋號碼，及各用戶端之資料庫應用程式在進入該伺服端 之資料庫系統後所開啓之相關資料庫檔名，俾任一用戶端進入該伺服端之資料庫 系統’更新該資料庫系統內某一資料庫之資料時，該用戶端可讀取該對照表20 之內容，以辨識出與該伺服端相連接之其它用戶端所開啓之資料庫檔名，並將所 更新之資料，傳送至其它用戶端，以更新該等其它用戶端之資料庫應用程式之畫 面上相關欄位內之資料，達成同步更新各用戶端之資料庫應用程式之畫面資料之 目的。 在該較佳實施例中，各該用戶端可透過其上所安裝之網路應用程式，進入該 伺服端之資料庫系統，並下載該資料庫系統之資料庫應用程式，加以執行。如此， 使用者即可透過各該用戶端上資料庫應用程式之畫面，將資料輸入至該資料庫之 記錄內，或至該資料庫之記錄內查詢所儲存之資料，此時，該伺服端將依下列步 驟進行處理，請參閱第3圖所示： (100) 偵測並讀取各該用戶端之IP位址及通訊埠號碼，及各該用戶端在該資 料庫系統中所開啓之資料庫檔名，並逐一將其寫入該對照表之對應欄位中； (101) 判斷各該用戶端在進入該伺服端後，是否有對該資料庫檔名所對應之 資料庫內之記錄，進行更新或異動處理，若否，返還步驟(100) ’重覆偵測及判斷 之動作；否則，繼續下列步驟； (102) 若任一用戶端在進入該伺服端後，有對該資料庫檔名所對應之資料庫 內之記錄，進行更新或異動處理，貝[J在完成更新或異動處理後，立即將該對照表 之內容傳送至該用戶端。 該用戶端在接收到該伺服端傳來之該對照表後，將依下列步驟進行處理’請 參閱第4圖所示： (200)讀取該對照表中各欄位之內容，並據以辨識出其它用戶端所開啓之相 ______________ fs 本紙張尺度適用中國國家標準（CNS)A4規格（210 X 297公爱） i. MW--------訂 (請先閱讀背面之注意事項再填寫本頁) 546570 A7 B7 五、發明說明（g ) 關資料庫檔名； (201)將所更新之資料，傳送至其它用戶端，以更新該等其它用戶端之資料 庫應用程式之畫面上相關欄位內之資料，達成同步更新各用戶端之資料庫應用程 式之畫面資料之目的。 據上所述，由於在本發明中，任一用戶端對該伺服端之資料庫系統中之資料， 進行更新或異動處理時，該筆資料均將依該對照表同步傳送至其它用戶端，以同 步更新其它用戶端之資料庫應用程式之畫面上相關欄位內之資料，令各用戶端無 須定時至該伺服端中讀取異動資料，即能隨時在其資料庫應用程式之畫面上呈現 最新之資料，故可大幅減少各用戶端進入伺服端讀取異動資料之頻率，有效減緩 伺服端之負荷。 按，以上所述，僅爲本發明最佳之一具體實施例，惟本發明之構造特徵並不 侷限於此，任何熟悉該項技藝者在本發明領域內，可輕易思及之變化或修飾’皆 可涵蓋在以下本案之專利範圍。 (請先閱讀背面之注意事項再填寫本頁) 訂、---------線j 經濟部智慧財產局員工消費合作社印製 ^紙張尺度適用中國國家標準（CNS)A4規格（210 X 297公7爱）The Intellectual Property Bureau employee consumer cooperative of the Ministry of Economic Affairs prints the client's IP address and communication number, and the relevant database file name opened by each client's database application after entering the server's database system, 俾When any client enters the database system of the server, when the data of a database in the database system is updated, the client can read the content of the comparison table 20 to identify the server connected to the server. The database file name opened by other clients, and the updated data is transmitted to other clients to update the data in the relevant fields on the screen of the database application of these other clients to achieve synchronous update of each Purpose of the screen data of the client's database application. In the preferred embodiment, each client can access the database system of the server through the network application installed on the client, and download and execute the database application of the database system. In this way, the user can input data into the records of the database through the screen of the database application on the client, or query the stored data in the records of the database. At this time, the server It will be processed according to the following steps, please refer to Figure 3: (100) Detect and read the IP address and port number of each client, and each client opened in the database system Database file name, and write it into the corresponding field of the comparison table one by one; (101) determine whether each client has a record in the database corresponding to the database file name after entering the server , Update or change processing, if not, return to step (100) 'repeated detection and judgment action; otherwise, continue to the following steps; (102) if any client has access to the data after entering the server The record in the database corresponding to the library file name is updated or changed. After the update or change is processed, the content of the comparison table is immediately transmitted to the client. After receiving the comparison table from the server, the client will process it according to the following steps' (see Figure 4): (200) Read the content of each field in the comparison table and use it as a basis Identified the phase opened by other clients ______________ fs This paper size is applicable to China National Standard (CNS) A4 (210 X 297 public love) i. MW -------- Order (Please read the note on the back first) Please fill in this page again for matters) 546570 A7 B7 V. Description of invention (g) Relevant database file name; (201) Send the updated information to other clients to update the database applications of these other clients The data in the relevant fields on the screen achieve the purpose of synchronously updating the screen data of the database application of each client. According to the above, in the present invention, when any client updates or changes the data in the database system of the server, the data will be transmitted to other clients synchronously according to the comparison table. Synchronously update the data in the relevant fields on the screen of the database application of other clients, so that each client can be presented on the screen of its database application at any time without reading the transaction data from the server regularly. The latest data can greatly reduce the frequency of each client entering the server to read the changed data, effectively reducing the load on the server. According to the above, it is only one of the best specific embodiments of the present invention, but the structural features of the present invention are not limited to this. Any person skilled in the art can easily think of changes or modifications in the field of the invention. 'All can be covered by the patent scope of this case. (Please read the notes on the back before filling out this page) Order, --------- Line j Printed by the Consumers' Cooperatives of the Intellectual Property Bureau of the Ministry of Economic Affairs ^ The paper size applies to China National Standard (CNS) A4 Specification (210 X 297 male 7 love)