Device and method for data transmission among Hash join operators

A technology for connecting subunits and data, which is applied in the database field, can solve problems such as database query performance degradation, and achieve the effect of improving query performance

Active Publication Date: 2014-05-28
HUAWEI TECH CO LTD
View PDF7 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The embodiment of the present invention discloses a method and device for data transfer between hash join operators, which are used to solve the problem that the existing hash join operators perform data transfer in the form of tuples and cause the performance of database query to decrease

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
  • Device and method for data transmission among Hash join operators
  • Device and method for data transmission among Hash join operators
  • Device and method for data transmission among Hash join operators

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0049] 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. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0050] Embodiments of the present invention provide a method and device for data transfer between hash join operators, which can perform data transfer between hash join operators in the form of a hash table, thereby improving the query performance of the database. Each will be described in detail below.

[0051] see figure 1 , figure 1 It is a schematic flowchart of a method for transferring data between hash join operators disclosed in an embodiment of the ...

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

An embodiment of the invention relates to the technical field of databases and discloses a device and a method for data transmission among Hash join operators. The method includes: connecting an external table with a pre-generated Hash table; updating the Hash table according to the external table to acquire the updated Hash table; detecting whether a next external table exists or not; if the next external table is detected, connecting the next external table with the updated Hash table. Implementing the embodiment enables data transmission among the Hash join operators in a Hash table manner, and database query performance is improved.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a method and device for data transfer between hash join operators. Background technique [0002] The connection statement in SQL (Structured Query Language, Structured Query Language) can connect two or more tables in the database, and the hash connection is the most commonly used connection algorithm for most databases. The hash connection uses the hash table The principle of realizing the equivalence connection of two or more tables is: construct a hash table, that is, select a table with fewer tuples (also known as an inner table) among the two tables to be connected, and store the The tuple uses a hash function and a conflict resolution method to construct a hash table; to detect the hash table, that is, to select the table with more tuples in the two tables as the detection table (also known as the appearance), and to take the Each tuple goes to the built hash table for h...

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
CPCG06F16/2255G06F16/23
Inventor 刘辉军王传廷
Owner HUAWEI TECH CO 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