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

Data query method and device

A data query and table query technology, applied in the database field, can solve problems such as inability to effectively improve query efficiency, inaccurate cost estimation, etc.

Active Publication Date: 2019-07-16
HANGZHOU HIKVISION DIGITAL TECH
View PDF5 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, due to the inaccurate cost estimation of the execution plan, the query efficiency cannot be effectively improved.

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0112] 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.

[0113] In order to improve data query efficiency, the embodiments of the present application provide a data query method and device. refer to figure 1 , figure 1 It is a schematic flowchart of the data query method provided by the embodiment of the present application, and the method can be applied to devices such as servers and storage devices. The method includes:

[0114] Step 101: Obtain a query request;

[0115] Wherein, the query request can be a SQL query statement, such ...

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 provides a data query method and device. The method comprises: acquiring a query request; establishing at least one plan tree according to the query request; determining the cost of each plan tree according to a preset network transmission weight coefficient, an I / O weight coefficient and a CPU calculation weight coefficient; and querying data according to the plantree with the lowest cost. By applying the embodiment of the invention, the data query efficiency is improved.

Description

technical field [0001] The present application relates to the technical field of databases, in particular to a data query method and device. Background technique [0002] With the rapid development of computer technology, electronic data proliferated. In order to quickly query data, data query systems based on Structured Query Language (SQL), such as Google Dremel, Cloudera Impala, Berkeley Shark, Apache Drill, etc., have emerged as the times require. [0003] At present, when using the data query system to query data, the user inputs a query request into the data query system, and the data query system may establish an execution plan based on the query request, and query data according to the execution plan. [0004] When the data query system is querying data, it estimates the cost of the execution plan and determines the best connection sequence of the execution plan, that is, determines the execution plan that consumes the least time, thereby improving query efficiency....

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
IPC IPC(8): G06F16/2453G06F16/245
CPCG06F16/24542G06F16/24553
Inventor 张敢
Owner HANGZHOU HIKVISION DIGITAL TECH