Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Data synchronization method and system, server and computer readable storage medium

A data synchronization and server technology, applied in the database field, can solve the problems of low efficiency in updating and deleting data, and achieve the effect of improving storage performance, solving inefficiency and improving speed.

Pending Publication Date: 2019-05-10
HANGZHOU DT DREAM TECH
View PDF6 Cites 10 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The purpose of this application is to provide a data synchronization method, a data synchronization system, a computer-readable storage medium and a server to solve the problem of low efficiency of updating and deleting data during data synchronization between existing databases

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
  • Data synchronization method and system, server and computer readable storage medium
  • Data synchronization method and system, server and computer readable storage medium
  • Data synchronization method and system, server and computer readable storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0048] In order to make the purposes, technical solutions and advantages of the embodiments of the present application clearer, the technical solutions in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments It is a part of the embodiments of this application, not all of them. Based on the embodiments in this application, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the scope of protection of this application.

[0049] Please refer to figure 1 , figure 1 It is a flow chart of a data synchronization method provided in the embodiment of the present application, and the data synchronization method includes:

[0050] S101: When it is detected that there is changed data in the first data table, and the changed data needs to be synchronized to the second data tab...

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 data synchronization method, which comprises the steps of judging whether a data change type is data update or data deletion when detecting that change data exists in a firstdata table and the change data needs to be synchronized to a second data table; if yes, writing the change data into a temporary table; and combining the temporary table and the second data table to complete data synchronization. When data updating or data deleting exists, data updating or data deleting is carried out, wherein the change record is a batch insertion action when being written into the temporary table from the first data table; the actual data content does not need to be updated or deleted according to the change records; different from a one-by-one updating or deleting action ofdirectly writing the change records into the second data table, the data updating or deleting speed is increased, the warehousing performance of the database is improved, and the problems of low dataupdating and deleting efficiency during data synchronization are solved. The invention also provides a data synchronization system between databases, a computer readable storage medium and a server,which have the same beneficial effects.

Description

technical field [0001] The present application relates to the field of databases, in particular to a data synchronization method, a data synchronization system, a computer-readable storage medium and a server. Background technique [0002] There are various solutions for existing incremental data synchronization, and commonly used methods include time stamp, trigger, log parsing and Oracle changed data capture (CDC) methods. Taking the Oracle CDC method as an example, data that changes over a period of time can be captured, and records of data insertion, update, and deletion will be saved. By parsing these records, the synchronization of incremental data is realized. [0003] However, when the incremental data of the source database is large, some databases with low write performance, such as analytical databases such as GBase and GreenPlum, do not support batch update and batch deletion, and can only update and delete data one by one, which directly affects Data synchroni...

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
IPC IPC(8): G06F16/27G06F16/23
Inventor 陶程飞褚占峰周鹏程
Owner HANGZHOU DT DREAM TECH
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

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