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

Communication method and communication device for parallel query of clustered databases

A communication method and technology of a communication device, which are applied in the field of database query, can solve the problems of poor query result reliability and storage performance, poor reliability and storage performance, etc., so as to avoid the overhead of data integrity and consistency maintenance, The effect of improving data transfer performance

Inactive Publication Date: 2013-11-20
DAWNING INFORMATION IND BEIJING
View PDF7 Cites 8 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0007] Aiming at the problem of poor reliability and warehousing performance in related technologies when memory and database temporary tables are used for data communication, the present invention proposes a communication method and communication device for parallel query of cluster databases, which can well solve the problem that query results are in Reliability and poor storage performance issues when saving and transferring

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
  • Communication method and communication device for parallel query of clustered databases
  • Communication method and communication device for parallel query of clustered databases
  • Communication method and communication device for parallel query of clustered databases

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0037] 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. All other embodiments obtained by persons of ordinary skill in the art based on the embodiments of the present invention belong to the protection scope of the present invention.

[0038] According to an embodiment of the present invention, a communication method for parallel query of a cluster database is provided.

[0039] Such as figure 1 As shown, the communication method of the cluster database parallel query according to the embodiment of the present invention includes:

[0040] Step S101, divide the query result from the query node to obtain the divided blocks;

[0041] Step S103, transmit each division block to the target node in the form of an independent dat...

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 communication method and a communication device for parallel query of clustered databases. The communication method comprises the following steps: dividing query results coming from query nodes to obtain division blocks; transmitting the division blocks to a target node in an independent data file form; under the condition of transmitting all the data files to the target node, performing data merging on the data files on the target node. Through the transmission of the query results in an independent data file form, the query results are still saved in a magnetic disk when the data nodes or networks fail, so that the problem that communication data between the database nodes is lost and not easy to recover when the data nodes or the networks fail is avoided.

Description

technical field [0001] The invention relates to the field of database query, in particular to a communication method and a communication device for parallel query of a cluster database. Background technique [0002] In a database cluster, data tables are usually distributed on multiple database nodes according to a certain data partition strategy, so query processing usually involves parallel execution of multiple database nodes and data transmission control between nodes. In a large-scale system, failure of a single component (such as a server's network, node, or disk, etc.) is inevitable. How to ensure that the communication state between nodes can be preserved when a node fails is a huge challenge faced by the database cluster. [0003] In the field of high-performance computing, message passing is usually used for communication, and the state of all parallel processes is regularly saved by saving checkpoints to provide system reliability. In a database cluster system, ...

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
Inventor 宋怀明王勇苗艳超刘新春邵宗有
Owner DAWNING INFORMATION IND BEIJING
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