Skip to main content
SpringerLink
Log in
Book cover

International Conference on Model and Data Engineering

MEDI 2017: Model and Data Engineering pp 223–231Cite as

Towards an Explicitation and a Conceptualization of Cost Models in Database Systems

  • Conference paper
  • First Online:

Part of the book series: Lecture Notes in Computer Science ((LNPSE,volume 10563))

Abstract

In the database landscape, the mathematical cost models play a crucial role in evaluating non-functional requirements such as the query execution performance, energy consumption, monetary cost estimation. The development of a such cost model is time consuming and requires the knowledge of the whole environment of database systems. Also, cost models are scattered either in scientific papers, usually with fewer details or inside commercial and academic database management systems. Therefore, cost models become a dark entity, because they cannot be easily exploited by researchers and students for learning, analysis or reproduction purposes. In this paper, first we aim to increase the awareness about the darkness of cost models. Secondly, thanks to meta modeling techniques, we explicit the different dimensions of cost models. Persisting the cost models in a repository via a user-friendly interface is also described and stressed through several usage scenarios.

This is a preview of subscription content, 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

Learn about institutional subscriptions

Notes

  1. 1.

    http://www.eclipse.org/cdo.

  2. 2.

    Eclipse Modeling Project. www.eclipse.org/modeling/.

References

  1. Bausch, D., et al.: Making cost-based query optimization asymmetry-aware. In: DaMoN, pp. 24–32. ACM (2012)

    Google Scholar 

  2. Bellatreche, L., Bress, S., Kerkad, A., Boukorca, A., Salmi, C.: The generalized physical design problem in data warehousing environment: towards a generic cost model. In: 2013 36th International Convention on Information & Communication Technology Electronics & Microelectronics (MIPRO), pp. 1131–1137. IEEE (2013)

    Google Scholar 

  3. Bellatreche, L., Cheikh, S., Breß, S., Kerkad, A., Boukhorca, A., Boukhobza, J.: How to exploit the device diversity and database interaction to propose a generic cost model? In: Proceedings of the 17th International Database Engineering & Applications Symposium, pp. 142–147. ACM (2013)

    Google Scholar 

  4. Burns, T., et al.: Reference model for DBMS standardization. SIGMOD Rec. 15(1), 19–58 (1986)

    Article  Google Scholar 

  5. Dayal, U., Kuno, H., Wiener, J.L., Wilkinson, K., Ganapathi, A., Krompass, S.: Managing operational business intelligence workloads. ACM SIGOPS Oper. Syst. Rev. 43(1), 92–98 (2009)

    Article  Google Scholar 

  6. Florescu, D., Kossmann, D.: Rethinking cost and performance of database systems. ACM Sigmod Rec. 38(1), 43–48 (2009)

    Article  Google Scholar 

  7. Fuentes-Fernández, L., Vallecillo-Moreno, A.: An introduction to UML profiles. In: UML and Model Engineering, vol. 2 (2004)

    Google Scholar 

  8. Gardarin, G. et al.: Calibrating the query optimizer cost model of IRO-DB, an object-oriented federated database system. In: VLDB, vol. 96, pp. 3–6 (1996)

    Google Scholar 

  9. O. M. Group. OMG Mof 2 XMI mapping specification. Version 2.4.1 (2011). http://www.omg.org/spec/XMI/2.4.1/. Accessed 06 March 17

  10. Leis, V., et al.: How good are query optimizers, really? Proc. VLDB Endow. 9(3), 204–215 (2015)

    Article  Google Scholar 

  11. Manegold, S., Boncz, P., Kersten, M.L.: Generic database cost models for hierarchical memory systems. In: VLDB, pp. 191–202 (2002)

    Google Scholar 

  12. Obermeier, L.N.P., Nixon, L.: A cost model for querying distributed RDF-repositories with SPARQL. In: Proceedings of the Workshop on Advancing Reasoning on the Web: Scalability and Commonsense Tenerife, Spain (2008)

    Google Scholar 

  13. OMG. Object Constraint Language. OMG available specification. Version 2.0 (2006). www.omg.org/spec/OCL/2.0/. Accessed 06 Apr 16

  14. Roukh, A., Bellatreche, L., Boukorca, A., Bouarar, S.: Eco-DMW: eco-design methodology for data warehouses. In: ACM DOLAP, pp. 1–10. ACM (2015)

    Google Scholar 

  15. Selinger, P.G., et al.: Access path selection in a relational database management system. In: ACM SIGMOD, pp. 23–34. ACM (1979)

    Google Scholar 

  16. Steinberg, D., Budinsky, F., et al.: EMF: eclipse modeling framework. In: Gamma, E., Nackman, L., Wiegand, J. (eds.) The Eclipse Series (2008)

    Google Scholar 

  17. Wu, W., Chi, Y., Zhu, S., et al.: Predicting query execution time: are optimizer cost models really unusable? In: ICDE, pp. 1081–1092. IEEE (2013)

    Google Scholar 

  18. Zhang, N., et al.: Towards cost-effective storage provisioning for DBMSS. Proc. VLDB Endow. 5(4), 274–285 (2011)

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. National High School for Computer Science (ESI), Algiers, Algeria

    Abdelkader Ouared

Authors
  1. Abdelkader Ouared
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Abdelkader Ouared .

Editor information

Editors and Affiliations

  1. ISAE-ENSMA, Chasseneuil, France

    Yassine Ouhammou

  2. University of Novi Sad, Novi Sad, Serbia

    Mirjana Ivanovic

  3. UPC-Barcelona Tech, Barcelona, Spain

    Alberto Abelló

  4. ISAE-ENSMA, Chasseneuil, France

    Ladjel Bellatreche

Rights and permissions

Reprints and permissions

Copyright information

© 2017 Springer International Publishing AG

About this paper

Cite this paper

Ouared, A. (2017). Towards an Explicitation and a Conceptualization of Cost Models in Database Systems. In: Ouhammou, Y., Ivanovic, M., Abelló, A., Bellatreche, L. (eds) Model and Data Engineering. MEDI 2017. Lecture Notes in Computer Science(), vol 10563. Springer, Cham. https://doi.org/10.1007/978-3-319-66854-3_17

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-66854-3_17

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-66853-6

  • Online ISBN: 978-3-319-66854-3

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation