TW561351B - Data updating method and system - Google Patents

Abstract

The present invention is a data updating method and system, which is a data updating system for the users of each client computer device to monitor the data change in the server. The method is applied to the server containing data updating execution module and data reading execution module, and making the server firstly establishing the data field library storing each field data sent from the data generation source, and the result table in the data field library corresponding to each data field. The method includes the following steps: first, when the data generation source transmits data into the server, the transmitted data is stored in the data field library; next, when reaching data updating time in the operation of the server, the data updating execution module extracts each field data from the data field library, and stores the extracted field data into the result table; then, when reaching data reading time in the operation of the client computer devices, sending a data reading request to the server to make the data reading execution module in the server to read data from the result table; and, transmitting the data in the result table according to the client computer device sending the data reading request to let the client computer device display the extracted data for the users of the client computer devices to monitor the data in the server.

Description

561351 Printed by the Consumers' Association of Wisdom-Property Bureau of the Ministry of Economics; "The paper size applies the Chinese National Standard (CNS) A4 specification (210 X 297 mm) A7 V. Description of the invention (1 [Field of invention] This invention relates to -A technique for updating data, and more specifically, a method and system for updating data to reduce the number of servers in the case where users of multiple client-side electronic devices monitor server data changes The workload of updating data. [Background of the Invention] Generally, a large amount of data is stored in a server to provide clients (Clien〇 access to its data, this architecture environment-generally called Master-slave architecture (CHent / Server) environment, which provides a structure to reduce costs in data maintenance, update, and transmission. For example, the most popular global information network (www.website.com) WWW) is a typical master-slave architecture application. Each host has a server listening to the CP port number 80, which is used to wait for the client's connection response (usually a browser). Later, the client sends a request, and the server sends a response, and then releases the response. However, if the server processes the data update requirements of several clients at the same time at the same time, it will increase the workload of the server, For example, when there are N clients in the master-slave architecture, and each client submits a data update request to the server every minute, the server will perform 60 × N responses within one hour. 凊 Refer to Section 1 The diagram is used to explain the data transmission processing architecture diagram between the client computer device 2 and the server 1. With the architecture diagram, the workload of the server 1 can be reduced. Among them, the server 丨 and the client computer An additional Agent Server 3 is added between the connection frameworks of Device 2 and an agent program is built in the Agent Server 3. The agent 16318 ^ ^ --------- line (please read the back first) Please note this page, please fill in this page again.) Ministry of Economy, Wisdom. ¾ Printed by Peicai Industry Bureau, Consumers ’Cooperative Association η 2 561351 A7 ____B7 V. Description of Invention (2) The program can be designed to run the proxy server by V1SUal Basic software. Servo 1 submits data _ fetch request for processing, so that the proxy server can grasp the information in server 1 or supervise the different actions of the existing resources in server i at any time. In addition, it is used in this proxy feeder 3 Wind reads Sockets to design an application program interface (AppUcati〇n pr〇grammi ^

Interface (API), which is used to support TCp / ip or udr price

PrOt⑽D's transmission protocol 'allows the proxy server II 3 to identify the origin point machine ... the server D and the destination point machine (ie, each client computer device 2), so each client computer device 2 needs to When a data update request is submitted to the server 1 in minutes, first, the proxy server 3 makes a request to the server 11 1 every t minutes:-the data update request is owed, and the uniform server 1 completes the poor material update and responds to the proxy server 3 After that, the agent feeder 3 will respond to the update information of the client according to the ^ address of each client computer device 2. In this way, the θ Η β level makes the servo state perform only 60 responses in one hour. . Although the architecture shown in Figure 1 can greatly reduce the original work load of the server i, the additional server-agent server 3 is required, thereby increasing the system cost. In addition, each client computer device 2 is also required. The API is built to support the π or 卿 transmission protocol, so as to establish an agreement with the proxy device: data transmission interface, so it takes more time than the previous structure, and also increases the complexity of the system architecture. Data = Two clients need time to monitor the data in the feeder. __ Ertongzhong 'For example, the production and sales personnel enter a new version or a changed production server. ^ Each production line host. W times. 4 This paper size applies 16318 (Please read the precautions on the back before this page)-Line 5 Stone 1351 'A7

3 16318 561351 A7 Printed by the Consumer Cooperative of the Intellectual Property Bureau of the Ministry of Economic Affairs, the description of the invention (4 / device; and 4) the client computer device displays the read data on a display for the user to monitor the server Changes in the data. The data update system of the present invention is a data update system that is applied to a client computer attacking a user's monitoring server for data movements. The data update system includes: at least _ 4 server servers ~ Q. Xi / Eight Dingbei Beibei To update the time, each client computer device has a network connection with the feeder, which is preset to the data reading time; and the data generation source has a network connection with the server: The rack materials generated by the data generating source are transmitted to the server for the client computer device to regularly monitor the data movement in the server; wherein, the feeder is at least: including. Data field library, It is used to misstore the niche data passed in from the data generation source; the result table has multiple data booths, and each of the data booths corresponds to each data bay in the poor material bay database. Data update execution module: If the server reaches a data update time during the operation of the server, the data update execution module will go to the data field library to obtain the remaining stop data and store it in the corresponding In the results table, Based on the update of the shelf data in the result table and the data reading execution module, if the client computer device is in operation, the client computer device will send a data reading request to the feed The server enables the data reading execution module to receive the data reading request from the client computer device, and takes out the shed data from the result table and transmits it to the client computer device. The data update method and system of the present invention are that the update data is stored in the result table, so that the multi-client computer device A can read the updated data, so that the server responds to each client computer device data update request. This paper is used in the national standard (CNS) A4 specification (210 X 297 mm) (please read the precautions on the back and then 3 pages)

-Order · T 丨 line 丨 i \ 16318 561351 Printed by the Ministry of Economic Affairs, Intellectual Property, Bureau of Consumer Cooperatives A7 _______B7__ 5. Description of the invention (5). It is the number of times the data is updated relative to the server itself, that is, different In the conventional technology, the server data update processing times are multiplied according to the number of client computer devices. Therefore, when multiple client guest devices simultaneously and multiple data read requests to the server, the server will not be increased. Workload of the server. [Brief description of the illustrations] In order to make the above and other objects, features, and advantages of the present invention more comprehensible, the preferred embodiments will be described in detail with the accompanying drawings to explain the embodiments of the present invention in detail. The content of the diagram is briefly described as follows: FIG. 1 is a network architecture diagram for explaining a data updating method of a traditional master-slave architecture; FIG. 2 is a system architecture block diagram showing the first aspect of the data updating system of the present invention. A block diagram of a system architecture according to an embodiment; FIG. 3 is an operation process group of an embodiment of the data updating method of the present invention, and FIG. 4 is a diagram illustrating a client computer device and a server during the steps described in FIG. 3 Figure 5 is a block diagram of the system structure of the first embodiment of the new system of the present invention and the new system of Beding Yewen; and Figure 6 is a block for explaining the data update program of Figure 5 Illustration. [Detailed description of the preferred embodiment] Refer to FIG. 2 for a block diagram of a system architecture of the first embodiment of the data updating system of the present invention. As shown in the figure, the data update system includes at least-server 1 ', multiple client computers with i 2 installed, and GNS A4 secret 0: ^^ 5 16318- ------------ I -------- ^ --------- ^ (Please read the notes on the back before filling this page) 561351 A7 V. Invention Explanation (6) The source 4 of the data is generated, and the source data is read back. The original 4 is connected to the server 1 through the network system (not shown), and each client Lei Cong makes the corpse device 2, also uses the network. The road system is connected to the server 1, where the data update system of the owner and the example is applied to, for example, a production line management system. ^ This source of generation 4 includes, for example, production and sales personnel or related supervisors. The order of the unit is from the production counter of the Jensei Securities <;, and the production counter is immediately transferred to the server 1 j server 1 through the network system. Therefore, the server 1 is used for storage, for example. The main volume of the production plan is a king machine and the client computer devices 2 ′ are, for example, the mainframes of each production line. The transparent system and the server 1 are connected to read the feeding service in real time. Γ health data as stored, each production line (e.g., a client computer device 2) produced according to the production day count made. The client computer device 2 (for example, I ** A, 1 is, for example, a production line host) includes a browser 20 and a timing group citrus group 21, so that the browser through the network system ( For example, it is “Internet 1” (not shown) to obtain the data stored in the server Γ and display the liver on the display (not shown), and use the timing module 21 to count It Θ # σ For each client computer device 2, when the data reading request is submitted to the server Γ, the time counted to the right reaches a predetermined data reading time, and # 芡 makes the client computer device 2 to the server The device Γ makes a request for data reading. The server 1 includes data 襕 ... 〇, a result table u, a data update execution module 12, and a data read execution module 13 for data transmitted from the data generation source 4 (for production and sales personnel). The production plan transmitted) is stored in the data paste position 10, where 'the shell material in the result table ^ and each of the assets in the shell material storage library 10'. If the server Γ reaches a When the scheduled information is updated,

The paper size is applicable to the national standard (CNS) A4 specification of the towel ⑵0 X 16318 (please read the precautions on the back first and then 1 ^? | This page)

V Printed by Qin 1351 B7, Employee Cooperative of Intellectual Property Bureau of the Ministry of Economic Affairs 5. Description of the Invention (7) The update execution module 12 will store the data in the library 10; therefore, when the feeder i receives the client electric mouth, ; If the data read request of Table 11 is' The data read execution mode ... So = the poor material is taken out, and according to the client mouth of the client who made the data read request, the data in Table 11 is transmitted. Set 2 This way, if there are multiple client computer devices 2, when the data read request is issued, the feeder! , You only need to transfer the data stored in the result table: 1φ4 to the client computer installation and store the client computer device 2, and perform data update processing :::::

Li material update method and system ’have changed the data in advance = order

:: 'Bianjian existence result table ", client computer device L In addition, the client computer device 2, the timing module = server is not shown in this embodiment), in order to count the server: 〇 The client computer device 2 'transmits the result table n to the stored operation time'. If the counted time reaches m when the data transmission =, the server Γ actively sends data to the client computer device 2. Please refer to FIG. 3, which is used to show the operation flow chart of the embodiment of FIG. 2. This embodiment mainly describes the operation relationship between the feed source 4 and the feeder. First, in step S1, it is judged whether or not data from the data generating source 4 is transmitted to the server Γ. If data is transmitted, the process proceeds to step S1; otherwise, step S1 is performed. In step S2, 'the transmitted data is stored in the data location 10, Guan Jiaxian (CNS) A4 secret X 297 public t) ----- ~. 7 16318 561351 B7 V. Description of the invention (8) and Based on the incoming data niche ', proceed to step S3. The result of the table should be Table II. Then, in step S3, when it is judged that the feeding service is crying and the update time is reached, the update time is continued. If the data is updated in step S4, the process proceeds to step S3. The stop data in the result table will be stored in the result table next time. 2 Please refer to Figure 4, which is used in the shell material fields. /, S child Ming in the process, feeder! , And the client electric drive device = the step Hui shown first, at step S5t, determine the operation relationship between the client electric drive. When the update time of the poor material is reached, if it reaches $ & 2, whether step S6 is reached, otherwise step S5 is performed. ,,, And time, then proceed to step S0, the client computer wears the reading request, and then continues to step ~ ... 1 server! , Put forward the server in step S7! When receiving the data read request, make the data ^ brain device 2, the table ii read the stop data and go to 13 to the result, then continue to step 88. The client ^ the electric nozzle device 2 is connected to the display of the client computer device 2 in step S8 (the field data transmitted by the server Γ is not shown in the figure. According to the first embodiment of the present invention The data update method and system, because the server 1 stores the changed data in the result table η in advance, and the client computer device 2 sends a request to the feeder to the feeder! = Server 1 ' Only the data in the result table 11 is transmitted, and the data update processing is not performed for each client computer device 2. Therefore, this paper size applies to China National Standards (CNS) A4. (210 x 297 mm) ------- 8 16318 &; 5 ministry ^. A property bureau employee consumer cooperatives seal 8561351 ----------B7 —_ V. Invention Explanation (9) Reduce the workload of the server 1 '. Figure 5 is a block diagram of the second embodiment of the data update system of the present invention, and Figure 6 is a block diagram of the data update program used in the second embodiment. As shown in Figs. 5 and 6, the data updating system of the second embodiment is constructed with an input / output interface 14. 15. Memory 15 and server i of the data storage medium 16, and the data storage medium 16 includes a data update program as shown in FIG. 6 and the aforementioned data block bank 10 and result table 11. The processor 15 can execute the data update program 16 to perform the tasks of the data field library 10, the data update execution module 丨 2, and the data reading and ordering module 13 described above. During the program execution, all data The transmission and reception are performed through the round-out / enter interface 14. As shown in FIG. 6, the data update program 160 includes a data block storage program 161, an update program μ], and a read program 163. In addition, in this embodiment, The data update program 16 is stored in the data storage medium 16, but it is not limited to this. The data update procedure can be stored in a read-only memory (such as MASK ROM) that can be read by another processor 15 when the formula 160 is not large. , EPROM, EEPROM). In the above system, the processor 15 may be a microprocessor (m1Crócessor) or a central processing unit (cpu), and the memory may be a dynamic random access memory (DRAM). Data storage media cannot be The hardware, tape, or optical disc 'data blocking library I has the data passed in from the data generating source 4 as described above, and the result table u also has the data update library 12 executing data on the data field library 10 as described above. Update the latest information obtained after processing. This paper is Lai Jiacai (CNS) A4 specification (2lQx 297 Gongwang 16318 ------------- Installation -------- Order .--- ----- line (please read the precautions on the back before filling in this page) 561351 A7 Consumer Property Bureau of the Ministry of Economic Affairs F Cooperative Seal V. Invention Description (10) The following information is used to store the data in 162, read The work of the program 163 "4 formula 161, the data update of the execution update program & α β, the target description details the data update method applied to the Beco update system in FIG. 5. The above data block is stored in Volume 7 ^ Ί ^ ^ ^ Program 161 is to establish a network connection between the server and the data source 4 and the data is sent to the source 4 'In addition, the data field device 1, according to the incoming data 扪 "^ in the servo response result table 11' and crying while processing ... Need to store a temporary memory 15 in the memory 15 The value of the material update time is used to determine whether or not the server has arrived .... The operation process of the word server Γ is not reached when the negative material update time is reached. When the update time is reached, the update program 1 62 is executed. To the data store A, the corresponding fields are obtained from ^ and the bit library 10, and they are correspondingly stored in the result table u. After updating each of the shelf data stored in the result table U, when When the feeder 1 'receives the data reading request from the client computer device 2, the reading program 163 goes everywhere. A # ^ Master, ··· Fruit table 1 read data And transmits the read data to the client computer device 2 that made the data read request. In the second embodiment, the system side In the figure, the data fields corresponding to the data block library 10, the data update execution module 12 and the data read execution module π of the first embodiment block diagram are stored in the program 161, the update program 162, and the read Although the program 163 (such as the ODBC interface) is a software program that can be executed by the processing 1§ 15 is not limited here, it can also be made into hardware with specific functions, such as integrated circuit (IC), and processing The controllers work together. I The above description is only a preferred embodiment of the present invention, and is not intended to limit the paper size to the national standard (CNSM4 specification (210x297 ^ 7 Thread 163! 8 561351 A7) V. Description of the invention (11 determines the scope of the essential technical content of the present invention. The essential technical content of the present invention is broadly defined in the scope of the patent application described below. Any technical entity or method completed by others is a pseudo-counterfeit. Those defined in the scope of patent application are all the same, or are within the scope of the same equivalent patent. Alteration Xiao will be regarded as the culprit here [Element Symbol Explanation] # #Economic Ministry Wisdom. Property-Bureau Consumer Cooperative Print 1 '1 2, 2 3 4 10 11 12 13 14 15 16 20 21 150 160 161 162 163 server client computer device proxy server data generation source data block database result table data update execution module data read Run module output / input interface processor data storage media browser timing module memory data update program data field save program run update program read program

^ -------- ^ --------- ^ (Please read the notes on the back before filling this page)

Claims (1)

561351 Α8 Β8 CS D8 Patent application scope A data update method, which is applied to a data update system for users of client computer devices to monitor data changes in the server, and the server is set up in advance to store The data library of each block data and the result table corresponding to each data booth transmitted from the data generating source. The data update method includes the following steps: 1) A data update time is scheduled by the data update system. When the data update time is reached during the operation of the feeder, the data of each block is taken from the data block library, and the obtained block data is stored in the result table to correspond to the data blocks of the data block library. In the data block, and (Please read the precautions on the back and then on this page) Employees of the Intellectual Property Bureau of the Ministry of Economic Affairs Consumption and Printing 2) The data update system is used to book a data reading time, and the operation process of the computer device When the data reading time is reached, the client's electric contact device sends a data reading request to the server, so that the block is removed from the result table. Data and pass it to the client brain device that requested the data. 2. The data updating method according to item 1 of the scope of patent application, wherein the data updating system is constructed in a connection system between at least one server and multiple client devices. 3. The method for updating data as described in item 2 of the scope of patent application, where the server and the source of data generation are connected via a network. 4. If the data updating method of item 3 of the scope of patent application is applied, the client computer device is a computer. 5. If the data updating method of item 4 of the scope of patent application, 1 includes a method for users to send the data to read, please apply this paper size to Chinese National Standard (CNS) A4 specification (21〇χ 297 When the client reads by the client server, the client computer 'the company, the client, the electricity, and the I-line. 12 16318 561351 A8 B8 CS D8 A, the scope of the patent application updates the information The system proposes a Browser that monitors the data changes of the server. 6. If the data updating method of the first item of the scope of patent application, the data updating system is applied to the production management system. 7, such as applying for a patent The method for updating the data in item 6 of the scope, wherein the source of the data refers to the production plan input by the production and sales personnel or the supervisor of the production line. : Β the data block library; the result table; a data update execution module for performing the step of updating the data fields in the result table; and (Please read the precautions on the back before filling this page) The data reading execution module is used to perform step 2) to read the data fields in the result table, and obtain the required information according to the incoming funds. The client computer device transmits the self-transforming β material. ° The read data 9: = The data update method of item 8 of the profit range, where the server includes-a timing module 'to perform the step u to count the time of reading the data: update System execution 10. If the method for updating material in item 丨 of the patent application scope, the electric contact device on the client side includes a timing module for performing the task of “the customer needs to submit a data reading request time to the feeder”. •-# 2 ^ New method for each client to use »163 561351 A8 B8 CS D8 Cancel 6. The data update system for data changes in the patent application monitoring server is applied to the data update execution module And the data reading execution module server, and preliminarily causing the server to establish a data block library for storing each block data passed in from the data generating source, and a result table corresponding to each data block, the The data update method includes the following steps: 1) When the data generation source transmits data to the server, the server causes the server to store the data transmitted from the data generation source in the data block database; 2) When the server arrives during the operation of the server, Capital When the time is updated, the data update execution module fetches the data of each block from the data block database, and stores the obtained block data in the result table to the data block corresponding to each data block of the data block database. 3) When the client computer device reaches the data reading time during operation, it sends a data reading request to the server; 4) The server receives the data reading request from the client electronic device When the data reading execution module reads the data from the result table; 5) the data reading execution module transmits the data in the result table according to the client computer device that receives the data reading request; and 6) the client The electric device displays the acquired data for the user of the client electric device to monitor the data in the server. 12 · For example, the method for updating data in the scope of the patent application No. 11, wherein the f :: new system is built on In the connection system of at least one feeder and a plurality of client electric contact devices. 13:! II The data updating method of the 12th item, wherein the feed and the data generation source are connected by a network. I Order 14 16318 5,61351 A8 B8 CS D8 Printed by the Consumer Cooperatives of the Intellectual Property Bureau of the Ministry of Economic Affairs1. Application for patent scope 14. If the information in the scope of application for item 13 of the patent application is more ancient, earth-bamboo ruler new method, its contention The client computer device is a computer. 15. The data updating method according to item 14 of the scope of patent application, wherein the computer includes a drama that can be used to transmit the data reading request, and to the data updating system to monitor the data changes of the server. Browser. 16. If the data updating method of item 11 of the scope of patent application is applied, it is claimed that the data updating system is applied to the production management system. 17. For the method of updating the data in the scope of application for item 16, the source of the data refers to the production plan that is rotated by the production and sales personnel or the production line supervisor. 18. —Species = beautiful material update system for users of each client electronic device to monitor data changes in the server, including at least one server; multiple client computer devices, which are separately associated with the There is a network connection between the servers; and a data generation source has a network connection with the server, so that the data generated by the data generation source is transmitted to the server for monitoring by the client computer device The situation of the data transferred into the server; 'Wherein, the server includes at least: a data bit library, which stores the bit data passed in from the data generating source; a result table, which has multiple data fields, and The various papers of the private paper are in accordance with China National Standard (CNS) A4 specifications (2) 0 X 297 I -------- ^ --------- (Please read the notes on the back before filling out this page) 15 16318 561351 cs D8 $, the scope of patent application is in the poor material warehouse. Each data block is created correspondingly; the shell material update execution module, if the server reaches one shell ^ update time, the data update execution module goes to the data storehouse to retrieve the niches data stored by the server. And correspondingly store it in the result table to update the stop data in the result table, as well as the execution of data reading, and if the client computer device is in the operation process, when the data is read in the material, the client | The brain device sends a data reading request to the server, so that the data reading execution module receives the data reading request from the client computer device, and removes the blocking data from the result table and transmits it. To the client computer device. 19 · -A kind of data updating system for users of each client computer device to monitor data changes in the server, including: at least one server; multiple client computers, each device is separately connected to the server There is a network connection between the devices; and a data generation source has a network connection with the server to transfer the shed data generated by the data generation source into the feeder, which is consumed by employees of the Intellectual Property Bureau of the Ministry of Economic Affairs Combined, the company prints it for the client's electronic device to monitor the situation of the data transferred into the server; where the server includes at least: the data block library 'stores the blocks passed in by the data source Information; 11 1 __ .--.... This paper < degree is applicable to Chinese National Standard Return (CNS V4 specification (210 X 297 mm) result table, which has multiple data niches, and each data column Positions ^ Established corresponding to the various positions in the data booth library • 16 16318 561351 Consumption Cooperative System of the Intellectual Property Bureau of the Ministry of Economic Affairs 17 A8 B8 CS D8 Module, if a data update time is reached during the server operation, the data update execution module goes to the data block library to obtain the stored block data and stores it in the result table accordingly to update the result table If the client computer device reaches a data reading time during the operation of the client computer device, the client computer device will send a data read request to the server, so that the server will send the stored data in the result table. The data is transmitted to the client computer device. 20 · If the data update system of the patent application scope item 18 or 19, wherein the client computer device is a computer. 21 · If the patent application is the data update system item 2G In #, the e-mail address includes a browser (Browser) that allows a user to transmit the data reading request on the server, and submits data reading to the server. 22 · If the scope of patent application is 18 or 19 Item data update system, in which the data update system is applied to the production management system. 23 · The data update system in item 22 of Rushen Patent, where the source of the data refers to the product Personnel or production line supervisor ’s rotation of the production plan. For example, the data updating system of item 18 or 19 of the “Patent”, where the feeding device includes a timing module, which is used to count the data reading of the client electric device ≪ 25. The data update system according to item 18 or 19 of the patent application scope, wherein the client computer device further includes a timing module for counting data read requests to the server. Time. Ben Zhang Zhang Qian Cai Jia Xian (CNS) A4 Yizheng 16318 -------- ^ --------- ^ (Please read the precautions on the back before filling this page)