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žené v:

Podrobná bibliografia
Vydané v:	Data Science and Engineering Ročník 6; číslo 1; s. 86 - 101
Hlavní autori:	Lan, Hai, Bao, Zhifeng, Peng, Yuwei
Médium:	Journal Article
Jazyk:	English
Vydavateľské údaje:	Singapore Springer Singapore 01.03.2021 Springer Springer Nature B.V
Predmet:	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 prístup:	Získať plný text
Tagy:	Pridať tag Žiadne tagy, Buďte prvý, kto otaguje tento záznam!

Buďte prvý, kto okomentuje tento záznam!