Data fuzzy query method and device

Abstract

The invention provides a data fuzzy query method and device which can be applied to the technical field of databases and computers. The method comprises the following steps: in response to a data query request sent to a data management platform by a user, determining a matching mode and an input keyword of data query; based on the matching mode, performing matching in a first database on the data query platform by utilizing the input keyword to obtain a plurality of display pages; based on a page switching instruction of a user, determining a target display page corresponding to the page switching instruction; based on session caches corresponding to the target display page, multiple matching results included in the target display page are determined, the data query platform comprises multiple session caches, and the multiple display pages are in one-to-one correspondence with the multiple session caches; and based on a result selection instruction of the user, determining a target query result in a plurality of matching results included in the target display page from the second database, and displaying the target query result on the data management platform.

Description

Technical Field

[0001] The present invention relates to the field of database and computer technology, and in particular to a data fuzzy query method and device. Background Art

[0002] With the development of computer hardware and software, the amount of projects included in the software is getting larger and larger. Since each project can include a large amount of documents and data, the amount of data included in the software as a whole is also increasing. Project management tools can be used to organize members, tasks, documents, discussions and various forms of resources together in the form of projects, and the progress of the project can be promoted by updating tasks, documents and other content, and large amounts of data can be queried and operated.

[0003] In the process of implementing the present invention, it is found that the prior art has at least the following problems: when using a project management tool to query data, if there are a large number of query results and paging occurs, it is usually necessary to re-query the data when turning the page, resulting in low data query efficiency. Summary of the invention

[0004] In view of the above problems, the present invention provides a data fuzzy query method and device.

[0005] According to a first aspect of the present invention, a data fuzzy query method is provided, comprising: in response to a data query request sent by a user to a data management platform, determining a matching mode and an input keyword of the data query; based on the matching mode, matching in a first database using the input keyword on the data query platform to obtain a plurality of display pages, wherein the plurality of display pages are obtained by paging a plurality of matching results matching the input keyword in the first database, and each display page, except for the last display page, includes a preset number of matching results, and the number of matching results included in the last display page is less than or equal to the preset number; based on a page switching instruction of the user, determining a target display page corresponding to the page switching instruction; based on a session cache corresponding to the target display page, determining a plurality of matching results included in the target display page, wherein the data query platform includes a plurality of session caches, and the plurality of display pages correspond one to one with the plurality of session caches; based on a result selection instruction of the user, determining a target query result from a plurality of matching results included in the target display page from a second database, and displaying the target query result on the data management platform; wherein the data query platform uses the first database to perform data query, the data management platform uses the second database to perform data management, and the data in the first database is obtained by data synchronization by a data synchronization component using a log file of the second database.

[0006] According to an embodiment of the present invention, the data in the first database is obtained by performing data synchronization by a data synchronization component using the log file of the second database, including: in the case of a newly created data query platform, reading the log file of the second database; parsing the log file to obtain multiple synchronization data; writing the multiple synchronization data into a synchronization message queue; using the data synchronization component to read the multiple synchronization data from the synchronization message queue, and writing the multiple synchronization data into the first database.

[0007] According to an embodiment of the present invention, the data in the first database is obtained by synchronizing the data with the log file of the second database by the data synchronization component, including: monitoring the data changes in the second database when the data query platform has been established; reading the log file of the second database when the data change indicates that the data in the second database has changed; parsing the log file to obtain one or more changed data; writing the one or more changed data into the changed message queue; using the data synchronization component to read one or more changed data from the changed message queue, and writing the one or more changed data into the first database.

[0008] According to an embodiment of the present invention, based on a matching method, matching is performed in a first database using input keywords on a data query platform to obtain multiple display pages, including: based on a matching method, matching is performed in a first database using input keywords on a data query platform to obtain multiple matching results; and paging the multiple matching results based on a preset number to obtain multiple display pages.

[0009] According to an embodiment of the present invention, based on a matching method, an input keyword is used to perform matching in a first database on a data query platform to obtain multiple matching results, including: processing the input keyword to obtain a query keyword for fuzzy query, wherein the query keyword includes synonyms and variant forms of the input keyword; based on the matching method, determining the data similarity between each of a plurality of first data items included in the first database and the query keyword; based on the plurality of data similarities, sorting the plurality of first data items to obtain a plurality of sorted first data items; selecting the plurality of sorted first data items whose data similarity with the query keyword is higher than a similarity threshold to obtain a plurality of matching results.

[0010] According to an embodiment of the present invention, based on the user's page switching instruction, determining the target display page corresponding to the page switching instruction includes: based on the user's page switching instruction, determining the page number of the display page that the user needs to view; based on the page number, determining the target display page.

[0011] According to an embodiment of the present invention, based on the session cache corresponding to the target display page, multiple matching results included in the target display page are determined, including: determining the session cache based on the page number of the target display page; and determining multiple matching results stored in the session cache.

[0012] According to an embodiment of the present invention, based on the user's result selection instruction, a target query result from a plurality of matching results included in a target display page is determined from a second database, and displayed on a data management platform, including: based on the result selection instruction, determining the target query result from a plurality of matching results included in the target display page; determining detailed data corresponding to the target query result from the second database; and displaying the detailed data on the data management platform.

[0013] According to an embodiment of the present invention, the first database includes a full-text indexing function and parallel processing capabilities; the data fuzzy query method also includes: in response to a data query request sent by a user to the data management platform, redirecting the data query request to the data query platform.

[0014] A second aspect of the present invention provides a data fuzzy query device, comprising:

[0015] A keyword determination module, used to determine a matching method and input keywords for data query in response to a data query request sent by a user to the data management platform;

[0016] A page determination module, for matching the input keyword in the first database on the data query platform based on the matching method to obtain multiple display pages, wherein the multiple display pages are obtained by paging multiple matching results matching the input keyword in the first database, and each display page, except for the last display page, includes a preset number of matching results, and the number of matching results included in the last display page is less than or equal to the preset number;

[0017] A page switching module, used to determine a target display page corresponding to a page switching instruction based on a user's page switching instruction;

[0018] A result determination module, used to determine a plurality of matching results included in the target display page based on a session cache corresponding to the target display page, wherein the data query platform includes a plurality of session caches, and the plurality of display pages correspond one-to-one to the plurality of session caches;

[0019] A result display module, used to determine a target query result from a plurality of matching results included in a target display page from a second database based on a result selection instruction of a user, and display the result on a data management platform;

[0020] The data query platform uses the first database to query data, the data management platform uses the second database to manage data, and the data in the first database is obtained by data synchronization using the log file of the second database by the data synchronization component.

[0021] A third aspect of the present invention provides an electronic device, comprising: one or more processors; a memory for storing one or more computer programs, wherein the one or more processors execute the one or more computer programs to implement the steps of the above method.

[0022] The fourth aspect of the present invention further provides a computer-readable storage medium on which a computer program or instruction is stored, and the steps of the above method are implemented when the above computer program or instruction is executed by a processor.

[0023] The fifth aspect of the present invention also provides a computer program product, including a computer program or instructions, which implement the steps of the above method when executed by a processor.

[0024] According to an embodiment of the present invention, in response to a data query request sent by a user to a data management platform, a matching method and input keywords of the data query are determined, and based on the matching method, the input keywords are used to match in the first database on the data query platform to obtain multiple display pages. Based on the page switching instruction, a session cache storing a target display page corresponding to the page switching instruction is determined from multiple session caches, and multiple matching results of the target display page are determined. Since the multiple display pages correspond to the multiple session caches one by one, the multiple matching results included in each of the multiple display pages are respectively stored in the corresponding session caches. Therefore, in the process of jumping between different display pages, there is no need to re-perform data fuzzy query, and the multiple matching results of the display page can be directly determined from the session cache, thereby improving the efficiency of data fuzzy query. Based on the result selection instruction, the target query result is selected from the multiple matching results, and the data item corresponding to the target query result is displayed on the data management platform from the second database. Since the data query and data display are respectively performed on the data query platform and the data management platform, the operation amount of the two platforms can be reduced, and the efficiency of the two platforms can be improved respectively. In addition, the data query platform and the data management platform use different databases. The data in the first database used by the data query platform is obtained by synchronization with the data in the second database used by the data management platform. Therefore, the data stored in the first database and the second database are exactly the same, which can ensure that the data sources for data query and data display are the same, thereby improving the accuracy of data fuzzy query. BRIEF DESCRIPTION OF THE DRAWINGS

[0025] The above contents and other objects, features and advantages of the present invention will become more apparent through the following description of the embodiments of the present invention with reference to the accompanying drawings.

[0026] Figure 1 The application scenario diagram of the data fuzzy query method and device according to an embodiment of the present invention is schematically shown.

[0027] Figure 2 The flowchart of the data fuzzy query method according to an embodiment of the present invention is schematically shown.

[0028] Figure 3 The hardware structure diagram of the data fuzzy query method according to an embodiment of the present invention is schematically shown.

[0029] Figure 4 The structure block diagram of the data fuzzy query device according to an embodiment of the present invention is schematically shown.

[0030] Figure 5 A block diagram of an electronic device suitable for implementing a data fuzzy query method according to an embodiment of the present invention is schematically shown. DETAILED DESCRIPTION

[0031] Below, embodiments of the present invention will be described with reference to the accompanying drawings. However, it should be understood that these descriptions are exemplary only and are not intended to limit the scope of the present invention. In the following detailed description, for ease of explanation, many specific details are set forth to provide a comprehensive understanding of embodiments of the present invention. However, it is apparent that one or more embodiments may also be implemented without these specific details. In addition, in the following description, descriptions of known structures and technologies are omitted to avoid unnecessary confusion of concepts of the present invention.

[0032] The terms used herein are only for describing specific embodiments and are not intended to limit the present invention. The terms "comprise", "include", etc. used herein indicate the existence of the features, steps, operations and / or components, but do not exclude the existence or addition of one or more other features, steps, operations or components.

[0033] All terms (including technical and scientific terms) used herein have the meanings commonly understood by those skilled in the art unless otherwise defined. It should be noted that the terms used herein should be interpreted as having a meaning consistent with the context of this specification and should not be interpreted in an idealized or overly rigid manner.

[0034] When using expressions such as "at least one of A, B, and C, etc.", they should generally be interpreted according to the meaning of the expression commonly understood by those skilled in the art (for example, "a system having at least one of A, B, and C" should include but is not limited to a system having A alone, B alone, C alone, A and B, A and C, B and C, and / or A, B, C, etc.).

[0035] In the technical solution of the present invention, the user information (including but not limited to user personal information, user image information, user device information, such as location information, etc.) and data (including but not limited to data used for analysis, stored data, displayed data, etc.) involved are all information and data authorized by the user or fully authorized by all parties, and the collection, storage, use, processing, transmission, provision, invention and application of the relevant data comply with relevant laws, regulations and standards, take necessary confidentiality measures, do not violate public order and good morals, and provide corresponding operation entrances for users to choose to authorize or refuse.

[0036] In the scenario of using personal information for automated decision-making, the methods, devices, and systems provided by the embodiments of the present invention provide users with corresponding operation portals for users to choose to agree or reject the automated decision-making results; if the user chooses to reject, the expert decision-making process will be entered. The expression "automated decision-making" here refers to the activity of automatically analyzing and evaluating an individual's behavioral habits, interests and hobbies, or economic, health, credit status, etc. through computer programs, and making decisions. The expression "expert decision-making" here refers to the activity of making decisions by people who specialize in a certain field, have specialized experience, knowledge and skills, and have reached a certain level of professionalism.

[0037] Since commonly used relational databases usually use row storage, they are more suitable for online transaction processing scenarios. However, since this type of database does not add mechanisms such as full-text indexing and query optimizer, the query efficiency is not high enough in online analytical processing scenarios.

[0038] An embodiment of the present invention provides a data fuzzy query method, comprising: determining a matching mode and input keywords of a data query in response to a data query request sent by a user to a data management platform; based on the matching mode, matching in a first database using the input keywords on the data query platform to obtain multiple display pages, wherein the multiple display pages are obtained by paging according to multiple matching results obtained by matching in the first database, and each display page except the last display page includes a preset number of matching results, and the number of matching results included in the last display page is less than or equal to the preset number; based on a page switching instruction of the user, determining a target display page corresponding to the page switching instruction; based on a session cache corresponding to the target display page, determining multiple matching results included in the target display page, wherein the data query platform includes multiple session caches, and the multiple display pages correspond to the multiple session caches one by one; based on a result selection instruction of the user, determining a target query result from the multiple matching results included in the target display page from a second database, and displaying it on the data management platform; wherein the data query platform uses the first database to perform data query, the data management platform uses the second database to perform data management, and the data in the first database is obtained by data synchronization by a data synchronization component using a log file of the second database.

[0039] Figure 1 The application scenario diagram of the data fuzzy query method and device according to an embodiment of the present invention is schematically shown.

[0040] like Figure 1 As shown, the application scenario 100 according to this embodiment may include a first terminal device 101, a second terminal device 102, a third terminal device 103, a network 104, and a server 105. The network 104 is used to provide a medium for a communication link between the first terminal device 101, the second terminal device 102, the third terminal device 103, and the server 105. The network 104 may include various connection types, such as wired, wireless communication links, or optical fiber cables, etc.

[0041] The user can use the first terminal device 101, the second terminal device 102, and the third terminal device 103 to interact with the server 105 through the network 104 to receive or send messages, etc. Various communication client applications can be installed on the first terminal device 101, the second terminal device 102, and the third terminal device 103, such as shopping applications, web browser applications, search applications, instant messaging tools, email clients, social platform software, etc. (only for example).

[0042] The first terminal device 101, the second terminal device 102, and the third terminal device 103 may be various electronic devices having display screens and supporting web browsing, including but not limited to smart phones, tablet computers, laptop computers, desktop computers, and the like.

[0043] The server 105 may be a server that provides various services, such as a background management server (only as an example) that provides support for websites browsed by users using the first terminal device 101, the second terminal device 102, and the third terminal device 103. The background management server may analyze and process the received data such as user requests, and feed back the processing results (such as web pages, information, or data obtained or generated according to user requests) to the terminal device.

[0044] It should be noted that the data fuzzy query method provided in the embodiment of the present invention can generally be executed by the server 105. Accordingly, the data fuzzy query device provided in the embodiment of the present invention can generally be set in the server 105. The data fuzzy query method provided in the embodiment of the present invention can also be executed by a server or server cluster that is different from the server 105 and can communicate with the first terminal device 101, the second terminal device 102, the third terminal device 103 and / or the server 105. Correspondingly, the data fuzzy query device provided in the embodiment of the present invention can also be set in a server or server cluster that is different from the server 105 and can communicate with the first terminal device 101, the second terminal device 102, the third terminal device 103 and / or the server 105.

[0045] It should be understood that Figure 1 The number of terminal devices, networks and servers in the embodiment is only for illustration. Any number of terminal devices, networks and servers may be provided according to the implementation requirements.

[0046] The following will be based on Figure 1 The scene described by Figure 2~Figure 3 The data fuzzy query method of an embodiment of the invention is described in detail.

[0047] Figure 2 The flowchart of the data fuzzy query method according to an embodiment of the present invention is schematically shown.

[0048] like Figure 2 As shown, the data fuzzy query method of this embodiment includes operations S210 to S250.

[0049] In operation S210 , in response to a data query request sent by a user to a data management platform, a matching method and input keywords for the data query are determined.

[0050] In operation S220, based on the matching method, the input keyword is matched in the first database on the data query platform to obtain a plurality of display pages.

[0051] In operation S230 , based on the page switching instruction of the user, a target display page corresponding to the page switching instruction is determined.

[0052] In operation S240 , a plurality of matching results included in the target presentation page are determined based on the session cache corresponding to the target presentation page.

[0053] In operation S250, based on the result selection instruction of the user, a target query result from a plurality of matching results included in the target display page is determined from the second database and displayed on the data management platform.

[0054] According to an embodiment of the present invention, in response to a data query request sent by a user to a data management platform, a matching method and input keywords for the data query are determined, wherein the data management platform may be a cross-platform project management system in which data from multiple data tables are stored, and the data query request includes a matching method and input keywords for the data query, which are used to perform data query from multiple data tables stored in the data management platform, wherein the matching method may include a variety of fuzzy query methods, for example, different fields in a data table for matching, the number of input keywords, the number of input keyword matches, etc.

[0055] According to an embodiment of the present invention, due to the use of fuzzy query, the matching results obtained by matching the input keywords are not unique, and the page size is limited and too many matching results cannot be displayed at the same time. Therefore, multiple matching results can be paged, wherein each matching result corresponds to a data item in the data table, and the matching results can be displayed in the form of an index, that is, only the part of the content in the corresponding data item that matches the input keyword is included.

[0056] According to an embodiment of the present invention, based on a matching method, input keywords are used to perform matching in a first database on a data query platform to obtain multiple display pages, wherein the multiple display pages are obtained by paging multiple matching results obtained by matching in the first database, and each display page except the last display page includes a preset number of matching results, and the number of matching results included in the last display page is less than or equal to the preset number.

[0057] According to an embodiment of the present invention, after obtaining multiple display pages, the display page initially displayed is the first display page, and the user selects the display page to be jumped to for browsing and selection. Based on the user's page switching instruction, a target display page corresponding to the page switching instruction is determined.

[0058] According to an embodiment of the present invention, the data query platform includes multiple session caches, multiple display pages correspond one-to-one to the multiple session caches, each session cache stores multiple matching results in the display page corresponding thereto, and based on the session cache corresponding to the target display page, the multiple matching results included in the target display page are determined.

[0059] According to an embodiment of the present invention, based on the user's result selection instruction, a target query result from a plurality of matching results included in a target display page is determined from a second database and displayed on a data management platform, wherein the result selection instruction includes selecting a matching result from a plurality of matching results included in the target display page, and the target query result may include all contents of the data item corresponding to the matching result.

[0060] According to an embodiment of the present invention, the data query platform uses the first database to query data, and the data management platform uses the second database to manage data. The data in the first database is obtained by the data synchronization component using the log file of the second database for data synchronization, wherein the first database may include a database that applies a distributed architecture and column storage, and the second database may include a database that applies a client / server (B / S) architecture and row storage. Using the log file of the second database to synchronize the data in the first database includes synchronizing all data when a new data query platform is created, and synchronizing the changed data when the data in the second database changes after the data query platform has been established.

[0061] According to an embodiment of the present invention, in response to a data query request sent by a user to a data management platform, a matching method and input keywords of the data query are determined, and based on the matching method, the input keywords are used to match in the first database on the data query platform to obtain multiple display pages. Based on the page switching instruction, a session cache storing a target display page corresponding to the page switching instruction is determined from multiple session caches, and multiple matching results of the target display page are determined. Since the multiple display pages correspond to the multiple session caches one by one, the multiple matching results included in each of the multiple display pages are respectively stored in the corresponding session caches. Therefore, in the process of jumping between different display pages, there is no need to re-perform data fuzzy query, and the multiple matching results of the display page can be directly determined from the session cache, thereby improving the efficiency of data fuzzy query. Based on the result selection instruction, the target query result is selected from the multiple matching results, and the data item corresponding to the target query result is displayed on the data management platform from the second database. Since the data query and data display are respectively performed on the data query platform and the data management platform, the operation amount of the two platforms can be reduced, and the efficiency of the two platforms can be improved respectively. In addition, the data query platform and the data management platform use different databases. The data in the first database used by the data query platform is obtained by synchronization with the data in the second database used by the data management platform. Therefore, the data stored in the first database and the second database are exactly the same, which can ensure that the data sources for data query and data display are the same, thereby improving the accuracy of data fuzzy query.

[0062] According to an embodiment of the present invention, the data in the first database is obtained by performing data synchronization by a data synchronization component using the log file of the second database, including: in the case of a newly created data query platform, reading the log file of the second database; parsing the log file to obtain multiple synchronization data; writing the multiple synchronization data into a synchronization message queue; using the data synchronization component to read the multiple synchronization data from the synchronization message queue, and writing the multiple synchronization data into the first database.

[0063] According to an embodiment of the present invention, when a new data query platform is created, a high-level language program is used to read the log file of the second database, wherein the log file includes a binary log for storing all modification operations of all data tables in the second database.

[0064] According to an embodiment of the present invention, by parsing the log file, multiple modification operations in all data tables in the second database are determined, and the synchronization data corresponding to each of the multiple modification operations are further determined, wherein each modification operation can correspond to a structured query statement (Structured Query Language, SQL). For example, for the SQL statement corresponding to the modification operation "insert into table3 (number, name, subject, score) values ​​(2, Zhang San, mathematics, 135)", it can be determined that the corresponding synchronization data is a row of data "2, Zhang San, mathematics, 135" inserted into table3.

[0065] According to an embodiment of the present invention, after determining multiple synchronization data, the multiple synchronization data are written into a synchronization message queue in the order of the multiple modification operations in the log file, and the data synchronization component is used to read the multiple synchronization data from the synchronization message queue and write them into the first database to complete data synchronization, wherein the synchronization message queue may include a kafka queue, and the data synchronization component may be used to load data from the kafka queue, such as a Consumer component of a database.

[0066] According to an embodiment of the present invention, in the case of a newly built data query platform, the log file and synchronization message queue of the second database are used to write the synchronization data into the first database. By using the log file of the second database to determine the synchronization data, the accuracy of the synchronization data can be ensured, while avoiding the omission of synchronization data, improving the accuracy of data synchronization, so that after the data synchronization is completed, the data in the first database is the same as the data in the second database, thereby improving the accuracy of data fuzzy query. Using the synchronization message queue to synchronize the synchronization data can improve the efficiency of data synchronization and improve the utilization rate of resources used for data synchronization.

[0067] According to an embodiment of the present invention, the data in the first database is obtained by synchronizing the data with the log file of the second database by the data synchronization component, including: monitoring the data changes in the second database when the data query platform has been established; reading the log file of the second database when the data change indicates that the data in the second database has changed; parsing the log file to obtain one or more changed data; writing the one or more changed data into the changed message queue; using the data synchronization component to read one or more changed data from the changed message queue, and writing the one or more changed data into the first database.

[0068] According to an embodiment of the present invention, when a data query platform has been established, data changes in the second database are monitored, wherein the methods for monitoring the second database may include polling, database triggers, database change data capture, observer mode, etc.

[0069] According to an embodiment of the present invention, when the data change situation indicates that the data in the second database has changed, a high-level language program is used to read the log file of the second database. By parsing the log file, one or more modification operations that are not currently synchronized among multiple modification operations in all data tables in the second database are determined, and the change data corresponding to each of the one or more modification operations is further determined.

[0070] According to an embodiment of the present invention, after determining one or more changed data, one or more changed data are written into a changed message queue in the order of one or more modification operations in the log file, and using a data synchronization component, one or more changed data are read from the changed message queue and written into the first database to complete data synchronization, wherein the changed message queue may include a kafka queue.

[0071] According to an embodiment of the present invention, when a data query platform has been established, the data changes in the second database are monitored, and when the data in the second database changes, the log file and change message queue of the second database are used to write the changed data into the first database. By monitoring the data changes in the second database, there is no need to synchronize data when no data changes occur in the second database, which reduces the workload of data synchronization and improves resource utilization. Using the log file of the second database to determine the changed data can ensure the accuracy of the changed data, improve the accuracy of data synchronization, and thus improve the accuracy of data fuzzy query. Using the change message queue to synchronize the changed data can improve the efficiency of data synchronization and improve the utilization of resources used for data synchronization.

[0072] According to an embodiment of the present invention, based on a matching method, matching is performed in a first database using input keywords on a data query platform to obtain multiple display pages, including: based on a matching method, matching is performed in a first database using input keywords on a data query platform to obtain multiple matching results; and paging the multiple matching results based on a preset number to obtain multiple display pages.

[0073] According to an embodiment of the present invention, based on a matching method, input keywords are used to perform matching in a first database on a data query page to obtain multiple matching results, wherein the matching method may include different fields in a data table for matching, the number of input keywords, and the number of input keyword matches.

[0074] According to an embodiment of the present invention, different fields used for matching in a data table may include matching according to the content of the title of each data item, matching according to the content of the description or summary of each data item, and matching according to the entire content of each data item. The number of input keywords may include multi-field input and single-field input. In the case of multi-field input, the number of input keyword matches may include multi-field matching in which all multiple input keywords are successfully matched and single-field matching in which one of multiple input keywords is successfully matched.

[0075] According to an embodiment of the present invention, multiple matching results are paged based on a preset number to obtain multiple display pages, wherein the preset number represents the number of matching results included in each display page.

[0076] According to an embodiment of the present invention, based on the matching method, multiple matching results are obtained by matching the input keywords from the first database, which can ensure that the matching results meet the matching method selected by the user and improve the success rate of data fuzzy query. Based on the number of matching results preset in each display page, the multiple matching results are paginated to improve the readability of the matching results.

[0077] According to an embodiment of the present invention, based on a matching method, an input keyword is used to perform matching in a first database on a data query platform to obtain multiple matching results, including: processing the input keyword to obtain a query keyword for fuzzy query, wherein the query keyword includes synonyms and variant forms of the input keyword; based on the matching method, determining the data similarity between each of a plurality of first data items included in the first database and the query keyword; based on the plurality of data similarities, sorting the plurality of first data items to obtain a plurality of sorted first data items; selecting the plurality of sorted first data items whose data similarity with the query keyword is higher than a similarity threshold to obtain a plurality of matching results.

[0078] According to an embodiment of the present invention, input keywords are processed to obtain query keywords for fuzzy query, wherein the query keywords include synonyms and variant forms of the input keywords, and the processing of the input keywords includes synonym conversion and translation between different languages.

[0079] According to an embodiment of the present invention, based on the matching method, multiple first data items included in the first database are matched using the query keyword, and the first data items that fail to match are filtered from the multiple first data items. And the data similarity between each of the remaining multiple first data items and the query keyword is determined, wherein the data similarity can be determined according to different matching methods, for example, in the case of multi-field input, single-field matching is performed, and the data similarity of the first data item that successfully matches multiple fields is higher than that of the first data item that successfully matches only one field.

[0080] According to an embodiment of the present invention, based on multiple data similarities, multiple first data items are sorted in order of data similarity from high to low to obtain multiple sorted first data items. Select multiple sorted first data items whose data similarity with the query keyword is higher than the similarity threshold to obtain multiple matching results, wherein the similarity threshold can be determined based on experience, for example, single-field matching is performed in the case of multi-field input, and according to historical matching results, the results that meet the requirements of data fuzzy query are all first data items with three or more fields successfully matched, so the similarity threshold can be set to two fields.

[0081] According to an embodiment of the present invention, an input keyword is processed to obtain a query keyword. By performing synonym conversion, translation and other processing on the input keyword, a query keyword with the same semantics as the input keyword is obtained, so that in the process of using the query keyword to perform data fuzzy matching, more matching results with the same semantics but different forms can be obtained, thereby increasing the probability that the target query result required by the user is included in multiple matching results, and improving the success rate of data fuzzy query. Based on the matching method, the data similarity between the first data item in the first database and the query keyword is determined, and the multiple first data items are sorted using the data similarity, and multiple first data items with data similarity higher than the similarity threshold are selected as matching results. The first data item with higher data similarity can be ranked higher. Since the matching result with higher data similarity with the query keyword is more likely to be the target query result required by the user, the first data item with higher data similarity can be ranked in advance, which can reduce the page turning operation in the process of selecting the target query result by the user, thereby improving the user experience.

[0082] According to an embodiment of the present invention, based on the user's page switching instruction, determining the target display page corresponding to the page switching instruction includes: based on the user's page switching instruction, determining the page number of the display page that the user needs to view; based on the page number, determining the target display page.

[0083] According to an embodiment of the present invention, based on the user's page switching instruction, the page number of the display page that the user needs to view is determined, wherein the page switching instruction may be sent when the user clicks a page turning button or the page number of the display page that the user needs to view, wherein the page turning button includes the previous page or the next page, and in the case where the page switching instruction is sent after the user clicks the page turning button, the page number of the display page that the user needs to view is the previous page or the next page of the current page, and in the case where the page switching instruction is sent after the user clicks the page number of the display page that the user needs to view, the page number of the display page that the user needs to view is the page number corresponding to the button clicked by the user.

[0084] According to an embodiment of the present invention, based on the page number, the target display page that the user needs to view can be determined.

[0085] According to an embodiment of the present invention, based on the user's page switching instruction, the page number of the display page that the user needs to view is determined, and the target display page is determined using the page number. Based on the page switching instructions sent in different operation modes, the page number of the display page that the user needs to view is determined using the page number determination method corresponding to the operation mode, which can accurately locate the target display page and improve the user experience.

[0086] According to an embodiment of the present invention, based on the session cache corresponding to the target display page, multiple matching results included in the target display page are determined, including: determining the session cache based on the page number of the target display page; and determining multiple matching results stored in the session cache.

[0087] According to an embodiment of the present invention, since each session cache corresponds to a display page, and multiple display pages can be distinguished by their respective page numbers, it is possible to determine a session cache storing multiple matching results in the target display page based on the page number of the target display page, and determine the multiple matching results stored in the session cache.

[0088] According to an embodiment of the present invention, by using the page number of the target display page to determine multiple matching results from the corresponding session cache, the matching results can be determined more accurately so that the multiple matching results can be displayed, thereby improving the accuracy of data fuzzy query.

[0089] According to an embodiment of the present invention, based on the user's result selection instruction, a target query result from a plurality of matching results included in a target display page is determined from a second database, and displayed on a data management platform, including: based on the result selection instruction, determining the target query result from a plurality of matching results included in the target display page; determining detailed data corresponding to the target query result from the second database; and displaying the detailed data on the data management platform.

[0090] According to an embodiment of the present invention, based on a result selection instruction, a target query result is determined from multiple matching results included in a target display page, wherein the result selection instruction can be triggered by a user's click selection operation, i.e., when the user selects a matching result to be viewed from multiple matching results in the target display page, and clicks on the matching result, i.e., the title or index corresponding to the target query result, the result selection instruction is triggered.

[0091] According to an embodiment of the present invention, detailed data of a data item corresponding to the target query result can be determined from the second database based on the title or index corresponding to the target query result, and the detailed data can be displayed on the data management platform.

[0092] According to an embodiment of the present invention, based on the result selection instruction of the user, the target query result is determined from the target display page, and the detailed data is determined from the second database and displayed on the data management platform. By displaying the detailed data corresponding to the target query result obtained by querying in the data query platform on the data management platform, the data query platform only needs to perform data fuzzy query without data display, which can reduce the load of the data query platform and improve the efficiency of data fuzzy query.

[0093] According to an embodiment of the present invention, the first database includes a full-text indexing function and parallel processing capabilities; the data fuzzy query method also includes: in response to a data query request sent by a user to the data management platform, redirecting the data query request to the data query platform.

[0094] According to an embodiment of the present invention, the first database may include a full-text indexing function and parallel processing capabilities, so that data queries can be performed more quickly. In response to a data query request sent by a user to the data management platform, the data query request is redirected to the data query platform so that a fuzzy query is performed on the data in the first database on the data query platform.

[0095] According to an embodiment of the present invention, when a user sends a data query request to a data management platform, the data query request is redirected to the data query platform so as to perform a data fuzzy query from the first database. In addition, since the first database includes a full-text indexing function and parallel processing capabilities, the data query efficiency of the first database is higher.

[0096] Figure 3 The hardware structure diagram of the data fuzzy query method according to an embodiment of the present invention is schematically shown.

[0097] like Figure 3 As shown, the hardware structure of the data fuzzy query method includes a user 301 , a data management platform 302 , a data query platform 303 , a second database 304 and a first database 305 .

[0098] According to an embodiment of the present invention, when establishing the data query platform 303, the log file of the second database 304 is read and analyzed, and the data synchronization component writes the synchronization data into the first database 305. After completing the data synchronization, the data changes of the second database 304 are continuously monitored. When the data of the second database 304 changes, the log file of the second database 304 is read and analyzed, and the data synchronization component writes the changed data into the first database 305, thereby ensuring that the data stored in the first database 305 is consistent with and correct to the data stored in the second database 304.

[0099] According to an embodiment of the present invention, user 301 sends a data query request to data management platform 302, and the data query request is redirected to data query platform 303. Data query platform 303 performs fuzzy query on the data stored in first database 305 according to the data query request, and displays the matching results in the form of multiple display pages to user 301. User 301 can issue a page switching instruction to switch to the target display page, and select the matching result to be viewed from the multiple matching results in the target display page, and send a result selection instruction.

[0100] According to an embodiment of the present invention, the data management platform 302 determines the target query result corresponding to the result selection instruction based on the result selection instruction, and displays all the contents of the data items corresponding to the target query result from the second database 304 on the interface of the data management platform 302.

[0101] Based on the above data fuzzy query method, the present invention also provides a data fuzzy query device. Figure 4 The device is described in detail.

[0102] Figure 4 The structure block diagram of the data fuzzy query device according to an embodiment of the present invention is schematically shown.

[0103] like Figure 4 As shown, the data fuzzy query device 400 of this embodiment includes a keyword determination module 410 , a page determination module 420 , a page switching module 430 , a result determination module 440 and a result display module 450 .

[0104] The keyword determination module 410 is used to respond to the data query request sent by the user to the data management platform, determine the matching mode of the data query and the input keyword. In one embodiment, the keyword determination module 410 can be used to perform the operation S210 described above, which will not be repeated here.

[0105] The page determination module 420 is used to match the input keyword in the first database on the data query platform based on the matching method to obtain multiple display pages, wherein the multiple display pages are obtained by paging multiple matching results that match the input keyword in the first database, and each display page includes a preset number of matching results except the last display page, and the number of matching results included in the last display page is less than or equal to the preset number. In one embodiment, the page determination module 420 can be used to perform the operation S220 described above, which will not be repeated here.

[0106] The page switching module 430 is used to determine the target display page corresponding to the page switching instruction based on the page switching instruction of the user. In one embodiment, the page switching module 430 can be used to perform the operation S230 described above, which will not be repeated here.

[0107] The result determination module 440 is used to determine multiple matching results included in the target display page based on the session cache corresponding to the target display page, wherein the data query platform includes multiple session caches, and the multiple display pages correspond to the multiple session caches one by one. In one embodiment, the result determination module 440 can be used to perform the operation S240 described above, which will not be repeated here.

[0108] The result display module 450 is used to determine the target query result from the second database among the multiple matching results included in the target display page based on the result selection instruction of the user, and display it on the data management platform. In one embodiment, the result display module 450 can be used to perform the operation S250 described above, which will not be repeated here.

[0109] According to an embodiment of the present invention, the data fuzzy query device 400 further includes a first file reading module, a first file parsing module, a synchronous data recording module and a synchronous data writing module.

[0110] The first file reading module is used to read the log file of the second database when a new data query platform is created.

[0111] The first file parsing module is used to parse the log file to obtain multiple synchronization data.

[0112] The synchronous data recording module is used to write multiple synchronous data into the synchronous message queue.

[0113] The synchronous data writing module is used to read multiple synchronous data from the synchronous message queue by using the data synchronization component, and write the multiple synchronous data into the first database.

[0114] According to an embodiment of the present invention, the data fuzzy query device 400 further includes a database monitoring module, a second file reading module, a second file parsing module, a change data recording module and a change data writing module.

[0115] The database monitoring module is used to monitor the data changes of the second database when the data query platform has been established.

[0116] The second file reading module is used to read the log file of the second database when the data change situation indicates that the data in the second database has changed.

[0117] The second file parsing module is used to parse the log file to obtain one or more change data.

[0118] The change data recording module is used to write one or more change data into the change message queue.

[0119] The change data writing module is used to read one or more change data from the change message queue using the data synchronization component, and write the one or more change data into the first database.

[0120] According to an embodiment of the present invention, the page determination module 420 includes a keyword matching submodule and a result paging submodule.

[0121] The keyword matching submodule is used to match the input keyword in the first database based on the matching method on the data query platform to obtain multiple matching results.

[0122] The result paging submodule is used to paginate multiple matching results based on a preset number to obtain multiple display pages.

[0123] According to an embodiment of the present invention, the keyword matching submodule includes a query keyword determination unit, a similarity determination unit, a data sorting unit and a data selection unit.

[0124] The query keyword determination unit is used to process the input keyword to obtain the query keyword used for fuzzy query, wherein the query keyword includes synonyms and variant forms of the input keyword.

[0125] The similarity determination unit is used to determine the data similarity between each of the plurality of first data items included in the first database and the query keyword based on the matching method.

[0126] The data sorting unit is used to sort the multiple first data items based on multiple data similarities to obtain the sorted multiple first data items.

[0127] The data selection unit is used to select a plurality of sorted first data items whose data similarity with the query keyword is higher than a similarity threshold, and obtain a plurality of matching results.

[0128] According to an embodiment of the present invention, the page switching module 430 includes a page number determination submodule and a page switching submodule.

[0129] The page number determination submodule is used to determine the page number of the display page that the user needs to view based on the user's page switching instruction.

[0130] The page switching submodule is used to determine the target display page based on the page number.

[0131] According to an embodiment of the present invention, the result determination module 440 includes a cache determination submodule and a result determination submodule.

[0132] The cache determination submodule is used to determine the session cache based on the page number of the target display page.

[0133] The result determination submodule is used to determine multiple matching results stored in the session cache.

[0134] According to an embodiment of the present invention, the result display module 450 includes a target result determination submodule, a data determination submodule and a result display submodule.

[0135] The target result determination submodule is used to determine the target query result from the multiple matching results included in the target display page based on the result selection instruction.

[0136] The data determination submodule is used to determine detailed data corresponding to the target query result from the second database.

[0137] The result display submodule is used to display detailed data on the data management platform.

[0138] According to an embodiment of the present invention, the first database includes a full-text indexing function and a parallel processing capability; the data fuzzy query device 400 also includes a request redirection module.

[0139] The request redirection module is used to respond to the data query request sent by the user to the data management platform and redirect the data query request to the data query platform.

[0140] According to an embodiment of the present invention, any multiple modules among the keyword determination module 410, the page determination module 420, the page switching module 430, the result determination module 440 and the result display module 450 can be combined into one module for implementation, or any one of the modules can be split into multiple modules. Alternatively, at least part of the functions of one or more of these modules can be combined with at least part of the functions of other modules and implemented in one module. According to an embodiment of the present invention, at least one of the keyword determination module 410, the page determination module 420, the page switching module 430, the result determination module 440 and the result display module 450 can be at least partially implemented as a hardware circuit, such as a field programmable gate array (FPGA), a programmable logic array (PLA), a system on a chip, a system on a substrate, a system on a package, an application specific integrated circuit (ASIC), or can be implemented by hardware or firmware such as any other reasonable way of integrating or packaging the circuit, or implemented in any one of the three implementation methods of software, hardware and firmware or in a suitable combination of any of them. Alternatively, at least one of the keyword determination module 410, the page determination module 420, the page switching module 430, the result determination module 440 and the result display module 450 may be at least partially implemented as a computer program module, which may perform a corresponding function when executed.

[0141] Figure 5 A block diagram of an electronic device suitable for implementing a data fuzzy query method according to an embodiment of the present invention is schematically shown.

[0142] like Figure 5 As shown, the electronic device 500 according to an embodiment of the present invention includes a processor 501, which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM) 502 or a program loaded from a storage part 508 to a random access memory (RAM) 503. The processor 501 may include, for example, a general-purpose microprocessor (such as a CPU), an instruction set processor and / or a related chipset and / or a special-purpose microprocessor (for example, an application-specific integrated circuit (ASIC)), etc. The processor 501 may also include an onboard memory for caching purposes. The processor 501 may include a single processing unit or multiple processing units for performing different actions of the method flow according to an embodiment of the present invention.

[0143] In RAM 503, various programs and data required for the operation of electronic device 500 are stored. Processor 501, ROM 502 and RAM 503 are connected to each other via bus 504. Processor 501 performs various operations of the method flow according to the embodiment of the present invention by executing the program in ROM 502 and / or RAM 503. It should be noted that the program can also be stored in one or more memories other than ROM 502 and RAM 503. Processor 501 can also perform various operations of the method flow according to the embodiment of the present invention by executing the program stored in the one or more memories.

[0144] According to an embodiment of the present invention, the electronic device 500 may further include an input / output (I / O) interface 505, which is also connected to the bus 504. The electronic device 500 may further include one or more of the following components connected to the input / output (I / O) interface 505: an input portion 506 including a keyboard, a mouse, etc.; an output portion 507 including a cathode ray tube (CRT), a liquid crystal display (LCD), etc., and a speaker, etc.; a storage portion 508 including a hard disk, etc.; and a communication portion 509 including a network interface card such as a LAN card, a modem, etc. The communication portion 509 performs communication processing via a network such as the Internet. A drive 510 is also connected to the input / output (I / O) interface 505 as needed. A removable medium 511, such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, etc., is installed on the drive 510 as needed, so that the computer program read therefrom is installed into the storage portion 508 as needed.

[0145] The present invention also provides a computer-readable storage medium, which may be included in the device / apparatus / system described in the above embodiment; or may exist independently without being assembled into the device / apparatus / system. The above computer-readable storage medium carries one or more programs, and when the above one or more programs are executed, the method according to the embodiment of the present invention is implemented.

[0146] According to an embodiment of the present invention, the computer-readable storage medium may be a non-volatile computer-readable storage medium, for example, may include but is not limited to: a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination thereof. In the present invention, the computer-readable storage medium may be any tangible medium containing or storing a program, which may be used by or in combination with an instruction execution system, an apparatus or a device. For example, according to an embodiment of the present invention, the computer-readable storage medium may include the ROM 502 and / or RAM 503 described above and / or one or more memories other than ROM 502 and RAM 503.

[0147] The embodiment of the present invention also includes a computer program product, which includes a computer program, and the computer program contains program code for executing the method shown in the flowchart. When the computer program product is run in a computer system, the program code is used to enable the computer system to implement the method provided by the embodiment of the present invention.

[0148] The computer program executes the above functions defined in the system / device of the embodiment of the present invention when it is executed by the processor 501. According to the embodiment of the present invention, the system, device, module, unit, etc. described above can be implemented by a computer program module.

[0149] In one embodiment, the computer program may rely on tangible storage media such as optical storage devices, magnetic storage devices, etc. In another embodiment, the computer program may also be transmitted and distributed in the form of signals on a network medium, and downloaded and installed through the communication part 509, and / or installed from the removable medium 511. The program code contained in the computer program may be transmitted using any appropriate network medium, including but not limited to: wireless, wired, etc., or any suitable combination of the above.

[0150] In such an embodiment, the computer program can be downloaded and installed from the network through the communication part 509, and / or installed from the removable medium 511. When the computer program is executed by the processor 501, the above functions defined in the system of the embodiment of the present invention are performed. According to the embodiment of the present invention, the system, device, means, module, unit, etc. described above can be implemented by a computer program module.

[0151] According to an embodiment of the present invention, the program code for executing the computer program provided by the embodiment of the present invention can be written in any combination of one or more programming languages. Specifically, these computing programs can be implemented using high-level process and / or object-oriented programming languages, and / or assembly / machine languages. Programming languages ​​include, but are not limited to, Java, C++, python, "C" language or similar programming languages. The program code can be executed entirely on the user computing device, partially on the user device, partially on the remote computing device, or entirely on the remote computing device or server. In the case of a remote computing device, the remote computing device can be connected to the user computing device through any type of network, including a local area network (LAN) or a wide area network (WAN), or can be connected to an external computing device (e.g., using an Internet service provider to connect through the Internet).

[0152] The flow chart and block diagram in the accompanying drawings illustrate the possible architecture, function and operation of the system, method and computer program product according to various embodiments of the present invention. In this regard, each box in the flow chart or block diagram can represent a module, a program segment, or a part of a code, and the above-mentioned module, program segment, or a part of a code contains one or more executable instructions for realizing the specified logical function. It should also be noted that in some alternative implementations, the functions marked in the box can also occur in a different order from the order marked in the accompanying drawings. For example, two boxes represented in succession can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each box in the block diagram or flow chart, and the combination of the boxes in the block diagram or flow chart can be implemented with a dedicated hardware-based system that performs a specified function or operation, or can be implemented with a combination of dedicated hardware and computer instructions.

[0153] It will be appreciated by those skilled in the art that the features described in the various embodiments of the present invention may be combined and / or combined in various ways, even if such combinations or combinations are not explicitly described in the present invention. In particular, without departing from the spirit and teachings of the present invention, the features described in the various embodiments of the present invention may be combined and / or combined in various ways. All of these combinations and / or combinations fall within the scope of the present invention.

[0154] The embodiments of the present invention are described above. However, these embodiments are only for the purpose of illustration, and are not intended to limit the scope of the present invention. Although each embodiment is described above, it does not mean that the measures in each embodiment cannot be used in combination advantageously. Without departing from the scope of the present invention, those skilled in the art may make various substitutions and modifications, which should all fall within the scope of the present invention.

Claims

1. A data fuzzy query method, characterized in that: The method comprises: In response to a data query request sent by a user to the data management platform, determine a matching method for the data query and input keywords; Based on the matching method, the input keyword is used to match in the first database on the data query platform to obtain multiple display pages, wherein the multiple display pages are obtained by paging multiple matching results matching the input keyword in the first database, and each of the display pages, except the last display page, includes a preset number of matching results, and the number of matching results included in the last display page is less than or equal to the preset number; Based on the page switching instruction of the user, determining a target display page corresponding to the page switching instruction; Based on the session cache corresponding to the target display page, determine a plurality of matching results included in the target display page, wherein the data query platform includes a plurality of the session caches, and the plurality of display pages correspond one-to-one to the plurality of session caches; Based on the result selection instruction of the user, determining a target query result from the plurality of matching results included in the target display page from the second database, and displaying the result on the data management platform; The data query platform uses the first database to query data, the data management platform uses the second database to manage data, and the data in the first database is obtained by data synchronization using the log file of the second database by the data synchronization component.

2. The method according to claim 1, characterized in that The data in the first database is obtained by synchronizing data using the log file of the second database by the data synchronization component, including: When the data query platform is newly established, reading the log file of the second database; Parsing the log file to obtain multiple synchronization data; Writing the plurality of synchronization data into a synchronization message queue; The data synchronization component is used to read the multiple synchronization data from the synchronization message queue, and the multiple synchronization data are written into the first database.

3. The method according to claim 1, characterized in that: The data in the first database is obtained by synchronizing data using the log file of the second database by the data synchronization component, including: When the data query platform has been established, monitoring the data changes of the second database; When the data change situation indicates that the data in the second database has changed, reading a log file of the second database; Parsing the log file to obtain one or more change data; Writing the one or more change data into the change message queue; The data synchronization component is used to read the one or more change data from the change message queue, and write the one or more change data into the first database.

4. The method according to claim 1, characterized in that: Based on the matching method, the input keyword is matched in the first database on the data query platform to obtain multiple display pages, including: Based on the matching method, matching is performed in the first database using the input keyword on the data query platform to obtain the multiple matching results; The multiple matching results are paginated based on the preset number to obtain the multiple display pages.

5. The method according to claim 4, characterized in that Based on the matching method, matching is performed in the first database using the input keyword on the data query platform to obtain the multiple matching results, including: Processing the input keyword to obtain a query keyword for fuzzy query, wherein the query keyword includes synonyms and variant forms of the input keyword; Based on the matching method, determining the data similarity between each of the plurality of first data items included in the first database and the query keyword; sorting the plurality of first data items based on the plurality of data similarities to obtain a plurality of sorted first data items; The sorted plurality of first data items whose data similarity with the query keyword is higher than a similarity threshold are selected to obtain the plurality of matching results.

6. The method according to claim 1, characterized in that The determining, based on the page switching instruction of the user, a target display page corresponding to the page switching instruction comprises: Based on the page switching instruction of the user, determining the page number of the displayed page that the user needs to view; Based on the page number, the target display page is determined.

7. The method according to claim 1, characterized in that The determining, based on the session cache corresponding to the target display page, a plurality of matching results included in the target display page comprises: Determining the session cache based on the page number of the target display page; A plurality of the matching results stored in the session cache is determined.

8. The method according to claim 1, characterized in that The step of determining, based on the result selection instruction of the user, a target query result from a plurality of matching results included in the target display page from a second database, and displaying the target query result on the data management platform comprises: Based on the result selection instruction, determining the target query result from the multiple matching results included in the target display page; Determining detailed data corresponding to the target query result from the second database; The detailed data is displayed on the data management platform.

9. The method according to claim 1, characterized in that: The first database includes full-text indexing functionality and parallel processing capabilities; The method further comprises: In response to the data query request sent by the user to the data management platform, the data query request is redirected to the data query platform.

10. A data fuzzy query device, characterized in that: The device comprises: A keyword determination module, used to determine a matching method and input keywords for data query in response to a data query request sent by a user to the data management platform; a page determination module, configured to perform matching in a first database using the input keyword on a data query platform based on the matching mode, and obtain a plurality of display pages, wherein the plurality of display pages are obtained by paging a plurality of matching results matching the input keyword in the first database, and each of the display pages, except for the last display page, includes a preset number of the matching results, and the number of the matching results included in the last display page is less than or equal to the preset number; A page switching module, used to determine a target display page corresponding to the page switching instruction based on the page switching instruction of the user; A result determination module, configured to determine a plurality of matching results included in the target display page based on a session cache corresponding to the target display page, wherein the data query platform includes a plurality of the session caches, and the plurality of display pages correspond one-to-one to the plurality of session caches; A result display module, configured to determine, based on the result selection instruction of the user, a target query result from the second database among the plurality of matching results included in the target display page, and display the result on the data management platform; The data query platform uses the first database to query data, the data management platform uses the second database to manage data, and the data in the first database is obtained by data synchronization using the log file of the second database by the data synchronization component.

Images