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

Data query method and related equipment

A data query and data table technology, applied in the field of data processing, can solve the problem of low efficiency of the data table association query method, and achieve the effect of high query efficiency

Active Publication Date: 2021-08-31
TENCENT TECH (SHENZHEN) CO LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In view of this, this application provides a data query method to solve the technical problem of low efficiency of the existing data table association query method

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 query method and related equipment
  • Data query method and related equipment
  • Data query method and related equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0035] The following will clearly and completely describe the technical solutions in the embodiments of the application with reference to the drawings in the embodiments of the application. Apparently, the described embodiments are only some of the embodiments of the application, not all of them. Based on the embodiments in this application, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the scope of protection of this application.

[0036] Data is usually stored in a database system, and after receiving a data query request, the database system can perform an associated query on two data tables. A commonly used technology for relational query is hash join (HASHJOIN), which is used to process the equivalence relational query of two data tables.

[0037] A data query process based on hash join technology see figure 1 . Such as figure 1 As shown, the two data tables to be queried are Table A and Table B. The ha...

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 present application provides a data query method. After receiving a data query request, the method determines two data tables associated with the request. The two data tables include the first data table and the second data table, and generate a preset number of data tables. A query process, multiple query processes read the data records in the first data table in parallel to generate a hash table, merge the hash tables obtained by different query processes, and multiple query processes read the data records in the second data table in parallel The data record is associated with the merged hash table to obtain the query result. In this query method, the hash table is built in parallel and the matching query is performed on the hash table in parallel, so that the query efficiency is generally higher. In addition, the present application also provides related equipment for data query, so as to ensure the application and realization of the method in practice.

Description

technical field [0001] This application relates to the technical field of data processing, more specifically, a data query method and related equipment. Background technique [0002] In order to facilitate data management, data is usually stored in a database system. If the data in the data table needs to be queried, a data query request can be sent to the database system, and the database can query the target data in the data table according to the data query request. [0003] In some cases, the target data does not come from one data table, but is obtained by associating multiple data tables. The current data table associative query method has low query efficiency. Contents of the invention [0004] In view of this, the present application provides a data query method to solve the technical problem of low efficiency of the existing data table association query method. [0005] In order to achieve said purpose, the technical scheme provided by the application is as foll...

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/245G06F16/22
Inventor 胡森李跃森刘煜宏
Owner TENCENT TECH (SHENZHEN) CO LTD