A Survey on Advancing the DBMS Query Optimizer: Cardinality Estimation, Cost Model, and Plan Enumeration

Query optimizer is at the heart of the database systems. Cost-based optimizer studied in this paper is adopted in almost all current database systems. A cost-based optimizer introduces a plan enumeration algorithm to find a (sub)plan, and then uses a cost model to obtain the cost of that plan, and s...

Celý popis

Uloženo v:

Podrobná bibliografie
Vydáno v:	Data Science and Engineering Ročník 6; číslo 1; s. 86 - 101
Hlavní autoři:	Lan, Hai, Bao, Zhifeng, Peng, Yuwei
Médium:	Journal Article
Jazyk:	angličtina
Vydáno:	Singapore Springer Singapore 01.03.2021 Springer Springer Nature B.V
Témata:	Algorithm Analysis and Problem Complexity Algorithms Artificial Intelligence Chemistry and Earth Sciences Computer Science Data Mining and Knowledge Discovery Database Management Economic aspects Enumeration Physics Queries Statistics for Engineering Surveys Systems and Data Security Canada Cardinality estimation Query optimizer Cost model Plan enumeration
ISSN:	2364-1185, 2364-1541
On-line přístup:	Získat plný text
Tagy:	Přidat tag Žádné tagy, Buďte první, kdo vytvoří štítek k tomuto záznamu!

Buďte první, kdo okomentuje tento záznam!