TY - GEN
T1 - Resources planning in database infrastructures
AU - Dosciatti, Eden
AU - Teixeira, Marcelo
AU - Ribeiro, Richardson
AU - Barbosa, Marco
AU - Favarim, Fábio
AU - Enembreck, Fabrício
AU - Adzkiya, Dieky
N1 - Publisher Copyright:
Copyright © 2016 by SCITEPRESS - Science and Technology Publications, Lda. All rights reserved.
PY - 2016
Y1 - 2016
N2 - 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.
AB - 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.
KW - Availability
KW - Modeling
KW - Performance
KW - Resources planning
KW - Simulation
UR - http://www.scopus.com/inward/record.url?scp=84979587651&partnerID=8YFLogxK
U2 - 10.5220/0005831700530062
DO - 10.5220/0005831700530062
M3 - Conference contribution
AN - SCOPUS:84979587651
T3 - ICEIS 2016 - Proceedings of the 18th International Conference on Enterprise Information Systems
SP - 53
EP - 62
BT - ICEIS 2016 - Proceedings of the 18th International Conference on Enterprise Information Systems
A2 - Hammoudi, Slimane
A2 - Maciaszek, Leszek
A2 - Maciaszek, Leszek
A2 - Missikoff, Michele M.
A2 - Camp, Olivier
A2 - Cordeiro, Jose
A2 - Cordeiro, Jose
PB - SciTePress
T2 - 18th International Conference on Enterprise Information Systems, ICEIS 2016
Y2 - 25 April 2016 through 28 April 2016
ER -