Computer Science > Artificial Intelligence
[Submitted on 25 Jun 2023]
Title:Utilizing deep learning for automated tuning of database management systems
View PDFAbstract:Managing the configurations of a database system poses significant challenges due to the multitude of configuration knobs that impact various system this http URL lack of standardization, independence, and universality among these knobs further complicates the task of determining the optimal this http URL address this issue, an automated solution leveraging supervised and unsupervised machine learning techniques was this http URL solution aims to identify influential knobs, analyze previously unseen workloads, and provide recommendations for knob this http URL effectiveness of this approach is demonstrated through the evaluation of a new tool called OtterTune [1] on three different database management systems (DBMSs).The results indicate that OtterTune's recommendations are comparable to or even surpass the configurations generated by existing tools or human this http URL this study, we build upon the automated technique introduced in the original OtterTune paper, utilizing previously collected training data to optimize new DBMS this http URL employing supervised and unsupervised machine learning methods, we focus on improving latency this http URL approach expands upon the methods proposed in the original paper by incorporating GMM clustering to streamline metrics selection and combining ensemble models (such as RandomForest) with non-linear models (like neural networks) for more accurate prediction modeling.
Submission history
From: Karthick Prasad Gunasekaran [view email][v1] Sun, 25 Jun 2023 21:50:14 UTC (593 KB)
References & Citations
Bibliographic and Citation Tools
Bibliographic Explorer (What is the Explorer?)
Litmaps (What is Litmaps?)
scite Smart Citations (What are Smart Citations?)
Code, Data and Media Associated with this Article
CatalyzeX Code Finder for Papers (What is CatalyzeX?)
DagsHub (What is DagsHub?)
Gotit.pub (What is GotitPub?)
Papers with Code (What is Papers with Code?)
ScienceCast (What is ScienceCast?)
Demos
Recommenders and Search Tools
Influence Flower (What are Influence Flowers?)
Connected Papers (What is Connected Papers?)
CORE Recommender (What is CORE?)
arXivLabs: experimental projects with community collaborators
arXivLabs is a framework that allows collaborators to develop and share new arXiv features directly on our website.
Both individuals and organizations that work with arXivLabs have embraced and accepted our values of openness, community, excellence, and user data privacy. arXiv is committed to these values and only works with partners that adhere to them.
Have an idea for a project that will add value for arXiv's community? Learn more about arXivLabs.