Database query optimization method and device

A query optimization and database technology, applied in the field of database systems, can solve problems such as unoptimizable and unsatisfactory performance, achieve low computing costs, save running time, and improve user experience

Inactive Publication Date: 2018-05-18
INT BUSINESS MASCH CORP
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] However, limited by existing technologies, the performance of the query optimizer is not ideal when performing optimization operations on certain query commands
In particular, when at least two query statements are included in these query commands, the two query statements refer to the same table, and the query result of one query statement is to be obtained based on the query result of the other query statement, the existing query optimizer cannot effectively optimize it

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0032] Some preferred embodiments of the present disclosure are shown in the drawings and will be described in more detail below with reference to the drawings. However, the present disclosure can be implemented in various forms and should not be limited by the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the disclosure to those skilled in the art.

[0033] Those skilled in the art know that various aspects of the present invention can be implemented as a system, method or computer program product. Therefore, various aspects of the present invention can be embodied in the following forms, that is: a complete hardware implementation, a complete software implementation (including firmware, resident software, microcode, etc.), or a combination of hardware and software implementations, These may collectively be referred to herein as "circuits," "modules," or "systems....

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 database query optimization method and equipment. The method includes: receiving a first query command, the first query command includes at least first and second query statements, the second query statement obtains a second query result from a second table, and the first query statement passes the second query statement result and the first filter condition to obtain the first query result from the first table, the first and second tables point to the same basic table in the database; generate the definition statement of the third table based on the second query statement, the third table The table is used to store the third query result, the third query result includes at least one of the first query result and the data value on the record identification column; and the definition statement is used to replace the second query statement, and based on the first Use three tables to rewrite the first query statement, so as to convert the first query command into a second query command. Therefore, the present invention can realize data query operation with lower calculation cost.

Description

technical field [0001] The present invention relates to a database system, and more particularly, to a database query optimization method and device. Background technique [0002] In recent years, with the rapid development of information technology and the market, data management has gradually shown a trend of increasing the total amount of data, and the data format and data type are becoming more and more complex. In order to enable users to quickly obtain the data they need from massive amounts of data, database technology emerges as the times require. [0003] In order to obtain the information required by the user from the database, the user needs to use query commands to complete a series of query operations. Typically, a query command usually includes multiple query statements, which are used to specify the query conditions applicable to one or more data columns in the database, so that when a record (or called, a data row) satisfying the query conditions is found in...

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): G06F17/30
Inventor 李硕杨新颖周祥
Owner INT BUSINESS MASCH CORP
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