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

Device and method for inquiring data

A processing method and processing device technology, applied in the information field, can solve the problems of poor database query performance, complicated and time-consuming process, etc.

Active Publication Date: 2016-07-06
HUAWEI TECH CO LTD
View PDF5 Cites 10 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0014] Through the above execution process, table 1 and table 2 need to be connected multiple times to obtain query results that satisfy the selection conditions for table 1 and table 2 at the same time. The process is very complicated and time-consuming, making the database poor query performance

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 inquiring data
  • Device and method for inquiring data
  • Device and method for inquiring data

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0104] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments It is a part of embodiments of the present invention, but not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of the present invention.

[0105] figure 1 It is a flow chart of Embodiment 1 of the query data processing method of the present invention. like figure 1 As shown, the execution subject of this embodiment is a processing device for querying data, and the processing device can be implemented in the form of software and / or hardware. Preferably, the device can be integrated ...

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 provides a device and method for inquiring data. The method comprises steps of receiving a first connection operation clause,wherein first connection operation clause carries a first selection condition targeting a first data table and a second selection condition for targeting a second data table, determining at least one main key value according to data information in the first selection condition and the first data table, successively obtaining a plurality of candidate items corresponding to the first main key value in a preset regulation indication inqury table according to each first main key value in at least first main key value, wherein each item comprises a first table value and a second table value related to the first table value, and determining a final item according with the first selection condition and the second selection condition according to the second selection condition. The device and method for inquiring data simplifies the inqury process and improves the inqury speed.

Description

technical field [0001] Embodiments of the present invention relate to the field of information technology, and in particular, to a method and device for processing query data. Background technique [0002] In the field of data warehouse and online analytical processing (On-Line Analytical Processing, OLAP for short), fast response to query statements is particularly important. In the field of OLAP, queries need to process G-level, T-level or even P-level data volumes. In the case of such a large amount of data, fast response to queries is required, which poses a great challenge to database processing performance. In a common query statement, a join operation between two data tables is usually included, so improving the speed of the join operation between the data tables is very important for database query performance. [0003] Take the following data sheet Table 1 and Table 2 as examples to illustrate: [0004] Table 1 [0005] [0006] Table 2 [0007] sid ...

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/2456G06F16/24564G06F16/283
Inventor 黄乐时家幸柯亮
Owner HUAWEI TECH CO LTD
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

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

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