Nina S. Mazyavkina

Nina S. Mazyavkina

Auto-generated profile, based on publicly available information

Nina S. Mazyavkina

Skolkovo Institute of Science and Technology, Moscow, Russia

Research Focus & Metrics

Academic Career Length

6Years (2021-Present)

(Calculated once Scilit publication data is synced: current year − year of first publication + 1)

Representative Publications

View All Publications
1 October 2021 in Computers & Operations Research
Verified
Journal Article
Closed access
NMNina Mazyavkina
Nina Mazyavkina
SSSergey Sviridov
Sergey Sviridov
SISergei Ivanov
Sergei Ivanov
Evgeny BurnaevEvgeny Burnaev
Evgeny Burnaev

13 July 2022 in IEEE Access
Verified
Journal Article
Open access
AMArtem Mikhaylov
Artem Mikhaylov
NMNina S. Mazyavkina
Nina S. Mazyavkina
MSMikhail Salnikov
Mikhail Salnikov
ITIlya Trofimov
Ilya Trofimov
FQFu Qiang
Fu Qiang
Evgeny BurnaevEvgeny Burnaev
Evgeny Burnaev
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.