Nina S. Mazyavkina
Current Organizations / Institutes
The organizations/institutes from the scholar's latest article
Research Subjects
Nina S. Mazyavkina has a total of 7 co-authors. Here are the top co-authors by number of shared publications:
- Evgeny Burnaev
Skolkovo Institute of Science and Technology
2 shared publications - Artem Mikhaylov
366033 Skolkovo Institute of Science and Technology , 121205 Moscow , Russia
1 shared publication - Ilya Trofimov
Skolkovo Institute of Science and Technology
1 shared publication - Mikhail Salnikov
Artificial Intelligence Research Institute (AIRI), Moscow, Russia
1 shared publication - Qiang Fu
Huawei Technologies Co., Ltd., Moscow, Russia
1 shared publication Sergei Ivanov
1 shared publication
Latest Publications
- Open Access
- 13 July 2022
- Published by Institute of Electrical and Electronics Engineers (IEEE) in IEEE Access
- Vol. 10, 75205-75218
Learned Query Optimizers: Evaluation and Improvement
Query Optimization is considered to be one of the most important challenges in database management. Existing built-in query optimizers are very complex and rely on various approximations and hand-picked rules. The rise of deep learning and deep reinforcement learning has aided many scientific and industrial fields, providing an opportunity to develop a learnable query optimizer. In this paper, we analyse and improve the state-of-the-art learned query optimizer, Neo for the JOB benchmark on two database systems: PostgreSQL and Huawei GaussDB.We describe our methods, based on combination of Neo, Tree-Transformers, auxiliary tasks, reward weighting. Combinations of these methods improve latency of the found query execution plans. We also conduct a thorough analysis of the resulting execution plans and devise a set of decision-based rules to indicate the cases when the learned optimizer will outperform the built-in one. We also provide a source code for the proposed methods and experiments. Finally, we provide possible directions for further improvement in this field.
- 13 July 2022
- Published by Institute of Electrical and Electronics Engineers (IEEE) in IEEE Access
- Vol. 10, 75205-75218
Open AccessLearned Query Optimizers: Evaluation and Improvement
Query Optimization is considered to be one of the most important challenges in database management. Existing built-in query optimizers are very complex and rely on various approximations and hand-picked rules. The rise of deep learning and deep reinforcement learning has aided many scientific and industrial fields, providing an opportunity to develop a learnable query optimizer. In this paper, we analyse and improve the state-of-the-art learned query optimizer, Neo for the JOB benchmark on two database systems: PostgreSQL and Huawei GaussDB.We describe our methods, based on combination of Neo, Tree-Transformers, auxiliary tasks, reward weighting. Combinations of these methods improve latency of the found query execution plans. We also conduct a thorough analysis of the resulting execution plans and devise a set of decision-based rules to indicate the cases when the learned optimizer will outperform the built-in one. We also provide a source code for the proposed methods and experiments. Finally, we provide possible directions for further improvement in this field.
- Top Cited Papers
- 1 October 2021
- Published by Elsevier in Computers & Operations Research
- Vol. 134
Reinforcement learning for combinatorial optimization: A survey
- 1 October 2021
- Published by Elsevier in Computers & Operations Research
- Vol. 134
Top Cited PapersReinforcement learning for combinatorial optimization: A survey