Method for localization transformation of application program adaptive database

Abstract

The invention discloses a localization transformation method for an application program adaptive database, and the method specifically comprises a database agent and an adapter, the database agent is divided into three main parts: a drive adapter, which is used for realizing drive adaptation of application program connection and connecting an original application program to an original database; the SQL optimization tool is mainly used for realizing an original logic unified standard for executing SQL and preparing for transmitting to an adapter of a next environment; the proxy / transponder is mainly used for forwarding the SQL, transmitting the currently executed SQL to the adapter and ensuring efficient and safe transmission of data by using a TCP (Transmission Control Protocol), and meanwhile, the proxy transponder encapsulates an original data mapping format in a return result of the adapter and responds to the application program; the adapter comprises an SQL (Structured Query Language) transfer station and an actuator, and the SQL transfer station is packaged as a pluggable universal component; and after the executor passes through the SQL transfer station, configuring a corresponding target library, submitting an execution SQL for execution, obtaining a corresponding result, and returning the result.

Description

Technical Field

[0001] The present invention relates to the field of databases, and in particular, mainly to a method for localization transformation of an application program adaptation database. Background Art

[0002] At present, although domestic databases have made significant progress in many aspects, they still face many challenges.

[0003] The main solution on the market is to adjust the original code program to adapt the mode. By completely analyzing the business system of the entire system, disassembling each implemented module, checking the syntax differences of the database before and after the transformation, confirming whether each action of operating the database needs to be changed, and then modifying and adjusting the statement or mapping relationship.

[0004] The current technical modification workload is large, and the personnel who modify the application are required to be familiar with the business, be able to accurately find the difference between two different databases, and be able to clearly have business logic significance. Every change requires testing and verification, which greatly increases the workload of testers. Moreover, if there are multiple systems, the same steps need to be performed on each system. The investment in R&D manpower is very high. Summary of the invention

[0005] Based on the problems existing in the above-mentioned prior art, the present invention abandons the method of solving the transformation of domestic databases from the business system and the business code, extracts the general logic of the program, and embeds the aspect solution from the versatility of business SQL submission and execution to achieve a one-time solution and a unified solution. A low-cost implementation scheme for the transformation of domestic databases is realized. Therefore, according to one aspect of the present invention, a method for the transformation of application program adaptation database is proposed, including:

[0006] The application specifies the database connection information through the configuration file, and the driver adapter reads the configuration file and initializes the connection pool; the application initiates a database connection request, and the driver adapter obtains the connection from the connection pool; the driver adapter returns the connection to the application, and at the same time, the application executes the SQL operation;

[0007] When the application executes an SQL operation, the SQL statement is passed to the SQL optimization tool through the driver adapter, and the SQL optimization tool parses the SQL statement and extracts the structure and content of the SQL statement; the SQL optimization tool optimizes the SQL statement according to the optimization rule and inputs the optimized SQL statement into the proxy forwarder;

[0008] After receiving the optimized SQL statement, the proxy forwarder sends the optimized SQL statement to the adapter through the TCP protocol, the adapter returns the execution result, the proxy forwarder encapsulates the result into the original data mapping format, and the proxy forwarder returns the encapsulated result to the application;

[0009] After the adapter receives the SQL statement sent by the proxy forwarder, the SQL transfer station parses the SQL statement, performs syntax conversion according to the configured conversion rules, and passes the converted SQL statement to the executor; the executor configures the corresponding target library, submits and executes the SQL statement; the executor obtains the execution result, returns the execution result to the SQL transfer station, and the SQL transfer station returns the result to the proxy forwarder.

[0010] Furthermore, the SQL optimization tool also includes an integrated performance monitoring tool to monitor SQL execution performance and discover slow queries in real time; at the same time, the SQL optimization tool adopts a caching mechanism to cache commonly used SQL execution plans to reduce the overhead of repeated parsing.

[0011] SQL optimization tools mainly implement unified standards for the original logic of executing SQL (some ORM data mapping frameworks also have the same capabilities) to prepare for passing it to the adapter of the next environment.

[0012] Furthermore, the proxy forwarder also includes: using a high-performance network programming framework such as Netty or MINA to implement TCP communication, and using Nginx or HAProxy to implement load balancing of multiple adapters.

[0013] The proxy forwarder mainly implements SQL forwarding and passes the currently executed SQL to the adapter. This implementation uses the TCP protocol to ensure efficient and secure data transmission. At the same time, the proxy forwarder encapsulates the original data mapping format in the return result of the adapter and responds to the application.

[0014] Furthermore, the proxy forwarder encapsulates the result into the original data mapping format, and encapsulates the return result in JSON or XML format to ensure compatibility with the application.

[0015] Furthermore, a unified error handling mechanism needs to be defined in the proxy forwarder to capture and handle any exceptions that occur during the SQL execution process and return friendly error information.

[0016] Furthermore, the SQL transfer station includes an SQL converter, which is specifically encapsulated as a pluggable universal component to achieve adaptation and mapping of multiple SQL grammars.

[0017] According to a second aspect of the present invention, a system for localization transformation of application adaptation database is proposed, which is characterized by specifically comprising:

[0018] A driver adapter unit, configured for an application to specify database connection information through a configuration file, the driver adapter reads the configuration file and initializes a connection pool; the application initiates a database connection request, the driver adapter obtains a connection from the connection pool; the driver adapter returns the connection to the application, and the application executes an SQL operation;

[0019] A SQL optimization tool unit is configured to pass the SQL statement to the SQL optimization tool through the driver adapter when the application executes the SQL operation, and the SQL optimization tool parses the SQL statement and extracts the structure and content of the SQL statement; the SQL optimization tool optimizes the SQL statement according to the optimization rule and inputs the optimized SQL statement to the proxy forwarder;

[0020] The proxy forwarder unit is configured to send the optimized SQL statement to the adapter through the TCP protocol after the proxy forwarder receives the optimized SQL statement, the adapter returns the execution result, the proxy forwarder encapsulates the result into the original data mapping format, and the proxy forwarder returns the encapsulated result to the application;

[0021] The adapter unit is configured to receive the SQL statement sent by the proxy forwarder, and the SQL transfer station parses the SQL statement, performs syntax conversion according to the configured conversion rules, and passes the converted SQL statement to the executor; the executor configures the corresponding target library, submits and executes the SQL statement; the executor obtains the execution result, returns the execution result to the SQL transfer station, and the SQL transfer station returns the result to the proxy forwarder.

[0022] According to a third aspect of the present invention, a computer program product is provided, on which one or more computer programs are stored. When the one or more computer programs are executed by a computer processor, the above method is implemented.

[0023] The above one or more technical solutions in the embodiments of the present application have at least one of the following technical effects:

[0024] 1. Low development cost

[0025] In the process of domestic database transformation, the traditional method is used to sort out the business and rebuild the database association and mapping. In a certain scale of engineering, the workload is very large. The strategy of this solution does not affect the original code logic. It only needs to convert SQL into the adaptation of the target database SQL in the execution result. It can be achieved by borrowing more open source implementation logic, which greatly reduces the manpower investment cost and development cost.

[0026] 2. Easy adaptability

[0027] This solution only needs to implement the proxy implementation of the original database type and adapt it to the adapter of the target database, and then the overall transformation plan of the solution can be introduced.

[0028] 3. Business stability

[0029] Since this solution does not modify the business logic and code, it is not task-invasive and can ensure the stability of the original business. As long as the relevant logic of the agent and adapter of this solution is implemented, the original business code can be guaranteed to run as is.

[0030] 4. Easy scalability

[0031] The implementation of this solution is not limited to a specific type of database, and can be implemented in various combinations of different original databases (agent layer implementation) and target databases (adapter implementation) by plugging and unplugging components. BRIEF DESCRIPTION OF THE DRAWINGS

[0032] The accompanying drawings are included to provide a further understanding of the embodiments and are incorporated into and constitute a part of this specification. The accompanying drawings illustrate the embodiments and are used together with the description to explain the principles of the present invention. It will be easy to recognize other embodiments and many expected advantages of the embodiments because they become better understood by reference to the following detailed description. The elements of the drawings are not necessarily to scale with each other. The same reference numerals refer to corresponding similar parts.

[0033] Figure 1 A schematic flow chart of a method for localizing an application adaptation database according to an embodiment of the present invention is shown.

[0034] Figure 2 A system framework diagram of a method for localizing an application adaptation database according to an embodiment of the present invention is shown.

[0035] Figure 3 It is a structural diagram of a computer system suitable for implementing an electronic device of an embodiment of the present application. DETAILED DESCRIPTION

[0036] The present application is further described in detail below in conjunction with the accompanying drawings and embodiments. It is to be understood that the specific embodiments described herein are only used to explain the relevant invention, rather than to limit the invention. It is also necessary to explain that, for ease of description, only the parts related to the relevant invention are shown in the accompanying drawings.

[0037] It should be noted that, in the absence of conflict, the embodiments and features in the embodiments of the present application can be combined with each other. The present application will be described in detail below with reference to the accompanying drawings and in combination with the embodiments.

[0038] Figure 1 A schematic diagram of a process flow of a method for localizing an application adaptation database according to an embodiment of the present invention is shown. Figure 1 As shown:

[0039] The application specifies the database connection information through the configuration file, and the driver adapter reads the configuration file and initializes the connection pool; the application initiates a database connection request, and the driver adapter obtains the connection from the connection pool; the driver adapter returns the connection to the application, and at the same time, the application executes the SQL operation;

[0040] The driver adapter implements driver adaptation of application connection. When the original application is connected to the original database, this module enables the original connection program to dock normally, achieving zero code changes on the business application side program.

[0041] In this embodiment, the connection pool includes management and monitoring, specifically including:

[0042] Initialize the connection pool: When the application starts, the connection pool will be initialized according to the connection information in the configuration file, including settings such as the maximum number of connections, the minimum number of connections, and the connection timeout.

[0043] Dynamically adjust the connection pool: Dynamically adjust the size of the connection pool based on the database load and application concurrency requirements. Adjustments can be made based on the current usage of database connections, such as increasing or releasing the number of connections.

[0044] Connection failure detection: Regularly check whether the connections in the connection pool are invalid, clean up invalid connections in time, and ensure that the connections in the connection pool are healthy.

[0045] Connection leak monitoring: If a connection is not returned to the connection pool for a long time, the system will record and alarm to prevent connection leaks from causing performance degradation or database connection exhaustion.

[0046] When the application executes an SQL operation, the SQL statement is passed to the SQL optimization tool through the driver adapter, and the SQL optimization tool parses the SQL statement and extracts the structure and content of the SQL statement; the SQL optimization tool optimizes the SQL statement according to the optimization rule and inputs the optimized SQL statement into the proxy forwarder;

[0047] The proxy forwarder also includes: using a high-performance network programming framework such as Netty or MINA to implement TCP communication, and using Nginx or HAProxy to implement load balancing of multiple adapters.

[0048] The SQL optimization tool also includes an integrated performance monitoring tool to monitor SQL execution performance and discover slow queries in real time; at the same time, the SQL optimization tool adopts a caching mechanism to cache commonly used SQL execution plans to reduce the overhead of repeated parsing.

[0049] After receiving the optimized SQL statement, the proxy forwarder sends the optimized SQL statement to the adapter through the TCP protocol, the adapter returns the execution result, the proxy forwarder encapsulates the result into the original data mapping format, and the proxy forwarder returns the encapsulated result to the application;

[0050] The proxy forwarder encapsulates the result into the original data mapping format, and encapsulates the return result in JSON or XML format to ensure compatibility with the application.

[0051] The proxy forwarder also needs to define a unified error handling mechanism to capture and handle any exceptions that occur during SQL execution and return friendly error information.

[0052] The exception capture and handling mechanism specifically includes: during the execution of SQL statements, if exceptions such as connection loss and SQL errors occur, the driver adapter or proxy forwarder should be able to capture these exceptions and perform appropriate retries or error handling, such as re-acquiring connections, rolling back transactions, etc.

[0053] Monitoring and alarm mechanism: The system should be equipped with a monitoring mechanism to monitor the performance indicators of the database in real time (such as the number of connections, query response time, database load, etc.). If the database encounters an abnormal situation, it can trigger an alarm in time to notify the operation and maintenance personnel to handle it.

[0054] After the adapter receives the SQL statement sent by the proxy forwarder, the SQL transfer station parses the SQL statement, performs syntax conversion according to the configured conversion rules, and passes the converted SQL statement to the executor; the executor configures the corresponding target library, submits and executes the SQL statement; the executor obtains the execution result, returns the execution result to the SQL transfer station, and the SQL transfer station returns the result to the proxy forwarder.

[0055] The SQL transfer station includes an SQL converter, which is specifically encapsulated as a pluggable universal component, such as converting mysql syntax into sql of the DAMO database syntax, etc., to achieve adaptation and mapping of multiple SQL syntaxes.

[0056] This method adopts the aspect approach, zero embedded code, adds a database unified proxy node and adapter, converts the execution statement that needs to migrate the database through the adapter, requests the target database, and executes and returns the request result.

[0057] In some business implementation examples, SQL queries are stress tested before going online to simulate the database response in a large concurrency scenario to ensure that the system can still work normally under high load conditions.

[0058] SQL stress testing helps to discover potential performance bottlenecks and evaluate the performance of the system in actual scenarios, including: high-concurrency queries, complex queries, large data volume queries and transaction operations (transaction commit and rollback, etc.). Among them, database response time measures the response speed of the database under large-scale query operations; concurrent query capability: tests how many query requests the database can handle simultaneously; resource consumption: evaluates the CPU, memory, disk and network resource consumption of the database under high load; scalability: under different loads, the scalability of the database, whether it can maintain stable performance; transaction consistency and reliability: tests whether the database can correctly handle transactions under pressure (such as ACID characteristics).

[0059] Further, such as Figure 2 The system framework diagram of the localization transformation method of the application adaptation database according to one embodiment of the present invention is shown, which specifically includes:

[0060] A driver adapter unit, configured for an application to specify database connection information through a configuration file, the driver adapter reads the configuration file and initializes a connection pool; the application initiates a database connection request, the driver adapter obtains a connection from the connection pool; the driver adapter returns the connection to the application, and the application executes an SQL operation;

[0061] A SQL optimization tool unit is configured to pass the SQL statement to the SQL optimization tool through the driver adapter when the application executes the SQL operation, and the SQL optimization tool parses the SQL statement and extracts the structure and content of the SQL statement; the SQL optimization tool optimizes the SQL statement according to the optimization rule and inputs the optimized SQL statement to the proxy forwarder;

[0062] The proxy forwarder unit is configured to send the optimized SQL statement to the adapter through the TCP protocol after the proxy forwarder receives the optimized SQL statement, the adapter returns the execution result, the proxy forwarder encapsulates the result into the original data mapping format, and the proxy forwarder returns the encapsulated result to the application;

[0063] The adapter unit is configured to receive the SQL statement sent by the proxy forwarder, and the SQL transfer station parses the SQL statement, performs syntax conversion according to the configured conversion rules, and passes the converted SQL statement to the executor; the executor configures the corresponding target library, submits and executes the SQL statement; the executor obtains the execution result, returns the execution result to the SQL transfer station, and the SQL transfer station returns the result to the proxy forwarder.

[0064] In summary, the present invention is based on plug-in transformation without embedding the original code, which provides the application side with a large amount of free choice and can continuously accumulate the adaptability between multiple databases.

[0065] The present invention is suitable for the needs of transforming existing business applications to adapt to domestic databases under the current domestic data adaptation wave, or for the needs of transforming existing business programs to switch to different underlying databases based on some special reasons.

[0066] Reference below Figure 3 , which shows a schematic diagram of the structure of a computer system 300 suitable for implementing an electronic device of an embodiment of the present application. Figure 3 The electronic device shown is merely an example and should not bring any limitation to the functions and scope of use of the embodiments of the present application.

[0067] like Figure 3As shown, the computer system 300 includes a central processing unit (CPU) 301, which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM) 302 or a program loaded from a storage part 308 into a random access memory (RAM) 303. In the RAM 303, various programs and data required for the operation of the system 300 are also stored. The CPU 301, the ROM 302, and the RAM 303 are connected to each other through a bus 304. An input / output (I / O) interface 305 is also connected to the bus 304.

[0068] The following components are connected to the I / O interface 305: an input section 306 including a keyboard, a mouse, etc.; an output section 307 including a liquid crystal display (LCD), etc. and a speaker, etc.; a storage section 308 including a hard disk, etc.; and a communication section 309 including a network interface card such as a LAN card, a modem, etc. The communication section 309 performs communication processing via a network such as the Internet. A drive 310 is also connected to the I / O interface 305 as needed. A removable medium 311, such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, etc., is installed on the drive 310 as needed, so that a computer program read therefrom is installed into the storage section 308 as needed.

[0069] In particular, according to an embodiment of the present disclosure, the process described above with reference to the flowchart can be implemented as a computer software program. For example, an embodiment of the present disclosure includes a computer program product, which includes a computer program carried on a computer-readable storage medium, and the computer program includes a program code for executing the method shown in the flowchart. In such an embodiment, the computer program can be downloaded and installed from the network through the communication part 309, and / or installed from the removable medium 311. When the computer program is executed by the central processing unit (CPU) 301, the above functions defined in the method of the present application are executed. It should be noted that the computer-readable storage medium of the present application can be a computer-readable signal medium or a computer-readable storage medium or any combination of the above two. The computer-readable storage medium can be, for example, - but not limited to - an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device or device, or any combination of the above. More specific examples of computer-readable storage media may include, but are not limited to, an electrical connection with one or more conductors, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In the present application, a computer-readable storage medium may be any tangible medium containing or storing a program that can be used by or in conjunction with an instruction execution system, device, or device. In the present application, a computer-readable signal medium may include a data signal propagated in a baseband or as part of a carrier wave, in which a computer-readable program code is carried. Such propagated data signals may take a variety of forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the above. A computer-readable signal medium may also be any computer-readable storage medium other than a computer-readable storage medium, which may send, propagate, or transmit a program for use by or in conjunction with an instruction execution system, device, or device. The program code contained on the computer-readable storage medium may be transmitted using any appropriate medium, including but not limited to: wireless, wireline, optical cable, RF, etc., or any suitable combination of the foregoing.

[0070] Computer program code for performing the operations of the present application may be written in one or more programming languages ​​or a combination thereof, including object-oriented programming languages, such as Java, Smalltalk, C++, and conventional procedural programming languages, such as "C" or similar programming languages. The program code may be executed entirely on the user's computer, partially on the user's computer, as a separate software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In cases involving a remote computer, the remote computer may be connected to the user's computer through any type of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computer (e.g., via the Internet using an Internet service provider).

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

[0072] The modules involved in the embodiments of the present application may be implemented by software or hardware.

[0073] As another aspect, the present application also provides a computer-readable storage medium, which may be included in the electronic device described in the above embodiment; or it may exist independently without being assembled into the electronic device. The above computer-readable storage medium carries one or more programs, and when the above one or more programs are executed by the electronic device, the electronic device: the application specifies the database connection information through the configuration file, the driver adapter reads the configuration file and initializes the connection pool; the application initiates a database connection request, and the driver adapter obtains the connection from the connection pool; the driver adapter returns the connection to the application, and at the same time, the application executes SQL operations;

[0074] When the application executes an SQL operation, the SQL statement is passed to the SQL optimization tool through the driver adapter, and the SQL optimization tool parses the SQL statement and extracts the structure and content of the SQL statement; the SQL optimization tool optimizes the SQL statement according to the optimization rule and inputs the optimized SQL statement into the proxy forwarder; after receiving the optimized SQL statement, the proxy forwarder sends the optimized SQL statement to the adapter through the TCP protocol, the adapter returns the execution result, the proxy forwarder encapsulates the result into the original data mapping format, and the proxy forwarder returns the encapsulated result to the application; after the adapter receives the SQL statement sent by the proxy forwarder, the SQL transfer station parses the SQL statement, performs syntax conversion according to the configured conversion rule, and passes the converted SQL statement to the executor; the executor configures the corresponding target library, submits and executes the SQL statement; the executor obtains the execution result, returns the execution result to the SQL transfer station, and the SQL transfer station returns the result to the proxy forwarder.

[0075] The above description is only a preferred embodiment of the present application and an explanation of the technical principles used. Those skilled in the art should understand that the scope of the invention involved in the present application is not limited to the technical solution formed by a specific combination of the above technical features, but should also cover other technical solutions formed by any combination of the above technical features or their equivalent features without departing from the above invention concept. For example, the above features are replaced with the technical features with similar functions disclosed in this application (but not limited to) by each other.

Claims

1. A method for localization transformation of application adaptation database, characterized in that: The following steps are involved: The application specifies the database connection information through the configuration file, and the driver adapter reads the configuration file and initializes the connection pool; the application initiates a database connection request, and the driver adapter obtains the connection from the connection pool; the driver adapter returns the connection to the application, and at the same time, the application executes the SQL operation; When the application executes an SQL operation, the SQL statement is passed to the SQL optimization tool through the driver adapter, and the SQL optimization tool parses the SQL statement and extracts the structure and content of the SQL statement; The SQL optimization tool optimizes the SQL statement according to the optimization rule, and inputs the optimized SQL statement into the proxy forwarder; After receiving the optimized SQL statement, the proxy forwarder sends the optimized SQL statement to the adapter through the TCP protocol, the adapter returns the execution result, the proxy forwarder encapsulates the result into the original data mapping format, and the proxy forwarder returns the encapsulated result to the application; After the adapter receives the SQL statement sent by the proxy forwarder, the SQL transfer station parses the SQL statement, performs syntax conversion according to the configured conversion rules, and passes the converted SQL statement to the executor; the executor configures the corresponding target library, submits and executes the SQL statement; the executor obtains the execution result, returns the execution result to the SQL transfer station, and the SQL transfer station returns the result to the proxy forwarder.

2. The method according to claim 1, characterized in that: The SQL optimization tool also includes an integrated performance monitoring tool to monitor SQL execution performance and discover slow queries in real time; at the same time, the SQL optimization tool adopts a caching mechanism to cache commonly used SQL execution plans to reduce the overhead of repeated parsing.

3. The method according to claim 1, characterized in that: The proxy forwarder also includes: using a high-performance network programming framework such as Netty or MINA to implement TCP communication, and using Nginx or HAProxy to implement load balancing of multiple adapters.

4. The method according to claim 1, characterized in that: The proxy forwarder encapsulates the result into the original data mapping format, and encapsulates the return result in JSON or XML format to ensure compatibility with the application.

5. The method according to claim 1, characterized in that The proxy forwarder also needs to define a unified error handling mechanism to capture and handle any exceptions that occur during SQL execution and return friendly error information.

6. The method according to claim 1, characterized in that The SQL transfer station includes an SQL converter, which is specifically encapsulated as a pluggable universal component to achieve adaptation and mapping of multiple SQL grammars.

7. A system for localization transformation of application adaptation database, characterized in that: Specifically include: A driver adapter unit, configured for an application to specify database connection information through a configuration file, and the driver adapter reads the configuration file to initialize a connection pool; The application initiates a database connection request, and the driver adapter obtains a connection from the connection pool; the driver adapter returns the connection to the application, and the application executes an SQL operation; A SQL optimization tool unit, configured to, when the application executes an SQL operation, pass the SQL statement to the SQL optimization tool through the driver adapter, and the SQL optimization tool parses the SQL statement and extracts the structure and content of the SQL statement; The SQL optimization tool optimizes the SQL statement according to the optimization rule, and inputs the optimized SQL statement into the proxy forwarder; The proxy forwarder unit is configured to send the optimized SQL statement to the adapter through the TCP protocol after the proxy forwarder receives the optimized SQL statement, the adapter returns the execution result, the proxy forwarder encapsulates the result into the original data mapping format, and the proxy forwarder returns the encapsulated result to the application; The adapter unit is configured to receive the SQL statement sent by the proxy forwarder, and the SQL transfer station parses the SQL statement, performs syntax conversion according to the configured conversion rules, and passes the converted SQL statement to the executor; the executor configures the corresponding target library, submits and executes the SQL statement; the executor obtains the execution result, returns the execution result to the SQL transfer station, and the SQL transfer station returns the result to the proxy forwarder.

8. A computer program product, characterized in that A computer program is stored thereon, and when the computer program is executed by a processor, the method according to any one of claims 1 to 6 is implemented.

9. A computing system, characterized in that: The method comprises a processor and a memory, wherein the processor is configured to execute the method according to any one of claims 1 to 6.

Images