TWI816875B - Data synchronous query method, device, computer device and storage medium - Google Patents

Abstract

The invention provides a data synchronization query method, a data synchronization query device, a computer device and a storage medium. The data synchronization query device creates a data item index and an operation instruction set table for the data in the database. The operation instruction set table includes: data item index, operation time, operation type, operation instruction and session table. The method includes: receiving a data query statement sent by the client; determining whether the data to be queried by the query statement is a first query; outputting the data query result if the query data is first queried; founding last synchronization time of the data item index in the session table, according to the synchronization time; confirming at least one operation instruction corresponding to the data item index; and outputting the operation instruction ， if the query data isn’t first queried.

Description

Data synchronization query method, device, computer device and storage medium

The invention relates to the technical field of data query, and specifically to a data synchronization query method, a data synchronization query device, a computer device and a computer-readable storage medium.

In daily work, it is often necessary to synchronize data between different data storage points, such as between a database and a client. Usually, the server that stores the database executes the client's synchronous query command to query the data and returns the desired query results to the client. This method of querying and transmitting complete data wastes bandwidth.

In view of the above, it is necessary to propose a data synchronization query method and device, a computer device and a computer-readable storage medium. Through the method, the client and the server can synchronize data in a more bandwidth-saving manner.

The first aspect of this application provides a data synchronization query method, which is applied in a data synchronization query device. The data synchronization query device creates a data item index and an operation instruction set table for the data in the database. The operation instruction set table includes : Data item index, operation time, operation type, operation command, and session table serial number. The method includes: receiving a data query statement sent by the client; determining whether the data to be queried by the query statement is the first query; If the data queried is the first query, the data query results are output; and if the data queried is not the first query, the last synchronization time of the data item index is searched in the session table, and based on The synchronization time determines at least one operation instruction corresponding to the data item index, and outputs the operation instruction.

Preferably, when the data in the database is updated, an update record is generated based on the data item index, operation type, operation instruction, and operation time of the data and added to the data operation instruction set table.

Preferably, the session table is used to store synchronization query records of the client; the content of the session table includes one or more of: data item index, synchronization time, and synchronization result.

Preferably, the method for determining whether the data to be queried in the query statement is the first query includes any of the following methods: searching in the operation instruction set table whether the session table contains the user-side synchronous query record. The sequence number; if it does not contain the sequence number of the session table of the client's synchronous query record, then it is determined that the query statement is the first query; if it contains the sequence number of the session table of the client's synchronous query record, in the session Check whether the table contains the data item index of the data to be queried. If not, the query statement is determined to be the first query.

Preferably, if the queried data is the first query, the step further includes: adding the data item index of the queried data and the operation type corresponding to the query statement to the session table.

Preferably, if the queried data is not queried for the first time, the last synchronization time of the data item index is searched in the session table, and at least one operation corresponding to the data item index is determined based on the synchronization time. instructions, and the steps of outputting the operation instructions include: Search at least one operation instruction corresponding to the data item index in a preset range in the operation instruction set table according to the synchronization time, where the preset range refers to the period from the synchronization time to the current query time. There is an operation instruction corresponding to the data item index; if there is one operation instruction corresponding to the data item index, the operation instruction is sent to the user terminal; and if there are multiple operation instructions corresponding to the data item index , then the operation instructions are sorted and merged and sent to the user end.

Preferably, if there are multiple operation instructions corresponding to the data item index, the step of sorting and merging the operation instructions includes: extracting multiple operation instructions corresponding to the data item index, and combining the multiple operation instructions. The instructions are sorted in chronological order; two adjacent operation instructions with the same operation type are merged in chronological order, and the operation type includes one or more of deletion, addition, and modification.

The second aspect of the present application provides a data synchronization query device. The device includes: a receiving module for receiving a data query sentence sent by the client; a judgment module for judging whether the data to be queried by the query sentence is The first query; the first execution module is used to output the data query results when the query data is the first query; and the second execution module is used when the query data is not the first query. During a query, the last synchronization time of the data item index is searched in the session table, at least one operation instruction corresponding to the data item index is determined based on the synchronization time, and the operation instruction is output.

The third party of this application provides a computer device. The computer device includes a processor. The processor is used to implement the data synchronization query method as described above when executing a computer program stored in the memory.

A fourth aspect of the present application provides a computer-readable storage medium on which a computer program is stored. When the computer program is executed by a processor, the data synchronization query method as described above is implemented.

The data synchronization query method of the present invention creates a data item index and a data operation instruction set table for all data in the database, and creates a session table for the user's query statement. The session table records the data items corresponding to the user's query statement. The index is sent to the user by querying the operation instruction set table for the operation instructions corresponding to the data item index corresponding to the data to be queried after the last update time. The method reduces the amount of query data and saves bandwidth.

1: Computer device

2: Client

10: Data synchronization query device

101:Receive module

102:Judgement module

103: First execution module

104: Second execution module

20:Memory

30: Processor

40:Computer program

Figure 1 is an application environment diagram of the data synchronization query method provided by an embodiment of the present invention.

Figure 2 is a flow chart of a data synchronization query method provided by an embodiment of the present invention.

Figure 3 is a functional module diagram of a data synchronization query device provided by an embodiment of the present invention.

FIG. 4 is a schematic diagram of a computer device according to an embodiment of the present invention.

In order to understand the above objects, features and advantages of the present invention more clearly, the present invention will be described in detail below with reference to the accompanying drawings and specific embodiments. It should be noted that, as long as there is no conflict, the embodiments of the present application and the features in the embodiments can be combined with each other.

Many specific details are set forth in the following description in order to fully understand the present invention. The described embodiments are only some, not all, of the embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without making creative efforts fall within the scope of protection of the present invention.

Unless otherwise defined, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this invention belongs. The terminology used herein in the description of the present invention is for the purpose of describing specific embodiments only and is not intended to limit the present invention.

Referring to Figure 1, an application of a data synchronization query method provided by an embodiment of the present invention is shown. Schematic diagram of the environment architecture.

The data synchronization query method in the present invention is applied to the computer device 1, and the computer device 1 and at least one client 2 establish a communication connection through the network. The network may be a wired network or a wireless network, such as radio, wireless fidelity (Wireless Fidelity, WIFI), cellular, satellite, broadcast, etc.

The computer device 1 can be an electronic device equipped with a data synchronization query method and has functions such as storage and calculation. Database information is stored in the computer device 1. The computer device 1 can be a personal computer, a server, etc., wherein, The server may be a single server, a server cluster or a cloud server, etc.

The client 2 can be various smart electronic devices with a file synchronization query function, used for sending query statements to the computer device 1 and receiving data query information sent by the computer device 1 . Including but not limited to smartphones, tablets, laptops, desktop computers, etc.

According to different requirements, the order of steps in the flow chart can be changed, and some steps can be omitted.

Step S1: Receive the query statement sent by the client.

In one implementation, the query statement may be a structured query language. The structured query language is a database query and programming language used for accessing data and querying, updating and managing relational database systems. The computer device 1 installed with the data synchronization query method accepts the query statements sent by the client 2, can receive the query statements one by one, and query the data to be queried according to the query statements.

In one implementation, the client 2 can also write multiple pieces of data information to be queried into a query script using structured query language. The query script can be used to query multiple pieces of data information at one time. The computer device 1 can receive a query script written using structured query language sent by the client 2 .

Step S2: Determine whether the data to be queried by the query statement is the first query.

In one embodiment, the computer device 1 can check the validity of the received query statement. Check, if the process of computer device 1 thinks that the query statement does not meet the grammatical requirements, this error message will be fed back to user terminal 2. If the query statement is legal, the identity information of the client 2 will be judged to determine whether the user terminal 2 has the permission to access the database corresponding to the query statement. And confirm the permission range of the client 2 to determine the data range that the client 2 can operate. If the client 2 does not have the database permission corresponding to the query statement, a feedback will be given to the client 2.

The method for the computer device 1 to determine whether the data to be queried in the query statement is the first query according to the received query statement sent by the client includes any of the following methods: searching in the operation instruction set table whether Contains the sequence number of the session table of the synchronous query record of the client 2; if it does not contain the sequence number of the session table of the synchronous query record of the client 2, it is determined that the query statement is the first query; if it contains the sequence number of the session table of the synchronous query record of the client 2 2. Query the serial number of the session table of the record synchronously, and search in the session table whether the data item index of the data to be queried is included. If it is not included, the query statement is determined to be the first query.

The data item index is created by the computer device 1 for all the data in the database, and the computer device 1 also creates a data operation instruction set table for the data in the database. The operation instruction set table includes: data item index, operation time, operation type, operation instruction, and serial number of the session table. The data operation instruction set table is shown in Table 1:

When the data in the database is updated, an update record is generated based on the data item index, operation type, operation instruction, and operation time of the data and added to the data operation instruction set table.

For example, the computer device 1 searches the operation instruction set table to see whether the sequence number of the session table of the client 2 is included. The session table is used to record the query record of the client 2, and the content of the session table includes query data. One or more of the data item index, synchronization time, and synchronization results. If the operation instruction set table does not contain the serial number of the session table of the client 2, the data to be queried by the query statement is the first query. If the operation instruction set table contains the serial number of the session table of the client 2, then in the session table, determine the data item index corresponding to the data according to the data to be queried, and search in the session table whether it contains If the data item index is not included, the data item index is the first query. For example, in the operation instruction set table in Table 1, each serial number in the sequence number column of the session table corresponds to a client. For the received query statement, the computer device 1 first searches the operation instruction set table to see whether there is a link to the client. The sequence number of the corresponding session table. As shown in Table 2, Table 2 is the content recorded in the session table 6, which is used to record the query records of the client, where The data information updated by the client is recorded as: data item index 4, synchronization time 201906290925, and the synchronization result is successful. If the data item index corresponding to the query data exists in the session table, the data to be queried is not the first query. If it does not exist, the data to be queried is the first query.

Step S3: If the data being queried is the first query, output the data query results.

If the queried data is the first query, the step may further include: adding the data item index of the queried data and the operation type corresponding to the query statement to the conversation table.

For example, after determining that the data to be queried is the first query, the computer device 1 outputs the data query results and adds the data item index of the data to be queried to the session table corresponding to the client 2. And record the time and synchronization result of this synchronization data in the session table.

In another embodiment of the present invention, after determining that the data to be queried is the first query, the computer device 1 outputs the data query results and sends the data item index corresponding to the queried data to the client 2 together. The client 2 receives the query data and the data item index of the data, and creates a synchronization information status table based on the data item index; the synchronization information status table includes one of: data item index, synchronization time, and synchronization result. item or multiple items.

The client 2 receives the data query results sent by the computer device 1, and updates the data query results in the data system of the client 2.

Step S4: If the queried data is not queried for the first time, search the session table for the last synchronization time of the data item index, and determine at least one operation corresponding to the data item index based on the synchronization time. instructions, and output the operation instructions.

In an embodiment of the present invention, if the queried data is not queried for the first time, the last synchronization time of the data item index is searched in the session table, and the determination is made based on the synchronization time. At least one operation instruction corresponding to the data item index, and the step of outputting the operation instruction includes: searching for an operation instruction corresponding to the data item index in a preset range in the operation instruction set table according to the synchronization time. At least one operation instruction, wherein the preset range refers to the operation instruction corresponding to the data item index from the synchronization time to the current query time; if there is one operation instruction corresponding to the data item index, then The operation instructions are sent to the user terminal; if there are multiple operation instructions corresponding to the data item index, the operation instructions are sorted and merged and then sent to the user terminal.

Wherein, if there are multiple operation instructions corresponding to the data item index, the step of sorting and merging the operation instructions may include: extracting multiple operation instructions corresponding to the data item index, and combining the multiple operation instructions. The instructions are sorted in chronological order; two adjacent operation instructions with the same operation type are merged in chronological order, and the operation type includes one or more of deletion, addition, and modification.

In one embodiment, after parsing the structured query statement, the computer device 1 determines that the data queried in the structured query statement is the second query, and searches the client in the session table according to the data item index corresponding to the query data. 2. The synchronization time of the last synchronization of the data item index, and query all the operation instructions of the data item index from the last synchronization time to the current query time in the data item index in the operation instruction set table according to the synchronization time. For example, according to the data item index 3 that the client 2 wants to query, the computer device 1 queries the data item index 3 in the session table. The last synchronization time is 201905091008, and then searches the operation instruction set table from All operation instructions corresponding to data item index 3 from 10:08 on May 9, 2019 to the current query time. The operation instructions corresponding to data item index 3 are as shown in Table 3, and the operation times are performed in chronological order. Arrange and merge operation instructions of the same operation type. For example, in Table 3, there are two "operation instructions" with the operation type "add". Merge these two operation instructions into one. to the stated After the operation instructions corresponding to the data item index are sorted and merged, the operation instructions and operation types are then sent to the user in chronological order.

The user terminal 2 receives the merged and sorted one or more operation instructions sent by the computer device 1, and executes the one or more operation instructions in the user terminal 2 according to the operation time sequence to complete the data information in the user terminal 2 synchronized updates.

The above-mentioned Figure 2 introduces the data synchronization query method of the present invention in detail. The following is a description of the functional modules of the software device that implements the data synchronization query method and the hardware device architecture that implements the data synchronization query method with reference to Figures 3-4. Make an introduction.

It should be understood that the above-described embodiments are for illustration only, and the scope of the patent application is not limited by this structure.

Figure 3 is a structural diagram of a preferred embodiment of the data synchronization query device of the present invention.

In some embodiments, the data synchronization query device 10 runs in the computer device 1 . The computer device 1 is connected to multiple clients 2 through the network. The data synchronization query device 10 may include a plurality of functional modules composed of program code segments. The program codes of each program segment in the data synchronization query device 10 can be stored in the memory of the computer device 1 and executed by the at least one processor to implement the data synchronization query function.

In this embodiment, the data synchronization query device 10 can be divided into multiple functional modules according to the functions it performs. Referring to Figure 3, the functional module may include: a receiving module 101, a judgment module 102, a first execution module 103, and a second execution module 104, which are referred to in the present invention. A module refers to a series of computer program segments that can be executed by at least one processor and perform a fixed function, and are stored in memory. In this embodiment, the functions of each module will be described in detail in subsequent embodiments.

The receiving module 101 is used to receive data query statements sent by the client.

In one implementation, the query statement may be a structured query language. The structured query language is a database query and programming language used for accessing data and querying, updating and managing relational database systems. The receiving module 101 accepts the query statements sent by the client 2, can receive the query statements one by one, and query the data to be queried according to the query statements.

In one implementation, the client 2 can also write multiple pieces of data information to be queried into a query script using structured query language. The query script can be used to query multiple pieces of data information at one time. The receiving module 101 can receive a query script written using structured query language sent by the client 2 .

The judgment module 102 is used to judge whether the data to be queried by the query statement is the first query.

In one embodiment, the judgment module 102 can check the validity of the received query statement. If the judgment module 102 believes that the query statement does not comply with the grammatical requirements, the error information will be fed back to the user terminal 2 . If the query statement is legal, the identity information of the client 2 will be judged to determine whether the user terminal 2 has the permission to access the database corresponding to the query statement. And confirm the permission range of the client 2 to determine the data range that the client 2 can operate. If the client 2 does not have the database permission corresponding to the query statement, a feedback will be given to the client 2.

The determination module 102 determines whether the data to be queried in the query statement is the first query according to the received query statement sent by the client, including any of the following methods: searching in the operation instruction set table Whether it contains the sequence number of the session table of the synchronous query record of the client 2; If the sequence number of the session table of the synchronous query record of the client 2 is not included, the query statement is determined to be the first query; if the sequence number of the session table of the synchronous query record of the client 2 is included, the query statement is determined in the session table. Search whether the data item index of the data to be queried is included. If not, the query statement is determined to be the first query.

The data item index is created by the computer device 1 for all the data in the database, and the computer device 1 also creates a data operation instruction set table for the data in the database. The operation instruction set table includes: data item index, operation time, operation type, operation instruction, and serial number of the session table. The data operation instruction set table is shown in Table 1:

When the data in the database is updated, an update record is generated based on the data item index, operation type, operation instruction, and operation time of the data and added to the data operation instruction set table.

For example, the judgment module 102 searches the operation instruction set table to see whether the sequence number of the session table of the client 2 is included. The session table is used to record the query record of the client 2. The content of the session table Contains one or more of the data item index, synchronization time, and synchronization results of the query data. If the operation instruction set table does not contain the serial number of the session table of the client 2, the data to be queried by the query statement is the first query. If the operation instruction set table contains the serial number of the session table of the client 2, then in the session table, determine the data item index corresponding to the data according to the data to be queried, and search in the session table whether it contains If the data item index is not included, the data item index is the first query. For example, in the operation instruction set table in Table 1, each serial number in the sequence number column of the session table corresponds to a client. For the received query statement, the judgment module 102 first searches the operation instruction set table to see whether there is a link with the user. The serial number of the session table corresponding to the end. As shown in Table 2, Table 2 is the content recorded in the session table 6. The session table 6 is used to record the query records of the client. The data information updated by the client is recorded as: data item index 4, The synchronization time is 201906290925, and the synchronization result is successful. If the data item index corresponding to the query data exists in the session table, the data to be queried is not the first query. If it does not exist, the data to be queried is the first query.

The first execution module 103 is used to output data query results when the data being queried is the first query.

If the data being queried is the first query, the steps may also include: converting the The data item index of the queried data and the operation type corresponding to the query statement are added to the session table.

For example, after the judgment module 103 determines that the data to be queried is the first query, the first execution module 103 outputs the data query result and adds the data item index of the data to be queried to the client. 2 in the corresponding session table, and record the time and synchronization result of this synchronization data in the session table.

In another embodiment of the present invention, after determining that the data to be queried is the first query, the computer device 1 outputs the data query results and sends the data item index corresponding to the queried data to the client 2 together. The client 2 receives the query data and the data item index of the data, and creates a synchronization information status table based on the data item index; the synchronization information status table includes one of: data item index, synchronization time, and synchronization result. item or multiple items.

The client 2 receives the data query results sent by the computer device 1, and updates the data query results in the data system of the client 2.

The second execution module 104 is used to search the last synchronization time of the data item index in the session table when the queried data is not queried for the first time, and determine the data item index according to the synchronization time. Index corresponding to at least one operation instruction, and output the operation instruction.

In an embodiment of the present invention, if the queried data is not queried for the first time, the last synchronization time of the data item index is searched in the session table, and the data item index is determined based on the synchronization time. Corresponding to at least one operation instruction, and the step of outputting the operation instruction includes: searching for at least one operation instruction corresponding to the data item index in a preset range in the operation instruction set table according to the synchronization time, wherein The preset range refers to the operation instruction corresponding to the data item index from the synchronization time to the current query time; if there is one operation instruction corresponding to the data item index, the operation instruction is sent to Client; if there are multiple operation instructions corresponding to the data item index, organize the operation instructions Combined and sent to the client.

Wherein, if there are multiple operation instructions corresponding to the data item index, the step of sorting and merging the operation instructions may include: extracting multiple operation instructions corresponding to the data item index, and combining the multiple operation instructions. The instructions are sorted in chronological order; two adjacent operation instructions with the same operation type are merged in chronological order, and the operation type includes one or more of deletion, addition, and modification.

In one embodiment, after parsing the structured query statement, the computer device 1 determines that the data queried in the structured query statement is the second query, and searches the client in the session table according to the data item index corresponding to the query data. 2. The synchronization time of the last synchronization of the data item index, and query all the operation instructions of the data item index from the last synchronization time to the current query time in the data item index in the operation instruction set table according to the synchronization time. For example, according to the data item index 3 that the client 2 wants to query, the computer device 1 queries the data item index 3 in the session table. The last synchronization time is 201905091008, and then searches the operation instruction set table from All operation instructions corresponding to data item index 3 from 10:08 on May 9, 2019 to the current query time. The operation instructions corresponding to data item index 3 are as shown in Table 3, and the operation times are performed in chronological order. Arrange and merge operation instructions of the same operation type. For example, in Table 3, there are two "operation instructions" with the operation type "add". Merge these two operation instructions into one. After the operation instructions corresponding to the data item index are sorted and merged, the operation instructions and operation types are then sent to the user terminal in chronological order.

The user terminal 2 receives the merged and sorted one or more operation instructions sent by the computer device 1, and executes the one or more operation instructions in the user terminal 2 according to the operation time sequence to complete the data information in the user terminal 2 synchronized updates.

Figure 4 is a schematic diagram of a preferred embodiment of the computer device of the present invention.

The computer device 1 includes a memory 20, a processor 30, and a computer program 40 stored in the memory 20 and executable on the processor 30, such as a data synchronization query program. When the processor 30 executes the computer program 40, the steps in the above embodiment of the data synchronization query method are implemented, such as steps S1 to S4 shown in Figure 2. Alternatively, when the processor 30 executes the computer program 40, it realizes the functions of each module/unit in the above embodiment of the data synchronization query device, such as the units 101-104 in Figure 3.

For example, the computer program 40 may be divided into one or more modules/units, and the one or more modules/units are stored in the memory 20 and executed by the processor 30 , to complete the present invention. The one or more modules/units may be a series of computer program instruction segments capable of completing specific functions. The instruction segments are used to describe the execution process of the computer program 40 in the computer device 1 . For example, the computer program 40 can be divided into the receiving module 101, the judging module 102, the first execution module 103, and the second execution module 104 in FIG. 3 . For the specific functions of each module, please refer to the specific function description of each module in Figure 2.

The computer device 1 may be a desktop computer, a notebook, a palmtop computer, a cloud server and other computing devices. Those skilled in the art can understand that the schematic diagram is only an example of the computer device 1 and does not constitute a limitation on the computer device 1. It may include more or less components than shown in the figure, or some components may be combined or different. Components, for example, the computer device 1 may also include input and output devices, network access devices, buses, etc.

The so-called processor 30 can be a central processing unit (Central Processing Unit, CPU), or other general-purpose processor, digital signal processor (Digital Signal Processor, DSP), Application Specific Integrated Circuit (ASIC), off-the-shelf programmable gate array (Field-Programmable Gate Array, FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. The general processor may be a microprocessor or the processor 30 may also be any conventional processor, etc. The processor 30 is the control center of the computer device 1 and is connected to the entire computer device 1 using various interfaces and lines. various parts.

The memory 20 can be used to store the computer program 40 and/or module/unit, and the processor 30 runs or executes the computer program and/or module/unit stored in the memory 20, and The data stored in the memory 20 is called to realize various functions of the computer device 1 . The memory 20 may mainly include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application program required for at least one function (such as a sound playback function, an image playback function, etc.), etc.; and a storage data area. The area can store data created based on the use of the computer device 1 (such as audio data, phone books, etc.). In addition, the memory 20 may include high-speed random access memory, and may also include non-volatile memory, such as a hard disk, a memory, a plug-in hard disk, a smart media card (SMC), a secure digital (Secure Digital, SD) card, flash memory card (Flash Card), at least one disk memory device, flash memory device, or other volatile solid-state memory device.

If the integrated modules/units of the computer device 1 are implemented in the form of software functional units and sold or used as independent products, they can be stored in a computer-readable storage medium. Based on this understanding, the present invention can implement all or part of the processes in the above embodiment methods by instructing relevant hardware through a computer program. The computer program can be stored in a computer-readable storage medium, so When the computer program is executed by the processor, the steps of each of the above method embodiments can be implemented. Wherein, the computer program includes computer program code, and the computer program code can be in the form of original program code, object code form, executable file or some intermediate form, etc. The computer-readable medium may include: any entity or device capable of carrying the computer program code, recording media, USB flash drive, mobile hard drive, magnetic disk, optical disk, computer memory, read-only memory (ROM, Read-only memory). Only Memory), random access memory (RAM, Random Access Memory), electrical carrier signal, telecommunications signal and software distribution media, etc. It should be noted that the content contained in the computer-readable medium can be appropriately added or deleted according to the requirements of legislation and patent practice in the jurisdiction. For example, in some jurisdictions, according to legislation and patent practice, the computer-readable medium Excludes electrical carrier signals and telecommunications signals.

In the several embodiments provided by the present invention, it should be understood that the disclosed computer device and method can be implemented in other ways. For example, the computer device embodiments described above are only illustrative. For example, the division of units is only a logical function division, and there may be other division methods in actual implementation.

In addition, each functional unit in various embodiments of the present invention can be integrated in the same processing unit, or each unit can exist physically alone, or two or more units can be integrated in the same unit. The above-mentioned integrated unit can be implemented in the form of hardware or in the form of hardware plus software function modules.

It is obvious to those skilled in the art that the present invention is not limited to the details of the above-described exemplary embodiments, and the present invention can be implemented in other specific forms without departing from the spirit or essential characteristics of the invention. Therefore, from any point of view, the embodiments should be regarded as illustrative and non-restrictive. The scope of the present invention is defined by the appended claims rather than the above description, and it is therefore intended that those falling within the claims All changes within the meaning and scope of the equivalent elements are included in the present invention. Any reference signs in a claim shall not be construed as limiting the claim involved. Furthermore, it is clear that the word "comprising" does not exclude other elements or steps, and the singular does not exclude the plural. Multiple units or computer devices stated in the computer device request may also be implemented by the same unit or computer device through software or hardware. Words such as first and second are used to indicate names and do not indicate any specific order.

Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention and are not limiting. Although the present invention has been described in detail with reference to the preferred embodiments, those of ordinary skill in the art will understand that the technical solutions of the present invention can be modified. Modifications or equivalent substitutions may be made without departing from the spirit and scope of the technical solution of the present invention.

Claims (8)

A data synchronization query method is applied to a data synchronization query device. The data synchronization query device creates a data item index and an operation instruction set table for the data in the database. The operation instruction set table includes: data item index, operation time , operation type, operation instruction, and the serial number of the session table. The method includes: receiving the data query statement sent by the client; based on the serial number of the session table, judging whether the data to be queried by the query statement is the first query, Wherein, the session table is used to store synchronization query records of the user end; the content of the session table includes: one or more of data item index, synchronization time, and synchronization results; the sequence number based on the session table, The method for determining whether the data to be queried by the query statement is the first query includes any of the following methods: searching in the operation instruction set table whether the serial number of the session table containing the user-end synchronization query record is included; if it does not include If the serial number of the session table recorded by the client's synchronous query is determined, the query statement is determined to be the first query; if the serial number of the session table recorded by the client's synchronous query is included, the session table is searched to see whether it contains the desired query. The query is the data item index of the data. If it is not included, it is determined that the query statement is the first query; if the data queried is the first query, the data query results are output; and if the data queried is not In the first query, the last synchronization time of the data item index is searched in the session table, at least one operation instruction corresponding to the data item index is determined based on the synchronization time, and the operation instruction is output. The data synchronization query method as described in request item 1, wherein the method also includes: when the data in the database is updated, generate a data based on the data item index, operation type, operation instruction, and operation time of the data. An update record is added to the data operation instruction set table. The data synchronization query method as described in request item 1, wherein if the data being queried is the first query, the steps further include: Add the data item index of the queried data and the operation type corresponding to the query statement to the session table. The data synchronization query method as described in request item 1, wherein if the data being queried is not the first query, the last synchronization time of the data item index is searched in the session table, and is determined based on the synchronization time. At least one operation instruction corresponding to the data item index, and the step of outputting the operation instruction includes: searching for an operation instruction corresponding to the data item index in a preset range in the operation instruction set table according to the synchronization time. At least one operation instruction, wherein the preset range refers to the operation instruction corresponding to the data item index from the synchronization time to the current query time; if there is one operation instruction corresponding to the data item index, then The operation instructions are sent to the user terminal; and if there are multiple operation instructions corresponding to the data item index, the operation instructions are sorted and merged and then sent to the user terminal. The data synchronization query method described in claim 4, wherein if there are multiple operation instructions corresponding to the data item index, the step of sorting and merging the operation instructions includes: extracting the operation instructions corresponding to the data item index. Multiple operation instructions are sorted in chronological order; two adjacent operation instructions with the same operation type are merged in chronological order, and the operation type includes one of deletion, addition, and modification. item or multiple items. A data synchronization query device, the device includes: a receiving module, used to receive a data query sentence sent by the client; a judgment module, used to judge whether the data to be queried by the query sentence is based on the serial number of the session table It is the first query, wherein the session table is used to store the synchronization query record of the client; the content of the session table includes: one or more of data item index, synchronization time, and synchronization result; The method of determining whether the data to be queried by the query statement is the first query based on the serial number of the session table includes any of the following methods: searching in the operation instruction set table whether the client synchronization query is included The serial number of the recorded session table; if it does not contain the serial number of the session table recorded by the client's synchronous query, then it is determined that the query statement is the first query; if it contains the serial number of the session table recorded by the client's synchronous query, Search the session table to see whether the data item index of the data to be queried is included. If not, determine that the query statement is the first query; the first execution module is used when the data of the query is the first query. When querying once, the data query results are output; and the second execution module is used to search the last synchronization time of the data item index in the session table when the data being queried is not the first query. , and determine at least one operation instruction corresponding to the data item index according to the synchronization time, and output the operation instruction. A computer device, wherein the computer device includes a processor and a memory, and the processor is used to implement the data synchronization query method described in any one of claims 1 to 5 when executing a computer program stored in the memory. A computer storage medium on which a computer program is stored, wherein when the computer program is executed by a processor, the data synchronization query method described in any one of claims 1 to 5 is implemented.

Images