Invention Grant
- Patent Title: Database query plan selection
-
Application No.: US17391882Application Date: 2021-08-02
-
Publication No.: US11243950B2Publication Date: 2022-02-08
- Inventor: Mengmeng Chen
- Applicant: Beijing OceanBase Technology Co., Ltd.
- Applicant Address: CN Beijing
- Assignee: Beijing OceanBase Technology Co., Ltd.
- Current Assignee: Beijing OceanBase Technology Co., Ltd.
- Current Assignee Address: CN Beijing
- Agency: Fish & Richardson P.C.
- Priority: CN201810551049.4 20180531
- Main IPC: G06F16/2453
- IPC: G06F16/2453 ; G06F16/22 ; G06F16/2452 ; G06K9/62

Abstract:
A computer-implemented database access method includes receiving, by a server, a database access statement including a target identifying parameter; parsing the database access statement to determine the target identifying parameter; determining a statement type of the database access statement; obtaining a pre-stored execution plan group corresponding to the statement type, the pre-stored execution plan group including one or more execution plans for accessing a database corresponding to the database access statement, in which each execution plan corresponds to a different respective identifying parameter; selecting a target execution plan from the pre-stored execution plan group based on the target identifying parameter; and executing the target execution plan.
Public/Granted literature
- US20210365454A1 DATABASE QUERY PLAN SELECTION Public/Granted day:2021-11-25
Information query