A method and device for optimizing data query

A data query and optimization method technology, applied in the computer field, can solve problems such as poor practicability

Active Publication Date: 2020-07-28
BEIJING OCEANBASE TECH CO LTD
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0010] The embodiment of the present application provides a data query optimization method to solve the problem of poor practicability in the existing data query optimization process

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
  • A method and device for optimizing data query
  • A method and device for optimizing data query
  • A method and device for optimizing data query

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0035] In order to make the objectives, technical solutions, and advantages of the present application clearer, the technical solutions of the present application will be described clearly and completely in conjunction with specific embodiments of the present application and the corresponding drawings. Obviously, the described embodiments are only a part of the embodiments of the present application, rather than all the embodiments. Based on the embodiments in this application, all other embodiments obtained by those of ordinary skill in the art without creative work fall within the protection scope of this application.

[0036] The method for optimizing data query provided by the embodiments of the present application is applied to relational databases (such as Oracle, DB2, MySQL, etc.), specifically, such as figure 1 As shown, the method specifically includes the following steps:

[0037] S101: Receive a data query request.

[0038] When the user needs to query data, he can send a...

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 discloses a data query optimization method and device. The method comprises the steps that a data query request is received, property information and all data tables of to-be-queried data corresponding to the data query request are determined, sampling is performed in each data table according to the property information, sample data corresponding to all the data tables is obtained, a sample execution plan based on all the sample data is generated according to the sample data, the sample execution plan is executed, sample statistical information for all the sample data is acquired according to the execution result, global statistical information for all the data tables is generated according to the sample statistical information, and according to the global statistical information, an optimal global execution plan is determined among all global execution plans generated according to all the data tables in advance. The method is suitable for query optimization of multiple tables and a single table and high in practicability.

Description

Technical field [0001] This application relates to the field of computer technology, and in particular to an optimization method and device for data query. Background technique [0002] With the development of information technology, databases have been widely used, the amount of data storage is increasing day by day, and users' query requirements for data in the database are becoming more and more complex. This requires optimization of database queries to ensure the query efficiency and quality of the database when processing a large number of complex query requests. [0003] At present, for relational databases, the optimization process for data queries is usually: the database receives a structured query language (Structured Query Language) query request, and according to the SQL query request, generates a variety of execution plans (among which, the execution plan It is a query plan generated by the database in response to a query request, such as: what query algorithm to use,...

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/2453G06F16/28
CPCG06F16/24542G06F16/284
Inventor 李阳
Owner BEIJING OCEANBASE 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