Data searching method and device

A data query and data table technology, applied in the storage field, can solve the problems of unable to obtain data query results, unable to obtain left outer join results, etc.

Active Publication Date: 2014-01-01
HUAWEI TECH CO LTD
View PDF9 Cites 25 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0008] However, if the above-mentioned left outer connection or right outer connection needs to be used in the data query of the MPP distributed database, for example, the left outer connection needs to be used, then when the database receives the user's data query request, the master node will send the data query request Split into multiple small data query tasks including left outer joins, each slave node performs left outer join according to the small data query tasks, and then the master node will not be able to obtain the correct left Outer join results, and thus the correct data query results cannot be obtained

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
  • Data searching method and device
  • Data searching method and device
  • Data searching method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0085] 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 making creative efforts belong to the protection scope of the present invention.

[0086] see figure 1 , is an example of the network structure of the MPP distributed database, wherein the client 110 where the client is located is connected to the master node 120, the master node 120 is connected to at least one slave node 130 through Ethernet, and the slave nodes 130 are also connected through Ethernet connection. Among them, the nodes in the MPP distributed database, such as master nodes and slave nodes, can be a physical device such as a p...

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 embodiment of the invention discloses a data searching method and device. The method comprises the following steps that a data searching request is received; two data sheets needing splitting in a hashing mode are determined; information of the data sheets is sent to each slave node; corresponding relations, between hashed values and sheet fragmentation files, sent by the slave nodes are received; fragmentation is conducted on the hashed values to acquire hashed value fragments, and the slave nodes corresponding to the hashed value fragments are respectively determined; according to the relations between the hashed values and the sheet fragmentation files, all the nodes are controlled to transfer the sheet fragmentation files; connecting results, corresponding to each hashed value, sent by each slave node are received, and the data search request result is determined according to the connecting result. The data searching method and device can be used for acquiring the correct left outer join or right outer join result and further acquiring the correct data searching result when left outer join or right outer join is used for achieving data searching processing in an MPP distributed type data base system.

Description

technical field [0001] The invention relates to storage technology, in particular to a data query method and device. Background technique [0002] Currently, databases are generally used for data storage. When the user performs data query through the client, the client sends the query keyword entered by the user to the database, and the database performs data query according to the query keyword, and feeds back the query result to the client, and then the client displays the query result to the user. [0003] In currently commonly used stand-alone databases, processing methods such as left outer join and right outer join are often used for data query, and then the result of the data query is determined based on the processing results of the left outer join and right outer join. Among them, the processing objects of the left outer join and the right outer join are two tables, called the left table and the right table respectively, and the connection relationship between the...

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/27G06F16/2455
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