CN117591531A - Remote data synchronization method and system for database - Google Patents
Remote data synchronization method and system for database Download PDFInfo
- Publication number
- CN117591531A CN117591531A CN202410069701.4A CN202410069701A CN117591531A CN 117591531 A CN117591531 A CN 117591531A CN 202410069701 A CN202410069701 A CN 202410069701A CN 117591531 A CN117591531 A CN 117591531A
- Authority
- CN
- China
- Prior art keywords
- file
- modified
- data information
- character
- updated
- 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 34
- 230000001360 synchronised effect Effects 0.000 claims description 10
- 238000000605 extraction Methods 0.000 claims description 7
- 238000005520 cutting process Methods 0.000 claims description 3
- 230000004048 modification Effects 0.000 description 7
- 238000012986 modification Methods 0.000 description 7
- 238000010586 diagram Methods 0.000 description 4
- 230000006870 function Effects 0.000 description 4
- 230000006978 adaptation Effects 0.000 description 2
- 230000005540 biological transmission Effects 0.000 description 2
- 238000004590 computer program Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 239000000284 extract Substances 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computing Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention is suitable for the technical field of data processing, and provides a remote data synchronization method and a remote data synchronization system for a database.
Description
Technical Field
The invention relates to the technical field of data processing, in particular to a remote data synchronization method and system of a database.
Background
Publication number CN115858688B discloses a remote data synchronization method and system for a database, comprising the following steps: receiving an information updating instruction sent by a user terminal, and updating data according to the information updating instruction by a database of an area where the user terminal is positioned; generating data synchronous update information and a quick update stamp, wherein the quick update stamp comprises an update time stamp and an update data address stamp; the fast update stamp is sent to the opposite-end database through a fast transmission channel, the data synchronous update information is sent to the opposite-end database through a common transmission channel, and the fast update stamp is deleted after the opposite-end database is updated; and receiving the information access command, judging whether the access data address in the information access command has a corresponding quick update stamp, and when the corresponding quick update stamp exists, carrying out quick synchronous update on the data in the access data address, so that the opposite-end database can know whether the data to be accessed is the latest data or not, and ensuring that the data accessed by the user is the latest.
The above remote data synchronization method also has the following drawbacks: when updating a file in a database, only a certain part of the file is required to be updated, but the data and the data position which need to be updated in the file cannot be quickly, intelligently and accurately identified in the traditional data updating process, and the whole file is generally directly updated, so that the data updating efficiency is lower.
Disclosure of Invention
Aiming at the defects existing in the prior art, the invention aims to provide a remote data synchronization method and a remote data synchronization system for a database, so as to solve the problems existing in the background art.
The invention is realized in that a remote data synchronization method of a database comprises the following steps:
receiving an information updating instruction sent by a user side, wherein the information updating instruction comprises an updating file;
inputting the updated file into a database for matching, and outputting a modified data information set and a data information set to be modified;
and executing an information updating instruction, and replacing the data information set to be modified with the modified data information set.
As a further scheme of the invention: the step of receiving an information updating instruction sent by a user terminal, wherein the information updating instruction comprises data to be synchronized, and specifically comprises the following steps:
storing the update file into an information update instruction;
and receiving an information updating instruction sent by the user terminal.
As a further scheme of the invention: the step of inputting the updated file into a database for matching, and outputting a modified data information set and a data information set to be modified, specifically comprising:
inputting the updated file into a database for matching, wherein the database stores the file to be updated;
when different data information exists in the update file and the file to be updated, respectively extracting a plurality of different modified data information and a plurality of different data information to be modified in the update file and the file to be updated;
and sorting a plurality of different modified data information and a plurality of different data information to be modified, and outputting a modified data information set and a data information set to be modified.
As a further scheme of the invention: when different data information exists in the update file and the file to be updated, respectively extracting a plurality of different modified data information and a plurality of different data information to be modified in the update file and the file to be updated, wherein the method specifically comprises the following steps of:
capturing the first and last different characters of the updated file respectively;
acquiring the character length from the first character to the last character in the update file, and marking the update file and the character position on the character length;
capturing the first and last different characters in the file to be updated respectively;
acquiring the character length and the character position from the first character to the last character in the file to be updated, marking the file to be updated on the character length, and enabling the character position of one character length in the updated file to correspond to the character position of the other character length in the file to be updated one by one.
As a further scheme of the invention: the step of sorting a plurality of different modified data information and a plurality of different data information to be modified and outputting a modified data information set and a data information set to be modified specifically includes:
establishing a modified data information set and a data information set to be modified;
searching a plurality of different character lengths according to the marks on the character lengths;
the character length marked with the updated file and the character length marked with the file to be updated are respectively stored in a modified data information set and a data information set to be modified by utilizing a cutting operation instruction;
and outputting the modified data information set and the data information set to be modified.
As a further scheme of the invention: executing an information updating instruction, and replacing the data information set to be modified with a modified data information set, wherein the method specifically comprises the following steps of:
executing an information updating instruction;
based on the one-to-one correspondence between the character position of one character length in the updated file and the character position of the other character length in the file to be updated, retrieving the character position of any one character length in the file to be updated according to the character position of any one character length in the modified data information set;
when the character positions of the character lengths in the two files are consistent, the character lengths in the modified data information set are copied to the corresponding character positions in the file to be updated by using a copy instruction.
A remote data synchronization system for a database, the system comprising:
the instruction receiving module is used for receiving an information updating instruction sent by the user side, wherein the information updating instruction comprises an updating file;
the information matching module is used for inputting the updated file into the database for matching and outputting a modified data information set and a data information set to be modified;
and the instruction execution module is used for executing the information updating instruction and replacing the data information set to be modified with the modified data information set.
As a further scheme of the invention: the information matching module comprises:
the information matching unit is used for inputting the updated file into a database for matching, and the database stores the file to be updated;
the information extraction unit is used for respectively extracting a plurality of different modified data information and a plurality of different data information to be modified in the update file and the file to be updated when different data information exists in the update file and the file to be updated;
the information output unit is used for sorting a plurality of different modified data information and a plurality of different data information to be modified and outputting a modified data information set and a data information set to be modified.
As a further scheme of the invention: the information extraction unit includes:
a first character capturing subunit for capturing the first and last different characters of the update file, respectively;
the first marking subunit is used for acquiring the character length from the first character to the last character in the updated file, and marking the updated file and the character position on the character length;
the second character capturing subunit is used for capturing the first and last different characters in the file to be updated respectively;
the second marking subunit is used for obtaining the character length and the character position from the first character to the last character in the file to be updated, marking the file to be updated on the character length, and enabling the character position of one character length in the updated file to correspond to the character position of the other character length in the file to be updated one by one.
As a further scheme of the invention: the information arrangement unit includes:
an information set establishing subunit, configured to establish a modified data information set and a data information set to be modified;
a searching subunit, configured to search a plurality of different character lengths according to the marks on the character lengths;
a storage subunit, configured to store the character length marked with the update file and the character length marked with the file to be updated in the modified data information set and the data information set to be modified, respectively, using the "cut" operation instruction;
and the output subunit is used for outputting the modified data information set and the data information set to be modified.
Compared with the prior art, the method has the advantages that the information updating instruction sent by the user side is received, the updating file is input into the database for matching, the data information set to be modified and the data information set to be modified are output, the information updating instruction is executed, the data information set to be modified is replaced by the method for modifying the data information set, the functions of automatically identifying the data needing to be updated and automatically replacing the updating data in the process of synchronous updating of remote data are achieved, and compared with the traditional mode of updating all the data, the size of the updating data is reduced, and the data updating efficiency is improved.
Drawings
FIG. 1 is a flow chart of a method of remote data synchronization for a database.
FIG. 2 is a flow chart of a method for synchronizing remote data of a database, wherein an update file is input into the database for matching, and a modified data information set and a data information set to be modified are output.
Fig. 3 is a flowchart of extracting a plurality of different data information to be modified and a plurality of different data information to be modified in an update file and a file to be updated respectively when different data information exists in the update file and the file to be updated in a remote data synchronization method of a database.
Fig. 4 is a flowchart of a method for synchronizing remote data of a database, in which a plurality of different data information to be modified and a plurality of different data information to be modified are consolidated, and a data information set to be modified are output.
FIG. 5 is a flowchart of a method for remote data synchronization of a database in which an information update instruction is executed to replace a data information set to be modified with a modified data information set.
Fig. 6 is a schematic structural diagram of a remote data synchronization system of a database.
Fig. 7 is a schematic diagram of a structure of information matching in a remote data synchronization system of a database.
Fig. 8 is a schematic diagram of the structure of an information extraction unit in a remote data synchronization system of a database.
Fig. 9 is a schematic diagram of the structure of an information sorting unit in a remote data synchronization system of a database.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more clear, the present invention will be described in further detail with reference to the accompanying drawings and specific embodiments. It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the scope of the invention.
Specific implementations of the invention are described in detail below in connection with specific embodiments.
As shown in fig. 1, an embodiment of the present invention provides a remote data synchronization method for a database, including the following steps:
s100, receiving an information updating instruction sent by a user side, wherein the information updating instruction comprises an updating file;
s200, inputting the updated file into a database for matching, and outputting a modified data information set and a data information set to be modified;
s300, executing an information updating instruction, and replacing the data information set to be modified with the modified data information set.
In the embodiment of the invention, the information updating instruction sent by the user side is received, the updating file is input into the database for matching, the modified data information set and the data information set to be modified are output, the information updating instruction is executed, and the data information set to be modified is replaced by the method for modifying the data information set, so that the functions of automatically identifying the data needing to be updated and automatically replacing the updated data in the process of synchronous updating of remote data are realized, the size of the updated data is reduced, and the data updating efficiency is improved compared with the traditional total data updating mode.
As a preferred embodiment of the present invention, the receiving the information update instruction sent by the ue, where the information update instruction includes a step of data to be synchronized, specifically includes:
s110, storing the updated file into an information updating instruction;
s120, receiving an information updating instruction sent by the user side.
In the embodiment of the invention, storing the update file in the information update instruction means that the user side can receive the update file and simultaneously receive the update file and the information update instruction sent by the user side while receiving the information update instruction.
As shown in fig. 2, as a preferred embodiment of the present invention, the step of inputting the update file into the database for matching, and outputting the modified data information set and the data information set to be modified specifically includes:
s210, inputting the updated file into a database for matching, wherein the database stores the file to be updated;
s220, when different data information exists in the update file and the file to be updated, respectively extracting a plurality of different modified data information and a plurality of different data information to be modified in the update file and the file to be updated;
s230, arranging a plurality of different modified data information and a plurality of different data information to be modified, and outputting a modified data information set and a data information set to be modified.
In the embodiment of the invention, an update file is firstly input into a database for matching, then when different data information exists in the update file and the file to be updated, a plurality of different modification data information and a plurality of different data information to be modified in the update file and the file to be updated are respectively extracted, and finally, the plurality of different modification data information and the plurality of different data information to be modified are sorted, and a modification data information set and a data information set to be modified are output.
As shown in fig. 3, as a preferred embodiment of the present invention, when different data information exists in the update file and the file to be updated, the steps of respectively extracting a plurality of different modified data information and a plurality of different data information to be modified in the update file and the file to be updated specifically include:
s2201, capturing the first and last different characters of the updated file respectively;
s2202, acquiring the character length from the first character to the last character in the update file, and marking the update file and the character position on the character length;
s2203, capturing the first and last different characters in the file to be updated respectively;
s2204, acquiring the character length and the character position from the first character to the last character in the file to be updated, and marking the file to be updated on the character length, wherein the character position of one character length in the updated file corresponds to the character position of the other character length in the file to be updated one by one.
In the embodiment of the invention, the text in the document is used for illustration, when a section of text in the document needs to be updated, all the text in the two documents are firstly matched, when one word of a certain line of text of the two documents is different from the other word, the character length of the document (all the characters from one word of the certain line of text to the other word of the certain line of text, including the first character and the last character of course) is obtained, and the character position is the line number where the character length is located.
As shown in fig. 4, as a preferred embodiment of the present invention, the step of sorting a plurality of different modified data information and a plurality of different data information to be modified, and outputting a modified data information set and a data information set to be modified specifically includes:
s2301, establishing a modified data information set and a data information set to be modified;
s2302, searching a plurality of different character lengths according to the marks on the character lengths;
s2303, storing the character length marked with the updated file and the character length marked with the file to be updated in the modified data information set and the data information set to be modified respectively by using the cutting operation instruction;
s2304, a modified data information set and a data information set to be modified are output.
In the embodiment of the invention, it is noted that the character lengths stored in the modified data information set and the data information set to be modified are marked with character positions.
As shown in fig. 5, as a preferred embodiment of the present invention, the step of executing the information update instruction to replace the data information set to be modified with the modified data information set specifically includes:
s310, executing an information updating instruction;
s320, searching the character position of any one character length in the file to be updated according to the character position of any one character length in the modified data information set based on the one-to-one correspondence between the character position of one character length in the updated file and the character position of the other character length in the file to be updated;
s330, when the character positions of the character lengths in the two files are consistent, the character lengths in the modified data information set are copied to the corresponding character positions in the file to be updated by using the copy instruction.
In the embodiment of the invention, when the character position to be modified in the file to be updated is obtained according to the character position, the character length in the modified data information set corresponding to the character position can be automatically copied to the corresponding character position in the file to be updated by utilizing the copy instruction, and the updating and the replacement of all data can be completed according to the method.
As shown in fig. 6 to 9, a remote data synchronization system of a database, the system comprising:
the instruction receiving module 100 is configured to receive an information update instruction sent by a user, where the information update instruction includes an update file;
the information matching module 200 is used for inputting the updated file into the database for matching, and outputting a modified data information set and a data information set to be modified;
the instruction execution module 300 is configured to execute the information update instruction to replace the data information set to be modified with the modified data information set.
In the embodiment of the present invention, after the instruction receiving module 10 receives the information update instruction sent by the user side, the information matching module 200 inputs the update file into the database to perform matching, outputs the modified data information set and the data information set to be modified, and the instruction executing module 300 executes the information update instruction to replace the data information set to be modified with the modified data information set, so that the update and replacement of all data are finally completed, and the present invention has the characteristic of high update efficiency.
As shown in fig. 7, as a preferred embodiment of the present invention, the information matching 200 module includes:
an information matching unit 201, configured to input an update file into a database for matching, where the database stores files to be updated;
an information extraction unit 202, configured to extract a plurality of different modified data information and a plurality of different data information to be modified in the update file and the file to be updated, respectively, when different data information exists in the update file and the file to be updated;
the information output unit 203 is configured to sort a plurality of different modified data information and a plurality of different data information to be modified, and output a modified data information set and a data information set to be modified.
In the embodiment of the present invention, after the information matching unit 201 matches the update file input database, the information extracting unit 202 extracts a plurality of different modification data information and a plurality of different data information to be modified in the update file and the file to be updated, the information output unit 203 sorts the plurality of different modification data information and the plurality of different data information to be modified, and outputs a modification data information set and a data information set to be modified, which has the function of automatically acquiring the modification data information and the data information to be modified in the update file and the file to be updated, and avoids updating the same data in the two files when updating data.
As shown in fig. 8, as a preferred embodiment of the present invention, the information extraction unit 202 includes:
a first character capturing subunit 2021 for capturing the first and last different characters of the update file, respectively;
a first marking subunit 2022, configured to obtain a character length from a first character to a last character in the update file, and mark the update file and the character position on the character length;
a second character capturing subunit 2023, configured to capture the first and last different characters in the file to be updated respectively;
the second marking subunit 2024 is configured to obtain a character length and a character position from a first character to a last character in the file to be updated, and mark the file to be updated on the character length, where the character position of one character length in the updated file corresponds to the character position of another character length in the file to be updated one by one.
In the embodiment of the present invention, after the first character capturing subunit 2021 captures the first and last different characters in the update file respectively, the first marking subunit 2022 obtains the character length from the first character to the last character in the update file, and marks the character length with the update file and the character position, and after the second character capturing subunit 2023 captures the first and last different characters in the file to be updated, the second marking subunit 2024 obtains the character length from the first character to the last character in the file to be updated, and marks the character length with the file to be updated, so that not only the character length and the character position in the update file, but also the character length in the file to be updated corresponding to the character position of the character length in the update file can be obtained, thereby facilitating accurate obtaining of the position of the data to be updated in subsequent data updating.
As shown in fig. 9, as a preferred embodiment of the present invention, the information sort unit 203 includes:
an information set creation subunit 2031 configured to create a modified data information set and a data information set to be modified;
a retrieving subunit 2032, configured to retrieve a plurality of different character lengths according to the marks on the character lengths;
a storage subunit 2033 configured to store the character length marked with the update file and the character length marked with the file to be updated in the modified data information set and the data information set to be modified, respectively, using the "cut" operation instruction;
an output subunit 2034 for outputting the modified data information set and the data information set to be modified.
In the embodiment of the present invention, after the information set creating subunit 2031 creates the modified data information set and the data information set to be modified, the retrieving subunit 2032 retrieves a plurality of different character lengths according to the marks on the character lengths, and the storing subunit 2033 stores the character lengths marked with the update file and the character lengths marked with the file to be updated in the modified data information set and the data information set to be modified respectively by using the "cut" operation instruction, and then the output subunit 2034 outputs the modified data information set and the data information set to be modified, thereby realizing the function of replacing the update data accurately according to the position of the data to be updated in the file to be updated.
It should be understood that, although the steps in the flowcharts of the embodiments of the present invention are shown in order as indicated by the arrows, these steps are not necessarily performed in order as indicated by the arrows. The steps are not strictly limited to the order of execution unless explicitly recited herein, and the steps may be executed in other orders. Moreover, at least some of the steps in various embodiments may include multiple sub-steps or stages that are not necessarily performed at the same time, but may be performed at different times, nor do the order in which the sub-steps or stages are performed necessarily performed in sequence, but may be performed alternately or alternately with at least a portion of the sub-steps or stages of other steps or other steps.
Those skilled in the art will appreciate that all or part of the processes in the methods of the above embodiments may be implemented by a computer program for instructing relevant hardware, where the program may be stored in a non-volatile computer readable storage medium, and where the program, when executed, may include processes in the embodiments of the methods described above. Any reference to memory, storage, database, or other medium used in the various embodiments provided herein may include non-volatile and/or volatile memory. The nonvolatile memory can include Read Only Memory (ROM), programmable ROM (PROM), electrically Programmable ROM (EPROM), electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double Data Rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous Link DRAM (SLDRAM), memory bus direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM), among others.
Other embodiments of the present disclosure will be apparent to those skilled in the art from consideration of the specification and practice of the disclosure. This application is intended to cover any adaptations, uses, or adaptations of the disclosure following, in general, the principles of the disclosure and including such departures from the present disclosure as come within known or customary practice within the art to which the disclosure pertains. It is intended that the specification and examples be considered as exemplary only, with a true scope and spirit of the disclosure being indicated by the following claims.
Claims (10)
1. A method for remote data synchronization of a database, the method comprising the steps of:
receiving an information updating instruction sent by a user side, wherein the information updating instruction comprises an updating file;
inputting the updated file into a database for matching, and outputting a modified data information set and a data information set to be modified;
and executing an information updating instruction, and replacing the data information set to be modified with the modified data information set.
2. The method for synchronizing remote data of a database according to claim 1, wherein the step of receiving an information update command sent by a user side, the information update command including data to be synchronized specifically includes:
storing the update file into an information update instruction;
and receiving an information updating instruction sent by the user terminal.
3. The method for remote data synchronization of a database according to claim 2, wherein the step of inputting the update file into the database for matching, and outputting the modified data information set and the data information set to be modified, specifically comprises the steps of:
inputting the updated file into a database for matching, wherein the database stores the file to be updated;
when different data information exists in the update file and the file to be updated, respectively extracting a plurality of different modified data information and a plurality of different data information to be modified in the update file and the file to be updated;
and sorting a plurality of different modified data information and a plurality of different data information to be modified, and outputting a modified data information set and a data information set to be modified.
4. A method for remote data synchronization of a database according to claim 3, wherein when different data information exists in the update file and the file to be updated, the steps of respectively extracting a plurality of different modified data information and a plurality of different data information to be modified in the update file and the file to be updated specifically include:
capturing the first and last different characters of the updated file respectively;
acquiring the character length from the first character to the last character in the update file, and marking the update file and the character position on the character length;
capturing the first and last different characters in the file to be updated respectively;
acquiring the character length and the character position from the first character to the last character in the file to be updated, marking the file to be updated on the character length, and enabling the character position of one character length in the updated file to correspond to the character position of the other character length in the file to be updated one by one.
5. The method for remote data synchronization of a database according to claim 4, wherein the step of sorting a plurality of different modified data information and a plurality of different data information to be modified, and outputting a modified data information set and a data information set to be modified specifically comprises:
establishing a modified data information set and a data information set to be modified;
searching a plurality of different character lengths according to the marks on the character lengths;
the character length marked with the updated file and the character length marked with the file to be updated are respectively stored in a modified data information set and a data information set to be modified by utilizing a cutting operation instruction;
and outputting the modified data information set and the data information set to be modified.
6. The method for remote data synchronization of a database according to claim 5, wherein the step of executing the information update instruction to replace the data information set to be modified with the modified data information set comprises:
executing an information updating instruction;
based on the one-to-one correspondence between the character position of one character length in the updated file and the character position of the other character length in the file to be updated, retrieving the character position of any one character length in the file to be updated according to the character position of any one character length in the modified data information set;
when the character positions of the character lengths in the two files are consistent, the character lengths in the modified data information set are copied to the corresponding character positions in the file to be updated by using a copy instruction.
7. A remote data synchronization system for a database, the system comprising:
the instruction receiving module is used for receiving an information updating instruction sent by the user side, wherein the information updating instruction comprises an updating file;
the information matching module is used for inputting the updated file into the database for matching and outputting a modified data information set and a data information set to be modified;
and the instruction execution module is used for executing the information updating instruction and replacing the data information set to be modified with the modified data information set.
8. The remote data synchronization system of claim 7, wherein the information matching module comprises:
the information matching unit is used for inputting the updated file into a database for matching, and the database stores the file to be updated;
the information extraction unit is used for respectively extracting a plurality of different modified data information and a plurality of different data information to be modified in the update file and the file to be updated when different data information exists in the update file and the file to be updated;
the information output unit is used for sorting a plurality of different modified data information and a plurality of different data information to be modified and outputting a modified data information set and a data information set to be modified.
9. The remote data synchronization system of a database according to claim 8, wherein the information extraction unit comprises:
a first character capturing subunit for capturing the first and last different characters of the update file, respectively;
the first marking subunit is used for acquiring the character length from the first character to the last character in the updated file, and marking the updated file and the character position on the character length;
the second character capturing subunit is used for capturing the first and last different characters in the file to be updated respectively;
the second marking subunit is used for obtaining the character length and the character position from the first character to the last character in the file to be updated, marking the file to be updated on the character length, and enabling the character position of one character length in the updated file to correspond to the character position of the other character length in the file to be updated one by one.
10. A remote data synchronization system for a database according to claim 9, wherein said information collating unit comprises:
an information set establishing subunit, configured to establish a modified data information set and a data information set to be modified;
a searching subunit, configured to search a plurality of different character lengths according to the marks on the character lengths;
a storage subunit, configured to store the character length marked with the update file and the character length marked with the file to be updated in the modified data information set and the data information set to be modified, respectively, using the "cut" operation instruction;
and the output subunit is used for outputting the modified data information set and the data information set to be modified.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202410069701.4A CN117591531B (en) | 2024-01-18 | 2024-01-18 | Remote data synchronization method and system for database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202410069701.4A CN117591531B (en) | 2024-01-18 | 2024-01-18 | Remote data synchronization method and system for database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN117591531A true CN117591531A (en) | 2024-02-23 |
| CN117591531B CN117591531B (en) | 2024-03-22 |
Family
ID=89918617
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202410069701.4A Active CN117591531B (en) | 2024-01-18 | 2024-01-18 | Remote data synchronization method and system for database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117591531B (en) |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105608064A (en) * | 2015-11-24 | 2016-05-25 | 小米科技有限责任公司 | Character replacement method and apparatus |
| US20180341640A1 (en) * | 2017-05-25 | 2018-11-29 | Baidu Online Network Technology (Beijing) Co., Ltd. | Amendment Source-Positioning Method and Apparatus, Computer Device and Readable Medium |
| CN110688348A (en) * | 2019-10-09 | 2020-01-14 | 李智鹏 | File management system |
| CN110782885A (en) * | 2019-09-29 | 2020-02-11 | 深圳和而泰家居在线网络科技有限公司 | Voice text correction method and device, computer equipment and computer storage medium |
| US10963717B1 (en) * | 2018-12-21 | 2021-03-30 | Automation Anywhere, Inc. | Auto-correction of pattern defined strings |
| CN113050926A (en) * | 2021-03-24 | 2021-06-29 | 中国工商银行股份有限公司 | Method, device and equipment for confirming synchronous change of codes |
| US11468074B1 (en) * | 2019-12-31 | 2022-10-11 | Rapid7, Inc. | Approximate search of character strings |
| CN116932499A (en) * | 2023-08-15 | 2023-10-24 | 天河智造(北京)科技股份有限公司 | Method for modifying labels of DWG format files in batches |
-
2024
- 2024-01-18 CN CN202410069701.4A patent/CN117591531B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105608064A (en) * | 2015-11-24 | 2016-05-25 | 小米科技有限责任公司 | Character replacement method and apparatus |
| US20180341640A1 (en) * | 2017-05-25 | 2018-11-29 | Baidu Online Network Technology (Beijing) Co., Ltd. | Amendment Source-Positioning Method and Apparatus, Computer Device and Readable Medium |
| US10963717B1 (en) * | 2018-12-21 | 2021-03-30 | Automation Anywhere, Inc. | Auto-correction of pattern defined strings |
| CN110782885A (en) * | 2019-09-29 | 2020-02-11 | 深圳和而泰家居在线网络科技有限公司 | Voice text correction method and device, computer equipment and computer storage medium |
| CN110688348A (en) * | 2019-10-09 | 2020-01-14 | 李智鹏 | File management system |
| US11468074B1 (en) * | 2019-12-31 | 2022-10-11 | Rapid7, Inc. | Approximate search of character strings |
| CN113050926A (en) * | 2021-03-24 | 2021-06-29 | 中国工商银行股份有限公司 | Method, device and equipment for confirming synchronous change of codes |
| CN116932499A (en) * | 2023-08-15 | 2023-10-24 | 天河智造(北京)科技股份有限公司 | Method for modifying labels of DWG format files in batches |
Also Published As
| Publication number | Publication date |
|---|---|
| CN117591531B (en) | 2024-03-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109325041B (en) | Service data processing method, device, computer equipment and storage medium | |
| CN110321470B (en) | Document processing method, device, computer equipment and storage medium | |
| CN109446173A (en) | Daily record data processing method, device, computer equipment and storage medium | |
| CN106844307B (en) | System and method for converting Excel into Word based on mark | |
| WO2020155749A1 (en) | Method and apparatus for constructing personal knowledge graph, computer device, and storage medium | |
| CN107992492B (en) | Data block storage method, data block reading method, data block storage device, data block reading device and block chain | |
| CN108595437B (en) | Text query error correction method and device, computer equipment and storage medium | |
| CN112286934A (en) | Database table importing method, device, equipment and medium | |
| CN111191079A (en) | Document content acquisition method, device, equipment and storage medium | |
| CN116701182A (en) | Coverage rate mark file updating method, coverage rate mark file updating device, coverage rate mark file updating equipment and storage medium | |
| CN114817230A (en) | Data stream filtering method and system | |
| CN117591531B (en) | Remote data synchronization method and system for database | |
| CN105488471A (en) | Character pattern recognition method and device | |
| CN108897727A (en) | Filing of contract method, apparatus, computer equipment and storage medium | |
| CN115455266B (en) | Automatic electronic file acquisition and filing method and system | |
| CN117473984A (en) | Method and system for dividing txt document content chapters | |
| CN115017871B (en) | Replacement display method and display system for file archive contents | |
| CN111831687A (en) | Data query optimization method and device, computer equipment and storage medium | |
| CN115495280A (en) | SQLite fuzzy matching-based general deleted data positioning method and device | |
| CN115686493A (en) | Method for automatically generating interface control document by C language data structure code | |
| CN113535962B (en) | Data warehouse-in method, device, electronic device, program product and storage medium | |
| CN112988137B (en) | System and method for managing class file import code | |
| CN111782657A (en) | Data processing method and device | |
| CN114816367B (en) | OD statement and Casetable editing method, system, storage medium and device | |
| CN114817685B (en) | Method and system for quickly locking target information |
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 |