在一起的路上-数据库和机器学习的性能调优

Cherry Khosla, B. Saini
{"title":"在一起的路上-数据库和机器学习的性能调优","authors":"Cherry Khosla, B. Saini","doi":"10.1109/ICCS54944.2021.00032","DOIUrl":null,"url":null,"abstract":"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.","PeriodicalId":340594,"journal":{"name":"2021 International Conference on Computing Sciences (ICCS)","volume":"21 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2021-12-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"On a Way Together - Database and Machine Learning for Performance Tuning\",\"authors\":\"Cherry Khosla, B. Saini\",\"doi\":\"10.1109/ICCS54944.2021.00032\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"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.\",\"PeriodicalId\":340594,\"journal\":{\"name\":\"2021 International Conference on Computing Sciences (ICCS)\",\"volume\":\"21 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2021-12-01\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"2021 International Conference on Computing Sciences (ICCS)\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1109/ICCS54944.2021.00032\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"2021 International Conference on Computing Sciences (ICCS)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/ICCS54944.2021.00032","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 0

摘要

数据库管理系统是数据密集型应用程序的关键组件。为了有效地处理和分析数据,数据库系统应该在性能方面达到同等水平。调优数据库是目前改善DBMS操作的主要目标。优化数据库以提高性能并满足应用程序的需求已经超出了人类的能力。因此,研究人员已经探索了如何使用机器学习来自动调优数据库。在本文中,我们回顾并讨论了数据库调优的各个领域,以及如何使用机器学习来自动调优配置。我们还讨论了可用于将机器学习与数据库系统集成的各种方法。最后,我们讨论了调优数据库系统中的开放问题。
本文章由计算机程序翻译,如有差异,请以英文原文为准。
On a Way Together - Database and Machine Learning for Performance Tuning
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.
求助全文
通过发布文献求助,成功后即可免费获取论文全文。 去求助
来源期刊
自引率
0.00%
发文量
0
×
引用
GB/T 7714-2015
复制
MLA
复制
APA
复制
导出至
BibTeX EndNote RefMan NoteFirst NoteExpress
×
提示
您的信息不完整,为了账户安全,请先补充。
现在去补充
×
提示
您因"违规操作"
具体请查看互助需知
我知道了
×
提示
确定
请完成安全验证×
copy
已复制链接
快去分享给好友吧!
我知道了
右上角分享
点击右上角分享
0
联系我们:info@booksci.cn Book学术提供免费学术资源搜索服务,方便国内外学者检索中英文文献。致力于提供最便捷和优质的服务体验。 Copyright © 2023 布克学术 All rights reserved.
京ICP备2023020795号-1
ghs 京公网安备 11010802042870号
Book学术文献互助
Book学术文献互助群
群 号:481959085
Book学术官方微信