A multi-database-based data query method and device

Abstract

The application provides a kind of based on multi-database data query method and device, it is related to big data technical field.The method includes: receiving the query request sent by user end, the query request includes data table name and query field;According to the data table name, determine the corresponding query database from the database of multiple different storage structures;Wherein, the database of multiple different storage structures is preset;The query request is forwarded to the database server of the database of the data table name corresponding query database belongs to and carries out data query;Receive the query result returned by the database server, and return the query result to the user end.The device is used to execute the above method.The data query method and device based on multi-database provided in the embodiment of the application improve data query efficiency.

Description

Technical Field

[0001] This invention relates to the field of big data technology, and specifically to a data query method and apparatus based on multiple databases. Background Technology

[0002] A database is a repository for data, and it can generally be divided into relational databases and non-relational databases. Banks typically use one type of database to store their business data.

[0003] Bank business departments often need to retrieve customer-related data from databases. In practical banking applications, single-dimensional data queries are relatively fast, but multi-dimensional data queries are less efficient. Therefore, developing a database query method to improve data retrieval efficiency is a crucial issue that the industry urgently needs to address. Summary of the Invention

[0004] To address the problems in the prior art, embodiments of the present invention provide a data query method and apparatus based on multiple databases, which can at least partially solve the problems existing in the prior art.

[0005] Firstly, this invention proposes a data query method based on multiple databases, including:

[0006] Receive a query request sent by the user, the query request including the data table name and query fields;

[0007] The corresponding query database is determined from multiple databases with different storage structures based on the data table name; wherein, the multiple databases with different storage structures are preset.

[0008] The query request is forwarded to the database server of the database corresponding to the data table name for data query;

[0009] Receive the query results returned by the database server and return the query results to the user terminal.

[0010] Furthermore, the multiple databases with different storage structures include a first database and a second database, and the data storage structures of the first database and the second database are different; the first database is used to query a second field corresponding to the multiple first fields in a first data table based on multiple first fields, and the second database is used to query multiple first fields corresponding to the second field in a second data table based on the second field.

[0011] Furthermore, determining the corresponding query database from multiple databases with different storage structures based on the data table name includes:

[0012] If it is determined that the data table name corresponds to the first database, then the corresponding query database is determined to be the first database;

[0013] If it is determined that the data table name corresponds to the second database, then the corresponding query database is determined to be the second database.

[0014] Furthermore, the first data table and the second data table are updated periodically.

[0015] Secondly, the present invention provides a data query device based on multiple databases, comprising:

[0016] The receiving unit is used to receive a query request sent by the user terminal, wherein the query request includes a data table name and query fields;

[0017] The determining unit is configured to determine the corresponding query database from multiple databases with different storage structures based on the data table name; wherein, the multiple databases with different storage structures are preset.

[0018] The forwarding unit is used to forward the query request to the database server to which the query database corresponding to the data table name belongs for data querying;

[0019] The return unit is used to receive the query results returned by the database server and return the query results to the user terminal.

[0020] Furthermore, the multiple databases with different storage structures include a first database and a second database, and the data storage structures of the first database and the second database are different; the first database is used to query a second field corresponding to the multiple first fields in a first data table based on multiple first fields, and the second database is used to query multiple first fields corresponding to the second field in a second data table based on the second field.

[0021] Furthermore, determining the corresponding query database from multiple databases with different storage structures based on the data table name includes:

[0022] If it is determined that the data table name corresponds to the first database, then the corresponding query database is determined to be the first database;

[0023] If it is determined that the data table name corresponds to the second database, then the corresponding query database is determined to be the second database.

[0024] Furthermore, the first data table and the second data table are updated periodically.

[0025] Thirdly, the present invention provides a computer device, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the program to implement the data query method based on multiple databases as described in any of the above embodiments.

[0026] Fourthly, the present invention provides a computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements the data query method based on multiple databases as described in any of the above embodiments.

[0027] Fifthly, the present invention provides a computer program product, the computer program product comprising a computer program, which, when executed by a processor, implements the data query method based on multiple databases as described in any of the above embodiments.

[0028] The data query method and apparatus based on multiple databases provided in this invention can receive query requests sent by a user terminal, determine the corresponding query database from multiple databases with different storage structures according to the data table name, forward the query request to the database server to which the query database corresponding to the data table name belongs for data query, receive the query results returned by the database server, and return the query results to the user terminal. By selecting a suitable database for data query, the data query efficiency is improved. Attached Figure Description

[0029] To more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort. In the drawings:

[0030] Figure 1 This is a schematic diagram of the structure of a data query system based on multiple databases provided in the first embodiment of the present invention.

[0031] Figure 2 This is a flowchart illustrating the data query method based on multiple databases provided in the second embodiment of the present invention.

[0032] Figure 3 This is a schematic diagram of the structure of a data query device based on multiple databases provided in the third embodiment of the present invention.

[0033] Figure 4 This is a schematic diagram of the structure of a data query device based on multiple databases provided in the fourth embodiment of the present invention.

[0034] Figure 5This is a schematic diagram of the physical structure of the computer device provided in the fifth embodiment of the present invention. Detailed Implementation

[0035] To make the objectives, technical solutions, and advantages of the embodiments of the present invention clearer, the embodiments of the present invention will be further described in detail below with reference to the accompanying drawings. Here, the illustrative embodiments and descriptions of the present invention are used to explain the present invention, but are not intended to limit the present invention. It should be noted that, unless otherwise specified, the embodiments and features in the embodiments of this application can be arbitrarily combined with each other. The acquisition, storage, use, and processing of data in the technical solutions of this application all comply with the relevant provisions of national laws and regulations.

[0036] Figure 1 This is a schematic diagram of the structure of the data query system based on multiple databases provided in the first embodiment of the present invention, as shown below. Figure 1 As shown, the data query system based on multiple databases provided in this embodiment of the invention includes a user terminal 1, a scheduling server 2, and multiple database servers 3, wherein:

[0037] User terminal 1 communicates with scheduling server 2, and scheduling server 2 communicates with each database server 3. User terminal 1 includes, but is not limited to, desktop computers, laptops, PDAs, and other devices.

[0038] A browser can be configured on client 1, allowing users to query data. Client 1 sends the query request to scheduling server 2. Heterogeneous databases are configured on multiple database servers 3, with at least two types configured. The types of heterogeneous databases configured are set according to actual needs, and this embodiment of the invention does not impose any limitations.

[0039] For example, configure two databases: Hermes and HBase. Hermes database offers real-time, multidimensional, and interactive query, statistical, and analytical capabilities, supporting various products in big data statistical analysis. It can achieve second-level statistical analysis of tens of thousands of dimensions and hundreds of billions of data points. HBase database is a column-oriented distributed database with a robust distributed architecture, enabling rapid storage and random access to massive amounts of data. Based on data replication and partitioning mechanisms, it can easily achieve online scaling up, scaling down, and data disaster recovery, making it the most commonly used database for key-value data structure storage in the big data field.

[0040] Understandably, a query request sent by client 1 can be forwarded to scheduling server 2 through an intermediate server.

[0041] The following describes the specific implementation process of the data query method based on multiple databases provided in this embodiment of the invention, taking the scheduling server as the execution subject as an example.

[0042] Figure 2 This is a flowchart illustrating the data query method based on multiple databases provided in the first embodiment of the present invention, as shown below. Figure 2 As shown, the data query method based on multiple databases provided in this embodiment of the invention includes:

[0043] S201. Receive a query request sent by the user terminal, the query request including the data table name and query fields;

[0044] Specifically, the user sends a query request to the scheduling server through the user terminal. The query request includes a data table name and query fields. The query fields can be one or multiple, depending on actual needs; this embodiment of the invention does not impose any limitations. The scheduling server receives the query request and obtains the data table name from it.

[0045] S202. Determine the corresponding query database from multiple databases with different storage structures based on the data table name; wherein, the multiple databases with different storage structures are preset;

[0046] Specifically, the scheduling server determines the database to which the data table name belongs based on the data table name and multiple databases with different storage structures, and uses the database to which the data table name belongs as the query database corresponding to the data table name. The multiple databases with different storage structures are preset, including the correspondence between the databases and each data table name.

[0047] It's important to note that databases with different storage structures are heterogeneous databases, and these structures are suited to different data query methods. For example, Hermes database tables offer high data query efficiency when querying a single field from multiple fields; while HBase databases offer high query efficiency when querying multiple field values ​​from a single field (key).

[0048] S203. Forward the query request to the database server to which the query database corresponding to the data table name belongs for data query;

[0049] Specifically, after determining the query database corresponding to the data table name, the scheduling server forwards the query request to the database server to which the query database belongs. Upon receiving the query request, the database server queries the corresponding data based on the query fields and returns the query results to the scheduling server.

[0050] S204. Receive the query results returned by the database server and return the query results to the user terminal.

[0051] Specifically, the scheduling server receives the query results returned by the database server, and then returns the query results to the user terminal for the user to view.

[0052] The data query method based on multiple databases provided in this embodiment of the invention can receive query requests sent by the user terminal, determine the corresponding query database from multiple databases with different storage structures according to the data table name, forward the query request to the database server to which the query database corresponding to the data table name belongs for data query, receive the query results returned by the database server, and return the query results to the user terminal. By selecting a suitable database for data query, the data query efficiency is improved.

[0053] Based on the above embodiments, the plurality of databases with different storage structures further include a first database and a second database, wherein the data storage structures of the first database and the second database are different; the first database is used to query a second field corresponding to the plurality of first fields in a first data table based on a plurality of first fields, and the second database is used to query a plurality of first fields corresponding to the second field in a second data table based on a second field.

[0054] Specifically, a first data table is pre-created and stored in a first database, and a second data table related to the first data table is created and stored in the second database. The first data table is built based on multiple first fields and a corresponding second field, with multiple first fields corresponding to a second field. When the first database queries the corresponding second field using multiple first fields, the query efficiency is high. The second data table is built based on a second field and multiple corresponding first fields. When the first database queries the corresponding multiple first fields using a second field, the query efficiency is high.

[0055] Because the first and second databases have different storage structures, the first database is less efficient than the second database when querying multiple first fields using a second field; conversely, the second database is less efficient when querying a corresponding first field using multiple first fields. In other words, the first database is suitable for many-to-one queries, such as Hermes, while the second database is suitable for one-to-many queries, such as HBase. Therefore, a first table is created in the first database to improve the query efficiency when querying a single second field using multiple first fields; and a second table is created in the second database to improve the query efficiency when querying multiple first fields using a single second field.

[0056] Based on the above embodiments, further, determining the corresponding query database from multiple databases with different storage structures according to the data table name includes:

[0057] If it is determined that the data table name corresponds to the first database, then the corresponding query database is determined to be the first database;

[0058] If it is determined that the data table name corresponds to the second database, then the corresponding query database is determined to be the second database.

[0059] Specifically, a pre-defined mapping between data table names and databases with different storage structures is established, ensuring that each data table name uniquely corresponds to a database. If the scheduling server finds a data table name corresponding to a first database, it determines that the database corresponding to that data table name is the first database and performs a data query in that database. Similarly, if the scheduling server finds a data table name corresponding to a second database, it determines that the database corresponding to that data table name is the second database and performs a data query in that database.

[0060] Based on the above embodiments, the first data table and the second data table are further updated periodically.

[0061] Specifically, since the original data related to the first and second data tables is updated periodically, the data in the first and second data tables will be updated periodically during the periodic updates of the original data to ensure the comprehensiveness of the data query.

[0062] The following uses customer tagging in banking as an example to illustrate the specific implementation process of the data query method based on multiple databases provided in this embodiment of the invention.

[0063] Customer tagging refers to the classification of customers. Every day at midnight, the bank executes a script to tag customers based on the previous day's customer data. Tags include, but are not limited to, regional tags, important customer tags, and special customer tags, which are set according to actual needs; this embodiment of the invention does not impose such limitations.

[0064] The results of customer tagging are distributed and stored in the business system. Each customer tagging result includes their customer ID and corresponding tag. A two-dimensional table is created with the customer ID as the horizontal axis and the tag as the vertical axis, serving as the customer ID lookup table, and stored in the Hermes database. Many customers have more than one tag; the customer ID lookup table allows for quick retrieval of customers with multiple tags. Comparing the current tagging result with the previous tagging result allows us to determine if the customer's tag has changed. Using the customer ID as the primary key, the customer's corresponding tag and any tag changes as primary key values, this is stored in an HBase columnar storage database as the customer tag lookup table. Since customers are tagged daily, the daily customer ID and customer tag lookup tables are mapped to the daily date, resulting in date-ordered customer ID and customer tag lookup tables. Each customer ID is uniquely associated with a customer, and the customer tag lookup table allows for quick retrieval of tags corresponding to a customer ID. The customer ID lookup table corresponds to the Hermes database. The customer tag lookup table corresponds to the HBase columnar storage database. Each customer is uniquely associated with their customer ID, allowing for retrieval of customer information within the bank system using the customer ID.

[0065] To find out which customers correspond to tags 1 and 2, banking staff can send a query request to the dispatch server via their work computers. The query request includes a customer number lookup table, tags 1 and 2. The dispatch server, based on the customer number lookup table, determines that the database to be queried is the Hermes database and forwards the query request to the primary database server to which the Hermes database belongs. The primary database server then performs a data query based on the customer number lookup table, tags 1 and 2, searching for the customer numbers corresponding to tags 1 and 2 in the customer number lookup table for all dates. The server then sends the query results to the dispatch server, which returns them to the banking staff's work computers for viewing.

[0066] To find out which tags correspond to customer number X, banking staff can send a query request to the scheduling server via their work computer. The query request includes the customer tag lookup table and the customer number. Based on the customer tag lookup table, the scheduling server determines that the database to be queried is an HBase column-oriented database and forwards the query request to the secondary database server that owns the HBase column-oriented database. The secondary database server then performs a data query based on the customer tag lookup table and the customer number, searching for the tags corresponding to the customer number in the customer tag lookup table for all dates. The server then sends the query results back to the scheduling server, which returns them to the banking staff's work computer for viewing.

[0067] Understandably, banking staff can specify a date range for their query to narrow down the data search. For example, if they are most interested in a customer's latest tags, they can query the customer tag lookup table for the previous day.

[0068] The data query method based on multiple databases provided by this invention achieves multi-dimensional query performance that meets real-time query requirements through multi-structure and multi-backup storage of data. By redundant storage of data in space, it expands the application scenarios of real-time query. The databases used are not limited to multi-dimensional analysis databases with various structures such as Hermes and columnar storage databases such as HBase.

[0069] Figure 3 This is a schematic diagram of the structure of the data query device based on multiple databases provided in the third embodiment of the present invention, as shown below. Figure 3 As shown, the data query device based on multiple databases provided in this embodiment of the invention includes a receiving unit 301, a determining unit 302, a forwarding unit 303, and a returning unit 304, wherein:

[0070] The receiving unit 301 is used to receive a query request sent by the user terminal, the query request including a data table name and query fields; the determining unit 302 is used to determine the corresponding query database from multiple databases with different storage structures according to the data table name; wherein, the multiple databases with different storage structures are preset; the forwarding unit 303 is used to forward the query request to the database server to which the query database corresponding to the data table name belongs for data query; the returning unit 304 is used to receive the query result returned by the database server and return the query result to the user terminal.

[0071] Specifically, the user sends a query request to the receiving unit 301 through the user terminal. The query request includes a data table name and query fields. The query fields can be one or multiple, depending on actual needs; this embodiment of the invention does not impose any limitations. The receiving unit 301 receives the query request and obtains the data table name from it.

[0072] The determining unit 302 determines the database to which the data table name belongs among multiple databases with different storage structures based on the data table name, and uses the database to which the data table name belongs as the query database corresponding to the data table name. The multiple databases with different storage structures are preset, including the correspondence between the databases and each data table name.

[0073] After determining the query database corresponding to the data table name, the forwarding unit 303 forwards the query request to the database server to which the query database corresponding to the data table name belongs. Upon receiving the query request, the database server queries the corresponding data based on the query fields and returns the query results to the scheduling server.

[0074] The return unit 304 receives the query results returned by the database server and then returns the query results to the user terminal for the user to view.

[0075] The data query device based on multiple databases provided in this embodiment of the invention can receive query requests sent by the user terminal, determine the corresponding query database from multiple databases with different storage structures according to the data table name, forward the query request to the database server to which the query database corresponding to the data table name belongs for data query, receive the query results returned by the database server, and return the query results to the user terminal. By selecting a suitable database for data query, the data query efficiency is improved.

[0076] Based on the above embodiments, the plurality of databases with different storage structures further include a first database and a second database, wherein the data storage structures of the first database and the second database are different; the first database is used to query a second field corresponding to the plurality of first fields in a first data table based on a plurality of first fields, and the second database is used to query a plurality of first fields corresponding to the second field in a second data table based on a second field.

[0077] Figure 4 This is a schematic diagram of the structure of the data query device based on multiple databases provided in the fourth embodiment of the present invention, as shown below. Figure 4 As shown, based on the above embodiments, the determining unit 302 further includes a first determining subunit 3021 and a second determining subunit 3022, wherein:

[0078] The first judgment subunit 3021 is used to determine the corresponding query database as the first database after determining that the data table name corresponds to the first data table; the second judgment subunit 3022 is used to determine the corresponding query database as the second database after determining that the data table name corresponds to the second data table.

[0079] Based on the above embodiments, the first data table and the second data table are further updated periodically.

[0080] The embodiments of the device provided in this invention can be used to execute the processing flow of the above-described method embodiments. Its functions will not be repeated here, but can be referred to the detailed description of the above-described method embodiments.

[0081] It should be noted that the data query method and apparatus based on multiple databases provided in the embodiments of the present invention can be used in the financial field, or in any technical field other than the financial field. The embodiments of the present invention do not limit the application field of the data query method and apparatus based on multiple databases.

[0082] Figure 5 This is a schematic diagram of the physical structure of the computer device provided in the fifth embodiment of the present invention, as shown below. Figure 5 As shown, the computer device may include a processor 501, a communications interface 502, a memory 503, and a communication bus 504. The processor 501, communications interface 502, and memory 503 communicate with each other via the communication bus 504. The processor 501 can invoke logical instructions in the memory 503 to execute the following methods: receiving a query request sent by a user client, the query request including a data table name and query fields; determining the corresponding query database from multiple databases with different storage structures based on the data table name; wherein the multiple databases with different storage structures are preset; forwarding the query request to the database server to which the query database corresponding to the data table name belongs for data query; receiving the query result returned by the database server, and returning the query result to the user client.

[0083] Furthermore, the logical instructions in the aforementioned memory 503 can be implemented as software functional units and, when sold or used as independent products, can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present invention, in essence, or the part that contributes to the prior art, or a part of the technical solution, can be embodied in the form of a software product. This computer software product is stored in a storage medium and includes several instructions to cause a computer device (which may be a personal computer, server, or network device, etc.) to execute all or part of the steps of the methods described in the various embodiments of the present invention. The aforementioned storage medium includes various media capable of storing program code, such as USB flash drives, portable hard drives, read-only memory (ROM), random access memory (RAM), magnetic disks, or optical disks.

[0084] This embodiment discloses a computer program product, which includes a computer program stored on a non-transitory computer-readable storage medium. The computer program includes program instructions, and when the program instructions are executed by a computer, the computer can perform the methods provided in the above-described method embodiments, such as: receiving a query request sent by a user terminal, the query request including a data table name and a query field; determining a corresponding query database from multiple databases with different storage structures based on the data table name; wherein the multiple databases with different storage structures are preset; forwarding the query request to the database server to which the query database corresponding to the data table name belongs for data query; receiving the query result returned by the database server, and returning the query result to the user terminal.

[0085] This embodiment provides a computer-readable storage medium storing a computer program that causes the computer to execute the methods provided in the above-described method embodiments. For example, the methods include: receiving a query request sent by a user terminal, the query request including a data table name and query fields; determining a corresponding query database from multiple databases with different storage structures based on the data table name; wherein the multiple databases with different storage structures are preset; forwarding the query request to the database server to which the query database corresponding to the data table name belongs for data query; receiving the query results returned by the database server and returning the query results to the user terminal.

[0086] Those skilled in the art will understand that embodiments of the present invention can be provided as methods, systems, or computer program products. Therefore, the present invention can take the form of a completely hardware embodiment, a completely software embodiment, or an embodiment combining software and hardware aspects. Furthermore, the present invention can take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0087] This invention is described with reference to flowchart illustrations and / or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each block of the flowchart illustrations and / or block diagrams, and combinations of blocks in the flowchart illustrations and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, special-purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, generate instructions for implementing the flowchart illustrations and / or block diagrams. Figure 1 One or more processes and / or boxes Figure 1A device that provides the functions specified in one or more boxes.

[0088] These computer program instructions may also be stored in a computer-readable storage medium that can direct a computer or other programmable data processing device to function in a particular manner, such that the instructions stored in the computer-readable storage medium produce an article of manufacture including instruction means, which are implemented in a process Figure 1 One or more processes and / or boxes Figure 1 The function specified in one or more boxes.

[0089] These computer program instructions may also be loaded onto a computer or other programmable data processing equipment to cause a series of operational steps to be performed on the computer or other programmable equipment to produce a computer-implemented process, thereby providing instructions that execute on the computer or other programmable equipment for implementing the process. Figure 1 One or more processes and / or boxes Figure 1 The steps of the function specified in one or more boxes.

[0090] The specific embodiments described above further illustrate the purpose, technical solution, and beneficial effects of the present invention. It should be understood that the above descriptions are merely specific embodiments of the present invention and are not intended to limit the scope of protection of the present invention. Any modifications, equivalent substitutions, improvements, etc., made within the spirit and principles of the present invention should be included within the scope of protection of the present invention.

Claims

1. A data query method based on multiple databases, characterized in that, include: Receive a query request sent by the user, the query request including the data table name and query fields; The corresponding query database is determined from multiple databases with different storage structures based on the data table name; wherein, the multiple databases with different storage structures are preset. The query request is forwarded to the database server of the database corresponding to the data table name for data query; Receive the query results returned by the database server and return the query results to the user terminal; The databases with different storage structures include a first database and a second database, which have different data storage structures. The first database is used to query a second field corresponding to a first field in a first data table based on a plurality of first fields. The second database is used to query a plurality of first fields corresponding to a second field in a second data table based on a second field. A first data table is pre-established and stored in the first database, and a second data table related to the first data table is established and stored in the second database. The first data table is established based on a plurality of first fields and a corresponding second field, and the plurality of first fields correspond to the second field. The second data table is established based on the second field and the plurality of corresponding first fields.

2. The method according to claim 1, characterized in that, The step of determining the corresponding query database from multiple databases with different storage structures based on the data table name includes: If it is determined that the data table name corresponds to the first database, then the corresponding query database is determined to be the first database; If it is determined that the data table name corresponds to the second database, then the corresponding query database is determined to be the second database.

3. The method according to claim 1 or 2, characterized in that, The first data table and the second data table are updated periodically.

4. A data query device based on multiple databases, characterized in that, include: The receiving unit is used to receive a query request sent by the user terminal, wherein the query request includes a data table name and query fields; The determining unit is configured to determine the corresponding query database from multiple databases with different storage structures based on the data table name; wherein, the multiple databases with different storage structures are preset. The forwarding unit is used to forward the query request to the database server to which the query database corresponding to the data table name belongs for data querying; The return unit is used to receive the query results returned by the database server and return the query results to the user terminal; The multiple databases with different storage structures include a first database and a second database, and the data storage structures of the first database and the second database are different; the first database is used to query a second field corresponding to the multiple first fields in a first data table based on multiple first fields, and the second database is used to query multiple first fields corresponding to the second field in a second data table based on the second field; a first data table is pre-established and stored in the first database, and a second data table related to the first data table is established and stored in the second database; the first data table is established based on multiple first fields and a corresponding second field, and the multiple first fields correspond to the second field, and the second table is established based on the second field and the corresponding multiple first fields.

5. The apparatus according to claim 4, characterized in that, The step of determining the corresponding query database from multiple databases with different storage structures based on the data table name includes: If it is determined that the data table name corresponds to the first database, then the corresponding query database is determined to be the first database; If it is determined that the data table name corresponds to the second database, then the corresponding query database is determined to be the second database.

6. The apparatus according to claim 4 or 5, characterized in that, The first data table and the second data table are updated periodically.

7. A computer device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that, When the processor executes the computer program, it implements the method according to any one of claims 1 to 3.

8. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores a computer program that, when executed by a processor, implements the method according to any one of claims 1 to 3.

9. A computer program product, characterized in that, The computer program product includes a computer program that, when executed by a processor, implements the method described in any one of claims 1 to 3.

Images