Placement of Workloads from Advanced RDBMS Architectures into Complex Cloud Infrastructure

Antony S. Higginson, Clive Bostock, Norman W. Paton, Suzanne M. Embury

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

65 Downloads (Pure)


Capacity planning is an essential activity in the procurement and daily running of any multi-server computer system. Workload placement is a well known problem and there are several solutions to help address capacity planning problems of knowing where, when and how much resource is needed to place workloads of varying shapes (resources consumed). Bin-packing algorithms are used extensively in addressing workload placement problems, however, we propose that extensions to existing bin-packing algorithms are required when dealing with workloads from advanced computational architectures such as clustering
and consolidation (pluggable), or workloads that exhibit complex data patterns in their signals, such as seasonality, trend and/or shocks (exogenous or otherwise). These extentions are especially needed when consolidating workloads together, for example, consolidation of multiple databases into one (pluggable databases) to reduce database server sprawl on estates. In this paper we address bin-packing for singular or clustered environments and propose new algorithms that introduce a time element, giving a richer understanding of the resources requested when workloads are consolidated together, ensuring High Availability (HA) for workloads obtained from advanced database configurations. An experimental evaluation shows that the approach we propose reduces the risk of provisioning wastage in pay-as-you-go cloud architectures.
Original languageEnglish
Title of host publicationProceedings 25th International Conference on Extending Database Technology ( EDBT 2022 )
Publication statusPublished - 23 Mar 2022
Event25th International Conference on Extending Database Technology - Online, United Kingdom
Duration: 29 Mar 20221 Apr 2022

Publication series

NameAdvances in Database Technology
PublisherOpen Proceedings
ISSN (Print)2367-2005


Conference25th International Conference on Extending Database Technology
Abbreviated titleEDBT 2022
Country/TerritoryUnited Kingdom
Internet address


Dive into the research topics of 'Placement of Workloads from Advanced RDBMS Architectures into Complex Cloud Infrastructure'. Together they form a unique fingerprint.

Cite this