Inferencing Relational Database Tuning Actions with OnDBTuning Ontology
Luciana de Sá Silva Perciliano, Verônica dos Santos, Fernanda Baião, Edward Hermann Hæusler, Sérgio Lifschitz, Ana Carolina Almeida · 2021
OnDBTuning is a relational database (automatic) tuning ontology. Ontologies are software artifacts that represent specific domain knowledge and can infer new knowledge. However, most cases involve only a formal and static description of concepts. Moreover, as database tuning involves many rules-ofthumb and black-box algorithms, it becomes challenging to describe these inference procedures. This research work first presents the OnDBTuning ontology solution focusing on the inference of tuning actions. Next, we provide an actual implementation using SPARQL Inferencing Notation (SPIN). Finally, we discuss a practical evaluation for index recommendation.