一种子查询抽取方法、装置、电子设备和存储介质
By splitting database query statements into subqueries and extracting common subqueries, the problem of slow query response speed in the database is solved, query efficiency is improved, and computing resources are saved.
CN116049232BActive Publication Date: 2026-07-17HANGZHOU HIKVISION SYST TECH CO LTD
Patent Information
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- HANGZHOU HIKVISION SYST TECH CO LTD
- Filing Date
- 2022-12-27
- Publication Date
- 2026-07-17
AI Technical Summary
Technical Problem
When a large number of SQL queries are received in the database, the data query response speed is slow and the query efficiency is low.
Method used
The target query statement is parsed into a logical plan and broken down into subqueries. The dependencies between the subqueries are determined, and common subqueries are extracted for data retrieval.
Benefits of technology
This reduces the number of subquery statements during the query process, improves the response speed and efficiency of data queries, and reduces the consumption of computing resources.
✦ Generated by Eureka AI based on patent content.
Smart Images
Figure CN116049232B_ABST
Abstract
本申请实施例提供了一种子查询抽取方法、装置、电子设备和存储介质，所述方法应用于数据库管理设备，所述方法包括：获取针对数据库的多个目标查询语句；针对每个目标查询语句，将该目标查询语句解析为逻辑计划，并基于解析得到的逻辑计划的计划内容，将解析得到的逻辑计划拆分为各个子查询语句，作为一组子查询语句；确定各组子查询语句所包括的各个子查询语句之间的依赖关系；根据依赖关系，抽取各组子查询语句中的公共子查询语句。应用本申请实施例，可以提升数据查询的响应速度，提高查询效率。
Need to check novelty before this filing date? Find Prior Art