Search International and National Patent Collections

1. (WO2018177060) QUERY OPTIMIZATION METHOD AND RELATED DEVICE

Pub. No.:    WO/2018/177060    International Application No.:    PCT/CN2018/077425
Publication Date: Fri Oct 05 01:59:59 CEST 2018 International Filing Date: Wed Feb 28 00:59:59 CET 2018
IPC: G06F 17/30
Applicants: HUAWEI TECHNOLOGIES CO., LTD.
华为技术有限公司
Inventors: DENG, Yong
邓勇
LIU, Chenghua
刘成华
YANG, Yidong
杨宜东
ZHU, Wenqi
朱文琦
Title: QUERY OPTIMIZATION METHOD AND RELATED DEVICE
Abstract:
Disclosed in the embodiments of the present application is a query optimization technique. A query optimization method executed by a data access node, comprising: receiving a query request for querying tenant data; searching for a buffered optimal query plan targeted to the query request; if an optimal query plan is found, using the optimal query plan as a target query plan; if no optimal query plan is found, generating a target query plan corresponding to the query request; submitting the target query plan to a database, the target query plan being used by the database to query the tenant data. Compared to the prior art, in the solution provided by the present application, a data access node rather than a database node converts a logical access (query request) into a query plan (physical data access). Moreover, the present invention uses an optimal query plan to perform query and can reduce query costs as much as possible and improve query performance.