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

Data synchronization method and device of distributed relational database

A data synchronization and relational technology, applied in the database field, can solve the problems of limited log file storage space and data loss, and achieve the effect of saving log storage space, ensuring integrity, and reducing the number of logs

Active Publication Date: 2016-05-11
CHINA UNITED NETWORK COMM GRP CO LTD
View PDF10 Cites 14 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] However, in the existing technology, when the data synchronization time is too long and the transaction submission is frequent, the log files recording transaction operations will increase in batches, and the storage space of the log files of the database nodes is limited, and the "ring storage" method is generally adopted , when the size of the log file exceeds the size of the storage space, the earliest log file will be overwritten, resulting in data loss

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 device of distributed relational database
  • Data synchronization method and device of distributed relational database
  • Data synchronization method and device of distributed relational database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0034] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0035] The terms "first", "second", "third", "fourth", etc. (if any) in the description and claims of the present invention and the above drawings are used to distinguish similar objects and not necessarily Describe a specific order or sequence. It is to be understood that the data so used are interchangeable under appropriate circumstances such that the embodiments of the invention described herein are, for example, capable of practice in sequences other than...

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 and device of a distributed relational database. The method comprises the following steps: determining whether a data fragment of the data to be operated by a transaction operation request is in a migrating state; if so, redirecting the address of the data fragment to the cache address of the data fragment, wherein the data fragment is divided into N small partitions in the cache; determining whether the data to be operated by the transaction operation request are the data corresponding to the migrated small partition; and if so, recording the transaction operation in a redo log, wherein since the redo log only records the transaction operations of the migrated small partitions rather than the non-migrated small partitions, the recording number in the redo log is reduced, the logo storage space is saved, the data loss is avoided, and the data integrity as well as the data synchronization consistency are guaranteed.

Description

technical field [0001] The invention relates to database technology, in particular to a data synchronization method and device for a distributed relational database. Background technique [0002] Distributed relational database (DataBase, referred to as DB) is widely used because it adopts cheap equipment stacked into a computing cluster with high availability and high scalability. [0003] Data synchronization refers to migrating the data of one database node to another database node. The distributed relational database needs a certain amount of time during the data migration process. During the data migration process, the business side may increase the original database node. , deletion, modification and other operations may lead to data inconsistency. Therefore, in order to ensure complete synchronization of data, in the prior art, the data files of the original database node are first copied to the new database node. According to the log files of the original database no...

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): G06F17/30
CPCG06F16/27G06F16/284
Inventor 李浩罗云彬王伟华
Owner CHINA UNITED NETWORK COMM GRP CO LTD
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