skip to main content
10.1145/3019612.3019821acmconferencesArticle/Chapter ViewAbstractPublication PagessacConference Proceedingsconference-collections
research-article

MetricStore repository: on the leveraging of performance metrics in databases

Published:03 April 2017Publication History

ABSTRACT

The database performance is one of the most important quality indicators that companies are looking for to choose their appropriate database management systems. Quantifying this performance is usually performed by the means of mathematical cost models. Due to the importance of these models, for each evolution of the database technology pushes researchers to revisit or to propose cost models in order to integrate new dimensions brought by that evolution. As a consequence, a huge number of cost models exists. To exploit them, we need to find their respective scientific papers. This situation is in contradiction with Era Sharing, because it reduces reuse of these cost models by researchers, students (from third world countries), etc. and even more it penalizes the reproduction of experiments that intensively use these cost models. In this paper, we propose a framework for cost models dedicated to query processing and optimization. We first propose a common repository, called, MetricStore, to store metrics of cost model units. Secondly, thanks to model-driven engineering facilities, the repository offers capabilities aiming at publishing, searching and reusing cost models through a suitable user interface. Tool support is fully available.

References

  1. D. Bausch, I. Petrov, et al. Making cost-based query optimization asymmetry-aware. In DaMoN, pages 24--32. ACM, 2012. Google ScholarGoogle ScholarDigital LibraryDigital Library
  2. L. Bellatreche, S. Benkrid, et al. Verification of partitioning and allocation techniques on teradata dbms. In ICA3PP, pages 158--169. Springer, 2011. Google ScholarGoogle ScholarDigital LibraryDigital Library
  3. L. Bellatreche, S. Cheikh, et al. How to exploit the device diversity and database interaction to propose a generic cost model? In Proceedings of the 17th IDEAS, pages 142--147. ACM, 2013. Google ScholarGoogle ScholarDigital LibraryDigital Library
  4. S. Breß, I. Geist, E. Schallehn, M. Mory, and G. Saake. A framework for cost based optimization of hybrid cpu/gpu query plans in database systems. Control and Cybernetics, 41, 2012.Google ScholarGoogle Scholar
  5. T. Burns, E. Fong, and Other. Reference model for dbms standardization. SIGMOD Record, 15(1):19--58, 1986. Google ScholarGoogle ScholarDigital LibraryDigital Library
  6. S. Chaudhuri and V. Narasayya. Self-tuning database systems: a decade of progress. In Proceedings of the 33rd international conference on VLDB, pages 3--14. VLDB Endowment, 2007. Google ScholarGoogle ScholarDigital LibraryDigital Library
  7. S. Chaudhuri and V. R. Narasayya. Autoadmin 'what-if' index analysis utility. In ACM SIGMOD, pages 367--378, 1998. Google ScholarGoogle ScholarDigital LibraryDigital Library
  8. G. Gardarin, F. Sha, and Z.-H. Tang. Calibrating the query optimizer cost model of iro-db, an object-oriented federated database system. In VLDB, volume 96, pages 3--6, 1996. Google ScholarGoogle ScholarDigital LibraryDigital Library
  9. S. Kent. Model driven language engineering. Electr. Notes Theor. Comput. Sci., 72(4):6, 2003. Google ScholarGoogle ScholarCross RefCross Ref
  10. V. Leis, A. Gubichev, and Other. How good are query optimizers, really? PVLDB, 9(3):204--215, 2015. Google ScholarGoogle ScholarDigital LibraryDigital Library
  11. A. Lübcke and Other. A framework for optimal selection of a storage architecture in rdbms. Datorzinātne un informācijas tehnologijas, page 65, 2010.Google ScholarGoogle Scholar
  12. C. Maier, D. Dash, et al. Parinda: an interactive physical designer for postgresql. In EDBT, pages 701--704. ACM, 2010. Google ScholarGoogle ScholarDigital LibraryDigital Library
  13. S. Manegold, P. Boncz, and M. L. Kersten. Generic database cost models for hierarchical memory systems. In VLDB, pages 191--202, 2002. Google ScholarGoogle ScholarDigital LibraryDigital Library
  14. B. Mozafari, E. Z. Y. Goh, and D. Y. Yoon. Cliffguard: A principled framework for finding robust database designs. In Proceedings of the 2015 ACM SIGMOD, pages 1167--1182. ACM, 2015. Google ScholarGoogle ScholarDigital LibraryDigital Library
  15. A. Ouared, Y. Ouhammou, and I. Bellatreche. Costdl: a cost models description language for performance metrics in database. In Proceedings of the 21ST IEEE ICECCS. IEEE, 2016. Google ScholarGoogle ScholarCross RefCross Ref
  16. A. Ouared, Y. Ouhammou, and A. Roukh. A meta-advisor repository for database physical design. In International Conference on MEDI, pages 72--87. Springer, 2016. Google ScholarGoogle ScholarCross RefCross Ref
  17. A. Roukh, L. Bellatreche, et al. Eco-dmw: Eco-design methodology for data warehouses. In ACM DOLAP, pages 1--10. ACM, 2015. Google ScholarGoogle ScholarDigital LibraryDigital Library
  18. P. G. Selinger, M. M. Astrahan, et al. Access path selection in a relational database management system. In ACM SIGMOD, pages 23--34. ACM, 1979. Google ScholarGoogle ScholarDigital LibraryDigital Library
  19. R. Varadarajan, V. Bharathan, et al. Dbdesigner: A customizable physical design tool for vertica analytic database. In IEEE 30th ICDE, pages 1084--1095. IEEE, 2014. Google ScholarGoogle ScholarCross RefCross Ref
  20. A. Wolke and Other. Reproducible experiments on dynamic resource allocation in cloud data centers. ISJ, 52:83--95, 2016. Google ScholarGoogle ScholarDigital LibraryDigital Library
  21. Z. Xu, Y. Tu, and X. Wang. PET: reducing database energy cost via query optimization. PVLDB, 5(12):1954--1957, 2012. Google ScholarGoogle ScholarDigital LibraryDigital Library
  22. N. Zhang, J. Tatemura, et al. Towards cost-effective storage provisioning for dbmss. Proceedings of the VLDB Endowment, 5(4):274--285, 2011. Google ScholarGoogle ScholarDigital LibraryDigital Library

Index Terms

  1. MetricStore repository: on the leveraging of performance metrics in databases

              Recommendations

              Comments

              Login options

              Check if you have access through your login credentials or your institution to get full access on this article.

              Sign in
              • Published in

                cover image ACM Conferences
                SAC '17: Proceedings of the Symposium on Applied Computing
                April 2017
                2004 pages
                ISBN:9781450344869
                DOI:10.1145/3019612

                Copyright © 2017 ACM

                Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

                Publisher

                Association for Computing Machinery

                New York, NY, United States

                Publication History

                • Published: 3 April 2017

                Permissions

                Request permissions about this article.

                Request Permissions

                Check for updates

                Qualifiers

                • research-article

                Acceptance Rates

                Overall Acceptance Rate1,650of6,669submissions,25%

                Upcoming Conference

                SAC '24

              PDF Format

              View or Download as a PDF file.

              PDF

              eReader

              View online with eReader.

              eReader