一种基于深度强化学习的数据库查询优化方法

By using a deep reinforcement learning-based approach, the database query optimization problem is transformed into a reinforcement learning task. By leveraging deep neural networks and reinforcement learning algorithms to autonomously select the optimal query execution plan, the performance degradation problem of traditional methods under complex queries and large-scale data is solved, achieving efficient query optimization.

CN117349319BActive Publication Date: 2026-07-17BEIJING INST OF TECH

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
BEIJING INST OF TECH
Filing Date
2023-10-16
Publication Date
2026-07-17

AI Technical Summary

Technical Problem

Traditional database query optimization methods struggle to find the optimal execution plan for complex queries and large-scale data, leading to decreased query performance. Existing technologies cannot effectively handle complex combinatorial optimization problems.

Method used

This paper adopts a deep reinforcement learning-based approach to transform the query optimization problem into a reinforcement learning task. It learns query optimization strategies through deep neural networks, optimizes network parameters by combining reinforcement learning algorithms, and autonomously selects the optimal query execution plan.

Benefits of technology

It improves the performance and efficiency of database queries, achieves adaptive and intelligent query optimization, adapts to different query scenarios and data scales, handles complex query optimization problems, and finds better execution plans.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN117349319B_ABST
    Figure CN117349319B_ABST
Patent Text Reader

Abstract

本发明涉及一种基于深度强化学习的数据库查询优化方法,属于计算机数据库与人工智能技术领域。本方法采用基于深度强化学习技术,通过自主学习和优化,能够针对大规模数据的查询请求,寻找最优查询执行计划,提高数据库查询性能和效率。通过将查询优化问题转化为强化学习任务,智能体根据查询语句和数据库环境的状态,选择最佳的查询执行计划。通过深度神经网络的非线性建模,智能体能够学习复杂的查询优化策略,并根据环境反馈不断改进自己的决策策略。这使得查询优化更具自适应性和智能化,适应不同的查询场景和数据规模,实现了自适应性和智能化的查询优化。本方法具备广阔的应用前景和重要的研究价值。
Need to check novelty before this filing date? Find Prior Art