A data query method, device, apparatus and storage medium
By introducing the PartitionTopN operator into the query plan, invalid data is filtered out in advance, which solves the problem of high computational cost and resource consumption in traditional query engines when handling TopN query patterns, and achieves efficient data query and system performance optimization.
CN120873013BActive Publication Date: 2026-02-10TIANJIN NANKAI UNIV GENERAL DATA TECH
1 Cites 0 Cited by
Patent Information
- Application Number
- CN202511383480.9
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2025-09-26
- Publication Date
- 2026-02-10
- Estimated Expiration
- 2045-09-26
AI Technical Summary
Technical Problem
Traditional query engines incur high computational costs and consume significant amounts of memory and CPU resources when processing TopN query patterns using window functions, thus impacting system performance and data query efficiency.
Method used
Add the PartitionTopN operator to the plan of the initial query statement to filter invalid data in advance and reduce the amount of data processed by the window operator.
Benefits of technology
Significantly reduce memory usage and CPU resource consumption, optimize data query efficiency, ensure consistent results before and after optimization, and improve overall system performance.
✦ Generated by Eureka AI based on patent content.
Abstract
The application discloses a data query method, device and equipment and a storage medium, and comprises the following steps: when it is identified that a specified element is included in a query statement SQL, a PartitionTopN operator is added at a specified position of an initial plan to obtain a latest plan; original data obtained by executing the latest plan is filtered by using the PartitionTopN operator to obtain effective data; and a query result of a database is determined according to the effective data obtained after filtering. The PartitionTopN operator is added in the initial plan corresponding to the initial query statement SQL, so that invalid data is filtered in advance when the latest plan is executed, the amount of data that needs to be processed by a window operator is greatly reduced, the use of memory and the occupation of CPU resources are reduced, the initial query statement is not changed in the optimization process, the results before and after optimization are consistent, and the efficiency of data query and the overall performance of the system are improved.
Need to check novelty before this filing date? Find Prior Art