TWI831023B - Query system and its data update method - Google Patents

Abstract

A query system data update method. The query system includes a query server that stores multiple query data and at least one database server. Each database server stores an update list including multiple interested update customers, including the following Steps: (A) For each database server, periodically transmit a plurality of first update data corresponding to all customers to the query server according to a first update cycle, so that the query server updates all query data; and (B) For each database server, periodically transmit a plurality of second update data corresponding to the interested update customers to the query server based on the update list and a second update cycle that is smaller than the first update cycle. server, causing the query server to update query data corresponding to the clients interested in updating the query.

Description

Query system and its data update method

The present invention relates to a data updating method, in particular to a query system and its data updating method.

The data in the existing query system is updated at a fixed frequency, such as once a day. However, a single fixed frequency update may not satisfy customers who are eager to know the latest information.

However, if the data update frequency is shortened in order to improve customer experience, the system needs to update all customer data in a short period of time. The amount of information is very large and consumes a lot of system resources.

How to improve customer experience without consuming a lot of system resources has become an important issue.

Therefore, the purpose of the present invention is to provide a query system data updating method that consumes a small amount of system resources to improve customer experience.

Therefore, the query system data update method of the present invention includes a query server and at least one database server. The query server is connected to the at least one database server through a first communication network. The query server stores Multiple query data, each query data corresponds to a customer, each database server stores an update list, the update list includes multiple customers who are interested in updating, the query system data update method includes one step (A) and one step (B).

In this step (A), for each database server, the database server periodically transmits a plurality of first update data corresponding to all customers to the query server according to a first update cycle, so that the query The server updates all query data based on the first updated data.

In this step (B), for each database server, the database server periodically transmits a plurality of second update data corresponding to the interested update customers based on the update list and a second update cycle. The query server causes the query server to update query data corresponding to the interested update clients based on the second update data, wherein the second update period is smaller than the first update period.

Another object of the present invention is to provide a query system that consumes a small amount of system resources to improve customer experience.

Therefore, the query system of the present invention includes a query server and at least one database server.

The query server stores multiple query data, each query data corresponds to a customer.

The at least one database server is connected to the query server through a first communication network, and each database server stores an update list, and the update list includes a plurality of interested update customers.

For each database server, the database server periodically sends a plurality of first update data corresponding to all customers to the query server according to a first update cycle, so that the query server responds to the first updates Data updates all query data.

For each database server, the database server periodically transmits a plurality of second update data corresponding to the interested update customers to the query server based on the update list and a second update cycle, so that the query The server updates the query data corresponding to the interested update customers based on the second update data, wherein the second update period is shorter than the first update period.

The effect of the present invention is that the database server periodically transmits the second update data corresponding to the interested update customers to the query server according to the update list and the second update cycle, thereby only shortening the Waiting for the updated information time for users who are interested in updating can achieve the effect of improving the user experience by consuming a small amount of system resources.

11: Query server

12: Database server

101:First Communication Network

102:Second Communication Network

103: Client to be queried

201~204: Query program

301~304:Update program

41:Query server

42: Database server

401:First Communications Network

402: Second communication network

403: Client to be queried

501~508: Query program

601~604:Update program

Other features and effects of the present invention will be described with reference to the embodiments of the drawings. is clearly presented in, wherein: Figure 1 is a block diagram illustrating a first embodiment of the query system of the present invention; Figure 2 is a flow chart illustrating a query of a first embodiment of the query system data update method of the present invention. Procedure; Figure 3 is a flow chart illustrating an update procedure of the first embodiment of the query system data update method of the present invention; Figure 4 is a block diagram illustrating a second embodiment of the query system of the present invention; Figure 5 is A flow chart illustrating a query procedure of a second embodiment of the query system data update method of the present invention; and FIG. 6 is a flow chart illustrating an update procedure of the second embodiment of the query system data update method of the present invention.

Before the present invention is described in detail, it should be noted that in the following description, similar elements are designated with the same numbering.

Referring to Figure 1, a first embodiment of the query system of the present invention is illustrated, including a query server 11 and a database server 12.

The query server 11 is connected to the database server 12 via a first communication network 101, and is connected to a client 103 to be queried related to a client to be queried via a second communication network 102. The query server 11 stores multiple query data. Each query The inquiry information corresponds to a customer. The database server 12 stores an update list including a plurality of interested update clients.

It is worth noting that in this embodiment, the client 103 to be queried is, for example, a smart electronic device or a computer, the first communication network 101 is, for example, an intranet, and the second communication network 102 is, for example, the Internet. (Internet), but not limited to this.

A first embodiment of the query system data updating method of the present invention includes a query program and an update program, which is implemented by the first embodiment of the query system of the present invention shown in FIG. 1 .

Referring to Figures 1 and 2, the following describes the step flow of the query program of the first embodiment of the query system data update method of the present invention.

In step 201, the client 103 to be queried generates and sends a query request including the client to be queried to the query server 11.

In step 202, the query server 11 returns query data corresponding to the client to be queried to the client 103 to be queried.

In step 203, the query server 11 generates and sends a list update request including the customer to be queried to the database server 12.

In step 204, the database server 12 updates the update list according to the list update request, and the updated update list includes the customer to be queried.

It is worth noting that in this embodiment, the update list is blank by default. When a customer makes an inquiry, the inquiry server 11 will generate and send a list update request to the database server 12, so that the database server 12 will add the inquiry customer to the update list as an interested update customer. In other implementations, customers interested in updating can also be added to the update list in other ways, but are not limited to this.

Referring to Figures 1 and 3, the following describes the step flow of the update procedure of the first embodiment of the query system data update method of the present invention.

In step 301, the database server 12 periodically transmits a plurality of first update data corresponding to all customers to the query server 11 according to a first update cycle.

In step 302, the query server 11 updates all query data according to the first updated data.

In step 303, the database server 12 periodically transmits a plurality of second update data corresponding to the interested update customers to the query server 11 according to the update list and a second update cycle, wherein the second update data is sent to the query server 11. The update period is smaller than the first update period.

In step 304, the query server 11 updates the query data corresponding to the interested update customers based on the second update data.

It is worth noting that in this embodiment, the first update period is, for example, one day, and the second update period is, for example, 12 hours.

Referring to Figure 4, a second embodiment of the query system of the present invention is illustrated, including a A query server 41 and a plurality of database servers 42 respectively corresponding to a plurality of data types.

The query server 41 is connected to the database server 42 via a first communication network 401, and is connected to a client 403 to be queried related to a client to be queried via a second communication network 402. The query server 41 stores multiple query data, a software container (Container), multiple query times corresponding to the database servers 42, and weights corresponding to the database servers 42. Each query server 41 stores multiple query data. One query data corresponds to one customer and one data category. Each database server 42 stores an update list including a plurality of clients interested in updating.

It is worth noting that in this embodiment, the data type is, for example, one of credit card, loan, and acquirer, and the database servers 42 are, for example, a credit card database server, a loan database server, and an acquirer. Database server, this software container is used to provide query microservices (Microservices), but is not limited to this.

A second embodiment of the query system data updating method of the present invention includes a query program and an update program, which is implemented by the second embodiment of the query system of the present invention as shown in FIG. 4 .

Referring to Figures 4 and 5, the following describes the step flow of the query program of the second embodiment of the query system data update method of the present invention.

In step 501, the client 403 to be queried generates and sends a query request including the client to be queried and a data category to be queried to the query server 41.

In step 502, the query server 41 executes the software container to return query data corresponding to the client to be queried to the client 403 to be queried.

In step 503, the query server 41 executes the software container to generate and send a list update request including the customer to be queried to a target database server 42 of the data type to be queried.

In step 504, the target database server 42 updates its stored update list according to the list update request, and the updated update list includes the customer to be queried.

In step 505, the query server 41 executes the software container to update the number of data queries corresponding to the target database server 42.

In step 506, the query server 41 executes the software container to calculate a query value based on the data query times.

M為該等資料庫伺服器42的數量，W _i 為第i個資料庫伺服器42對應的權重，N _i 為第i個資料庫伺服器42對應的查詢次數，在其他實施方式中，該查詢數值亦可為該等查詢次數的總和，不以此為限。 It is worth noting that in this embodiment, the query value V can be expressed by the following formula:

M is the number of these database servers 42, Wi _is the weight corresponding to the i- th database server 42, Ni _is the number of queries corresponding to the i- th database server 42, in other embodiments, The query value can also be the sum of the number of queries, but is not limited to this.

In step 507, the query server 41 executes the software container to determine The query value is greater than a threshold value. When it is determined that the query value is greater than the threshold value, the process proceeds to step 508; and when it is determined that the query value is not greater than the threshold value, the process ends.

In step 508, the query server 41 generates another software container.

It is important to note that when the query value is greater than the threshold, it is predicted that the customer will have a large number of query needs in the future, so the query server 41 uses the characteristics of instantaneous replication and capacity expansion of the container to generate another software container to increase system services ( i.e. query microservices).

Referring to Figures 4 and 6, the following describes the step flow of the update procedure of the second embodiment of the query system data update method of the present invention.

In step 601, for each database server 42, the database server 42 periodically transmits a plurality of first update data corresponding to all customers to the query server 41 according to a first update cycle.

In step 602, the query server 41 updates all query data according to the first update data sent by the database servers 42.

In step 603, for each database server 42, the database server 42 periodically transmits a plurality of second updates corresponding to the interested update clients of the update list based on the update list it stores and a second update cycle. Update data to the query server 41, wherein the second update period is smaller than the first update period.

In step 604, for each second updated data, the query server 41 Update the query information of the interested customer based on the second updated information.

In summary, the query system and its data update method of the present invention periodically transmit the second updates corresponding to the interested update customers through each database server 42 according to the update list and the second update cycle. Updating data to the query server 41 only shortens the data update time for customers who are interested in updating, achieving the effect of improving customer experience by consuming a small amount of system resources. In addition, the query server 41 uses the query value and the Threshold value, when it is predicted that the customer will have a large number of query needs in the future, another software container will be generated to increase system services, so the purpose of the present invention can indeed be achieved.

However, the above are only examples of the present invention. They cannot be used to limit the scope of the present invention. All simple equivalent changes and modifications made based on the patent scope of the present invention and the contents of the patent specification are still within the scope of the present invention. within the scope covered by the patent of this invention.

11: Query server

12: Database server

101:First Communication Network

102:Second Communication Network

103: Client to be queried

Claims (6)

A method for updating data in a query system. The query system includes a query server and a plurality of database servers corresponding to multiple data categories. The query server is connected to the database servers through a first communication network, and is connected to the database servers via a first communication network. A second communication network is connected to a client to be queried related to a client to be queried. The query server stores a plurality of query data, each query data corresponds to a customer, and each database server stores an update list. The update The list includes multiple customers who are interested in updating. The query system data update method includes the following steps: (A) For each database server, the database server periodically transmits multiple records corresponding to all customers according to a first update cycle. of the first updated data to the query server, causing the query server to update all query data based on the first updated data; and (B) for each database server, the database server based on the updated list and A second update cycle periodically transmits a plurality of second update data corresponding to the interested update customers to the query server, so that the query server updates the second update data corresponding to the interested update customers based on the second update data. Query data, wherein the second update period is less than the first update period; (C) when the query server receives a query request from the client to be queried that includes the client to be queried and a data category to be queried, the The query server generates a list update request including the customer to be queried, and sends the list update request to a target database server of the data category to be queried; and (D) The target database server corresponding to the type of data to be queried updates the update list according to the list update request, and the updated update list includes the customer to be queried. In the query system data update method described in claim 1, the query server also stores a software container and a plurality of data query times corresponding to the database servers, wherein, in step (D), the query server Executing the software container to generate and transmit the list update request to the target database server, the method further includes the following steps: (E) the query server executes the software container to calculate a query value based on the number of data queries ; (F) The query server executes the software container to determine whether the query value is greater than a threshold; and (G) When the query server determines that the query value is greater than the threshold, the query server generates another Software container. As in the query system data update method described in request item 2, the query server also stores a plurality of weights corresponding to the database servers, wherein the query value V in step (E) is expressed by the following formula:

M is the number of such database servers, Wi _is the weight corresponding to the i- th database server, and N _i is the number of queries corresponding to the i- th database server. A query system includes: a query server connected to a client to be queried related to a client to be queried via a second communication network, and storing a plurality of query data. Each query The query data corresponds to one customer; and multiple database servers respectively correspond to multiple data categories. The query server is connected to the query server through a first communication network. Each database server stores an update list, and the update list includes multiple Customers interested in updating; wherein, for each database server, the database server periodically transmits a plurality of first update data corresponding to all customers to the query server according to a first update cycle, so that the query server The server updates all query data based on the first update data; for each database server, the database server periodically sends a plurality of updates corresponding to the interested customers based on the update list and a second update cycle. The second update data is sent to the query server, so that the query server updates the query data corresponding to the interested update customers based on the second update data, wherein the second update period is less than the first update period; when the query When the server receives a query request from the client to be queried that includes the customer to be queried and a data category to be queried, the query server generates a list update request including the customer to be queried, and sends the list update request to A pair of target database servers corresponding to the type of data to be queried; the target database server corresponding to the type of data to be queried updates the update list according to the list update request, and the updated update list includes the customer to be queried. The query system as described in claim 4, wherein the query server also stores a software container and a plurality of data queries respectively corresponding to the database servers. The query server executes the software container to generate and send the list update request to the target database server, calculates a query value based on the number of data queries, and determines whether the query value is greater than a threshold. , when the query server determines that the query value is greater than the threshold, the query server generates another software container. The query system as described in claim 5, wherein the query server also stores a plurality of weights corresponding to the database servers, and the query value V is expressed by the following formula:

M is the number of such database servers, Wi _is the weight corresponding to the i- th database server, and N _i is the number of queries corresponding to the i- th database server.

Images