Data query processing method and device, equipment, medium and program product

Abstract

The embodiment of the invention provides a data query processing method and device, equipment, a medium and a program product, and the method comprises the steps: screening out a target database matched with an obtained data query request from a plurality of databases in the process of performing data query in response to the data query request, querying the connection information of the target database, the connection program of the target database establishes the connection with the target database based on the connection information, the query statement is generated according to the query parameter in the data query request and sent to the target database, and the query response message is generated according to the query result returned by the target database, so that a requester cross-database data query function is realized; and the stability of data query is improved.

Description

Technical Field

[0001] This document relates to the field of data processing technology, and in particular to a data query processing method, device, equipment, medium and program product. Background Art

[0002] With the continuous development of Internet technology and the continuous increase in the total amount of data, more and more data needs to be stored and processed. As the demand for data storage continues to increase, more and more systems begin to store and manage data through databases. Databases can manage data efficiently and conveniently, so that the system can quickly query the required data. With the continuous development of emerging technologies, new systems are also being put into use, which has caused the problem of adapting new systems to old databases. In the prior art, data interaction between a newly built system and an old database is usually achieved by configuring the data interface of the database, but this will increase the operation and maintenance costs. How to conveniently interact data between the newly built system and the old database has become a concern for all parties. Summary of the invention

[0003] The purpose of one embodiment of the present specification is to provide a data query processing method, device, equipment, medium and program product to solve the problem of complex data transmission between an old database and a newly built platform.

[0004] To solve the above technical problems, an embodiment of this specification is implemented as follows: In a first aspect, an embodiment of the present specification provides a data query processing method, including: Obtaining a data query request, and screening out a target database matching the data query request from multiple databases; Querying the connection information of the target database, and establishing a connection with the target database based on the connection information through a connection program of the target database; A query statement is generated according to the query parameters in the data query request and sent to the target database, and a query response message is generated according to the query result returned by the target database.

[0005] In a second aspect, another embodiment of the present specification provides a data query processing device, including: A database determination module is used to obtain a data query request and select a target database matching the data query request from multiple databases; A database connection module, used to query the connection information of the target database, and establish a connection with the target database based on the connection information through a connection program of the target database; The response message generation module is used to generate a query statement according to the query parameters in the data query request and send it to the target database, and generate a query response message according to the query result returned by the target database.

[0006] In a third aspect, another embodiment of the present specification provides a data query processing device, comprising: a memory, a processor, and computer executable instructions stored on the memory and executable on the processor, wherein the computer executable instructions, when executed by the processor, implement the steps of the data query processing method as described in the first aspect above.

[0007] In a fourth aspect, another embodiment of the present specification provides a computer-readable storage medium, wherein the computer-readable storage medium is used to store computer-executable instructions, and when the computer-executable instructions are executed by a processor, the steps of the data query processing method as described in the first aspect above are implemented.

[0008] In a fifth aspect, another embodiment of the present specification provides a computer program product, wherein the computer program product includes a data query processing program, and when the data query processing program is executed by a processor, the steps of the data query processing method described in the first aspect are implemented.

[0009] The data query processing method provided in the present embodiment, in the process of performing data query in response to a data query request, screens out a target database matching the data query request from multiple databases, queries the connection information of the target database and establishes a connection with the target database based on the connection information through a connection program of the target database, manages multiple third-party databases and connects to the database in response to the data query request of the requester, performs data transmission between the requester and the database, saves the cost of configuring the interface between the requester and the database by directly connecting through a connection program, improves the stability of data query by establishing a database connection in response to a request, and relieves the load pressure in the operation of the database, generates a query statement according to the query parameters in the data query request and sends it to the target database, so that the target database executes the query statement and returns the query result, generates a query response message according to the query result, converts the query result into a query response message composed of text, improves the interactive perception of the requester, and realizes the function of the requester performing data query across databases. BRIEF DESCRIPTION OF THE DRAWINGS

[0010] In order to more clearly illustrate one or more embodiments of the present specification or the technical solutions in the prior art, the drawings required for use in the embodiments or the prior art descriptions are briefly introduced below. Obviously, the drawings described below are only some embodiments recorded in the present specification. For those of ordinary skill in the art, other drawings can be obtained based on these drawings without creative work. Figure 1 A processing flow chart of a data query processing method provided by one or more embodiments of this specification; Figure 2 A processing flow chart of a data query processing method applied to a data query scenario provided by one or more embodiments of this specification; Figure 3 A schematic diagram of an implementation environment of a data query method provided in one or more embodiments of this specification; Figure 4 A schematic diagram of a data query processing device provided for one or more embodiments of this specification; Figure 5 A schematic diagram of the structure of a data query processing device provided in one or more embodiments of this specification. DETAILED DESCRIPTION

[0011] In order to enable those skilled in the art to better understand the technical solutions in one or more embodiments of this specification, the following will be combined with the drawings in one or more embodiments of this specification to clearly and completely describe the technical solutions in one or more embodiments of this specification. Obviously, the described embodiments are only part of the embodiments of this specification, not all of the embodiments. Based on one or more embodiments of this specification, all other embodiments obtained by ordinary technicians in this field without creative work should fall within the scope of protection of this document.

[0012] This specification provides a data query processing method embodiment: Reference Figure 1 , which shows a data query processing method processing flow chart provided by this embodiment, referring to Figure 2 , which shows a processing flow chart of a data query processing method applied to a data query scenario provided by this embodiment.

[0013] Reference Figure 1 The data query processing method provided in this embodiment can be applied to a data query system, and specifically includes the following steps S102 to S106.

[0014] Step S102: obtaining a data query request, and screening out a target database matching the data query request from multiple databases.

[0015] In specific implementation, an externally input data query request is obtained, a database identifier contained in the data query request is parsed, and the database targeted by the data query request is determined from multiple databases according to the database identifier. Specifically, a data query request submitted by an operating user and / or a third-party platform can be obtained to determine a database matching the data query request, that is, to determine the database targeted by the data query request.

[0016] In this embodiment, the data query system responds to data query requests. The data query system can receive data query requests submitted by third-party platforms, and can also receive data query requests submitted by operating users; the data query system can query data from multiple databases and / or third-party databases.

[0017] During the specific execution process, the data query request may be submitted through a third-party platform and / or an external business system. By providing a method for querying data in a third-party database to the third-party platform and / or the external business system, a cross-database query function is provided. In an optional implementation manner provided in this embodiment, obtaining a data query request includes: Get the data query request submitted by the third-party platform calling the request transmission interface.

[0018] Specifically, the third-party platform may generate a data query request according to the queried database information and query parameters, call the request transmission interface of the data query system to submit the data query request, and the data query system obtains the data query request and processes it.

[0019] Furthermore, the third-party platform may generate a data query request according to the data query instruction of the operating user of the third-party platform. Specifically, the operating user corresponding to the third-party platform may trigger the query control configured on the data query page of the third-party platform to submit a query instruction to the third-party platform, and the third-party platform may generate a data query request according to the query instruction and send it to the data query system.

[0020] For example, an operating user of a third-party platform edits the query parameters for data a in database A on the data query page of the third-party platform, triggering the "Confirm Submission" button configured on the data query page to submit a data query instruction to the third-party platform. The third-party platform can generate a data query request based on the data query instruction and send it to the data query system. The data query system determines that the database to be queried subsequently is database A based on the identifier of database A in the data query request.

[0021] In addition, the data query request can also be submitted by the operating user, that is: the data query system can provide an interactive page for the operating user to edit, and the interactive perception is improved by providing the data query page; in an optional implementation manner provided by this embodiment, obtaining the data query request includes: Get the data query request generated after the user submits the data query instruction on the data query page.

[0022] Specifically, the operating user may trigger the query control configured on the data query page of the data query system to submit a query instruction to the data query system, and the data query system generates a data query request according to the query instruction.

[0023] For example, an operating user of the data query system edits the query parameters for data b in database B on the data query page of the data query system, triggers the "Confirm Submit" button configured on the data query page to submit a data query instruction to the data query system, and the data query system generates a data query request based on the data query instruction. The data query system determines that the database for subsequent query is database B based on the identifier of database B in the data query request.

[0024] During the specific execution process, in order to improve the management efficiency of the database and improve the data processing efficiency, each database and / or third-party database may be registered and / or associated in advance, and database authentication may be performed according to the connection information of each database and / or third-party database; in an optional implementation manner provided by this embodiment, before obtaining the data query request, it also includes: Acquire connection information of a target database, and perform authentication processing of the target database based on the connection information through a connection program of the target database; When the authentication result is that the authentication is passed, an association relationship among the connection information, the target database and the connection program is established.

[0025] In this embodiment, the connection information is information used to connect to the database. The connection information may include: database IP address, database connection port, database connection user name, database connection password and / or database provider information. The connection information may be any one of the above, or a combination of any two or more of the above.

[0026] Specifically, the connection information of the target database is queried according to the identification information of the target database, the connection program of the target database is determined according to the connection information and the connection program is run, the connection information is input as input data into the connection program to establish a connection with the database, and a successful connection indicates that the authentication is passed, and the connection information, the association relationship between the target database and the connection program is established when the authentication is passed. It should be noted that in the process of associating and / or registering the database, that is, in the process of connecting to the database for the first time, the connection information may include: the database IP address, the database connection port, the database connection user name, the database connection password, and the provider information of the database. In the subsequent process of connecting to the database, the connection information may only include the user name and password of the database.

[0027] For example, query the connection information of the target database, determine the connection program corresponding to the target database according to the database brand in the connection information and run the connection program, enter the database IP, port number, user name and password in the connection information as input data into the connection program to connect to the database, and if the connection is successful, establish an association between the connection information, the target database and the connection program.

[0028] It should be noted that the registration and / or association of each database managed by the data query system can be performed in the registration and / or association manner of the above-mentioned target database, and the specific execution process can refer to the registration and / or association manner of the above-mentioned target database, which will not be described in detail in this embodiment. For example, the operation and maintenance members of the system can fill in the connection information of the database through the interactive page provided by the system, including the database brand, database IP address, database port, database name, data table name, and database user password, so as to perform database authentication, registration, and / or association processing.

[0029] In actual applications, the requester may query other data during the process of cross-database data query. To address this, query permissions may be set for the requester, and the security of data query is improved by the requester applying for permissions. In an optional implementation manner provided by this embodiment, before obtaining the data query request, the following is also included: Obtaining a registration request submitted by a requesting party, and extracting database information contained in the registration request; The query authority of the requester is configured according to the database information, and the query authority is bound to the requester.

[0030] Furthermore, the registration request of the requesting party may also include data type information, and the query authority of the requesting party may be configured according to the database information and the data type information; optionally, the query authority includes: database range and / or data type range. For example, if the registration request submitted by the requesting party includes database A and identity information type, the query authority of the requesting party includes: data of identity information type in database A, that is, the requesting party can only query data of identity information type in database A.

[0031] It should be noted that the registration request submitted by the requester may include configuration information, that is, the requester may submit configuration information on the configuration page for registration. Optionally, the configuration information includes: database provider information, database IP address, database port, database name, and data table name.

[0032] During the specific execution process, it is also necessary to verify whether the data query request matches the query authority of the requesting party to improve data security; an optional implementation manner provided by this embodiment also includes: Querying the query authority of the requesting party according to the requesting party information in the data query request; Verify whether the target database is within the scope of the query authority. If the verification is successful, execute step S104.

[0033] For example, the authentication component is used to verify the query parameters contained in the data query request to determine whether the data query request has the access rights corresponding to the requested resource. If the verification fails (such as insufficient permissions, illegal identity, etc.), the verification failure information will be returned. If the verification succeeds, proceed to the next step.

[0034] Step S104, querying the connection information of the target database, and establishing a connection with the target database based on the connection information through a connection program of the target database.

[0035] In this embodiment, when the requester does not establish a direct connection and / or interface connection with the database, the data query is performed by connecting to the database in response to the requester's data query request, thereby realizing the function of the requester querying data across databases, while ensuring the query load of the database, and improving the stability of database operation and data query. By providing data access services to the outside by directly connecting to the database, isolation from the old business system, that is, the system corresponding to the database, is achieved at the system level. In this case, if the old business system crashes, data query can also be achieved under the normal operation of the database, and the third-party platform is connected to the old business system and / or database configuration interface.

[0036] In specific implementation, the connection information of the target database is queried according to the identification information of the target database, the connection program associated with the target database is run, and the user name and password of the target database in the connection information are input as input data into the connection program to establish a connection with the target database. Specifically, the connection information of each database can be stored in a data query system, the connection information of the target database is queried according to the identification information of the target database, and the target database is connected through the connection program of the database according to the connection information, that is, the database is directly connected.

[0037] In actual applications, there is still a problem that the number of database connection users is too large and the load is too high, resulting in the inability to connect to the database; in response to this, a reconnection time range can be set, and the target database is reconnected after the time expires, which improves data query efficiency and improves the stability of the database and data query; an optional implementation provided by this embodiment also includes: If a connection timeout message is received from the target database, reconnecting to the target database after a preset time has expired; When a connection success message is received from the target database, a query statement is generated according to the query parameters in the data query request and sent to the target database, and a query response message is generated according to the query result returned by the target database.

[0038] For example, if the target database connection fails, the system operation and maintenance personnel will be reminded via SMS and will immediately try to reconnect. If the database connection cannot be made after three attempts, the business system operation and maintenance personnel will be reminded of the database connection abnormality again via SMS, which will facilitate locating and solving the problem.

[0039] Furthermore, after the database connection is successful, it can enter the monitoring state, provide the database connection channel for data access authentication and service components for data query; at the same time, the component polls the database connection status every 5 minutes to ensure the link availability. For example: if the connection timeout information returned by the target database is received, a connection timeout message is generated and sent to the management user. In addition, in order to improve the connection stability of the target database, a secondary database connection and the sending of a connection timeout message can also be performed at the same time; for example: if the connection timeout information returned by the target database is received, the target database is connected again after the preset time expires and a connection timeout message is generated and sent to the management user.

[0040] It should be noted that steps S102 to S104 may be replaced by: obtaining a data query request, querying connection information of a database corresponding to a database identifier in the data query request, and establishing a connection with the database through a connection program of the database based on the connection information.

[0041] Step S106: Generate a query statement according to the query parameters in the data query request and send it to the target database, and generate a query response message according to the query result returned by the target database.

[0042] In specific implementation, a query statement is generated based on the query input parameters in the data query request, and the query statement is sent to the target database through a connection established with the target database, so that the target database executes the query statement to obtain the query result and returns the query result, and a query response message is generated based on the query result returned by the target database. Specifically, the query result can be converted into a query response message according to a preset parameter output strategy, and the query response message can also be returned to the requester.

[0043] During the specific execution process, a query statement can be generated according to the input parameters in the data query request. Specifically, the data query SQL in the data query request can be parsed to generate a query statement containing the data query SQL and input parameters. After executing the query statement, the query result and / or data query information containing the data query SQL, input parameters, and output parameters can be obtained. For example, two layers of brackets (such as "[[ value ]]") can be used to wrap the relevant fields as input parameters, and the fields between SELCT and FROM in the SQL statement are used as output parameters by default.

[0044] In actual applications, the requester of the data query request may be an organization member; in this regard, the query result may be converted into text to obtain a query response message and sent to the requester so that the organization member can view it.

[0045] In summary, the one or more data query processing methods provided in this embodiment, in the process of performing data query in response to a data query request, screen out a target database matching the data query request from multiple databases, query the connection information of the target database and establish a connection with the target database based on the connection information through the connection program of the target database, manage multiple third-party databases and connect to the database in response to the data query request of the requester, perform data transmission between the requester and the database, save the cost of configuring the interface between the requester and the database by directly connecting through the connection program, improve the stability of data query by establishing a database connection in response to the request, and alleviate the load pressure in the operation of the database, generate a query statement according to the query parameters in the data query request and send it to the target database, so that the target database executes the query statement and returns the query result, generate a query response message according to the query result, convert the query result into a query response message composed of text, improve the interactive perception of the requester, and realize the function of the requester to perform data query across databases.

[0046] The following combination Figure 2 , taking the application of the data query processing method provided by this embodiment in the data query scenario as an example, the data query processing method provided by this embodiment is further explained. Figure 2 The data query processing method applied to the data query scenario specifically includes steps S202 to S214.

[0047] Step S202: obtaining a data query request, and screening out a target database matching the data query request from multiple databases.

[0048] Previously, the third-party platform generated and submitted data query requests.

[0049] Step S204, querying the query authority of the requesting party according to the requesting party information in the data query request.

[0050] Step S206, verifying whether the target database is within the scope of the query authority; If the verification is successful, execute step S208; If the verification fails, no action will be taken.

[0051] Step S208, querying the connection information of the target database, and establishing a connection with the target database based on the connection information through the connection program of the target database.

[0052] Step S210: receiving connection timeout information returned by the target database, and reconnecting to the target database after a preset time expires.

[0053] Step S212: Generate a query statement according to the query parameters in the data query request and send it to the target database.

[0054] Step S214: Generate a query response message according to the query result returned by the target database.

[0055] It should be noted that any one of steps S202 to S214 or any combination of multiple steps can be selected from steps S102 to S106 to form a new implementation method according to the needs of implementation deployment; and any one or multiple technical features in the technical scheme composed of steps S202 to S214 can be selected from steps S102 to S106 to form a new implementation method according to the needs of actual deployment, or the technical features in one or more optional implementation methods provided by steps S102 to S106 can be selected to combine into a new implementation method, which will not be elaborated here one by one.

[0056] It should be noted that it is also possible to Figure 3 The data query processing is performed in the implementation environment of the data query method shown. Among them, the database connection component 301 can be used to establish and detect the links to databases of different brands and manufacturers, and multiple database connection methods can also be used. The database connection component uses the database connection information generated by the service configuration component to determine the database brand and manufacturer to which the information belongs, and calls the corresponding database link driver to connect to the database according to the judgment result. After the connection is successful, it enters the monitoring state and provides a database link channel for data query for the data access authentication and service component; the service configuration component 302 can generate database link information and data query information according to the configuration information submitted by the configuration interface; the data access authentication and service component 303 can generate corresponding data access services according to the data query information provided by the service configuration component 302, and provide a unified authentication mechanism for the data access service to process data query requests; the user configuration interface 304 can provide a visual operation interface for the operating user, which is convenient for the operating user to configure various parameters of the data access service.

[0057] Figure 4 A schematic diagram of a data query processing device provided by an embodiment of the present invention is shown in FIG. Figure 4 As shown, the device comprises: The database determination module 402 is used to obtain a data query request and select a target database matching the data query request from multiple databases; A database connection module 404 is used to query the connection information of the target database and establish a connection with the target database based on the connection information through a connection program of the target database; The response message generation module 406 is used to generate a query statement according to the query parameters in the data query request and send it to the target database, and generate a query response message according to the query result returned by the target database.

[0058] The data query processing device provided in this embodiment, in the process of performing data query in response to a data query request, first runs the database determination module 402 to screen out a target database matching the data query request from multiple databases, then runs the database connection module 404 to query the connection information of the target database and establishes a connection with the target database based on the connection information through the connection program of the target database, manages multiple third-party databases and connects to the database in response to the data query request of the requester, performs data transmission between the requester and the database, saves the cost of configuring the interface between the requester and the database by directly connecting through the connection program, improves the stability of data query by establishing a database connection in response to the request, and relieves the load pressure in the operation of the database, finally runs the response message generation module 406 to generate a query statement according to the query parameters in the data query request and sends it to the target database, so that the target database executes the query statement and returns the query result, generates a query response message according to the query result, converts the query result into a query response message composed of text, improves the interactive perception of the requester, and realizes the function of the requester performing data query across databases.

[0059] The data query processing device provided in one embodiment of this specification can implement each process in the aforementioned method embodiment and achieve the same functions and effects, which will not be repeated here.

[0060] Furthermore, an embodiment of the present specification also provides a data query processing device, Figure 5 A structural diagram of a data query processing device provided in an embodiment of this specification is shown as follows: Figure 5 As shown, the device includes: a memory 501, a processor 502, a bus 503 and a communication interface 504. The memory 501, the processor 502 and the communication interface 504 communicate through the bus 503, and the communication interface 504 may include an input and output interface, which includes but is not limited to a keyboard, a mouse, a display, a microphone, a loudspeaker, etc.

[0061] Figure 5 In the embodiment, the memory 501 stores computer executable instructions that can be run on the processor 502. When the computer executable instructions are executed by the processor 502, the following process is implemented: Obtaining a data query request, and screening out a target database matching the data query request from multiple databases; Querying the connection information of the target database, and establishing a connection with the target database based on the connection information through a connection program of the target database; A query statement is generated according to the query parameters in the data query request and sent to the target database, and a query response message is generated according to the query result returned by the target database.

[0062] The data query processing device provided in this embodiment, through the cooperation of the memory 501, the processor 502, the bus 503 and the communication interface 504, in the process of performing data query in response to the data query request, screens out the target database matching the data query request from multiple databases, queries the connection information of the target database and establishes a connection with the target database based on the connection information through the connection program of the target database, manages multiple third-party databases and connects to the database in response to the data query request of the requester, performs data transmission between the requester and the database, saves the cost of configuring the interface between the requester and the database by directly connecting through the connection program, improves the stability of data query by establishing a database connection in response to the request, and relieves the load pressure in the operation of the database, generates a query statement according to the query parameters in the data query request and sends it to the target database, so that the target database executes the query statement and returns the query result, generates a query response message according to the query result, converts the query result into a query response message composed of text, improves the interactive perception of the requester, and realizes the function of the requester performing data query across databases.

[0063] The data query processing device provided in an embodiment of this specification can implement each process in the aforementioned method embodiment and achieve the same functions and effects, which will not be repeated here.

[0064] Furthermore, another embodiment of the present specification provides a computer-readable storage medium, wherein the computer-readable storage medium is used to store computer-executable instructions, and when the computer-executable instructions are executed by a processor, the following process is implemented: Obtaining a data query request, and screening out a target database matching the data query request from multiple databases; Querying the connection information of the target database, and establishing a connection with the target database based on the connection information through a connection program of the target database; A query statement is generated according to the query parameters in the data query request and sent to the target database, and a query response message is generated according to the query result returned by the target database.

[0065] The computer-readable storage medium provided in this embodiment, in the process of performing data query in response to a data query request, screens out a target database matching the data query request from multiple databases, queries the connection information of the target database and establishes a connection with the target database based on the connection information through a connection program of the target database, manages multiple third-party databases and connects to the database in response to the data query request of the requester, performs data transmission between the requester and the database, saves the cost of configuring the interface between the requester and the database by directly connecting through the connection program, improves the stability of data query by establishing a database connection in response to the request, and relieves the load pressure in the operation of the database, generates a query statement according to the query parameters in the data query request and sends it to the target database, so that the target database executes the query statement and returns the query result, generates a query response message according to the query result, converts the query result into a query response message composed of text, improves the interactive perception of the requester, and realizes the function of the requester performing data query across databases.

[0066] The computer-readable storage medium includes a read-only memory (ROM), a random access memory (RAM), a magnetic disk or an optical disk, etc.

[0067] The computer-readable storage medium provided in an embodiment of this specification can implement each process in the aforementioned method embodiment and achieve the same functions and effects, which will not be repeated here.

[0068] Furthermore, another embodiment of the present specification also provides a computer program product, which implements the following process when executed by a processor: Obtaining a data query request, and screening out a target database matching the data query request from multiple databases; Querying the connection information of the target database, and establishing a connection with the target database based on the connection information through a connection program of the target database; A query statement is generated according to the query parameters in the data query request and sent to the target database, and a query response message is generated according to the query result returned by the target database.

[0069] The computer product program provided in this embodiment, in the process of performing data query in response to a data query request, screens out a target database matching the data query request from multiple databases, queries the connection information of the target database and establishes a connection with the target database based on the connection information through a connection program of the target database, manages multiple third-party databases and connects to the database in response to the data query request of the requester, performs data transmission between the requester and the database, saves the cost of configuring the interface between the requester and the database by directly connecting through the connection program, improves the stability of data query by establishing a database connection in response to the request, and relieves the load pressure in the operation of the database, generates a query statement according to the query parameters in the data query request and sends it to the target database, so that the target database executes the query statement and returns the query result, generates a query response message according to the query result, converts the query result into a query response message composed of text, improves the interactive perception of the requester, and realizes the function of the requester performing data query across databases.

[0070] The computer program product provided in one embodiment of this specification can implement each process in the aforementioned method embodiment and achieve the same functions and effects, which will not be repeated here.

[0071] It will be appreciated by those skilled in the art that embodiments of the present invention may be provided as methods, systems, or computer program products. Therefore, the present invention may take the form of a complete hardware embodiment, a complete software embodiment, or an embodiment combining software and hardware. Furthermore, the present invention may take the form of a computer program product implemented on one or more computer-readable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0072] The present invention is described with reference to flowcharts and / or block diagrams of methods, devices (systems), and computer program products according to embodiments of the present invention. It should be understood that each process and / or block in the flowchart and / or block diagram, as well as the combination of processes and / or blocks in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to generate a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1 A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.

[0073] These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable data processing device to operate in a specific manner, so that the instructions stored in the computer-readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 A process or multiple processes and / or boxes Figure 1 A function specified in one or more boxes.

[0074] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions for implementing the process. Figure 1 A process or multiple processes and / or boxes Figure 1 A step that specifies a function in one or more boxes.

[0075] In a typical configuration, a computing device includes one or more processors (CPU), input / output interfaces, network interfaces, and memory.

[0076] Memory may include non-permanent storage in a computer-readable storage medium, random access memory (RAM) and / or non-volatile memory in the form of read-only memory (ROM) or flash RAM. Memory is an example of a computer-readable storage medium.

[0077] Computer-readable storage media include permanent and non-permanent, removable and non-removable media that can be implemented by any method or technology to store information. Information can be computer-readable instructions, data structures, program modules or other data. Examples of computer-readable storage media include, but are not limited to, phase change memory (PRAM), static random access memory (SRAM), dynamic random access memory (DRAM), other types of random access memory (RAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), flash memory or other memory technology, compact disk read-only memory (CD-ROM), digital versatile disk (DVD) or other optical storage, magnetic cassettes, magnetic tape disk storage or other magnetic storage devices or any other non-transmission media that can be used to store information that can be accessed by a computing device. As defined herein, computer-readable storage media does not include temporary computer-readable media (transitory media), such as modulated data signals and carrier waves.

[0078] It should also be noted that the terms "include", "comprises" or any other variations thereof are intended to cover non-exclusive inclusion, so that a process, method, commodity or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, commodity or device. In the absence of more restrictions, the elements defined by the sentence "comprises a ..." do not exclude the existence of other identical elements in the process, method, commodity or device including the elements.

[0079] Those skilled in the art will appreciate that the embodiments of the present application may be provided as methods, systems or computer program products. Therefore, the present application may take the form of a complete hardware embodiment, a complete software embodiment or an embodiment combining software and hardware. Moreover, the present application may take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program codes.

[0080] The above is only an embodiment of the present application and is not intended to limit the present application. For those skilled in the art, the present application may have various changes and variations. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included in the scope of the claims of the present application.

Claims

1. A data query processing method, characterized in that: The method comprises: Obtaining a data query request, and screening out a target database matching the data query request from multiple databases; Querying the connection information of the target database, and establishing a connection with the target database based on the connection information through a connection program of the target database; A query statement is generated according to the query parameters in the data query request and sent to the target database, and a query response message is generated according to the query result returned by the target database.

2. The data query processing method according to claim 1, characterized in that: The obtaining of the data query request, before screening out a target database matching the data query request from multiple databases, further comprises: Acquire connection information of a target database, and perform authentication processing of the target database based on the connection information through a connection program of the target database; When the authentication result is that the authentication is passed, an association relationship among the connection information, the target database and the connection program is established.

3. The data query processing method according to claim 1, characterized in that: The obtaining of the data query request, before screening out a target database matching the data query request from multiple databases, further comprises: Obtaining a registration request submitted by a requesting party, and extracting database information contained in the registration request; The query authority of the requesting party is configured according to the database information.

4. The data query processing method according to claim 1, characterized in that: The obtaining of data query request includes: Obtain the data query request submitted by the third-party platform calling the request transmission interface; Alternatively, a data query request generated after the operating user submits a data query instruction on the data query page is obtained.

5. The data query processing method according to claim 1, characterized in that: The obtaining of the data query request, after screening out a target database matching the data query request from multiple databases, and before querying the connection information of the target database and establishing a connection with the target database based on the connection information through a connection program of the target database, further includes: Querying the query authority of the requesting party according to the requesting party information in the data query request; Verify whether the target database is within the scope of the query authority. If the verification is successful, query the connection information of the target database and establish a connection with the target database based on the connection information through the connection program of the target database.

6. The data query processing method according to claim 1, characterized in that: After querying the connection information of the target database, establishing a connection with the target database based on the connection information through a connection program of the target database, and generating a query statement according to the query parameters in the data query request and sending it to the target database, and before generating a query response message according to the query result returned by the target database, the method includes: If the connection timeout information returned by the target database is received, the target database is connected again after the preset time expires and a connection timeout message is generated and sent to the management user; When a connection success message is received from the target database, a query statement is generated according to the query parameters in the data query request and sent to the target database, and a query response message is generated according to the query result returned by the target database.

7. A data query processing device, characterized in that: The device comprises: A database determination module is used to obtain a data query request and select a target database matching the data query request from multiple databases; A database connection module, used to query the connection information of the target database, and establish a connection with the target database based on the connection information through a connection program of the target database; The response message generation module is used to generate a query statement according to the query parameters in the data query request and send it to the target database, and generate a query response message according to the query result returned by the target database.

8. A data query processing device, characterized in that: The device includes a memory and a processor, wherein the memory stores computer executable instructions, and when the computer executable instructions are executed on the processor, the steps of the data query processing method according to any one of claims 1 to 6 can be implemented.

9. A computer-readable storage medium having computer-executable instructions stored therein, characterized in that: When the computer executable instructions are executed by a processor, the steps of the data query processing method described in any one of claims 1 to 6 can be implemented.

10. A computer program product, characterized in that The computer program product includes a data query processing program, and when the data query processing program is executed by a processor, the steps of the data query processing method described in any one of claims 1 to 6 can be implemented.

Images