Outer-Tuning: an Ontology-based Extensible Framework for Supporting Database Automatic Tuning

This paper presents the Outer-Tuning framework, which aims to support the (semi) automatic tuning of relational database systems through a domain-specific ontology. Ontologies have shown themselves to be increasingly promising, adding semantics and standardizing the different terms used in a domain. Thereby, our framework seeks to explain and make explicit the tuning heuristics reasoning while enabling the evaluation of new ontology-inferred methods. In this paper we focus on the main aspects of the Outer-Tuning component-based architecture. We also give an overview of our tool in practice. Finally, we show two useful extensions, concerning new DBMSs and a way of dockerizing into a container.

[1]  Kamsuriah Ahmad,et al.  Query Tuning in Oracle Database , 2012 .

[2]  Nicolas Bruno Automated Physical Database Design and Tuning , 2011, Emerging directions in database systems and applications.

[3]  H. Lan,et al.  SWRL : A semantic Web rule language combining OWL and ruleML , 2004 .

[4]  Ke Zhou,et al.  An End-to-End Automatic Cloud Database Tuning System Using Deep Reinforcement Learning , 2019, SIGMOD Conference.

[5]  Maria Luiza Machado Campos,et al.  An Ontological Perspective for Database Tuning Heuristics , 2019, ER.

[6]  François Goasdoué,et al.  View Selection in Semantic Web Databases , 2011, Proc. VLDB Endow..

[7]  Fernanda Araujo Baião,et al.  Outer-Tuning: an integration of rules, ontology and RDBMS , 2019, SBSI.

[8]  Lakhmi C. Jain,et al.  Design of intelligent multi-agent systems : human-centredness, architectures, learnings and adaptation , 2005 .

[9]  Tao Dai,et al.  A Demonstration of the OtterTune Automatic Database Management System Tuning Service , 2018, Proc. VLDB Endow..

[10]  José Maria Monteiro,et al.  Autonomous re-indexing , 2012, SAC '12.

[11]  Philippe Bonnet,et al.  Database tuning principles, experiments, and troubleshooting techniques , 2004, SGMD.

[12]  Fernanda Araujo Baião,et al.  Tun-OCM: A model-driven approach to support database tuning decision making , 2021, Decis. Support Syst..

[13]  Ralph Johnson,et al.  design patterns elements of reusable object oriented software , 2019 .

[14]  Graham Wood,et al.  Automatic Performance Diagnosis and Tuning in Oracle , 2005, CIDR.