Database synchronization method and device

A database and master database technology, applied in the computer field, can solve problems such as database synchronization blocking and inability to execute concurrently, and achieve the effect of speeding up efficiency and realizing management and operation

Active Publication Date: 2016-03-23
ALIBABA GRP HLDG LTD
View PDF5 Cites 13 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, when these technologies are used to process DCL statements or DDL statements, the control rights of all locks will be locked when the DCL statements or DDL statements are executed. From the execution of the corresponding DCL statement or DDL statement to the execution success, other execution statements will be in Waiting state, non-executable, so it will cause the database to block synchronously, so it is presumed that there is a conflict between the DML statement and the DCL / DDL statement, and cannot be executed concurrently

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
  • Database synchronization method and device
  • Database synchronization method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0019] The application will be described in further detail below in conjunction with the accompanying drawings.

[0020] In a typical configuration of the present application, the terminal, the device serving the network and the trusted party all include one or more processors (CPUs), input / output interfaces, network interfaces and memory.

[0021] Memory may include non-permanent storage in computer-readable media, in the form of random access memory (RAM) and / or nonvolatile memory, such as read-only memory (ROM) or flash memory (flashRAM). Memory is an example of computer readable media.

[0022] Computer-readable media, including both permanent and non-permanent, removable and non-removable media, can be implemented by any method or technology for storage of information. Information may be computer readable instructions, data structures, modules of a program, or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), sta...

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 present application aims to provide a database synchronization method and device. The method comprises: acquiring a to-be-synchronized data operation record in a primary database; acquiring a read authority of an upper-layer object of an operational object corresponding to the data operation record, and acquiring a control authority that corresponds to the data operation record and relates to the operational object; and performing the data operation record on the operational object in a backup database corresponding to the primary database. Compared with the prior art, according to the database synchronization method and device provided by the present application, each data operation record acquires, according to actual needs, an operation authority corresponding to a corresponding operation hierarchy; and an influence scope of a DCL statement or a DDL statement on data synchronization is reduced, so that a DCL, a DDL and a DML can be concurrently performed without affecting consistence of a transaction, thereby accelerating primary-backup synchronization efficiency, and implementing management and operation on the database more effectively.

Description

technical field [0001] The present application relates to the computer field, in particular to a database synchronization technology. Background technique [0002] With the improvement of database performance, it is usually possible to use the master-slave synchronization method between databases to meet various requirements for database management and operation, such as data backup, load balancing, and improving database availability and fault tolerance. When a certain number of data operation records, such as DCL (Data Control Language), DDL (Data Definition Language), DML (Data Manipulation Language) and other statements in the database, are synchronized in the database or between databases, if they can be executed concurrently The data operation record will greatly increase the speed of master-standby synchronization. [0003] Currently, the schemes adopted in this field are: [0004] For concurrent synchronization of DML statements in the database, first obtain the su...

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
Inventor 钱在晨陈招尚曾文旌
Owner ALIBABA GRP HLDG LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap