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

System and method for massively parallel processing database

A parallel processing and database technology, applied in electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as complex visibility detection

Active Publication Date: 2017-02-22
HUAWEI TECH CO LTD
View PDF8 Cites 12 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Visibility detection using transaction IDs and transaction status logs such as Clog in PostgreSQL is usually complicated because time information is not used to judge the occurrence of events

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
  • System and method for massively parallel processing database
  • System and method for massively parallel processing database
  • System and method for massively parallel processing database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0022] It should be understood at the outset that, although an illustrative implementation of one or more embodiments is provided below, the disclosed systems and / or methods may be implemented using any number of techniques, whether currently known or in existence. The invention should in no way be limited to the illustrative implementations, drawings, and techniques illustrated below, including the exemplary designs and implementations illustrated and described herein, but rather be within the scope of the appended claims and their equivalents Modified within the full range of .

[0023] Global point-in-time recovery (PITR) can be problematic in massively parallel processing (MPP) databases because data nodes run with their timers, so commit requests for the same transaction may Arrives at data nodes at different times. Using time or transaction identification number (identification number, ID) as the recovery target in PITR will not achieve consistent recovery points.

[0...

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

System and Method for Massively Parallel Processing Database are provided. A coordinator is configured to transmit a reader timestamp request to a global transaction manager (GTM), and receive a reader timestamp from the GTM. A plurality of transaction requests are transmitted from the coordinator to a plurality of data nodes, and a plurality of transaction results will be transmitted from the plurality of data nodes to the coordinator, where a first transaction request of the plurality of transaction requests comprises the reader timestamp.

Description

[0001] Related Applications Cross Application [0002] This application claims a prior application to U.S. Nonprovisional Patent Application No. 14 / 249,558, filed April 10, 2014, by Le Cai and Guogen Zhang, entitled "A System and Method for Massively Parallel Processing Databases" Priority, the content of this earlier application is incorporated herein by reference. technical field [0003] The present invention relates to a database system and method, in particular to a large-scale parallel processing database system and method. Background technique [0004] A massively parallel processing (MPP) database management system scales by allocating data partitions to servers and running transactions in parallel. A single transaction can be processed in parallel on multiple servers. This parallel processing poses challenges to transaction management, multi-version concurrency control (MVCC), and recovery. [0005] The global transaction manager (global transaction manager, GTM)...

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): G06F17/30
CPCG06F11/1474G06F2201/835G06F16/2379G06F16/128G06F16/24532G06F11/1451G06F2201/80G06F11/1446
Inventor 蔡乐张国根
Owner HUAWEI TECH CO LTD
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