Data query optimization method and device

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

Active Publication Date: 2017-09-15
BEIJING OCEANBASE TECH CO LTD
View PDF5 Cites 19 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

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0035] In order to make the purpose, technical solution and advantages of the present application clearer, the technical solution of the present application will be clearly and completely described below in conjunction with specific embodiments of the present application and corresponding drawings. Apparently, the described embodiments are only some of the embodiments of the present application, rather than all the embodiments. 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] A data query optimization method provided in the embodiment of the present application is applied to relational databases (such as: Oracle, DB2, MySQL, etc. databases), specifically, 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 da...

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] The present application relates to the field of computer technology, in particular to a data query optimization method and device. Background technique [0002] With the development of information technology, the database has been widely used, the amount of data storage is increasing day by day, and the user's query requirements for the data in the database are becoming more and more complex. This requires optimizing the query of the database to ensure the query efficiency and quality of the database when processing a large number of complex query requests. [0003] At present, for a relational database, its optimization process for data query is usually: the database receives a structured query language (Structured Query Language) query request, and generates various execution plans according to the SQL query request (wherein, the execution plan It is a query plan generated by the database for the query request, such as: which 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
IPC IPC(8): G06F17/30
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