Title:
METHOD AND DEVICE FOR GENERATING EXECUTION PLAN, AND DATABASE SERVER
Document Type and Number:
WIPO Patent Application WO/2018/157680
Kind Code:
A1
Abstract:
A method for generating an execution plan, the execution plan comprising a first execution sub-plan and a second execution sub-plan. The method comprises: parsing an obtained data manipulation language (DML) statement to determine a first data table, the first data table comprising first data stored in a solid state disk (SSD) medium, and second data stored on a mechanical hard disk (HDD); generating the first execution sub-plan for the first data, the first execution sub-plan comprising reading the first data by means of table scanning; and generating the second execution sub-plan for the second data. In this way, an execution plan which is more in line with data storage characteristics is generated, so that more resourced can be saved when the execution plan is executed.
More Like This:
Inventors:
YANG XINYING (CN)
Application Number:
PCT/CN2018/074034
Publication Date:
September 07, 2018
Filing Date:
January 24, 2018
Export Citation:
Assignee:
HUAWEI TECH CO LTD (CN)
International Classes:
G06F17/30
Domestic Patent References:
| WO2016146057A2 | 2016-09-22 |
Foreign References:
| CN105518674A | 2016-04-20 | |||
| CN101408900A | 2009-04-15 | |||
| CN105243068A | 2016-01-13 |
Download PDF:
Previous Patent: SOUNDING CONTROL METHOD AND ELECTRONIC DEVICE
Next Patent: LOCKS AND WATERPROOF STRUCTURES THEREOF
Next Patent: LOCKS AND WATERPROOF STRUCTURES THEREOF