Database query method and apparatus, electronic device, and storage medium
By optimizing nested loop joins using caching and dynamic range scans in database queries, the low efficiency of static execution plans and inner table scans is resolved, resulting in more efficient query performance.
CN122173534APending Publication Date: 2026-06-09JINZHUAN INFORMATION TECHNOLOGY CO LTD
Patent Information
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- JINZHUAN INFORMATION TECHNOLOGY CO LTD
- Filing Date
- 2026-01-23
- Publication Date
- 2026-06-09
AI Technical Summary
Technical Problem
Traditional nested loop join algorithms suffer from limitations in static execution plans and low efficiency in scanning inner tables, resulting in poor query performance in database queries.
Method used
By storing the target query information set in the cache, it can determine whether the current query object is within the cached range and query the information in the target set, or dynamically calculate the range of the specified query object for range query, replace the information set in the cache, and optimize the query object range using contour histograms and adaptive values.
Benefits of technology
It improves the efficiency of database queries, reduces the overhead of full table scans, and enhances I/O performance.
✦ Generated by Eureka AI based on patent content.
Smart Images
Figure CN122173534A_ABST
Abstract
The application provides a database query method and device, an electronic device and a storage medium, and the method comprises the following steps: determining a current query object of a driving table; determining whether the current query object is within a current query object range that has been cached, wherein the target queried information set that has been stored in the cache comprises queried information corresponding to any one query object within the current query object range, and the target queried information set is part of the information in the queried table; and in the case that it is determined that the current query object is within the current query object range that has been cached, the target queried information corresponding to the current query object is queried from the target queried information set. Through the application, the technical problem of low database query performance in the related art is solved.
Need to check novelty before this filing date? Find Prior Art