Evolutionary Multiobjective Query Workload Optimization of Cloud Data Warehouses

Table 12

Proposed paretooptimal VM and network configurations for workload 3.

Solution	Virtual machines	Network type
The most expensive	VM0 = A7; VM1 = A7; VM2 = A7; VM3 = A7; VM4 = A7; VM5 = A7	200 (Mbps)
The cheapest	VM0 = XS; VM1 = XS; VM2 = XS; VM3 = XS; VM4 = XS; VM5 = XS	10 (Mbps)
SHA-1	VM0 = L; VM1 = A7; VM2 = A6; VM3 = XL; VM4 = L; VM5 = M	10 (Mbps)
SHA-2	VM0 = L; VM1 = A7; VM2 = A6; VM3 = XL; VM4 = L; VM5 = M	100 (Mbps)
SHA-3	VM0 = L; VM1 = A7; VM2 = A6; VM3 = XL; VM4 = L; VM5 = M	200 (Mbps)
MOBB-1	VM0 = S; VM1 = XL; VM2 = L; VM3 = XL; VM4 = M; VM5 = M	200 (Mbps)
MOBB-2	VM0 = XS; VM1 = XL; VM2 = XL; VM3 = XL; VM4 = XL; VM5 = S	200 (Mbps)
MOBB-3	VM0 = L; VM1 = A6; VM2 = L; VM3 = M; VM4 = M; VM5 = XS	200 (Mbps)
MOBB-4	VM0 = A7; VM1 = M; VM2 = A6; VM3 = XL; VM4 = A6; VM5 = A6	200 (Mbps)
MOBB-5	VM0 = A6; VM1 = A7; VM2 = L; VM3 = S; VM4 = L; VM5 = A7	200 (Mbps)
MOGA-1	VM0 = M; VM1 = M; VM2 = A6; VM3 = A7; VM4 = A6; VM5 = L	200 (Mbps)
MOGA-2	VM0 = A6; VM1 = A7; VM2 = XS; VM3 = M; VM4 = A6; VM5 = XL	200 (Mbps)
MOGA-3	VM0 = XS; VM1 = XL; VM2 = L; VM3 = XS; VM4 = L; VM5 = L	200 (Mbps)
MOGA-4	VM0 = S; VM1 = L; VM2 = S; VM3 = A7; VM4 = A7; VM5 = XS	200 (Mbps)
MOGA-5	VM0 = M; VM1 = A7; VM2 = M; VM3 = A7; VM4 = L; VM5 = S	200 (Mbps)