数据查询优化方法、装置、设备及存储介质
By combining monitoring data from data nodes in a distributed database to update execution costs, the problem of accuracy in selecting execution plans in a distributed database is solved, achieving more efficient data query optimization.
Patent Information
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- BEIJING BAIDU NETCOM SCI & TECH CO LTD
- Filing Date
- 2023-10-16
- Publication Date
- 2026-07-17
AI Technical Summary
In distributed database scenarios, existing technologies struggle to accurately account for the performance differences of each data node and network transmission costs when determining the appropriate execution plan from multiple execution plans to optimize data queries.
By combining monitoring data from data nodes, the execution costs of candidate execution plans are updated, including processor utilization, network status, network latency parameters, and pending task planning, thus optimizing the cost estimation process of the query optimizer to select the final execution plan.
It improves the accuracy of execution plans and optimizes data queries, ensuring efficient execution at each data node and reducing system response time and resource waste.
Smart Images
Figure CN117421331B_ABST