Data interaction method between heterogeneous databases, electronic equipment and storage medium
By generating and converting command statements in the local database system, the complexity and low efficiency of data interaction between heterogeneous databases are solved, and compatibility and real-time data interaction across database systems are realized, and user experience and data processing efficiency are improved. .
Patent Information
- Application Number
- CN202411174318.1
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-08-26
- Publication Date
- 2024-11-22
AI Technical Summary
When data interaction between heterogeneous databases, users need to operate on each database system separately, which increases operational complexity and reduces data processing efficiency and affects user experience.
By entering command information in the local database system, the command statements that can be executed by the target database system are generated, and the data type of the target database system is converted based on the syntax conversion rules, and the corresponding operations are pushed to the target database system to solve cross-database interactions. Compatibility issues, real-time data interaction across database systems.
It improves data processing efficiency, improves user experience, and realizes compatibility between different database systems to facilitate data interaction.
Smart Images

Figure CN119003596A_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the technical field of database data processing, and more specifically to a data interaction method between heterogeneous databases, an electronic device, and a storage medium. Background Art
[0002] With the rapid development of information technology, various database systems such as GaussDB, OpenGauss, Oracle, MySQL and SQL Server have been widely used in various application scenarios. These database systems provide powerful data management functions, enabling enterprises to perform operations such as data query, deletion, and update to achieve in-depth management and analysis of data.
[0003] In actual applications, enterprises often need to perform data interaction operations between these heterogeneous databases, such as data synchronization, query, update, etc. At present, when data interaction operations involving different heterogeneous databases are performed, users are usually required to perform operations on each heterogeneous database system separately, which not only increases the complexity of the operation, but also reduces the data processing efficiency, thus affecting the user experience. Summary of the invention
[0004] The present application is proposed in view of the above problems. According to one aspect of the present application, a method for data interaction between heterogeneous databases is provided, comprising: in response to command information input by a user in a local database system, generating a command statement for execution in a target database system in the local database system; based on a grammar conversion rule, converting the data type of the command statement into a data type corresponding to the target database system; pushing the converted command statement down to the target database system to execute the operation corresponding to the command statement in the target database system.
[0005] Exemplarily, the command information is query command information, the command statement is a query command statement, and the operation corresponding to the command statement is a query operation; pushing the converted command statement to the target database system to execute the operation corresponding to the command statement in the target database system includes: pushing the converted query command statement to the target database system to execute the query operation in the target database system; the method also includes: receiving a query result obtained by executing the query operation in the target database system; mapping the data type of the query result to the data type corresponding to the local database system.
[0006] Exemplarily, before receiving the query results obtained by executing the query operation on the target database system, the method also includes: determining the data volume of the query results; wherein, when the data volume is greater than a data volume threshold, receiving the query results obtained by executing the query operation on the target database system includes: receiving the query results in batches.
[0007] Exemplarily, the command information is insert command information, the command statement is an insert command statement, and the operation corresponding to the command statement is an insert operation; pushing the converted command statement to the target database system to execute the operation corresponding to the command statement in the target database system includes: pushing the converted insert command statement to the target database system to execute the insert operation in the target database system.
[0008] Exemplarily, the command information is update command information, the command statement is an update command statement, and the operation corresponding to the command statement is an update operation; pushing the converted command statement to the target database system to execute the operation corresponding to the command statement in the target database system includes: pushing the converted update command statement to the target database system to execute the update operation in the target database system.
[0009] Exemplarily, the command information is delete command information, the command statement is a delete command statement, and the operation corresponding to the command statement is a delete operation; pushing the converted command statement to the target database system to execute the operation corresponding to the command statement in the target database system includes: pushing the converted delete command statement to the target database system to execute the delete operation in the target database system.
[0010] Exemplarily, in response to command information input by a user in the local database system, before the local database system generates a command statement, the method further includes: configuring a dblink link between the local database system and the target database system based on access information input by the user, so that the local database system and the target database system are data connected through the dblink link.
[0011] Exemplarily, the access information includes the database type, IP address and port information of the target database system; preferably, the access information also includes a user name and password for accessing the target database system.
[0012] According to another aspect of the present application, an electronic device is provided, including a processor and a memory, wherein a computer program is stored in the memory, and the processor is used to execute the computer program to implement the above method.
[0013] According to another aspect of the present application, a computer-readable storage medium is provided, storing a computer program / instruction, and the computer program / instruction implements the above method when executed by a processor.
[0014] In the above technical solution, the user can input command information in the local database system, and the command statement corresponding to the command information can be converted into a command statement executable by the target database system based on the grammar conversion rules, and directly pushed down to the target database system for execution after conversion. This solution can solve the compatibility problem during cross-database interaction by converting the command information based on the grammar conversion rules, so that the command can be initiated in the local database system and executed in the target database system. This helps to improve data processing efficiency, improve user experience, and is conducive to achieving compatibility across database systems, facilitating data interaction between different database systems.
[0015] The above description is only an overview of the technical solution of the present application. In order to more clearly understand the technical means of the present application, it can be implemented in accordance with the contents of the specification. In order to make the above and other purposes, features and advantages of the present application more obvious and easy to understand, the specific implementation methods of the present application are listed below. BRIEF DESCRIPTION OF THE DRAWINGS
[0016] By describing the embodiments of the present application in more detail in conjunction with the accompanying drawings, the above and other purposes, features and advantages of the present application will become more apparent. The accompanying drawings are used to provide a further understanding of the embodiments of the present application and constitute a part of the specification. Together with the embodiments of the present application, they are used to explain the present application and do not constitute a limitation of the present application. In the accompanying drawings, the same reference numerals generally represent the same components or steps.
[0017] Figure 1 A schematic flow chart showing a data interaction method according to an embodiment of the present application; Figure 2 A schematic block diagram of an electronic device according to an embodiment of the present application is shown. DETAILED DESCRIPTION
[0018] In order to make the purpose, technical solutions and advantages of the present application more obvious, the example embodiments according to the present application will be described in detail with reference to the accompanying drawings. Obviously, the described embodiments are only part of the embodiments of the present application, rather than all the embodiments of the present application, and it should be understood that the present application is not limited to the example embodiments described herein. Based on the embodiments of the present application described in the present application, all other embodiments obtained by those skilled in the art without creative work should fall within the scope of protection of the present application.
[0019] As described above, when data interaction operations involving different heterogeneous databases are performed, users are usually required to perform operations separately on each heterogeneous database system, which not only increases the complexity of the operation, but also reduces the data processing efficiency, thereby affecting the user experience. In view of this, the present application provides a data interaction method, electronic device and storage medium between heterogeneous databases, which can realize real-time data interaction across database systems without the need for users to perform operations separately on each heterogeneous database system, thereby improving data processing efficiency. The method, electronic device and storage medium are described in detail below.
[0020] According to one aspect of an embodiment of the present application, a method for data interaction between heterogeneous databases is provided. Figure 1 FIG. 1 is a schematic flow chart of a data interaction method according to an embodiment of the present application. Figure 1 As shown, the method 100 may include the following steps S110, S120 and S130.
[0021] In step S110 , in response to command information input by a user in the local database system, a command statement for execution in the target database system is generated in the local database system.
[0022] In this article, the database system includes but is not limited to OpenGauss database, GaussDB database, Oracle database, MySQL database, SQL Server database, etc. Those skilled in the art can select the local database system and the target database system according to actual needs, and this application does not limit this. In some embodiments of this application, the local database system can be an OpenGauss database or a GaussDB database.
[0023] In this paper, the local database system and the target database system are heterogeneous databases.
[0024] In step S110 of this invention, the command information is a command input by the user in the local database system, which is at least used to be executed in other database systems (i.e., the target database system). For example, the user can input command information for data query in other database systems in the local database system. After the user inputs the command information, a command statement (i.e., an SQL statement) corresponding to the command information can be generated in the local database system according to the command information. The way in which the user inputs the command information in the local database system includes, but is not limited to, through a keyboard, a touch screen, a microphone, etc., and this application does not limit this.
[0025] Of course, the command information may include commands executed in the local database system in addition to the commands executed in the target database system. In some embodiments, the method may further include the following steps: In response to the command information input by the user in the local database system, a command statement for execution in the local database system is generated in the local database system. In the scheme of this embodiment, the command statement executed in the target database system and the command statement executed in the local database system can be generated simultaneously according to the command information. For example, when the user needs to perform an associated query in the local database system and the target database system, the command information can be input in the local database system. At this time, the command statement executed in the target database system and the command statement executed in the local database system can be generated simultaneously according to the command information input by the user in the local database system, so as to perform query operations in the local database system and the target database system respectively in the subsequent process. Those skilled in the art can understand the implementation method of the command statement executed in the local database system, which will not be repeated. In the following, unless otherwise specified, the command statements mentioned are all command statements for execution in the target database system.
[0026] In step S120, based on the syntax conversion rules, the data type of the command statement is converted into a data type corresponding to the target database system.
[0027] In this article, the syntax conversion rule is a rule for mapping the data type of a command statement from the data type corresponding to the local database system to the data type of the target database system. The rule can be pre-defined according to the standard SQL and will not be described in detail.
[0028] It is understandable that the data types corresponding to different database systems may be different, and thus, the command statements directly generated in the local database system may not be executable in the target database system. In this article, step S120 can be executed to convert the data type of the command statement into the data type corresponding to the target database system, that is, the command statement is converted into a compatible format of the target database system through the grammar conversion rules, thereby ensuring the executability of the command statement and thus ensuring the rationality of the solution.
[0029] In step S130, the converted command statement is pushed down to the target database system to execute the operation corresponding to the command statement in the target database system.
[0030] After obtaining the converted command statement, the converted command statement can be pushed down to the target database system. After being pushed down to the target database system, the command statement can be executed in the target database system, thereby realizing data interaction across database systems.
[0031] The inventors have found through research that there are currently compatibility issues when processing cross-database queries and data interactions, that is, there are differences in the SQL syntax and functions of different database systems, resulting in the need for complex syntax conversion when querying across databases. In the above technical solution, the user can enter command information in the local database system, and the command statement corresponding to the command information can be converted into a command statement that can be executed by the target database system based on the syntax conversion rules, and directly pushed down to the target database system for execution after the conversion. This solution can solve the compatibility problem during cross-database interaction by converting the command information based on the syntax conversion rules, so that commands can be initiated in the local database system and executed in the target database system. This helps to improve data processing efficiency, improve user experience, and is conducive to achieving compatibility across database systems, facilitating data interaction between different database systems.
[0032] Exemplarily, the command information is query command information, the command statement is a query command statement, and the operation corresponding to the command statement is a query operation; step S130, pushing the converted command statement down to the target database system to execute the operation corresponding to the command statement in the target database system, can specifically include the following steps: pushing the converted query command statement down to the target database system to execute the query operation in the target database system.
[0033] In this example, method 100 may further include the following steps S140 and S150.
[0034] In step S140, a query result obtained by executing a query operation in the target database system is received.
[0035] In step S150, the data type of the query result is mapped to the data type corresponding to the local database system.
[0036] In the solution of this example, the command statement is a query command statement. In one embodiment, the command statement may be: SELECT * FROM zdblink('test', 'SELECT scdm FROM public.dblink_test') AStmp(scdm int). This command indicates that the SELECT * FROM public.dblink_test query is executed in the target database system through the database link "test", and the result is returned to the local database system.
[0037] In some embodiments, the command executed in the target database system may be an associated query "Join", which may be executed in the target database system and return the query results to the local database system. The command statement corresponding to the associated query command may be: SELECT * FROM zdblink('to_gauss', 'SELECTa.k,as FROM public.test1 a INNER JOIN public.test2 b ON a.id = b.id') AStmpla(int k varchar, s varchar), that is, this command executes an associated query in the target database system through the database link "to_gauss", associates the records with the same id in the public.test1 and public.test2 tables, and returns the results to the local database system.
[0038] After obtaining the query results, the data type of the query results can be mapped to the data type corresponding to the local database system, so that it is convenient for users to view the data in the local database system.
[0039] The above technical solution can realize querying the data of the target database system in the local database system, thereby helping to improve data processing efficiency and user experience.
[0040] Exemplarily, before receiving the query results obtained by executing the query operation in the target database system, the method may further include the following steps: determining the data volume of the query results; wherein, when the data volume is greater than a data volume threshold, receiving the query results obtained by executing the query operation in the target database system includes: receiving the query results in batches.
[0041] Optionally, the data volume threshold can be determined according to user needs and will not be described in detail.
[0042] It can be understood that receiving query results in batches means dividing the query results obtained in the target database system into multiple batches, and then transmitting them to the local database system through multiple transmissions. This solution measures the data volume of the query results and uses batch transmission to transmit data when the data volume of the query results is large, thereby reducing the amount of data transmitted in a single transmission, which helps to improve transmission efficiency.
[0043] Optionally, when processing query results with large amounts of data, you can also use streaming processing to avoid memory overflow caused by loading a large amount of data at one time.
[0044] Exemplarily, the command information is insert command information, the command statement is an insert command statement, and the operation corresponding to the command statement is an insert operation; step S130, pushing the converted command statement down to the target database system to execute the operation corresponding to the command statement in the target database system, can specifically include the following steps: pushing the converted insert command statement down to the target database system to execute the insert operation in the target database system.
[0045] In the solution of this example, data can be inserted into the target database system from the local database system, thereby helping to improve data processing efficiency and user experience.
[0046] Exemplarily, the insert statement command may include data to be inserted. When the operation corresponding to the command statement is an insert operation, before pushing the converted command statement to the target database system, the method may further include the following steps: determining the amount of data to be inserted; wherein, when the amount of data is greater than the data amount threshold, pushing the converted command statement to the target database system may include: pushing the data to be inserted to the target database system in batches. In the scheme of this example, the data amount threshold can be selected according to actual needs. For ease of distinction, the above-mentioned data amount threshold for measuring the amount of query result data can be referred to as the first data amount threshold, and the data amount threshold in this example can be referred to as the second data amount threshold. In some embodiments, the second data amount threshold can be 1000. This scheme can reduce the amount of data transmitted in a single transmission by adopting a multi-transmission method for data transmission, which helps to improve transmission efficiency.
[0047] Exemplarily, the command information is update command information, the command statement is an update command statement, and the operation corresponding to the command statement is an update operation; step S130, pushing the converted command statement down to the target database system to execute the operation corresponding to the command statement in the target database system, can specifically include the following steps: pushing the converted update command statement down to the target database system to execute the update operation in the target database system. In the solution of this example, data in the target database system can be updated in the local database system, thereby helping to improve data processing efficiency and user experience.
[0048] Exemplarily, the command information is delete command information, the command statement is a delete command statement, and the operation corresponding to the command statement is a delete operation; step S130, pushing the converted command statement down to the target database system to execute the operation corresponding to the command statement in the target database system, can specifically include the following steps: pushing the converted delete command statement down to the target database system to execute the delete operation in the target database system. In the solution of this example, data in the target database system can be deleted in the local database system, thereby helping to improve data processing efficiency and user experience.
[0049] The inventors have found through research that cross-database queries usually involve a large amount of data transmission, which can easily lead to a decrease in query performance. In the above example solution of the present application, batch data transmission and streaming data processing technology are used when the amount of data is large, which greatly improves the performance of cross-database queries and helps reduce data delays and network overhead.
[0050] Exemplarily, the operation corresponding to the command statement is an insert operation, an update operation or a delete operation; a trigger is configured in the target database system, which is used to capture the operations performed in the target database system and synchronize the operation records to the incremental log table; method 100 may also include: scanning the incremental log table to synchronize the operation records recorded in the incremental log table to the local database system.
[0051] Optionally, the scanning period can be set according to actual needs, which will not be described in detail.
[0052] The inventor found in the research that although there are some cross-database data synchronization solutions, the existing cross-database data synchronization solutions are difficult to meet the real-time requirements and have large data delays. The above technical solution uses an incremental data synchronization mechanism to synchronize data changes (i.e. data insertion, update, and deletion) in the target database system to the local database system in real time, thereby helping to improve the real-time data interaction effect across database systems and ensure data consistency and real-time performance.
[0053] Exemplarily, in response to command information input by a user in the local database system, before the local database system generates a command statement, the method also includes: configuring a dblink link between the local database system and the target database system based on access information input by the user, so that the local database system and the target database system achieve data connection through the dblink link.
[0054] In the solution of this example, data connection can be achieved by creating a dynamic extension in the local database system using a dblink link. This dynamic extension method can avoid affecting the database system. In a specific embodiment, the initialization logic of dblink can be completed first, that is, the odbc connection can be configured first, and then the dblink dynamic extension can be created in the local database system, and the corresponding connection function can be created, and then a simple query can be executed. If a success message is returned, it means that the initialization logic is completed. After the initialization is completed, the target database system can be specified based on the access information entered by the user and configured through odbc to achieve data connection between the local database system and the target database system.
[0055] In the scenario of this example, the access information entered by the user is used to specify the target database system.
[0056] In some embodiments, there may be multiple target database systems. In this case, a dblink link may be configured between each target database system and the local database system.
[0057] The above technical solution realizes the data connection between the local database system and the target database system through the dblink link. The solution is simple and can be applied to a variety of different database systems, greatly improving the usability and flexibility of the system.
[0058] Exemplarily, the access information includes the database type, IP address and port information of the target database system; preferably, the access information also includes a user name and password for accessing the target database system.
[0059] In the solution of this example, the target database system can be accurately specified through the database type, IP address and port information. In a further preferred solution, sufficient permissions can be guaranteed to access the target database system through the user name and password, thereby helping to improve the security of data interaction.
[0060] In a specific embodiment, suppose we need to connect to a database named "test". In this case, we can create a connection command: Selectzdblink create (DBLINK NAME, DBTYPE, IP, PORT, DBNAMEUSER, PASSWORD). By executing this command, the local database system will create a link to the target database system locally to facilitate subsequent operations.
[0061] According to another aspect of the embodiments of the present application, an electronic device is also provided. Figure 2 FIG. 1 is a schematic block diagram of an electronic device according to an embodiment of the present application. Figure 2As shown, the electronic device 200 includes: a processor 210 and a memory 220. The memory 220 stores a computer program, and the processor 210 is used to execute the computer program to implement the above method.
[0062] According to another aspect of the embodiment of the present application, a computer-readable storage medium is also provided. The storage medium stores a computer program / instruction, and the computer program / instruction implements the above method when executed by the processor. The storage medium may include, for example, a read-only memory (ROM), an erasable programmable read-only memory (EPROM), a portable compact disk read-only memory (CD-ROM), a USB memory, or any combination of the above storage media. The computer-readable storage medium may be any combination of one or more computer-readable storage media.
[0063] A person skilled in the art can easily understand the implementation structure, working principle and beneficial effects of the electronic device and the computer-readable storage medium by reading the above method, and will not be described in detail for the sake of brevity.
[0064] Although example embodiments have been described herein with reference to the accompanying drawings, it should be understood that the above example embodiments are merely exemplary and are not intended to limit the scope of the present application to this. Those of ordinary skill in the art may make various changes and modifications therein without departing from the scope and spirit of the present application. All these changes and modifications are intended to be included within the scope of the present application as required by the appended claims.
[0065] Those of ordinary skill in the art will appreciate that the units and algorithm steps of each example described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, or a combination of computer software and electronic hardware. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. Professional and technical personnel can use different methods to implement the described functions for each specific application, but such implementation should not be considered to be beyond the scope of this application.
[0066] In the several embodiments provided in this application, it should be understood that the disclosed devices and methods can be implemented in other ways. For example, the device embodiments described above are only schematic, for example, the division of units is only a logical function division, and there may be other division methods in actual implementation, such as multiple units or components can be combined or integrated into another device, or some features can be ignored or not executed.
[0067] In the description provided herein, a large number of specific details are described. However, it is understood that the embodiments of the present application can be practiced without these specific details. In some instances, well-known methods, structures and techniques are not shown in detail so as not to obscure the understanding of this description.
[0068] Similarly, it should be understood that in order to streamline the present application and help understand one or more of the various application aspects, in the description of the exemplary embodiments of the present application, the various features of the present application are sometimes grouped together into a single embodiment, figure, or description thereof. However, the method of the present application should not be interpreted as reflecting the following intention: the claimed application requires more features than the features clearly stated in each claim. More specifically, as reflected in the corresponding claims, the application point is that the corresponding technical problem can be solved with less than all the features of a single disclosed embodiment. Therefore, the claims following the specific embodiment are hereby explicitly incorporated into the specific embodiment, wherein each claim itself serves as a separate embodiment of the present application.
[0069] Those skilled in the art will understand that, except for mutually exclusive features, all features disclosed in this specification (including the accompanying claims, abstract and drawings) and all processes or units of any method or device disclosed in this specification may be combined in any combination. Unless otherwise explicitly stated, each feature disclosed in this specification (including the accompanying claims, abstract and drawings) may be replaced by an alternative feature that provides the same, equivalent or similar purpose.
[0070] In addition, those skilled in the art will appreciate that, although some embodiments described herein include certain features included in other embodiments but not other features, the combination of features of different embodiments is meant to be within the scope of the present application and form different embodiments. For example, in the claims, any one of the claimed embodiments can be used in any combination.
[0071] The various component embodiments of the present application may be implemented in hardware, or in software modules running on one or more processors, or in a combination thereof. It should be understood by those skilled in the art that a microprocessor or a digital signal processor (DSP) may be used in practice to implement some or all functions of some modules in the electronic device according to the embodiment of the present application. The present application may also be implemented as a device program (e.g., a computer program and a computer program product) for executing part or all of the methods described herein. Such a program implementing the present application may be stored on a computer-readable medium, or may be in the form of one or more signals. Such a signal may be downloaded from an Internet website, or provided on a carrier signal, or provided in any other form.
[0072] It should be noted that the above embodiments illustrate the present application rather than limit the present application, and that those skilled in the art may design alternative embodiments without departing from the scope of the appended claims. In the claims, any reference symbol between brackets should not be constructed as a limitation to the claims. The word "comprising" does not exclude the presence of elements or steps not listed in the claims. The word "one" or "an" preceding an element does not exclude the presence of multiple such elements. The present application may be implemented by means of hardware including several different elements and by means of a suitably programmed computer. In a unit claim that lists several devices, several of these devices may be embodied by the same hardware item. The use of the words first, second, and third, etc. does not indicate any order. These words may be interpreted as names.
[0073] The above is only a specific implementation or description of a specific implementation of the present application, and the protection scope of the present application is not limited thereto. Any technician familiar with the technical field can easily think of changes or substitutions within the technical scope disclosed in the present application, which should be included in the protection scope of the present application. The protection scope of the present application shall be based on the protection scope of the claims.
Claims
1. A data interaction method between heterogeneous databases, characterized in that: include: In response to command information input by a user in a local database system, generating a command statement in the local database system for execution in a target database system; Based on the syntax conversion rules, convert the data type of the command statement into the data type corresponding to the target database system; The converted command statement is pushed down to the target database system to execute the operation corresponding to the command statement in the target database system.
2. The data interaction method according to claim 1, characterized in that: The command information is query command information, the command statement is a query command statement, and the operation corresponding to the command statement is a query operation; The step of pushing the converted command statement to the target database system to execute the operation corresponding to the command statement in the target database system includes: Pushing the converted query command statement down to the target database system to execute the query operation in the target database system; The method further comprises: Receiving a query result obtained by executing the query operation on the target database system; The data type of the query result is mapped to the data type corresponding to the local database system.
3. The data interaction method according to claim 2, characterized in that: Before receiving the query result obtained by executing the query operation in the target database system, the method further includes: Determining the data volume of the query result; Wherein, when the data volume is greater than a data volume threshold, receiving the query results obtained by executing the query operation in the target database system includes: receiving the query results in batches.
4. The data interaction method according to claim 1, characterized in that: The command information is insert command information, the command statement is an insert command statement, and the operation corresponding to the command statement is an insert operation; The step of pushing the converted command statement to the target database system to execute the operation corresponding to the command statement in the target database system includes: The converted insert command statement is pushed down to the target database system to execute the insert operation in the target database system.
5. The data interaction method according to claim 1, characterized in that: The command information is update command information, the command statement is an update command statement, and the operation corresponding to the command statement is an update operation; The step of pushing the converted command statement to the target database system to execute the operation corresponding to the command statement in the target database system includes: The converted update command statement is pushed down to the target database system to execute the update operation in the target database system.
6. The data interaction method according to claim 1, characterized in that: The command information is deletion command information, the command statement is a deletion command statement, and the operation corresponding to the command statement is a deletion operation; The step of pushing the converted command statement to the target database system to execute the operation corresponding to the command statement in the target database system includes: The converted delete command statement is pushed down to the target database system to execute the delete operation in the target database system.
7. The data interaction method according to claim 1, characterized in that: In response to the command information input by the user in the local database system, before the local database system generates a command statement, the method further includes: Based on the access information input by the user, a dblink link is configured between the local database system and the target database system, so that the local database system and the target database system are data connected through the dblink link.
8. The data interaction method according to claim 7, characterized in that: The access information includes the database type, IP address and port information of the target database system; Preferably, the access information also includes a user name and password for accessing the target database system.
9. An electronic device, characterized in that: The method comprises a processor and a memory, wherein the memory stores a computer program, and the processor is used to execute the computer program to implement the method according to any one of claims 1 to 8.
10. A computer-readable storage medium, characterized in that: A computer program / instruction is stored, and when the computer program / instruction is executed by a processor, the method according to any one of claims 1 to 8 is implemented.
