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

Method for remove SQL inquiry statment constant condition

A query statement and condition technology, applied in special data processing applications, instruments, electronic digital data processing, etc., can solve problems such as inability to eliminate, tedious data processing, affecting database query speed, etc., to reduce processing overhead and avoid query processing. Effect

Active Publication Date: 2007-11-21
北京神舟航天软件技术股份有限公司
View PDF0 Cites 14 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] In daily applications, databases often need to process large-scale data. Query is an operation frequently used by users. A complex query statement will cause the database system to perform a large amount of tedious data processing. For example, the complexity of the WHERE condition can greatly affect the performance of the database. query speed
[0003] At present, the known database query optimization technologies cannot eliminate complex WHERE constant conditions at the semantic level, which leads to the query executor needing to use the WHERE condition for filtering when scanning each row of the table, thus greatly increasing the data processing overhead

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
  • Method for remove SQL inquiry statment constant condition
  • Method for remove SQL inquiry statment constant condition
  • Method for remove SQL inquiry statment constant condition

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0021] In the OSCAR database, the parser syntax analysis sub-module converts the SQL query statement in the form of a string into a parse tree structure, and then the analyze semantic analysis sub-module converts the parse tree structure into an internally recognized Query query tree structure, different parts of the SQL statement It is converted into each subtree of the query tree, and then the Optimizer query optimization module optimizes the Query structure, generates an execution plan Plan, and submits it to the Executer module for execution to obtain the query result. The present invention is located in the rule-based optimization sub-module in the Optimizer module.

[0022] The method of the present invention includes three steps shown in Fig. 1: creating linked lists, merging linked lists and rewriting query statements.

[0023] The present invention at first all converts CHECK restriction and WHERE condition into the subtree of query tree, and the tree structure of exp...

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

A method for removing off constant condition of SQL query statement includes setting up chain list, combining chain list and rewriting query statement for effectively removing off constant condition of SQL query statement on semantics grade so as to avoid unnecessary query treatments.

Description

technical field [0001] The invention relates to a method for rewriting an SQL query statement, in particular to a method for removing constant conditions existing in the SQL query statement by using a linked list. Background technique [0002] In daily applications, databases often need to process large-scale data. Query is an operation frequently used by users. A complex query statement will cause the database system to perform a large amount of tedious data processing. For example, the complexity of the WHERE condition can greatly affect the performance of the database. query speed. [0003] At present, the known database query optimization technologies cannot eliminate complex WHERE constant conditions at the semantic level, which leads to the need for query executors to use WHERE conditions for filtering when scanning each row of the table, thereby greatly increasing data processing overhead. If the query optimizer can eliminate some unnecessary WHERE conditions from th...

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
Inventor 郭毅
Owner 北京神舟航天软件技术股份有限公司
Features
  • Generate Ideas
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

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