Unlock instant, AI-driven research and patent intelligence for your innovation.

Database query method, device, server and storage medium in mpp environment

A query method and database technology, applied in database management systems, structured data retrieval, electronic digital data processing, etc., can solve the problems of low efficiency of database query methods

Active Publication Date: 2022-03-08
SHANGHAI DAMENG DATABASE
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The invention provides a database query method, device, server and storage medium in an MPP environment to solve the technical problem of low efficiency of the database query method in the current MPP environment

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 query method, device, server and storage medium in mpp environment
  • Database query method, device, server and storage medium in mpp environment
  • Database query method, device, server and storage medium in mpp environment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0032] The present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present invention, but not to limit the present invention. In addition, it should be noted that, for the convenience of description, only some structures related to the present invention are shown in the drawings but not all structures.

[0033] figure 1 A system architecture diagram for the application of the database query method under the MPP environment provided by the present invention. Such as figure 1 As shown, the MPP environment includes multiple nodes 11, and each node 11 includes two data sets, data set 1 and data set 2. A certain node receives a Structured Query Language (Structured Query Language, SQL) statement to query the database. In this embodiment, for the convenience of description, the node that receives the SQL statement is ...

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 database query method, device, server and storage medium in an MPP environment, including: determining the left data set and the right data set of the target node according to the received SQL statement, and collecting the left data set and hash of all nodes The data related to the semi-join operation is used as the new left data set, and temporary items are added to the new left data set, and the new left data set is sent to other nodes except the target node to obtain the output items of the target node. Use the output item of the target node as the output item in the initial subquery result of the target node, use the value corresponding to the output item in the temporary item of the new left data set as the value of the temporary item of the initial subquery result, and receive other The initial sub-query results sent by the nodes determine the final query results according to the values ​​of the output items in the initial sub-query results of all nodes and the values ​​of the temporary items in each initial sub-query results, which improves the database query efficiency.

Description

technical field [0001] Embodiments of the present invention relate to the technical field of data processing, and in particular to a database query method, device, server and storage medium in a massively parallel processing (Massively Parallel Processing, MPP) environment. Background technique [0002] In the MPP environment, each node in the non-shared database cluster has an independent disk storage system and memory system. The data between nodes are connected to each other through the network, and the calculations are coordinated with each other. To put it simply, MPP distributes tasks to multiple nodes in parallel. After the calculation is completed on each node, the results of each part are aggregated to obtain the final execution result. In the MPP environment, the database tables are distributed with appropriate distribution columns and stored on each node. When a user performs a database query, during the query process, the database table needs to be connected an...

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 Patents(China)
IPC IPC(8): G06F16/2453G06F16/248G06F16/25
CPCG06F16/24532G06F16/256G06F16/248
Inventor 张钦朱仲颖韩朱忠
Owner SHANGHAI DAMENG DATABASE
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

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

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com