A data query method and device, electronic equipment and storage medium
CN116414856BActive Publication Date: 2026-05-29SHANGHAI DAMENG DATABASE
Patent Information
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- SHANGHAI DAMENG DATABASE
- Filing Date
- 2023-03-20
- Publication Date
- 2026-05-29
AI Technical Summary
Technical Problem
In database queries, nested subqueries containing ORDER BY clauses and outer queries with rownum filtering conditions lead to wasted database resources and affect query efficiency.
Method used
By generating a relation spanning tree, the branch to be optimized for the pseudo-column key is determined, and the target pseudo-column filter condition is replaced with the specified condition statement to optimize the query plan.
Benefits of technology
It reduces the transmission of invalid data during database queries, lowers computational costs, and improves query efficiency.
✦ Generated by Eureka AI based on patent content.
Smart Images
Figure CN116414856B_ABST
Abstract
The application discloses a data query method and device, electronic equipment and a storage medium, and specifically relates to the technical field of databases, and particularly relates to a data query method and device, electronic equipment and a storage medium.The method comprises the following steps: generating a relation generation tree of a to-be-optimized query statement based on a preprocessing process; determining a to-be-optimized branch with a pseudo-column keyword in the relation generation tree; and replacing a target pseudo-column filter condition of the to-be-optimized branch based on a specified condition statement to optimize the relation generation tree. Through optimization of an execution plan of a query statement, the application can reduce the amount of invalid data query, reduce the database computing resource overhead, and enhance the operation performance of the database.
Need to check novelty before this filing date? Find Prior Art