dissertation · OpenMETU (Middle East Technical University) · 2019
A C++ implementation and evoluation of alternative plan generation methods for multiple query optimization
Abudula, Dilixiati
Cited by 0Open access
Abstract
In this thesis, alternative plan generation methods for multiple query optimization(MQO) are introduced and an implementation in the C++ programming.language has been developed. Multiple query optimization, aims to minimize the total cost of executing a set of relational database queries. In traditional single query optimization only the cost of execution of a single relational database query is minimized. In single query optimization a search is performed to investigate possible alternative methods of accessing relational database tables and alternative methods of performing join operations in the case of multi-relation queries where records from two or more relational tables have to be brought together using one of the join algortihms (e.g. nested loops, sort merge, hash join,etc). The choice of join method depends on the availability of indexes, amount of available main memory, the existence of ORDER BY clause for sorted output, the sizes of involved relations, many other factors. A simple way of performing multiple query optimization is to take the query execution plans generated for each of the queries as input to a MQO algorithm, and then try to identify common tasks in those plans using the MQO algorithm. However, this approach will reduce the achievable benefits since a more expensive execution plan (thus discarded by a single query optimizer) could have more common operations with other query execution plans, resulting in a lower total cost for MQO. .For this purpose we will introduce several methods for generating such potentially beneficial alternative query execution plans and experimentaly evaluate and compare their performances.
Cite this paper
Abudula, D. (2019). A C++ implementation and evoluation of alternative plan generation methods for multiple query optimization. OpenMETU (Middle East Technical University).
Abudula, Dilixiati. “A C++ implementation and evoluation of alternative plan generation methods for multiple query optimization.” OpenMETU (Middle East Technical University), 2019.
Abudula, Dilixiati. 2019. “A C++ implementation and evoluation of alternative plan generation methods for multiple query optimization.” OpenMETU (Middle East Technical University).
Abudula, D. (2019) ‘A C++ implementation and evoluation of alternative plan generation methods for multiple query optimization’, OpenMETU (Middle East Technical University).
@phdthesis{abudula2019implementation,
title = {{A C++ implementation and evoluation of alternative plan generation methods for multiple query optimization}},
author = {Abudula, Dilixiati},
school = {OpenMETU (Middle East Technical University)},
year = {2019}
}Made from the index record. Check names, capitalisation and page numbers against the paper. Need another style? AI for Research has over 10,000.