Processing

Please wait...

Settings

Settings

Goto Application

1. CN112163000 - Data query method and device

Office
China
Application Number 202010901686.7
Application Date 31.08.2020
Publication Number 112163000
Publication Date 01.01.2021
Publication Kind A
IPC
G06F 16/2452
GPHYSICS
06COMPUTING; CALCULATING OR COUNTING
FELECTRIC DIGITAL DATA PROCESSING
16Information retrieval; Database structures therefor; File system structures therefor
20of structured data, e.g. relational data
24Querying
245Query processing
2452Query translation
G06F 16/2455
GPHYSICS
06COMPUTING; CALCULATING OR COUNTING
FELECTRIC DIGITAL DATA PROCESSING
16Information retrieval; Database structures therefor; File system structures therefor
20of structured data, e.g. relational data
24Querying
245Query processing
2455Query execution
CPC
G06F 16/24522
GPHYSICS
06COMPUTING; CALCULATING; COUNTING
FELECTRIC DIGITAL DATA PROCESSING
16Information retrieval; Database structures therefor; File system structures therefor
20of structured data, e.g. relational data
24Querying
245Query processing
2452Query translation
24522Translation of natural language queries to structured queries
G06F 16/2455
GPHYSICS
06COMPUTING; CALCULATING; COUNTING
FELECTRIC DIGITAL DATA PROCESSING
16Information retrieval; Database structures therefor; File system structures therefor
20of structured data, e.g. relational data
24Querying
245Query processing
2455Query execution
Applicants ALIBABA GROUP HOLDING LTD.
阿里巴巴集团控股有限公司
Inventors XU WEIDONG
许伟栋
WU XUDONG
吴旭冬
ZHANG JIANWEI
张建伟
WANG CHEN
王晨
Agents 北京润泽恒知识产权代理有限公司 11319
Title
(EN) Data query method and device
(ZH) 一种数据查询方法和装置
Abstract
(EN) Embodiments of the invention provide a data query method and apparatus. The method comprises the steps of obtaining a query statement; wherein the query statement comprises parameter information; searching a preset template statement matched with the query statement, and obtaining preprocessing information corresponding to the template statement; generating a target execution statement by adoptingthe preprocessing information and the parameter information; and querying target data from a preset database by adopting the target execution statement. Therefore, the query statement sent by the user can be converted into the target execution statement, and the target execution statement is adopted to query the target data in the database, so that the database can directly execute the query taskwithout a statement analysis optimization process, and the query efficiency of the database is improved.
(ZH) 本申请实施例提供了一种数据查询方法和装置,所述方法包括:获取查询语句;其中,所述查询语句包括参数信息;查找与所述查询语句匹配的预设的模板语句,并获取所述模板语句对应的预处理信息;采用所述预处理信息以及所述参数信息,生成目标执行语句;采用所述目标执行语句,向预设的数据库查询目标数据。从而可以将用户发送的查询语句转换为目标执行语句,并采用所述目标执行语句向数据库查询目标数据,从而所述数据库可以无需经过语句解析优化过程,即可直接执行查询任务,提高了数据库的查询效率。
Related patent documents