Check patentability & draft patents in minutes with Patsnap Eureka AI!

Table-level data synchronization method and device in database

A data synchronization and database technology, applied in the computer field, can solve problems such as slow synchronization speed

Pending Publication Date: 2022-02-18
白腊梅
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] Embodiments of the present invention provide a table-level data synchronization method and device in a database, aiming to solve the problem of slow synchronization speed in existing data synchronization methods

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Table-level data synchronization method and device in database
  • Table-level data synchronization method and device in database
  • Table-level data synchronization method and device in database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0047] In order to make the object, technical solution and advantages of the present invention clearer, the present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.

[0048] see figure 1 , is a schematic flowchart of a table-level data synchronization method in a database provided in Embodiment 1 of the present invention. The method includes the following steps:

[0049] Step S1, at a first time point, obtain the record set of the source data table from the source database, and insert the record set into the target database to form the target data table.

[0050] Step S2. Continue the operation of acquiring the source data table in the source database from a second time point, wherein the second time point is less than or equal to the first time point.

[0051...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention provides a table-level data synchronization method and device in a database, and the method comprises the following steps: S1, obtaining a record set of a source data table at a first time point, and generating a target data table; s2, continuously obtaining the operation of the source data table from a second time point less than or equal to the first time point; s3, dividing the operation of the source data table into a plurality of sub-operation sets according to the primary key, wherein each sub-operation set stores the related operation of the primary key arranged according to the time sequence; s4, counting the storage quantity of related operations in each sub-operation set, and when the storage quantity reaches a preset threshold value, obtaining target operations involved in the counting in the sub-operation set; s5, updating the data of the corresponding primary key in the target data table according to the target operation; and S6, carrying out zero clearing on the storage quantity count, and cyclically executing the step S4. The invention comprises continuously obtaining the operation of a source data table in a source database from a second time point, and continuously and circularly updating, so that the synchronization speed is improved on the premise of ensuring no data omission.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a table-level data synchronization method and device in a database. Background technique [0002] Data is an indispensable information basis that we face every day, and database technology is a core technology of information systems. With the development of information technology, in order to meet the requirements of use, the amount of data in the database and the location of data storage are also constantly changing. For example, the expansion of the database in the information system, the data redistribution of the data tables in the database, the replacement of the database with a new running server, the replacement of the information system of the database, and the backup of the database and other situations require data migration and synchronization of the database. [0003] The existing data synchronization technology of the data table is: obtain the first operation acti...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/22G06F16/23G06F16/242G06F16/2458G06F16/27
CPCG06F16/2228G06F16/2433G06F16/2379G06F16/2474G06F16/27
Inventor 白腊梅
Owner 白腊梅
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com