CN115687529A - Data synchronization method and device, electronic equipment and storage medium - Google Patents

Data synchronization method and device, electronic equipment and storage medium Download PDF

Info

Publication number
CN115687529A
CN115687529A CN202211426071.9A CN202211426071A CN115687529A CN 115687529 A CN115687529 A CN 115687529A CN 202211426071 A CN202211426071 A CN 202211426071A CN 115687529 A CN115687529 A CN 115687529A
Authority
CN
China
Prior art keywords
data
time
incremental
operation information
incremental data
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.)
Pending
Application number
CN202211426071.9A
Other languages
Chinese (zh)
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.)
Lianren Healthcare Big Data Technology Co Ltd
Original Assignee
Lianren Healthcare Big Data Technology 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 Lianren Healthcare Big Data Technology Co Ltd filed Critical Lianren Healthcare Big Data Technology Co Ltd
Priority to CN202211426071.9A priority Critical patent/CN115687529A/en
Publication of CN115687529A publication Critical patent/CN115687529A/en
Pending legal-status Critical Current

Links

Images

Landscapes

  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The embodiment of the invention discloses a data synchronization method, a data synchronization device, electronic equipment and a storage medium. The method comprises the following steps: determining incremental data in a source database, and determining a target database and an intermediate table corresponding to the source database, wherein the intermediate table stores data creation time and data updating time of the incremental data; synchronizing the delta data to the target database based on the data creation time and the data update time. The technical scheme of the embodiment of the invention solves the technical problems of resource waste and data omission in the existing data synchronization, and can avoid resource waste and data omission in the data synchronization process, thereby improving the data synchronization efficiency and further ensuring the data synchronization effect.

Description

Data synchronization method and device, electronic equipment and storage medium
Technical Field
The present invention relates to the field of computer technologies, and in particular, to a data synchronization method and apparatus, an electronic device, and a storage medium.
Background
And data synchronization, namely, synchronizing data from the source database to the target database. In the data synchronization process, multiple synchronization processes are often required. In the related art, each data synchronization is generally divided into full synchronization and partial synchronization. However, full synchronization has the problem of resource waste, and partial synchronization usually has the problem of data omission.
Disclosure of Invention
In view of the above existing problems, the present invention provides a data synchronization method, apparatus, electronic device and storage medium, so as to avoid resource waste and data omission during the data synchronization process, improve the data synchronization efficiency, and ensure the data synchronization effect.
According to an aspect of the present invention, there is provided a data synchronization method, the method including:
determining incremental data in a source database, and determining a target database and a middle table corresponding to the source database, wherein the middle table stores data creation time and data updating time of the incremental data;
synchronizing the delta data to the target database based on the data creation time and the data update time.
Optionally, the intermediate table further stores the incremental data, and the incremental data is stored in correspondence with a data creation time and a data update time of the incremental data.
Optionally, the method further comprises:
acquiring an operation record aiming at the incremental data in the source database based on a preset trigger of the intermediate table, wherein the operation record comprises operation information and specific operation time aiming at the incremental data;
and setting data creating time and data updating time corresponding to the incremental data in the intermediate table according to the specific operation time and a preset time setting rule corresponding to the operation information.
Optionally, the setting, according to the specific operation time and a preset time setting rule corresponding to the operation information, a data creation time and a data update time corresponding to the incremental data in the intermediate table includes:
if the operation information is first operation information, setting data creating time and data updating time corresponding to the incremental data in the intermediate table as the specific operation time;
if the operation information is second operation information, setting the data updating time corresponding to the incremental data in the intermediate table as the specific operation time;
the first operation information is operation information for adding the incremental data in the source database, and the second operation information is operation information for modifying or deleting the incremental data in the source database.
Optionally, the synchronizing the incremental data to the target database based on the data creation time and the data update time includes:
comparing the data creating time with the data updating time to obtain a time comparison result;
and synchronizing the incremental data to the target database based on a preset data synchronization strategy of the time comparison result.
Optionally, the synchronizing the incremental data to the target database based on the preset data synchronization policy of the time comparison result includes:
and under the condition that the time comparison result is that the data creating time is the same as the data updating time, newly adding the incremental data to the target database.
Optionally, the synchronizing the incremental data to the target database corresponding to the source database according to the comparison result includes:
and under the condition that the time comparison result is that the data creating time is different from the data updating time, determining to-be-updated data corresponding to the incremental data in the target database, and updating the to-be-updated data based on the incremental data.
According to another aspect of the present invention, there is provided a data synchronization apparatus. The device includes:
the data acquisition module is used for determining incremental data in a source database and determining a target database and an intermediate table corresponding to the source database, wherein the intermediate table stores data creation time and data updating time of the incremental data;
and the data synchronization module is used for synchronizing the incremental data to the target database based on the data creation time and the data updating time.
According to another aspect of the present invention, there is provided an electronic apparatus including:
at least one processor; and
a memory communicatively coupled to the at least one processor; wherein, the first and the second end of the pipe are connected with each other,
the memory stores a computer program executable by the at least one processor, the computer program being executable by the at least one processor to enable the at least one processor to perform any of the data synchronization methods of the present invention.
According to another aspect of the present invention, there is provided a computer-readable storage medium storing computer instructions for causing a processor to implement any one of the data synchronization methods of the present invention when executed.
According to the technical scheme of the embodiment of the invention, incremental data in a source database are determined, and a target database and a middle table which correspond to the source database are determined, wherein the middle table stores data creation time and data updating time of the incremental data; synchronizing the delta data to the target database based on the data creation time and the data update time. The technical scheme of the embodiment of the invention solves the technical problems of resource waste and data omission in the existing data synchronization, and can avoid resource waste and data omission in the data synchronization process, thereby improving the data synchronization efficiency and further ensuring the data synchronization effect.
It should be understood that the statements in this section are not intended to identify key or critical features of the embodiments of the present invention, nor are they intended to limit the scope of the invention. Other features of the present invention will become apparent from the following description.
Drawings
In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings needed to be used in the description of the embodiments will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without creative efforts.
Fig. 1 is a schematic flowchart of a data synchronization method according to an embodiment of the present invention;
fig. 2 is a schematic structural diagram of a data synchronization apparatus according to a second embodiment of the present invention;
fig. 3 is a schematic structural diagram of an electronic device according to a third embodiment of the present invention.
Detailed Description
In order to make the technical solutions of the present invention better understood, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
It should be noted that the terms "first," "second," and the like in the description and claims of the present invention and in the drawings described above are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the invention described herein are capable of operation in other sequences than those illustrated or described herein. Moreover, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
It will be appreciated that the data involved in the subject technology, including but not limited to the data itself, the acquisition or use of the data, should comply with the requirements of the corresponding laws and regulations and related regulations.
Example one
Fig. 1 is a flowchart of a data synchronization method according to an embodiment of the present invention, where the embodiment is applicable to a data synchronization situation, the method may be executed by a data synchronization apparatus, the data synchronization apparatus may be implemented in a form of hardware and/or software, and the data synchronization apparatus may be configured in an electronic device such as a computer or a server. As shown in fig. 1, the method of the present embodiment includes:
s110, determining incremental data in a source database, and determining a target database and an intermediate table corresponding to the source database, wherein the intermediate table stores data creation time and data updating time of the incremental data.
Wherein a source database is a database that sends data to other databases. The target database is a database that receives data from other databases. Incremental data may be understood as data that changes in the source database. The delta data can include at least one of new data, modified data, and deleted data. The data creation time may be understood as the time at which incremental data is created. The data update time may be understood as the time when the delta data is modified. The intermediate table may be understood as a data table for storing the data creation time and the data update time of the incremental data in the source database. Optionally, the intermediate table may further store the incremental data, and the incremental data is stored in correspondence with a data creation time and a data update time of the incremental data. In the embodiment of the present invention, the intermediate table may be provided with a preset trigger, which may be used to monitor the change of data in the source database and record the operation for the changed data. It will be appreciated that the operation on the changed data may include at least one of an add data operation, a modify data operation, and a delete data operation.
In an embodiment of the present disclosure, determining incremental data in the source database may include: and determining incremental data in the source database based on a preset trigger set by the intermediate table. Determining the target database corresponding to the source database may include: receiving a data synchronization request, wherein the data synchronization request comprises a database name of a target database corresponding to a source database. And determining the database of the database names as a target database. Determining an intermediate table corresponding to the source database may include: and pre-creating an intermediate table created for the source database, and taking the created intermediate table as the intermediate table corresponding to the source database.
Optionally, the method further comprises: acquiring an operation record aiming at the incremental data in the source database based on a preset trigger of the intermediate table, wherein the operation record comprises operation information aiming at the incremental data and specific operation time; and setting data creation time and data updating time corresponding to the incremental data in the intermediate table according to the specific operation time and a preset time setting rule corresponding to the operation information.
The operation record can be used to record operation information and specific operation time for the incremental data in the source database. The operation information may be used to describe a specific operation on the delta data. The specific operation time can be understood as the time for creating or modifying the incremental data in the source database. Illustratively, the operation record is XX month XX in XX year XX and XX day 9 am. At this time, the operation information is information of newly added data. Specific operating time XX year XX month XX day 9 am. The preset time setting rule can be understood as a preset data assignment rule for two fields of data creation time and data update time in the intermediate table based on the operation information and the specific operation time.
In this embodiment of the present invention, the setting, according to the specific operation time and the preset time setting rule corresponding to the operation information, the data creation time and the data update time corresponding to the incremental data in the intermediate table, includes: if the operation information is first operation information, setting data creating time and data updating time corresponding to the incremental data in the intermediate table as the specific operation time; if the operation information is second operation information, setting the data updating time corresponding to the incremental data in the intermediate table as the specific operation time; the first operation information is operation information for adding the incremental data in the source database, and the second operation information is operation information for modifying or deleting the incremental data in the source database.
In this embodiment of the present invention, if the operation information is operation information of adding the incremental data in the source database, the data creation time corresponding to the incremental data in the intermediate table may be set as the specific operation time, and the data update time corresponding to the incremental data in the intermediate table may be set as the specific operation time.
On the basis of the above embodiment, if the operation information is operation information for modifying or deleting the incremental data in the source database, the data update time corresponding to the incremental data in the intermediate table may be set as the specific operation time.
And S120, synchronizing the incremental data to the target database based on the data creation time and the data updating time.
On the basis of the foregoing embodiment, the synchronizing the incremental data to the target database based on the data creation time and the data update time may include: comparing the data creating time with the data updating time to obtain a time comparison result; and then, the incremental data can be synchronized to the target database based on a preset data synchronization strategy of the time comparison result. The preset data synchronization strategy can be set according to actual requirements.
Optionally, the synchronizing the incremental data to the target database based on the preset data synchronization policy of the time comparison result may include: and under the condition that the time comparison result is that the data creation time is the same as the data updating time, the incremental data can be added to the target database to realize synchronous data.
Optionally, the synchronizing the incremental data to the target database corresponding to the source database according to the comparison result includes: and if the time comparison result is that the data creating time is different from the data updating time, determining to-be-updated data corresponding to the incremental data in the target database, and updating the to-be-updated data based on the incremental data.
The data to be updated may be understood as data that needs to be updated in the target database, and may include data that needs to be marked as deleted and data that needs to be modified.
In the embodiment of the present invention, the data to be updated is updated based on the incremental data, which may be understood as modifying the data before modification, corresponding to the modified data, in the target database by the modified data if the incremental data is the modified data; and if the incremental data is the data marked as deleted, determining the data in the target database corresponding to the data marked as deleted, and marking the data as deleted.
According to the technical scheme of the embodiment of the invention, incremental data in a source database are determined, and a target database and a middle table which correspond to the source database are determined, wherein the middle table stores data creation time and data updating time of the incremental data; synchronizing the delta data to the target database based on the data creation time and the data update time. The technical scheme of the embodiment of the invention solves the technical problems of resource waste and data omission in the existing data synchronization, and can avoid resource waste and data omission in the data synchronization process, thereby improving the data synchronization efficiency and further ensuring the data synchronization effect.
Example two
Fig. 2 is a schematic structural diagram of a data synchronization apparatus according to a second embodiment of the present invention. As shown in fig. 2, the apparatus includes: a data acquisition module 210 and a data synchronization module 220.
The data obtaining module 210 is configured to determine incremental data in a source database, and determine a target database and an intermediate table corresponding to the source database, where the intermediate table stores data creation time and data update time of the incremental data;
a data synchronization module 220, configured to synchronize the incremental data to the target database based on the data creation time and the data update time.
According to the technical scheme of the embodiment of the invention, incremental data in a source database are determined through a data acquisition module, a target database and a middle table corresponding to the source database are determined, and the middle table stores data creation time and data updating time of the incremental data; synchronizing, by a data synchronization module, the delta data to the target database based on the data creation time and the data update time. The technical scheme of the embodiment of the invention solves the technical problems of resource waste and data omission in the existing data synchronization, and can avoid resource waste and data omission in the data synchronization process, thereby improving the data synchronization efficiency and further ensuring the data synchronization effect.
Optionally, the intermediate table further stores the incremental data, and the incremental data is stored in correspondence with a data creation time and a data update time of the incremental data.
Optionally, the apparatus further comprises: the time setting module is used for acquiring an operation record aiming at the incremental data in the source database based on a preset trigger of the intermediate table, wherein the operation record comprises operation information aiming at the incremental data and specific operation time; and setting data creating time and data updating time corresponding to the incremental data in the intermediate table according to the specific operation time and a preset time setting rule corresponding to the operation information.
Optionally, the time setting module is specifically configured to:
if the operation information is first operation information, setting data creating time and data updating time corresponding to the incremental data in the intermediate table as the specific operation time;
if the operation information is second operation information, setting the data updating time corresponding to the incremental data in the intermediate table as the specific operation time;
the first operation information is operation information for adding the incremental data in the source database, and the second operation information is operation information for modifying or deleting the incremental data in the source database.
Optionally, the data synchronization module 220 is configured to perform time comparison between the data creation time and the data update time to obtain a time comparison result; and synchronizing the incremental data to the target database based on a preset data synchronization strategy of the time comparison result.
Optionally, the data synchronization module 220 is configured to add the incremental data to the target database when the time comparison result is that the data creation time is the same as the data update time.
Optionally, the data synchronization module 220 is configured to determine to-be-updated data corresponding to the incremental data in the target database when the time comparison result is that the data creation time is different from the data update time, and update the to-be-updated data based on the incremental data.
The data synchronization device provided by the embodiment of the invention can execute the data synchronization method provided by any embodiment of the invention, and has corresponding functional modules and beneficial effects of the execution method.
It should be noted that, the units and modules included in the data synchronization apparatus are merely divided according to functional logic, but are not limited to the above division, as long as the corresponding functions can be implemented; in addition, specific names of the functional units are only for convenience of distinguishing from each other, and are not used for limiting the protection scope of the embodiment of the invention.
EXAMPLE III
FIG. 3 illustrates a block diagram of an electronic device 10 that may be used to implement an embodiment of the invention. Electronic devices are intended to represent various forms of digital computers, such as laptops, desktops, workstations, personal digital assistants, servers, blade servers, mainframes, and other appropriate computers. The electronic device may also represent various forms of mobile devices, such as personal digital assistants, cellular phones, smart phones, wearable devices (e.g., helmets, glasses, watches, etc.), and other similar computing devices. The components shown herein, their connections and relationships, and their functions, are meant to be exemplary only, and are not meant to limit implementations of the inventions described and/or claimed herein.
As shown in fig. 3, the electronic device 10 includes at least one processor 11, and a memory communicatively connected to the at least one processor 11, such as a Read Only Memory (ROM) 12, a Random Access Memory (RAM) 13, and the like, wherein the memory stores a computer program executable by the at least one processor, and the processor 11 may perform various suitable actions and processes according to the computer program stored in the Read Only Memory (ROM) 12 or the computer program loaded from the storage unit 18 into the Random Access Memory (RAM) 13. In the RAM 13, various programs and data necessary for the operation of the electronic apparatus 10 can also be stored. The processor 11, the ROM 12, and the RAM 13 are connected to each other via a bus 14. An input/output (I/O) interface 15 is also connected to the bus 14.
A number of components in the electronic device 10 are connected to the I/O interface 15, including: an input unit 16 such as a keyboard, a mouse, or the like; an output unit 17 such as various types of displays, speakers, and the like; a storage unit 18 such as a magnetic disk, an optical disk, or the like; and a communication unit 19 such as a network card, modem, wireless communication transceiver, etc. The communication unit 19 allows the electronic device 10 to exchange information/data with other devices via a computer network, such as the internet, and/or various telecommunication networks.
The processor 11 may be a variety of general and/or special purpose processing components having processing and computing capabilities. Some examples of processor 11 include, but are not limited to, a Central Processing Unit (CPU), a Graphics Processing Unit (GPU), various specialized Artificial Intelligence (AI) computing chips, various processors running machine learning model algorithms, a Digital Signal Processor (DSP), and any suitable processor, controller, microcontroller, or the like. The processor 11 performs the various methods and processes described above, such as a data synchronization method.
In some embodiments, the data synchronization method may be implemented as a computer program tangibly embodied in a computer-readable storage medium, such as storage unit 18. In some embodiments, part or all of the computer program may be loaded and/or installed onto the electronic device 10 via the ROM 12 and/or the communication unit 19. When the computer program is loaded into the RAM 13 and executed by the processor 11, one or more steps of the data synchronization method described above may be performed. Alternatively, in other embodiments, the processor 11 may be configured to perform the data synchronization method by any other suitable means (e.g., by means of firmware).
Various implementations of the systems and techniques described here above may be implemented in digital electronic circuitry, integrated circuitry, field Programmable Gate Arrays (FPGAs), application Specific Integrated Circuits (ASICs), application Specific Standard Products (ASSPs), system on a chip (SOCs), load programmable logic devices (CPLDs), computer hardware, firmware, software, and/or combinations thereof. These various embodiments may include: implemented in one or more computer programs that are executable and/or interpretable on a programmable system including at least one programmable processor, which may be special or general purpose, receiving data and instructions from, and transmitting data and instructions to, a storage system, at least one input device, and at least one output device.
A computer program for implementing the methods of the present invention may be written in any combination of one or more programming languages. These computer programs may be provided to a processor of a general purpose computer, special purpose computer, or other programmable data processing apparatus, such that the computer programs, when executed by the processor, cause the functions/acts specified in the flowchart and/or block diagram block or blocks to be performed. A computer program can execute entirely on a machine, partly on a machine, as a stand-alone software package partly on a machine and partly on a remote machine or entirely on a remote machine or server.
In the context of the present invention, a computer-readable storage medium may be a tangible medium that can contain, or store a computer program for use by or in connection with an instruction execution system, apparatus, or device. A computer readable storage medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. Alternatively, the computer readable storage medium may be a machine readable signal medium. More specific examples of a machine-readable storage medium would include an electrical connection based on one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
To provide for interaction with a user, the systems and techniques described here can be implemented on an electronic device having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to a user; and a keyboard and a pointing device (e.g., a mouse or a trackball) by which a user can provide input to the electronic device. Other kinds of devices may also be used to provide for interaction with a user; for example, feedback provided to the user can be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form, including acoustic, speech, or tactile input.
The systems and techniques described here can be implemented in a computing system that includes a back-end component (e.g., as a data server), or that includes a middleware component (e.g., an application server), or that includes a front-end component (e.g., a user computer having a graphical user interface or a web browser through which a user can interact with an implementation of the systems and techniques described here), or any combination of such back-end, middleware, or front-end components. The components of the system can be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: local Area Networks (LANs), wide Area Networks (WANs), blockchain networks, and the internet.
The computing system may include clients and servers. A client and server are generally remote from each other and typically interact through a communication network. The relationship of client and server arises by virtue of computer programs running on the respective computers and having a client-server relationship to each other. The server can be a cloud server, also called a cloud computing server or a cloud host, and is a host product in a cloud computing service system, so that the defects of high management difficulty and weak service expansibility in the traditional physical host and VPS service are overcome.
It should be understood that various forms of the flows shown above may be used, with steps reordered, added, or deleted. For example, the steps described in the present invention may be executed in parallel, sequentially, or in different orders, and are not limited herein as long as the desired result of the technical solution of the present invention can be achieved.
The above-described embodiments should not be construed as limiting the scope of the invention. It should be understood by those skilled in the art that various modifications, combinations, sub-combinations and substitutions may be made in accordance with design requirements and other factors. Any modification, equivalent replacement, and improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.

Claims (10)

1. A method of data synchronization, comprising:
determining incremental data in a source database, and determining a target database and a middle table corresponding to the source database, wherein the middle table stores data creation time and data updating time of the incremental data;
synchronizing the delta data to the target database based on the data creation time and the data update time.
2. The method of claim 1, wherein the intermediate table further stores the incremental data and corresponds to a data creation time and a data update time of the incremental data.
3. The method of claim 2, further comprising:
acquiring an operation record aiming at the incremental data in the source database based on a preset trigger of the intermediate table, wherein the operation record comprises operation information aiming at the incremental data and specific operation time;
and setting data creation time and data updating time corresponding to the incremental data in the intermediate table according to the specific operation time and a preset time setting rule corresponding to the operation information.
4. The method according to claim 3, wherein the setting of the data creation time and the data update time corresponding to the incremental data in the intermediate table according to the specific operation time and a preset time setting rule corresponding to the operation information comprises:
if the operation information is first operation information, setting data creating time and data updating time corresponding to the incremental data in the intermediate table as the specific operation time;
if the operation information is second operation information, setting the data updating time corresponding to the incremental data in the intermediate table as the specific operation time;
the first operation information is operation information for adding the incremental data in the source database, and the second operation information is operation information for modifying or deleting the incremental data in the source database.
5. The method of claim 1, wherein the synchronizing the delta data to the target database based on the data creation time and the data update time comprises:
comparing the data creating time with the data updating time to obtain a time comparison result;
and synchronizing the incremental data to the target database based on a preset data synchronization strategy of the time comparison result.
6. The method of claim 5, wherein the synchronizing the incremental data to the target database based on the predetermined data synchronization policy of the time alignment result comprises:
and under the condition that the time comparison result is that the data creating time is the same as the data updating time, newly adding the incremental data to the target database.
7. The method of claim 5, wherein the synchronizing the incremental data to the target database corresponding to the source database according to the comparison result comprises:
and under the condition that the time comparison result is that the data creating time is different from the data updating time, determining to-be-updated data corresponding to the incremental data in the target database, and updating the to-be-updated data based on the incremental data.
8. A data synchronization apparatus, comprising:
the data acquisition module is used for determining incremental data in a source database, and determining a target database and a middle table corresponding to the source database, wherein the middle table stores data creation time and data updating time of the incremental data;
and the data synchronization module is used for synchronizing the incremental data to the target database based on the data creation time and the data updating time.
9. An electronic device, characterized in that the electronic device comprises:
at least one processor; and
a memory communicatively coupled to the at least one processor; wherein, the first and the second end of the pipe are connected with each other,
the memory stores a computer program executable by the at least one processor to enable the at least one processor to perform the data synchronization method of any one of claims 1-7.
10. A computer-readable storage medium having stored thereon computer instructions for causing a processor to perform the data synchronization method of any one of claims 1-7 when executed.
CN202211426071.9A 2022-11-14 2022-11-14 Data synchronization method and device, electronic equipment and storage medium Pending CN115687529A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202211426071.9A CN115687529A (en) 2022-11-14 2022-11-14 Data synchronization method and device, electronic equipment and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202211426071.9A CN115687529A (en) 2022-11-14 2022-11-14 Data synchronization method and device, electronic equipment and storage medium

Publications (1)

Publication Number Publication Date
CN115687529A true CN115687529A (en) 2023-02-03

Family

ID=85051379

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202211426071.9A Pending CN115687529A (en) 2022-11-14 2022-11-14 Data synchronization method and device, electronic equipment and storage medium

Country Status (1)

Country Link
CN (1) CN115687529A (en)

Similar Documents

Publication Publication Date Title
CN113193947B (en) Method, apparatus, medium, and program product for implementing distributed global ordering
EP4145298A1 (en) Method and apparatus for snapshotting metadata
CN116028517A (en) Fusion database system and electronic equipment
CN115454971A (en) Data migration method and device, electronic equipment and storage medium
CN115905322A (en) Service processing method and device, electronic equipment and storage medium
CN116185389A (en) Code generation method and device, electronic equipment and medium
CN115525721A (en) Data synchronization method, device, equipment and storage medium
CN115687529A (en) Data synchronization method and device, electronic equipment and storage medium
CN114328739A (en) Data synchronization method, data reading method, data synchronization device, data reading device, electronic equipment, storage medium and product
CN114691781A (en) Data synchronization method, system, device, equipment and medium
CN114564149A (en) Data storage method, device, equipment and storage medium
CN114417070A (en) Method, device and equipment for converging data authority and storage medium
CN116775171B (en) Architecture switching method and device, electronic equipment and storage medium
CN112948461A (en) Method, apparatus, storage medium, and program product for schedule data processing
CN115098520A (en) Device data updating method and device, electronic device and storage medium
CN115904720A (en) Resource group generation method, device, equipment and storage medium
CN114546478A (en) Method, device, equipment and medium for updating code and database version
CN115525659A (en) Data query method and device, electronic equipment and storage medium
CN115309568A (en) Method, device, equipment and medium for realizing multi-process file sharing
CN117707856A (en) Data backup method, device, equipment and storage medium
CN115576977A (en) Data paging query method and device, electronic equipment and storage medium
CN116708478A (en) Sea-land communication-based data synchronous transmission system, method, equipment and medium
CN115730000A (en) Medical data integration method, device, equipment and medium based on data lake
CN115983222A (en) EasyExcel-based file data reading method, device, equipment and medium
CN115617804A (en) Data processing method, device and equipment for uninterrupted service and storage medium

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