CN115982284B - Database incremental synchronization method, system, electronic device and medium - Google Patents
Database incremental synchronization method, system, electronic device and medium Download PDFInfo
- Publication number
- CN115982284B CN115982284B CN202310125753.4A CN202310125753A CN115982284B CN 115982284 B CN115982284 B CN 115982284B CN 202310125753 A CN202310125753 A CN 202310125753A CN 115982284 B CN115982284 B CN 115982284B
- Authority
- CN
- China
- Prior art keywords
- sql
- target
- version number
- database
- ciphertext
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 34
- 238000001914 filtration Methods 0.000 claims description 41
- 238000004590 computer program Methods 0.000 claims description 10
- 230000008569 process Effects 0.000 abstract description 6
- 230000006870 function Effects 0.000 description 7
- 230000008859 change Effects 0.000 description 6
- 238000011161 development Methods 0.000 description 2
- 230000018109 developmental process Effects 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 238000007792 addition Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 230000008140 language development Effects 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
- 238000012552 review Methods 0.000 description 1
- 230000033772 system development Effects 0.000 description 1
Classifications
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a database increment synchronization method, a system, electronic equipment and a medium, which belong to the field of databases, wherein the method comprises the steps of obtaining a target version number, and obtaining an SQL statement set of a corresponding version from a code library according to the target version number; analyzing the SQL statement to obtain a target SQL statement, encrypting the target SQL statement to obtain an SQL ciphertext, querying whether the SQL ciphertext exists in an execution record data table corresponding to the target version number, if so, not executing the corresponding SQL statement, otherwise querying whether keywords in the SQL statement exist in the filter configuration file, if so, not executing the SQL statement, otherwise, executing the SQL statement to perform incremental synchronization on the database, and storing the SQL ciphertext in the execution record data table corresponding to the target version number. The invention automates the process of incremental synchronization of the database, reduces manual intervention and improves synchronization efficiency.
Description
Technical Field
The present invention relates to the field of databases, and in particular, to a method, a system, an electronic device, and a medium for incremental synchronization of a database.
Background
Because the current general system development adopts agile mode, the system functions are frequently changed, namely when the current system version is upgraded, the DDL (Data DefinitionLanguage ) and DML (DataManipulationLanguage, data manipulation language) sentences are often required to be manually checked and executed to change the database structure, add, modify and delete the basic configuration data due to the change of the corresponding functions, so that the database synchronization efficiency is extremely low.
Disclosure of Invention
The invention aims to provide a database increment synchronization method, a system, electronic equipment and a medium, which can improve the efficiency of database synchronization.
In order to achieve the above object, the present invention provides the following solutions:
a database delta synchronization method, comprising:
acquiring a target version number, and acquiring an SQL statement set of a corresponding version from a code library according to the target version number, wherein a plurality of version numbers and SQL statements corresponding to each version number are prestored in the code library;
analyzing the SQL statement aiming at any SQL statement to obtain a target SQL statement;
Encrypting the target SQL statement to obtain an SQL ciphertext;
inquiring whether the SQL ciphertext exists in an execution record data table corresponding to the target version number;
if the SQL ciphertext exists in the execution record data table corresponding to the target version number, not executing the corresponding SQL sentence;
If the SQL ciphertext does not exist in the execution record data table corresponding to the target version number, inquiring whether keywords in the SQL sentence exist in a filtering configuration file or not;
If keywords in the SQL statement exist in the filtering configuration file, the SQL statement is not executed;
And if the key words in the SQL sentences do not exist in the filtering configuration file, executing the SQL sentences to perform incremental synchronization on the database, and storing the SQL ciphertext into an execution record data table corresponding to the target version number.
Optionally, the code library is a GIT code repository.
Optionally, analyzing the SQL sentence to obtain a target SQL sentence, which specifically comprises:
formatting the SQL sentence by using an SQL grammar interpreter to obtain a standard SQL sentence;
judging whether the standard SQL statement has grammar errors or not;
If yes, filtering the standard SQL sentence, generating prompt information, and acquiring a target SQL sentence input by a user;
if not, the standard SQL statement is a target SQL statement.
Optionally, after obtaining the target SQL statement input by the user, parsing the SQL statement to obtain the target SQL statement further includes:
Storing target SQL sentences input by a user into an analysis library so as to optimize the SQL grammar interpreter.
Optionally, the SQL grammar interpreter is CCJSqlParserUtil parse tool.
Optionally, encrypting the target SQL sentence to obtain an SQL ciphertext, which specifically comprises:
and encrypting the target SQL statement by using an Md5Util tool class to obtain an SQL ciphertext.
In order to achieve the above purpose, the present invention also provides the following solutions:
A database delta synchronization system, comprising:
The system comprises a statement acquisition unit, a code library, a statement acquisition unit and a storage unit, wherein the statement acquisition unit is used for acquiring a target version number and acquiring an SQL statement set of a corresponding version from the code library according to the target version number;
The analysis unit is connected with the statement acquisition unit and is used for analyzing the SQL statement aiming at any SQL statement to obtain a target SQL statement;
The encryption unit is connected with the analysis unit and used for encrypting the target SQL statement to obtain an SQL ciphertext;
The first query unit is connected with the encryption unit and is used for querying whether the SQL ciphertext exists in the execution record data table corresponding to the target version number;
The first filtering unit is connected with the first query unit and is used for not executing the corresponding SQL sentence if the SQL ciphertext exists in the execution record data table corresponding to the target version number;
The second query unit is connected with the first query unit and is used for querying whether keywords in the SQL sentences exist in a filtering configuration file or not if the SQL ciphertext does not exist in an execution record data table corresponding to the target version number;
The second filtering unit is connected with the second query unit and is used for not executing the SQL sentence if the keywords in the SQL sentence exist in the filtering configuration file;
And the execution unit is connected with the second query unit and is used for executing the SQL sentence if the key words in the SQL sentence do not exist in the filtering configuration file, so as to perform incremental synchronization on the database, and storing the SQL ciphertext into an execution record data table corresponding to the target version number.
In order to achieve the above purpose, the present invention also provides the following solutions:
An electronic device comprising a memory for storing a computer program and a processor that runs the computer program to cause the electronic device to perform the database delta synchronization method described above.
In order to achieve the above purpose, the present invention also provides the following solutions:
a computer readable storage medium storing a computer program which when executed by a processor implements the database delta synchronization method described above.
According to the specific embodiment provided by the invention, the invention discloses the following technical effects:
According to the method, the SQL sentences corresponding to the appointed version numbers are automatically obtained from the code library, and the SQL sentences are automatically analyzed, encrypted, filtered and executed, so that the manual participation is greatly reduced, and the database synchronization efficiency is improved.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions of the prior art, the drawings that are needed in the embodiments will be briefly described below, it being obvious that the drawings in the following description are only some embodiments of the present invention, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a flow chart of a database incremental synchronization method of the present invention;
FIG. 2 is a schematic diagram of a database incremental synchronization process;
FIG. 3 is a block diagram of a database incremental synchronization system of the present invention.
Symbol description:
The system comprises a statement acquisition unit-1, a parsing unit-2, an encryption unit-3, a first query unit-4, a first filtering unit-5, a second query unit-6, a second filtering unit-7 and an execution unit-8.
Detailed Description
The following description of the embodiments of the present invention will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present invention, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
The invention aims to provide a database increment synchronization method, a system, electronic equipment and a medium, which can automatically acquire database change sentences submitted by developers through designing a database increment synchronization program, analyze and filter the database change sentences and then execute the database change sentences so as to improve the efficiency of database synchronization.
In order that the above-recited objects, features and advantages of the present invention will become more readily apparent, a more particular description of the invention will be rendered by reference to the appended drawings and appended detailed description.
First, the database technical terms used in the invention are described:
SQL (StructuredQueryLanguage ) is a database query and programming language used to access data and query, update, and manage relational database systems.
DDL, a data definition language, common DDL statements are create a database, create a database table, modify a database table, delete a database table, create a view, modify a view, and the like.
DML, data manipulation language, common DML sentences have inquiry, addition, modification and deletion of data.
Example 1
As shown in fig. 1 and 2, the present embodiment provides a database incremental synchronization method, including:
S1, acquiring a target version number, and acquiring an SQL statement set of a corresponding version from a code library according to the target version number. The SQL statement set includes one or more SQL statements.
Specifically, a plurality of version numbers and SQL sentences corresponding to the version numbers are stored in the code library in advance. In this embodiment, the code library is a GIT code library. That is, the code and database execution statement generated during the development process of the developer are all uploaded to the GIT code repository. The object of the present invention is to synchronize data in the GIT code repository to a target folder to save copies.
The software project will determine software versions during the daily development process, each version involving the adjustment of several important functions, such as V1.1.0.0 version numbers. The new function of each version involves a corresponding database change, embodied as DDL, DML database statements. The database sentences are stored in different folders according to different version numbers, and the SQL sentences are read from the corresponding version folders of the GIT code library according to the manually input target version numbers and stored in the background folders.
S2, analyzing the SQL statement aiming at any SQL statement to obtain a target SQL statement.
Further, S2 specifically includes:
(1) And formatting the SQL sentence (removing redundant space, adjusting to a regular style and the like) by using an SQL grammar interpreter to obtain a standard SQL sentence. In this embodiment, the SQL grammar interpreter is CCJSqlParserUtil parse tool.
(2) And judging whether the standard SQL statement has grammar errors or not. And if the standard SQL statement exists, filtering the standard SQL statement, generating prompt information, and acquiring a target SQL statement input by a user. If not, the standard SQL statement is a target SQL statement.
Specifically, if the parsing fails, a popup prompt is generated, the SQL sentence still needed to be executed is provided for the user, and the SQL sentence manually selected by the user is the target SQL sentence.
After the target SQL sentence input by the user is obtained, the target SQL sentence input by the user is stored in an analysis library so as to optimize the SQL grammar interpreter. The third party analysis tool CCJSqlParserUtil with limited abundant functions and inapplicable part of actual working scenes strengthens the analysis capability, and when similar SQL sentences are encountered again later, the analysis is successful by using CCJSqlParserUtil and manual selection records at the same time, and the self-adaption and self-learning capabilities are realized without manual intervention. SQL statements that are not successfully parsed and not manually selected will not flow to subsequent decryption and execution.
And S3, encrypting the target SQL statement to obtain an SQL ciphertext. Preferably, the target SQL statement is encrypted using the Md5Util tool class.
Md5Util is a mature third party tool, and can realize the encryption function by directly calling a line of codes. Encryption is used for converting SQL sentences with different lengths and complexities into ciphertext with uniform length, and matching inquiry is carried out by using the ciphertext subsequently, so that the inquiry matching efficiency can be greatly improved.
And S4, inquiring whether the SQL ciphertext exists in an execution record data table corresponding to the target version number. The execution record data table is used for storing the SQL ciphertext which is executed corresponding to the target version number. The execution log (execution record data table) is preloaded into the cache after the version number is acquired, so that the query efficiency is improved.
And S5, if the SQL ciphertext exists in the execution record data table corresponding to the target version number, not executing the corresponding SQL sentence.
And S6, if the SQL ciphertext does not exist in the execution record data table corresponding to the target version number, inquiring whether keywords in the SQL sentence exist in the filtering configuration file. And if the keywords in the SQL statement exist in the filtering configuration file, not executing the SQL statement. I.e., the SQL ciphertext has been executed and is not repeatedly executed. And keywords to be filtered are prestored in the filtering configuration file.
The filtering rules are configured independently by using configuration files, and a keyword matching filtering mode is adopted to exclude SQL sentences which are not wanted to be executed. And preloading the filtering configuration file during initialization to improve the matching efficiency. Specifically, the user may configure certain keywords in the filtering configuration file, such as droptable, delete, etc., according to the actual service requirement, or use regular expression configuration to protect the key configuration data. The user saves the SQL keywords which do not want to be executed in the filtering configuration file, and the related SQL can be filtered out by using the file without being executed.
And S7, if the key words in the SQL sentences do not exist in the filtering configuration file, executing the SQL sentences to perform incremental synchronization on the database, and storing the SQL ciphertext into an execution record data table corresponding to the target version number.
In this embodiment, each SQL statement uses independent transactional execution, so as to ensure that execution among SQL statements does not interfere with each other, and normal execution of other SQL statements is not affected by executing an SQL statement with an error report. After the program executes the SQL statement, the corresponding SQL ciphertext is stored in the execution record data table. And the database maintenance personnel can conveniently track and review the execution condition.
As a specific implementation manner, the database related to the invention is an insurance claim database, and the version number is the version number of insurance claim software. The insurance claim database comprises a plurality of claim data tables. The data in the claim data table comprises version number, serial number, insurance policy number, report number, processing place and the like.
The method automatically acquires SQL sentences with appointed version numbers from a code library when incremental updating is carried out on an insurance claim database, and carries out the processes of analysis, encryption, filtering and execution.
The invention uses java language development, adopts a C/S (Client/Server) structure, integrates the original database increment synchronization process of acquisition, analysis, judgment and execution of manual whole participation in comparison with the existing database synchronization mode of whole-process manual participation, is basically automatically executed by a program, only needs manual participation in two places, namely, selecting a target version number, manually selecting a target SQL sentence after analysis failure, but has self-adaptive and self-learning analysis capability, increases the results of each analysis and manual selection to an analysis library, continuously enriches the analysis library, reduces the intervention of manual selection during later version analysis, and greatly improves the efficiency of database synchronization.
Example two
In order to perform a corresponding method of the above embodiment to achieve the corresponding functions and technical effects, a database incremental synchronization system is provided below.
As shown in fig. 3, the incremental database synchronization system provided in this embodiment includes a statement obtaining unit 1, an parsing unit 2, an encrypting unit 3, a first querying unit 4, a first filtering unit 5, a second querying unit 6, a second filtering unit 7, and an executing unit 8.
The statement obtaining unit 1 is used for obtaining a target version number and obtaining an SQL statement set of a corresponding version from a code library according to the target version number. And the code library is pre-stored with a plurality of version numbers and SQL sentences corresponding to the version numbers. The set of SQL statements includes one or more SQL statements.
The analysis unit 2 is connected with the statement acquisition unit 1, and the analysis unit 2 is used for analyzing any SQL statement to obtain a target SQL statement.
The encryption unit 3 is connected with the analysis unit 2, and the encryption unit 3 is used for encrypting the target SQL sentence to obtain an SQL ciphertext.
The first query unit 4 is connected to the encryption unit 3, and the first query unit 4 is configured to query whether the SQL ciphertext exists in the execution record data table corresponding to the target version number.
The first filtering unit 5 is connected to the first query unit 4, where the first filtering unit 5 is configured to not execute the corresponding SQL statement if the SQL ciphertext exists in the execution record data table corresponding to the target version number.
The second query unit 6 is connected to the first query unit 4, where the second query unit 6 is configured to query whether a keyword in the SQL statement exists in a filtering configuration file if the SQL ciphertext does not exist in the execution record data table corresponding to the target version number, and the filtering configuration file stores the keyword to be filtered in advance.
The second filtering unit 7 is connected to the second query unit 6, and the second filtering unit 7 is configured to not execute the SQL statement if the keywords in the SQL statement exist in the filtering configuration file.
The execution unit 8 is connected with the second query unit 7, and the execution unit 8 is configured to execute the SQL statement if no keyword in the SQL statement exists in the filtering configuration file, so as to perform incremental synchronization on the database, and store the SQL ciphertext into an execution record data table corresponding to the target version number.
Compared with the prior art, the database increment synchronization system provided in this embodiment has the same beneficial effects as the database increment synchronization method provided in the first embodiment, and will not be described in detail herein.
Example III
The present embodiment provides an electronic device, including a memory and a processor, where the memory is configured to store a computer program, and the processor is configured to execute the computer program to cause the electronic device to execute the database incremental synchronization method of the first embodiment.
Alternatively, the electronic device may be a server.
In addition, the embodiment of the present invention further provides a computer readable storage medium storing a computer program, where the computer program when executed by a processor implements the database incremental synchronization method of the first embodiment.
In the present specification, each embodiment is described in a progressive manner, and each embodiment is mainly described in a different point from other embodiments, and identical and similar parts between the embodiments are all enough to refer to each other.
The principles and embodiments of the present invention have been described herein with reference to specific examples, which are intended to facilitate an understanding of the principles and concepts of the invention and are to be varied in scope and detail by persons of ordinary skill in the art based on the teachings herein. In view of the foregoing, this description should not be construed as limiting the invention.
Claims (7)
1. A database delta synchronization method, the database delta synchronization method comprising:
acquiring a target version number, and acquiring an SQL statement set of a corresponding version from a code library according to the target version number, wherein a plurality of version numbers and SQL statements corresponding to each version number are prestored in the code library;
Analyzing the SQL sentence to obtain a target SQL sentence, wherein the method specifically comprises the steps of formatting the SQL sentence by using an SQL grammar interpreter to obtain a standard SQL sentence, judging whether the standard SQL sentence has grammar errors or not, filtering the standard SQL sentence and generating a popup prompt if the standard SQL sentence has grammar errors, providing the SQL sentence which still needs to be executed for a user, wherein the SQL sentence which is manually selected by the user is the target SQL sentence, storing the target SQL sentence input by the user into an analysis library to optimize the SQL grammar interpreter, and if the standard SQL sentence does not have grammar errors, the standard SQL sentence is the target SQL sentence;
Encrypting the target SQL statement to obtain an SQL ciphertext;
inquiring whether the SQL ciphertext exists in an execution record data table corresponding to the target version number;
if the SQL ciphertext exists in the execution record data table corresponding to the target version number, not executing the corresponding SQL sentence;
If the SQL ciphertext does not exist in the execution record data table corresponding to the target version number, inquiring whether keywords in the SQL sentence exist in a filtering configuration file or not;
If keywords in the SQL statement exist in the filtering configuration file, the SQL statement is not executed;
And if the key words in the SQL sentences do not exist in the filtering configuration file, executing the SQL sentences to perform incremental synchronization on the database, and storing the SQL ciphertext into an execution record data table corresponding to the target version number.
2. The database delta synchronization method of claim 1, wherein the code library is a GIT code library.
3. The method of claim 1, wherein the SQL syntax interpreter is CCJSqlParserUtil parsing tool.
4. The method for incremental synchronization of a database according to claim 1, wherein encrypting the target SQL statement to obtain an SQL ciphertext comprises:
and encrypting the target SQL statement by using an Md5Util tool class to obtain an SQL ciphertext.
5. A database delta synchronization system for use in the database delta synchronization method of any one of claims 1-4, the database delta synchronization system comprising:
The system comprises a statement acquisition unit, a code library, a statement acquisition unit and a storage unit, wherein the statement acquisition unit is used for acquiring a target version number and acquiring an SQL statement set of a corresponding version from the code library according to the target version number;
The analysis unit is connected with the statement acquisition unit and is used for analyzing the SQL statement aiming at any SQL statement to obtain a target SQL statement;
The encryption unit is connected with the analysis unit and used for encrypting the target SQL statement to obtain an SQL ciphertext;
The first query unit is connected with the encryption unit and is used for querying whether the SQL ciphertext exists in the execution record data table corresponding to the target version number;
The first filtering unit is connected with the first query unit and is used for not executing the corresponding SQL sentence if the SQL ciphertext exists in the execution record data table corresponding to the target version number;
The second query unit is connected with the first query unit and is used for querying whether keywords in the SQL sentences exist in a filtering configuration file or not if the SQL ciphertext does not exist in an execution record data table corresponding to the target version number;
The second filtering unit is connected with the second query unit and is used for not executing the SQL sentence if the keywords in the SQL sentence exist in the filtering configuration file;
And the execution unit is connected with the second query unit and is used for executing the SQL sentence if the key words in the SQL sentence do not exist in the filtering configuration file, so as to perform incremental synchronization on the database, and storing the SQL ciphertext into an execution record data table corresponding to the target version number.
6. An electronic device comprising a memory for storing a computer program and a processor that runs the computer program to cause the electronic device to perform the database delta synchronization method of any one of claims 1 to 4.
7. A computer readable storage medium, characterized in that it stores a computer program which, when executed by a processor, implements the database delta synchronization method according to any one of claims 1 to 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310125753.4A CN115982284B (en) | 2023-02-01 | 2023-02-01 | Database incremental synchronization method, system, electronic device and medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310125753.4A CN115982284B (en) | 2023-02-01 | 2023-02-01 | Database incremental synchronization method, system, electronic device and medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN115982284A CN115982284A (en) | 2023-04-18 |
| CN115982284B true CN115982284B (en) | 2025-03-07 |
Family
ID=85968162
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310125753.4A Active CN115982284B (en) | 2023-02-01 | 2023-02-01 | Database incremental synchronization method, system, electronic device and medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115982284B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116737752A (en) * | 2023-06-07 | 2023-09-12 | 金篆信科有限责任公司 | SQL statement interception method, device, equipment and storage medium |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107357907A (en) * | 2017-07-17 | 2017-11-17 | 郑州云海信息技术有限公司 | A kind of database upgrade method and device for supporting cross-version |
Family Cites Families (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20100132752A (en) * | 2009-06-10 | 2010-12-20 | (주)자이네스 | Query data distribution processing system for improving service performance through database distribution |
| EP2891994A4 (en) * | 2013-11-04 | 2016-06-01 | Guangdong Electronics Industry Inst Ltd | METHOD FOR AUTOMATICALLY SYNCHRONIZING MULTI-SOURCE HETEROGENEOUS DATA RESOURCES |
| CN106599167B (en) * | 2016-12-09 | 2020-11-20 | 苏州浪潮智能科技有限公司 | A system and method for supporting incremental database upgrade |
| CN109960710B (en) * | 2019-01-16 | 2023-04-11 | 平安科技（深圳）有限公司 | Data synchronization method and system between databases |
| CN110209684A (en) * | 2019-06-03 | 2019-09-06 | 深圳前海微众银行股份有限公司 | Tracking, device, system and the medium of database D DL change operation |
| CN115495440A (en) * | 2022-10-25 | 2022-12-20 | 金篆信科有限责任公司 | Data migration method, device and equipment of heterogeneous database and storage medium |
-
2023
- 2023-02-01 CN CN202310125753.4A patent/CN115982284B/en active Active
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107357907A (en) * | 2017-07-17 | 2017-11-17 | 郑州云海信息技术有限公司 | A kind of database upgrade method and device for supporting cross-version |
Also Published As
| Publication number | Publication date |
|---|---|
| CN115982284A (en) | 2023-04-18 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11354284B2 (en) | System and method for migration of a legacy datastore | |
| CN105868204B (en) | A kind of method and device for converting Oracle scripting language SQL | |
| US6360214B1 (en) | Automatic database statistics creation | |
| US7809763B2 (en) | Method(s) for updating database object metadata | |
| US11693912B2 (en) | Adapting database queries for data virtualization over combined database stores | |
| US20080256026A1 (en) | Method For Optimizing And Executing A Query Using Ontological Metadata | |
| US20040019587A1 (en) | Method and device for processing a query in a database management system | |
| CN105912594B (en) | SQL statement processing method and system | |
| CN111177788A (en) | Hive dynamic desensitization method and dynamic desensitization system | |
| EP3734443B1 (en) | Intelligent application programming interface (api) proxy design system | |
| CN112579610A (en) | Multi-data source structure analysis method, system, terminal device and storage medium | |
| CN113934750A (en) | Data blood relationship analysis method based on compiling mode | |
| EP2975535A1 (en) | Checking freshness of data for a data integration system, DIS | |
| US20200089792A1 (en) | Consistency checks between database systems | |
| CN113515564B (en) | J2 EE-based data access method, device, equipment and storage medium | |
| CN115982284B (en) | Database incremental synchronization method, system, electronic device and medium | |
| CN115391142A (en) | Database audit log generation method and system | |
| US10726011B2 (en) | System to search heterogeneous data structures | |
| US7559048B1 (en) | System and method for managing objects between projects | |
| CN117555969A (en) | Hive-based blood-edge information management method and device and computer equipment | |
| US20040249792A1 (en) | Automated query file conversions upon switching database-access applications | |
| US11681721B2 (en) | Systems and methods for spark lineage data capture | |
| US9916154B2 (en) | File-based transport of table content | |
| US11455294B2 (en) | Information lifecycle management notification framework | |
| US10042942B2 (en) | Transforms using column dictionaries |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |