CN115858688A - Remote data synchronization method and system for database - Google Patents

Remote data synchronization method and system for database Download PDF

Info

Publication number
CN115858688A
CN115858688A CN202310193158.4A CN202310193158A CN115858688A CN 115858688 A CN115858688 A CN 115858688A CN 202310193158 A CN202310193158 A CN 202310193158A CN 115858688 A CN115858688 A CN 115858688A
Authority
CN
China
Prior art keywords
updating
data
information
quick
update
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
Application number
CN202310193158.4A
Other languages
Chinese (zh)
Other versions
CN115858688B (en
Inventor
请求不公布姓名
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Beijing Amax Heat Exchange Equipment Manufacturing Co ltd
Original Assignee
Beijing Amax Heat Exchange Equipment Manufacturing Co ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Beijing Amax Heat Exchange Equipment Manufacturing Co ltd filed Critical Beijing Amax Heat Exchange Equipment Manufacturing Co ltd
Priority to CN202310193158.4A priority Critical patent/CN115858688B/en
Publication of CN115858688A publication Critical patent/CN115858688A/en
Application granted granted Critical
Publication of CN115858688B publication Critical patent/CN115858688B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Abstract

The invention is suitable for the technical field of databases, and provides a remote data synchronization method and a remote data synchronization system for a database, wherein the method comprises the following steps: receiving an information updating instruction sent by a user terminal, and updating data by a database of an area where the user terminal is located according to the information updating instruction; generating data synchronization updating information and a quick updating stamp, wherein the quick updating stamp comprises an updating time stamp and an updating data address stamp; sending the quick update stamp to an opposite-end database through a quick transmission channel, sending data synchronization update information to the opposite-end database through a common transmission channel, and deleting the quick update stamp after the opposite-end database is updated; and receiving an information access command, judging whether the access data address in the information access command has a corresponding quick update stamp, and if so, quickly and synchronously updating the data in the access data address. Therefore, the opposite-end database in the invention can know whether the data to be accessed is the latest data, and ensures that the data accessed by the user is the latest.

Description

Remote data synchronization method and system for database
Technical Field
The invention relates to the technical field of databases, in particular to a remote data synchronization method and a remote data synchronization system for a database.
Background
In the application of databases, data deployed among databases in different positions needs to be synchronized, when the databases with data synchronization requirements are far apart, for example, one database is abroad, the other database is domestic, and the amount of data to be updated is large, synchronization updating has a high delay, for example, after data in the domestic databases is updated, corresponding data in the foreign databases can be updated after a certain time, and when a user accesses the foreign databases, the foreign databases do not know whether the data is the latest data, and the accessed data is probably not the latest data. Therefore, it is desirable to provide a method and system for remote data synchronization of a database, which aim to solve or alleviate the above problems.
Disclosure of Invention
In view of the shortcomings in the prior art, an object of the present invention is to provide a method and a system for remote data synchronization of a database, so as to solve or alleviate the problems in the background art.
The invention is realized in such a way that a remote data synchronization method of a database comprises the following steps:
receiving an information updating instruction sent by a user terminal, wherein a database of an area where the user terminal is located performs data updating according to the information updating instruction, and the database of the area where the user terminal is located is an original database;
generating data synchronization updating information and quick updating stamps, wherein the data synchronization updating information and the quick updating stamps correspond to each other one by one, and the quick updating stamps comprise updating time stamps and updating data address stamps;
sending the quick update stamp to an opposite-end database through a quick transmission channel, sending data synchronization update information to the opposite-end database through a common transmission channel, updating data by the opposite-end database according to the data synchronization update information, and deleting the corresponding quick update stamp after updating;
receiving an information access command, wherein the information access command comprises an access data address, judging whether the access data address has a corresponding quick update stamp, and if so, determining that the data in the access data address is not the latest data, and quickly and synchronously updating the data in the access data address.
As a further scheme of the invention: the step of generating the data synchronization update information and the fast update stamp specifically includes:
determining data before updating, data after updating, updating time and an updating data address according to the updating condition of a database in the area where the user terminal is located;
generating data synchronization updating information according to the data before updating and the data after updating;
and generating a quick update stamp according to the update time and the update data address.
As a further scheme of the invention: the step of performing fast synchronous update on the data in the access data address specifically includes:
determining corresponding data synchronous updating information according to the existing quick updating stamp;
sending the data synchronization updating information to an opposite-end database through a quick transmission channel;
and synchronously updating the data in the access data address in the opposite-end database according to the data synchronous updating information, and deleting the corresponding quick updating stamp after updating.
As a further scheme of the invention: the step of determining the corresponding data synchronization update information according to the existing fast update stamp specifically includes:
sending the quick updating stamp existing in the opposite-end database to the original database through a quick transmission channel;
and receiving the quick updating stamp, and determining corresponding data synchronous updating information according to the received quick updating stamp.
As a further scheme of the invention: before the step of performing the fast synchronous update on the data in the access data address, it is further required to determine whether the fast update stamp and the corresponding data synchronous update information exist in the opposite-end database at the same time, and when the fast update stamp and the corresponding data synchronous update information exist at the same time, the synchronous update is only required to be waited for to be completed.
It is another object of the present invention to provide a remote data synchronization system for a database, the system comprising:
the system comprises an information initial updating module, a database updating module and a data updating module, wherein the information initial updating module is used for receiving an information updating instruction sent by a user terminal, the database of an area where the user terminal is located carries out data updating according to the information updating instruction, and the database of the area where the user terminal is located is an original database;
the synchronous updating information module is used for generating data synchronous updating information and quick updating stamps, the data synchronous updating information and the quick updating stamps correspond to each other one by one, and the quick updating stamps comprise updating time stamps and updating data address stamps;
the updating information transmission module is used for sending the quick updating stamp to the opposite-end database through a quick transmission channel, sending the data synchronization updating information to the opposite-end database through a common transmission channel, updating data by the opposite-end database according to the data synchronization updating information, and deleting the corresponding quick updating stamp after updating;
and the quick synchronous updating module is used for receiving an information access command, judging whether the access data address has a corresponding quick updating stamp or not, and if so, determining that the data in the access data address is not the latest data and quickly and synchronously updating the data in the access data address.
As a further scheme of the invention: the synchronization update information module includes:
the updating related information unit is used for determining data before updating, data after updating, updating time and an updating data address according to the updating condition of the database of the area where the user terminal is located;
the synchronous updating information unit is used for generating data synchronous updating information according to the data before updating and the data after updating;
and the quick update stamp unit is used for generating a quick update stamp according to the update time and the update data address.
As a further scheme of the invention: the fast synchronization update module comprises:
a synchronous updating information determining unit, which is used for determining the corresponding data synchronous updating information according to the existing quick updating stamp;
the synchronous updating information transmission unit is used for transmitting the data synchronous updating information to an opposite-end database through a quick transmission channel;
and the quick synchronous updating unit is used for synchronously updating the data in the access data address in the opposite terminal database according to the data synchronous updating information, and deleting the corresponding quick updating stamp after updating.
As a further scheme of the invention: the synchronization update information determination unit includes:
the quick update stamp feedback subunit is used for sending the quick update stamp existing in the opposite-end database to the original database through a quick transmission channel;
and the updating information determining subunit is used for receiving the quick updating stamp and determining corresponding data synchronization updating information according to the received quick updating stamp.
Compared with the prior art, the invention has the beneficial effects that:
the data synchronization updating information and the quick updating stamp are generated, the quick updating stamp is sent to the opposite-end database through the quick transmission channel, the data synchronization updating information is sent to the opposite-end database through the common transmission channel, the opposite-end database performs data updating according to the data synchronization updating information, and after the data updating, the corresponding quick updating stamp is deleted. Therefore, when the opposite-end database receives the information access command, whether the corresponding quick update stamp exists in the access data address in the information access command or not can be judged, and when the access data address is the same as any one of the update data address stamps, the corresponding quick update stamp exists, so that the opposite-end database can know that the data needing to be accessed is not the latest data, and after the data in the access data address is quickly and synchronously updated, the latest data is provided for a user, and the latest data accessed by the user is ensured to be the latest.
Drawings
Fig. 1 is a flowchart of a remote data synchronization method of a database.
Fig. 2 is a flowchart of generating data synchronization update information and a fast update stamp in a remote data synchronization method of a database.
Fig. 3 is a flowchart of a method for remote data synchronization of a database, in which data in an access data address is updated quickly and synchronously.
Fig. 4 is a flowchart of determining corresponding data synchronization update information according to an existing fast update stamp in a remote data synchronization method for a database.
Fig. 5 is a schematic structural diagram of a remote data synchronization system of a database.
FIG. 6 is a diagram illustrating a structure of a synchronous update information module in a remote data synchronization system of a database.
FIG. 7 is a block diagram of a fast synchronization update module in a remote data synchronization system for a database.
Fig. 8 is a schematic diagram of a synchronization update information determination 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 is further described in detail below with reference to the accompanying drawings and specific embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
Specific implementations of the present invention are described in detail below with reference to specific embodiments.
As shown in fig. 1, an embodiment of the present invention provides a remote data synchronization method for a database, where the method includes the following steps:
s100, receiving an information updating instruction sent by a user terminal, wherein a database of an area where the user terminal is located performs data updating according to the information updating instruction, and the database of the area where the user terminal is located is an original database;
s200, generating data synchronization updating information and quick updating stamps, wherein the data synchronization updating information and the quick updating stamps correspond to each other one by one, and the quick updating stamps comprise updating time stamps and updating data address stamps;
s300, sending the quick update stamp to an opposite-end database through a quick transmission channel, sending data synchronization update information to the opposite-end database through a common transmission channel, carrying out data update on the opposite-end database according to the data synchronization update information, and deleting the corresponding quick update stamp after the data update;
s400, receiving an information access command, wherein the information access command comprises an access data address, judging whether the access data address has a corresponding quick update stamp, and if so, determining that the data in the access data address is not the latest data, and quickly and synchronously updating the data in the access data address.
It should be noted that, in the application of the databases, data deployed between databases in different locations needs to be synchronized, when the databases having data synchronization requirements are far apart, for example, one database is abroad, the other database is domestic, and the amount of data to be updated is large, synchronization update may have a high delay, for example, after data in a domestic database is updated, corresponding data in a foreign database may be updated after a certain time, and when a user accesses the foreign database, the foreign database does not know whether the data is the latest data, and the accessed data is likely not the latest data.
In the embodiment of the invention, two transmission channels exist between the databases, one is a quick transmission channel, and the other is a common transmission channel. When a user needs to update data in a database, the user can input an information updating instruction through a user terminal, the database of an area where the user terminal is located updates the data according to the information updating instruction, the database of the area where the user terminal is located is an original database, if the user uses the user terminal at home, the home database is the original database, and the foreign database is an opposite-end database; if the user uses the user terminal abroad, the foreign database is the original database, the domestic database is the opposite-end database, and the original database and the opposite-end database are relatively speaking. Then, the original database generates data synchronization update information and a quick update stamp, the data synchronization update information and the quick update stamp are in one-to-one correspondence, the quick update stamp comprises an update time stamp and an update data address stamp, the quick update stamp only comprises time and address information, the data volume is very small, the data synchronization update information comprises data before update and data after update, the data volume is large, therefore, the quick update stamp can be sent to the opposite-end database through a quick transmission channel, basically, no time delay exists, the data synchronization update information is sent to the opposite-end database through a common transmission channel, the quick update stamp can reach the opposite-end database faster than the data synchronization update information, when the data synchronization update information reaches the opposite-end database, the opposite-end database can update data according to the data synchronization update information, and after the update, the corresponding quick update stamp needs to be deleted. In addition, when the opposite-end database receives the information access command, whether the corresponding quick update stamp exists in the access data address in the information access command or not is judged, and when the access data address is the same as any update data address stamp, the corresponding quick update stamp exists, so that the opposite-end database can know that the data needing to be accessed is not the latest data, and the latest data is provided for a user after the data in the access data address is quickly and synchronously updated; on the contrary, when the corresponding quick update stamp does not exist, the data to be accessed is determined to be the latest data and is directly provided for the user.
As shown in fig. 2, as a preferred embodiment of the present invention, the step of generating the data synchronization update information and the fast update stamp specifically includes:
s201, determining data before updating, data after updating, updating time and an updating data address according to the updating condition of a database in the area where the user terminal is located;
s202, generating data synchronization updating information according to the data before updating and the data after updating;
and S203, generating a quick update stamp according to the update time and the update data address.
In the embodiment of the invention, after the original database is updated, the data before updating, the data after updating, the updating time and the updating data address can be determined according to the specific updating condition, so that the data synchronization updating information can be generated according to the data before updating and the data after updating, and the quick updating stamp can be generated according to the updating time and the updating data address.
As shown in fig. 3, as a preferred embodiment of the present invention, the step of performing fast synchronous update on the data in the access data address specifically includes:
s401, determining corresponding data synchronous updating information according to the existing quick updating stamp;
s402, sending the data synchronization updating information to an opposite-end database through a quick transmission channel;
and S403, synchronously updating the data in the access data address in the opposite-end database according to the data synchronous updating information, and deleting the corresponding quick updating stamp after updating.
In the embodiment of the invention, in order to realize the rapid synchronous update of the data in the access data address, the corresponding data synchronous update information needs to be determined according to the rapid update stamp, and the data synchronous update information is sent to the opposite-end database through the rapid transmission channel.
As shown in fig. 4, as a preferred embodiment of the present invention, the step of determining corresponding data synchronization update information according to an existing fast update stamp specifically includes:
s4011, sending the fast update stamp existing in the opposite-end database to the original database through a fast transmission channel;
and S4012, receiving the quick update stamp, and determining corresponding data synchronization update information according to the received quick update stamp.
In the embodiment of the invention, in order to determine the corresponding data synchronization update information, the determined quick update stamp in the opposite-end database needs to be returned to the original database through the quick transmission channel, and the original database can determine the corresponding data synchronization update information according to the quick update stamp after receiving the returned quick update stamp, and then sends the data synchronization update information to the opposite-end database through the quick transmission channel.
As a preferred embodiment of the present invention, before the step of performing the fast synchronous update on the data in the access data address, it is further required to determine whether the fast update stamp and the corresponding data synchronous update information exist in the opposite-end database at the same time, and when the fast update stamp and the corresponding data synchronous update information exist at the same time, it is indicated that the data synchronous update information has reached the opposite-end database, and only the synchronous update is not completed, and at this time, it is only required to wait for the completion of the synchronous update.
As shown in fig. 5, an embodiment of the present invention further provides a remote data synchronization system for a database, where the system includes:
the information initial updating module 100 is configured to receive an information updating instruction sent by a user terminal, where a database of an area where the user terminal is located performs data updating according to the information updating instruction, and the database of the area where the user terminal is located is an original database;
a synchronous update information module 200, configured to generate data synchronous update information and fast update stamps, where the data synchronous update information and the fast update stamps correspond to each other one to one, and the fast update stamps include update time stamps and update data address stamps;
the update information transmission module 300 is configured to send the fast update stamp to the opposite-end database through a fast transmission channel, send the data synchronization update information to the opposite-end database through a common transmission channel, perform data update on the opposite-end database according to the data synchronization update information, and delete the corresponding fast update stamp after update;
the fast synchronization update module 400 is configured to receive an information access command, where the information access command includes an access data address, determine whether the access data address has a corresponding fast update stamp, determine that data in the access data address is not the latest data when the access data address has the corresponding fast update stamp, and perform fast synchronization update on the data in the access data address.
In the embodiment of the invention, two transmission channels exist between the databases, one is a quick transmission channel, and the other is a common transmission channel. When a user needs to update data in a database, the user can input an information updating instruction through a user terminal, the database of an area where the user terminal is located updates the data according to the information updating instruction, the database of the area where the user terminal is located is an original database, if the user uses the user terminal at home, the home database is the original database, and the foreign database is an opposite-end database; if the user uses the user terminal abroad, the foreign database is the original database, the domestic database is the opposite-end database, and the original database and the opposite-end database are relatively speaking. Then, the original database generates data synchronization update information and a quick update stamp, the data synchronization update information and the quick update stamp are in one-to-one correspondence, the quick update stamp comprises an update time stamp and an update data address stamp, the quick update stamp only comprises time and address information, the data volume is very small, the data synchronization update information comprises data before update and data after update, the data volume is large, therefore, the quick update stamp can be sent to the opposite-end database through a quick transmission channel, basically, no time delay exists, the data synchronization update information is sent to the opposite-end database through a common transmission channel, the quick update stamp can reach the opposite-end database faster than the data synchronization update information, when the data synchronization update information reaches the opposite-end database, the opposite-end database can update data according to the data synchronization update information, and after the update, the corresponding quick update stamp needs to be deleted. In addition, when the opposite-end database receives the information access command, whether the corresponding quick update stamp exists in the access data address in the information access command or not is judged, and when the access data address is the same as any update data address stamp, the corresponding quick update stamp exists, so that the opposite-end database can know that the data needing to be accessed is not the latest data, and the latest data is provided for a user after the data in the access data address is quickly and synchronously updated; on the contrary, when the corresponding quick update stamp does not exist, the data to be accessed is determined to be the latest data and is directly provided for the user.
As shown in fig. 6, as a preferred embodiment of the present invention, the synchronization update information module 200 includes:
an update related information unit 201, configured to determine pre-update data, post-update data, update time, and an update data address according to an update condition of a database in an area where the user terminal is located;
a synchronous update information unit 202, configured to generate data synchronous update information according to the pre-update data and the post-update data;
and a fast update stamp unit 203 for generating a fast update stamp according to the update time and the update data address.
As shown in fig. 7, as a preferred embodiment of the present invention, the fast synchronization update module 400 includes:
a synchronous update information determination unit 401, configured to determine corresponding data synchronous update information according to the existing fast update stamp;
a synchronous update information transmission unit 402, configured to send the data synchronous update information to an opposite-end database through a fast transmission channel;
and a fast synchronous updating unit 403, configured to enable data in the access data address in the peer database to be updated synchronously according to the data synchronous updating information, and delete the corresponding fast updating stamp after updating.
As shown in fig. 8, as a preferred embodiment of the present invention, the synchronization update information determination unit 401 includes:
the quick update stamp feedback sub-unit 4011 is configured to send the quick update stamp existing in the opposite-end database to the original database through a quick transmission channel;
and an update information determining subunit 4012, configured to receive the fast update stamp, and determine corresponding data synchronization update information according to the received fast update stamp.
The present invention has been described in detail with reference to the preferred embodiments thereof, and it should be understood that the invention is not limited thereto, but is intended to cover modifications, equivalents, and improvements within the spirit and scope of the present invention.
It should be understood that, although the steps in the flowcharts of the embodiments of the present invention are shown in sequence as indicated by the arrows, the steps are not necessarily performed in sequence as indicated by the arrows. The steps are not performed in the exact order shown and described, and may be performed in other orders, unless explicitly stated otherwise. Moreover, at least a portion of the steps in various embodiments may include multiple sub-steps or multiple stages that are not necessarily performed at the same time, but may be performed at different times, and the order of performance of the sub-steps or stages is not necessarily sequential, but may be performed in turn or alternately with other steps or at least a portion of the sub-steps or stages of other steps.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by a computer program, which can be stored in a non-volatile computer-readable storage medium, and can include the processes of the embodiments of the methods described above when the program is executed. Any reference to memory, storage, database, or other medium used in the embodiments provided herein may include non-volatile and/or volatile memory, among others. Non-volatile 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), rambus (Rambus) direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).
Other embodiments of the disclosure will be apparent to those skilled in the art from consideration of the specification and practice of the disclosure herein. This application is intended to cover any variations, 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 (9)

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 terminal, wherein a database of an area where the user terminal is located performs data updating according to the information updating instruction, and the database of the area where the user terminal is located is an original database;
generating data synchronization updating information and quick updating stamps, wherein the data synchronization updating information and the quick updating stamps correspond to each other one by one, and the quick updating stamps comprise updating time stamps and updating data address stamps;
sending the quick update stamp to an opposite-end database through a quick transmission channel, sending data synchronization update information to the opposite-end database through a common transmission channel, updating data by the opposite-end database according to the data synchronization update information, and deleting the corresponding quick update stamp after updating;
receiving an information access command, wherein the information access command comprises an access data address, judging whether the access data address has a corresponding quick update stamp, and if so, determining that the data in the access data address is not the latest data, and quickly and synchronously updating the data in the access data address.
2. The method for remote data synchronization of a database according to claim 1, wherein the step of generating data synchronization update information and a fast update stamp specifically comprises:
determining data before updating, data after updating, updating time and an updating data address according to the updating condition of a database in the area where the user terminal is located;
generating data synchronous updating information according to the data before updating and the data after updating;
and generating a quick update stamp according to the update time and the update data address.
3. The method for remote data synchronization of a database according to claim 1, wherein the step of performing fast synchronization update on the data in the access data address specifically comprises:
determining corresponding data synchronous updating information according to the existing quick updating stamp;
sending the data synchronization updating information to an opposite-end database through a quick transmission channel;
and synchronously updating the data in the access data address in the opposite-end database according to the data synchronous updating information, and deleting the corresponding quick updating stamp after updating.
4. The method for remote data synchronization of a database according to claim 3, wherein the step of determining the corresponding data synchronization update information according to the existing fast update stamp specifically comprises:
sending the quick updating stamp existing in the opposite-end database to the original database through a quick transmission channel;
and receiving the quick updating stamp, and determining corresponding data synchronous updating information according to the received quick updating stamp.
5. The method for remote data synchronization of a database according to claim 1, wherein before the step of performing fast synchronization update on the data in the access data address, it is further determined whether the fast update stamp and the corresponding data synchronization update information exist in the opposite database at the same time, and when the fast update stamp and the corresponding data synchronization update information exist at the same time, it is only necessary to wait for the completion of the synchronization update.
6. A system for remote data synchronization of a database, the system comprising:
the system comprises an information initial updating module, a database updating module and a data updating module, wherein the information initial updating module is used for receiving an information updating instruction sent by a user terminal, the database of an area where the user terminal is located carries out data updating according to the information updating instruction, and the database of the area where the user terminal is located is an original database;
the synchronous updating information module is used for generating data synchronous updating information and quick updating stamps, the data synchronous updating information and the quick updating stamps correspond to each other one by one, and the quick updating stamps comprise updating time stamps and updating data address stamps;
the updating information transmission module is used for sending the quick updating stamp to the opposite-end database through a quick transmission channel, sending the data synchronization updating information to the opposite-end database through a common transmission channel, updating data by the opposite-end database according to the data synchronization updating information, and deleting the corresponding quick updating stamp after updating;
and the quick synchronous updating module is used for receiving an information access command, judging whether the access data address has a corresponding quick updating stamp or not, and if so, determining that the data in the access data address is not the latest data and quickly and synchronously updating the data in the access data address.
7. The system for remote data synchronization of a database according to claim 6, wherein said synchronization update information module comprises:
the updating related information unit is used for determining data before updating, data after updating, updating time and an updating data address according to the updating condition of the database of the area where the user terminal is located;
the synchronous updating information unit is used for generating data synchronous updating information according to the data before updating and the data after updating;
and the quick update stamp unit is used for generating a quick update stamp according to the update time and the update data address.
8. The system for remote data synchronization of a database according to claim 6, wherein the fast synchronization update module comprises:
a synchronous updating information determining unit, which is used for determining the corresponding data synchronous updating information according to the existing quick updating stamp;
the synchronous updating information transmission unit is used for transmitting the data synchronous updating information to an opposite-end database through a quick transmission channel;
and the quick synchronous updating unit is used for synchronously updating the data in the access data address in the opposite terminal database according to the data synchronous updating information, and deleting the corresponding quick updating stamp after updating.
9. The remote data synchronization system of a database according to claim 8, wherein the synchronization update information determination unit comprises:
the quick update stamp feedback subunit is used for sending the quick update stamp existing in the opposite-end database to the original database through a quick transmission channel;
and the updating information determining subunit is used for receiving the quick updating stamp and determining corresponding data synchronization updating information according to the received quick updating stamp.
CN202310193158.4A 2023-03-03 2023-03-03 Remote data synchronization method and system for database Active CN115858688B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202310193158.4A CN115858688B (en) 2023-03-03 2023-03-03 Remote data synchronization method and system for database

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202310193158.4A CN115858688B (en) 2023-03-03 2023-03-03 Remote data synchronization method and system for database

Publications (2)

Publication Number Publication Date
CN115858688A true CN115858688A (en) 2023-03-28
CN115858688B CN115858688B (en) 2023-04-18

Family

ID=85659797

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202310193158.4A Active CN115858688B (en) 2023-03-03 2023-03-03 Remote data synchronization method and system for database

Country Status (1)

Country Link
CN (1) CN115858688B (en)

Citations (12)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1627296A (en) * 2003-12-12 2005-06-15 国际商业机器公司 Data collection updating device, terminal device, data collection updating method and program
CN1677887A (en) * 2005-02-01 2005-10-05 北京北方烽火科技有限公司 N+1 duplicates data real-time synchronising method
US20070180075A1 (en) * 2002-04-25 2007-08-02 Doug Chasman System and method for synchronization of version annotated objects
CN102737028A (en) * 2011-04-01 2012-10-17 深圳市赛格导航科技股份有限公司 Synchronization method and synchronization system of database
CN107613024A (en) * 2017-10-31 2018-01-19 维沃移动通信有限公司 A kind of method of data synchronization and mobile terminal
CN110674146A (en) * 2019-08-22 2020-01-10 视联动力信息技术股份有限公司 Data synchronization method, synchronization end, end to be synchronized, equipment and storage medium
CN110727892A (en) * 2019-09-24 2020-01-24 北京奇艺世纪科技有限公司 Cache data updating method and device and electronic equipment
CN113407560A (en) * 2021-08-19 2021-09-17 太平金融科技服务(上海)有限公司深圳分公司 Update message processing method, data synchronization method and configuration information configuration method
US20210294785A1 (en) * 2020-03-20 2021-09-23 Sap Se Version table scheme for fast version space access
CN113986939A (en) * 2021-11-05 2022-01-28 中国工商银行股份有限公司 Data change method and device for database
CN114706923A (en) * 2021-11-09 2022-07-05 中国建设银行股份有限公司 Data synchronization method and device, electronic equipment and storage medium
CN115357662A (en) * 2022-08-19 2022-11-18 浪潮电子信息产业股份有限公司 Data synchronization method, device and medium

Patent Citations (12)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20070180075A1 (en) * 2002-04-25 2007-08-02 Doug Chasman System and method for synchronization of version annotated objects
CN1627296A (en) * 2003-12-12 2005-06-15 国际商业机器公司 Data collection updating device, terminal device, data collection updating method and program
CN1677887A (en) * 2005-02-01 2005-10-05 北京北方烽火科技有限公司 N+1 duplicates data real-time synchronising method
CN102737028A (en) * 2011-04-01 2012-10-17 深圳市赛格导航科技股份有限公司 Synchronization method and synchronization system of database
CN107613024A (en) * 2017-10-31 2018-01-19 维沃移动通信有限公司 A kind of method of data synchronization and mobile terminal
CN110674146A (en) * 2019-08-22 2020-01-10 视联动力信息技术股份有限公司 Data synchronization method, synchronization end, end to be synchronized, equipment and storage medium
CN110727892A (en) * 2019-09-24 2020-01-24 北京奇艺世纪科技有限公司 Cache data updating method and device and electronic equipment
US20210294785A1 (en) * 2020-03-20 2021-09-23 Sap Se Version table scheme for fast version space access
CN113407560A (en) * 2021-08-19 2021-09-17 太平金融科技服务(上海)有限公司深圳分公司 Update message processing method, data synchronization method and configuration information configuration method
CN113986939A (en) * 2021-11-05 2022-01-28 中国工商银行股份有限公司 Data change method and device for database
CN114706923A (en) * 2021-11-09 2022-07-05 中国建设银行股份有限公司 Data synchronization method and device, electronic equipment and storage medium
CN115357662A (en) * 2022-08-19 2022-11-18 浪潮电子信息产业股份有限公司 Data synchronization method, device and medium

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
梁凝;单晓强;孙叠;: "数据库同步技术的研究" *
王慧;郭明阳;董欢庆;许鲁;: "BW-RAID系统的分布式异步版本识别机制" *

Also Published As

Publication number Publication date
CN115858688B (en) 2023-04-18

Similar Documents

Publication Publication Date Title
CN112073405B (en) Webpage data loading method and device, computer equipment and storage medium
CN107291869B (en) Distributed service system and data query method thereof
CN111245548A (en) Data synchronization method and device based on timestamp and computer equipment
CN110795171B (en) Service data processing method, device, computer equipment and storage medium
CN111309785A (en) Spring framework-based database access method and device, computer equipment and medium
CN113094430B (en) Data processing method, device, equipment and storage medium
CN111767297B (en) Big data processing method, device, equipment and medium
CN112559529B (en) Data storage method, device, computer equipment and storage medium
CN115858688B (en) Remote data synchronization method and system for database
CN111443875B (en) Data processing method, device and equipment based on address relation table
CN112632375B (en) Session information processing method, server and storage medium
CN112069239A (en) Method, system, device and storage medium for using database based on HTTP request
CN109542872B (en) Data reading method and device, computer equipment and storage medium
CN112261090A (en) Web data processing method and device, computer equipment and readable storage medium
CN115168307A (en) Data synchronization method, system, equipment and storage medium supporting breakpoint continuous transmission
CN115374133A (en) Data processing method and device, electronic equipment and computer readable storage medium
CN112783866A (en) Data reading method and device, computer equipment and storage medium
CN114138785A (en) Data retrieval method, device, equipment and storage medium suitable for large data volume
CN109766361B (en) Cache data reading method, device, computer equipment and storage medium
CN116546038A (en) Intelligent handheld terminal data synchronization system and method
CN114079588B (en) Equipment control method, device, server and storage medium
CN110928598B (en) System configuration method, device, computer equipment and storage medium
CN115454936A (en) Document number processing control method and device, server and storage medium
CN110196724A (en) File loading method, terminal, server, computer equipment and storage medium
CN111507566B (en) Method, device, computer equipment and storage medium for generating article production list

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