On a Way Together - Database and Machine Learning for Performance Tuning

被引:0
作者
Khosla, Cherry [1 ]
Saini, Baljit Singh [1 ]
机构
[1] Lovely Profess Univ, Sch Comp Sci & Engn, Phagwara, India
来源
2021 INTERNATIONAL CONFERENCE ON COMPUTING SCIENCES (ICCS 2021) | 2021年
关键词
Database Tuning; Machine Learning; Tuning methods; Performance tuning;
D O I
10.1109/ICCS54944.2021.00032
中图分类号
TP18 [人工智能理论];
学科分类号
081104 ; 0812 ; 0835 ; 1405 ;
摘要
Database Management systems are the crucial components in data intensive applications. For efficiently processing and analyzing the data,the database systems should be at par in terms of performance. Tuning the database is nowadays the major goal to improve DBMS's operations.Optimizing the databases to increase the performance and to meet the needs of an application has surpassed the abilities of the humans. Therefore, the researchers have explored how machine learning can be used to tune the databases automatically. In this paper, we have reviewed and discussed various areas of the database tuning, and how machine learning is used to automatically tune the configurations. We have also discussed the various approaches that can be used to integrate the machine learning with database systems. Lastly, we discussed the open problem in tuning database systems.
引用
收藏
页码:123 / 128
页数:6
相关论文
共 41 条
[1]   MacroBase: Prioritizing Attention in Fast Data [J].
Bailis, Peter ;
Gan, Edward ;
Maddens, Samuel ;
Narayanan, Deepak ;
Rong, Kexin ;
Suri, Sahaana .
SIGMOD'17: PROCEEDINGS OF THE 2017 ACM INTERNATIONAL CONFERENCE ON MANAGEMENT OF DATA, 2017, :541-556
[2]  
Bao L, 2018, IEEE INT CONF BIG DA, P181, DOI 10.1109/BigData.2018.8622018
[3]  
Basu Debabrota, 2015, Database and Expert Systems Applications. 26th International Conference, DEXA 2015. Proceedings: LNCS 9261, P253, DOI 10.1007/978-3-319-22849-5_18
[4]  
Bernstein Bernstein P. P., ACM SIGMOD RECORD, V27 27, P74, DOI 10.1145/306101.306137 10.1145/306101.306137
[5]  
Binnig Carsten, 2019, P 2 INT WORKSHOP EXP, P1
[6]  
Chaudhuri S., 1998, SIGMOD Record, V27, P367, DOI 10.1145/276305.276337
[7]  
Chaudhuri S., 2007, P 33 INT C VER LARG, P3
[8]  
Dageville B., 2002, Proceedings of the Twenty-eighth International Conference on Very Large Data Bases, P962
[9]  
Dias K., 2005, CIDR, P84
[10]  
Ding B., 2020, uS Patent App., Patent No. [16/282,116, 16282116]