Skip to main content
SpringerLink
Log in

An Ontological Perspective for Database Tuning Heuristics

  • Conference paper
  • First Online:
Book cover Conceptual Modeling (ER 2019)

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 11788))

Included in the following conference series:

Abstract

Database tuning is a complex task, involving technology-specific concepts. Although they seem to share a common meaning, there are very specific implementations across different DBMSs vendors and particular releases. Database tuning also involves parameters that are often adjusted empirically based on rules of thumb. Moreover, the intricate relationships among these parameters often pose a contradictory impact on the overall performance improvement goal. Nevertheless, the literature – and practice – on this topic defines a set of heuristics followed by DBAs, which are implemented by the available tuning tools in different ways for specific DBMSs. In this paper, we argue that a semantic support for the implementation of tuning heuristics is crucial for providing DBAs with a higher-level conceptualization, unburdening them from worrying about internal implementations of data access structures in distinct platforms. Our proposal encompasses a set of formally-defined rules based on an ontology, enabling DBAs to define new configuration parameters and to assess the application of tuning heuristics at a conceptual level. We illustrate this proposal with two use case scenarios that show the advantages of this semantic support for the definition and execution of sophisticated DB tuning heuristics, involving hypothetical indexes and what-if situations for relational databases.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Notes

  1. 1.

    https://github.com/BioBD/outer_tuning, last accessed 2019/04/07.

  2. 2.

    https://sparxsystems.com/enterprise_architect_user_guide/14.0/guidebooks/tools_ba_uml_activity_diagram.html, last accessed 2019/04/07.

  3. 3.

    https://www.ime.uerj.br/ontuning/, last accessed 2019/04/07.

  4. 4.

    http://www.inf.puc-rio.br/~postgresql/conteudo/projeto4/download/OntologiaTuning.owl, last accessed 2019/04/07.

References

  1. Shasha, D., Bonnet, P.: Database Tuning: Principles, Experiments, and Troubleshooting Techniques. Morgan Kaufmann Publishers, San Francisco (2003)

    Google Scholar 

  2. OMG (Object Management Group): Common Warehouse Metamodel (CWM) Specification. Version 1.1, vol. 1, No. formal/03-03-02 (2003)

    Google Scholar 

  3. Aguiar, C.Z., Falbo, R.D., Souza, V.E.: Ontological representation of relational databases. In: ONTOBRAS (2018)

    Google Scholar 

  4. Ouared, A., Ouhammou, Y., Roukh, A.: A meta-advisor repository for database physical design. In: Bellatreche, L., Pastor, Ó., Almendros Jiménez, J., Aït-Ameur, Y. (eds.) MEDI 2016. LNCS, vol. 9893, pp. 72–87. Springer, Cham (2016). https://doi.org/10.1007/978-3-319-45547-1_6

    Chapter  Google Scholar 

  5. Ding, Z., Wei, Z., Chen, H.: A software cybernetics approach to self-tuning performance of on-line transaction processing systems. J. Syst. Softw. 124, 247–259 (2017)

    Article  Google Scholar 

  6. Noon, N.N., Getta, J.R.: Automated performance tuning of data management systems with materializations and indices. J. Comput. Commun. 4, 46–52 (2016)

    Article  Google Scholar 

  7. Morelli, E., Almeida, A., Lifschitz, S., Monteiro, J.M., Machado, J.: Autonomous re-indexing. In: Proceedings of the ACM Symposium on Applied Computing (SAC), pp. 893–897 (2012)

    Google Scholar 

  8. Bruno, N., Chaudhuri, S., König, A.C., Narasayya, V., Ramamurthy, R., Syamala, M.: AutoAdmin project at Microsoft research: lessons learned. Bull. IEEE Comput. Soc. Tech. Comm. Data Eng. 34(4), 12–19 (2011)

    Google Scholar 

  9. Rangaswamy, S., Shobha, G.: Online indexing for databases using query workloads. Int. J. Comput. Sci. Commun. 2(2), 427–433 (2011)

    Google Scholar 

  10. Goasdoué, F., Karanasos, K., Leblay, J., Manolescu, I.: View selection in semantic web databases. Proc. VLDB Endow. 5(2), 97–108 (2012)

    Article  Google Scholar 

  11. Basu, D., et al.: Regularized cost-model oblivious database tuning with reinforcement learning. In: Hameurlain, A., Küng, J., Wagner, R., Chen, Q. (eds.) Transactions on Large-Scale Data- and Knowledge-Centered Systems XXVIII. LNCS, vol. 9940, pp. 96–132. Springer, Heidelberg (2016). https://doi.org/10.1007/978-3-662-53455-7_5

    Chapter  Google Scholar 

  12. Bellatreche, L., Schneider, M., Lorinquer, H., Mohania, M.: Bringing together partitioning, materialized views and indexes to optimize performance of relational data warehouses. In: Kambayashi, Y., Mohania, M., Wöß, W. (eds.) DaWaK 2004. LNCS, vol. 3181, pp. 15–25. Springer, Heidelberg (2004). https://doi.org/10.1007/978-3-540-30076-2_2

    Chapter  Google Scholar 

  13. Bouchakri, R., Bellatreche, L.: On simplifying integrated physical database design. In: Eder, J., Bielikova, M., Tjoa, A.M. (eds.) ADBIS 2011. LNCS, vol. 6909, pp. 333–346. Springer, Heidelberg (2011). https://doi.org/10.1007/978-3-642-23737-9_24

    Chapter  Google Scholar 

  14. Bellatreche, L., Khouri, S., Boukhari, I., Bouchakri, R.: Using ontologies and requirements for constructing and optimizing data warehouses. In: Proceedings of International Convention MIPRO, pp. 1568–1573 (2012)

    Google Scholar 

  15. Khouri, S., Bellatreche, L., Boukhari, I., Bouarar, S.: More investment in conceptual designers: think about it! In: Proceedings of the IEEE International Conference on Computational Science and Engineering, pp. 88–93 (2012)

    Google Scholar 

  16. Horrocks, I., Patel-Schneider, P.F., Boley, H., Tabet, S., Grosof, B., Dean, M.: SWRL: a semantic web rule language combining OWL and RuleML. National Research Council of Canada, Network Inference, and Stanford University (2004)

    Google Scholar 

  17. Zhang, B., et al.: A demonstration of the ottertune automatic database management system tuning service. Proc. VLDB Endow. 11(12), 1910–1913 (2018)

    Article  Google Scholar 

  18. Zhang, J., et al.: An end-to-end automatic cloud database tuning system using deep reinforcement learning. In: Proceedings of the 2019 International Conference on Management of Data, pp. 415–432. ACM (2019)

    Google Scholar 

  19. Zheng, C., Ding, Z., Hu, J.: Self-tuning performance of database systems with neural network. In: Huang, D.-S., Bevilacqua, V., Premaratne, P. (eds.) ICIC 2014. LNCS, vol. 8588, pp. 1–12. Springer, Cham (2014). https://doi.org/10.1007/978-3-319-09333-8_1

    Chapter  Google Scholar 

  20. Dias, K., Ramacher, M., Shaft, U., Venkataramani, V., Wood, G.: Automatic performance diagnosis and tuning in oracle. In: Proceedings of CIDR Conference, pp. 84–94 (2005)

    Google Scholar 

  21. Alhadi, N., Ahmad, K.: Query tuning in oracle database. J. Comput. Sci. 8(11), 1889–1896 (2012)

    Article  Google Scholar 

  22. Guizzardi, G.: Ontological foundations for structural conceptual models. Thesis presented in the University of Twente (2005). http://doc.utwente.nl/50826

  23. Guizzardi, G., Wagner, G., de Almeida Falbo, R., Guizzardi, R.S.S., Almeida, J.P.A.: Towards ontological foundations for the conceptual modeling of events. In: Ng, W., Storey, V.C., Trujillo, J.C. (eds.) ER 2013. LNCS, vol. 8217, pp. 327–341. Springer, Heidelberg (2013). https://doi.org/10.1007/978-3-642-41924-9_27

    Chapter  Google Scholar 

  24. Lohman, G., Valentin, G., Zilio, D., Zuliani, M., Skelley, A.: DB2 advisor: an optimizer smart enough to recommend its own indexes. In: Proceedings of the IEEE International Conference on Data Engineering (ICDE), pp. 101–110 (2000)

    Google Scholar 

  25. Bruno, N.: Automated Physical Database Design and Tuning. CRC Press, Boca Raton (2011)

    Book  Google Scholar 

  26. Oliveira, R.P., Baião, F., Almeida, A.C., Schwabe, D., Lifschitz, S.: Outer-tuning: an integration of rules, ontology and RDBMS. In: Proceedings of the Brazilian Symposium on Information Systems (SBSI), Aracaju, Sergipe, Brazil (2019)

    Google Scholar 

  27. O’Connor, M.J., Das, A.K.: SQWRL: a query language for OWL. In: Proceedings of the 5th International Workshop on OWL: Experiences and Directions, OWLED (2009)

    Google Scholar 

  28. Oliveira, R.P.: Ontology-based database tuning: the case of materialized views. Master thesis presented at PUC-Rio, Rio de Janeiro, Brazil (2015)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. State University of Rio de Janeiro (UERJ), Rio de Janeiro, RJ, Brazil

    Ana Carolina Almeida

  2. Federal University of Rio de Janeiro (UFRJ), Rio de Janeiro, RJ, Brazil

    Maria Luiza M. Campos

  3. Pontifical Catholic University of Rio de Janeiro (PUC-Rio), Rio de Janeiro, RJ, Brazil

    Fernanda Baião, Sergio Lifschitz, Rafael P. de Oliveira & Daniel Schwabe

Authors
  1. Ana Carolina Almeida
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Maria Luiza M. Campos
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Fernanda Baião
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Sergio Lifschitz
    View author publications

    You can also search for this author in PubMed Google Scholar

  5. Rafael P. de Oliveira
    View author publications

    You can also search for this author in PubMed Google Scholar

  6. Daniel Schwabe
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Ana Carolina Almeida .

Editor information

Editors and Affiliations

  1. Universidade Federal de Minas Gerais, Belo Horizonte, Brazil

    Alberto H. F. Laender

  2. Politecnico di Milano, Milan, Italy

    Barbara Pernici

  3. Singapore Management University, Singapore, Singapore

    Ee-Peng Lim

  4. Univ Federal do Rio Grande do Sul, Porto Alegre, Brazil

    José Palazzo M. de Oliveira

Rights and permissions

Reprints and permissions

Copyright information

© 2019 Springer Nature Switzerland AG

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Almeida, A.C., Campos, M.L.M., Baião, F., Lifschitz, S., de Oliveira, R.P., Schwabe, D. (2019). An Ontological Perspective for Database Tuning Heuristics. In: Laender, A., Pernici, B., Lim, EP., de Oliveira, J. (eds) Conceptual Modeling. ER 2019. Lecture Notes in Computer Science(), vol 11788. Springer, Cham. https://doi.org/10.1007/978-3-030-33223-5_20

Download citation

  • DOI: https://doi.org/10.1007/978-3-030-33223-5_20

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-030-33222-8

  • Online ISBN: 978-3-030-33223-5

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation