Resources planning in database infrastructures

Eden Dosciatti, Marcelo Teixeira, Richardson Ribeiro, Marco Barbosa, Fábio Favarim, Fabrício Enembreck, Dieky Adzkiya

Research output: Chapter in Book/Report/Conference proceedingConference contributionpeer-review

Abstract

Anticipating resources consumption is essential to project robust database infrastructures able to support transactions to be processed with certain quality levels. In Database-as-a-Service (DBaaS), for example, it could help to construct Service Level Agreements (SLA) to intermediate service customers and providers. A proper database resources assessment can avoid mistakes when choosing technology, hardware, network, client profiles, etc. However, to be properly evaluated, a database transaction usually requires the physical system to be measured, which can be expensive an time consuming. As most information about resource consumption are useful at design time, before developing the whole system, is essential to have mechanisms that partially open the black box hiding the in-operation system. This motivates the adoption of predictive evaluation models. In this paper, we propose a simulation model that can be used to estimate performance and availability of database transactions at design time, when the system is still being conceived. By not requiring real time inputs to be simulated, the model can provide useful information for resources planning. The accuracy of the model is checked in the context of a SLA composition process, in which database operations are simulated and model estimations are compared to measurements collected from a real database system.

Original languageEnglish
Title of host publicationICEIS 2016 - Proceedings of the 18th International Conference on Enterprise Information Systems
EditorsSlimane Hammoudi, Leszek Maciaszek, Leszek Maciaszek, Michele M. Missikoff, Olivier Camp, Jose Cordeiro, Jose Cordeiro
PublisherSciTePress
Pages53-62
Number of pages10
ISBN (Electronic)9789897581878
DOIs
Publication statusPublished - 2016
Externally publishedYes
Event18th International Conference on Enterprise Information Systems, ICEIS 2016 - Rome, Italy
Duration: 25 Apr 201628 Apr 2016

Publication series

NameICEIS 2016 - Proceedings of the 18th International Conference on Enterprise Information Systems
Volume1

Conference

Conference18th International Conference on Enterprise Information Systems, ICEIS 2016
Country/TerritoryItaly
CityRome
Period25/04/1628/04/16

Keywords

  • Availability
  • Modeling
  • Performance
  • Resources planning
  • Simulation

Fingerprint

Dive into the research topics of 'Resources planning in database infrastructures'. Together they form a unique fingerprint.

Cite this