Distributed database management method and device based on distributed logic timestamps

A management method and distributed technology, applied in the field of distributed database management methods and devices, can solve the problems of large network overhead, reduced overall system performance, heavy GTM load, etc., and achieve the effect of reducing overhead and improving overall performance

Inactive Publication Date: 2020-02-14
SEQUOIADB CORP
View PDF0 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The disadvantage of this implementation is that when the scale of the system cluster is large and there are many concurrent operations, the load of GTM will be heavy, and the network overhead will be very large, resulting in a decrease in the overall performance of the system
At the same time, it is very complicated to implement GTM in a small cluster to avoid single point of failure, and the reliability cannot be fully guaranteed

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
  • Distributed database management method and device based on distributed logic timestamps
  • Distributed database management method and device based on distributed logic timestamps
  • Distributed database management method and device based on distributed logic timestamps

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0037] The technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with 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 creative efforts fall within the protection scope of the present invention.

[0038] See figure 1 , the embodiment of the present invention provides a distributed database management method based on distributed logical time stamps, the distributed database includes coordination nodes, catalog nodes and data nodes, and the local logical time of each node is according to the preset global logic The time is synchronized to adjust the time;

[0039] See figure 1 , in the system shown in the figure, a distributed database is taken as an example, ...

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 discloses a distributed database management method and device based on a distributed logic timestamp. The method comprises the steps of setting transaction starting time of a transaction; if the difference value between the local logic time of the data node and the local logic time of the coordination node exceeds a preset threshold value, timing the local logic time of the data node, enabling the coordination node to roll back the transaction, and retrying the transaction after timing the time of the coordination node; if the difference between the transaction pre-submission time and the transaction start time is greater than the transaction tolerance error of the transaction, sending the transaction pre-submission time and the pre-submission message of the transaction to all data nodes participating in the transaction; and selecting one data node as an arbitration node to arbitrate the timestamps of the two different transactions according to the difference value condition of the timestamps of the two different transactions. According to the invention, the overhead of the network can be reduced while the requirements of distributed storage and processing are met, sothat the overall performance of the system is effectively improved.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a distributed database management method and device based on distributed logical time stamps. Background technique [0002] The distributed database management system is a very important part of the practical application of the distributed system. It not only has and uses the characteristics of all distributed systems, but also puts forward higher requirements for data storage and processing. Database management systems have been widely used since the 1980s. Initially, databases were deployed on one computer, and all transactions were processed in this single-computer database. With the rapid expansion of data volume and business volume, a single machine can no longer meet the requirements of data storage and data processing capabilities, and distributed database systems have become the preferred architecture for various application deployments. Solving distributed storage in ...

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/27
CPCG06F16/275
Inventor 许建辉陈元熹何国明王涛
Owner SEQUOIADB CORP
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