Research Article
Evolutionary Multiobjective Query Workload Optimization of Cloud Data Warehouses
Table 2
Response time and monetary costs of TPC-H query 3 (QP2) with 6 different virtual resource configurations.
| Virtual
machine
configuration | Network
bandwidth | Response
time (sec.) | Price |
| | 1 × 2 Ghz CPU, 768 MB RAM | 10 Mbps | 32.5 | 0.027 | | 1 × 2 Ghz CPU, 768 MB RAM | 100 Mbps | 31.2 | 0.104 | | 1 × 2 Ghz CPU, 768 MB RAM | 300 Mbps | 29.6 | 0.263 | 4 × 2 Ghz CPU,
8 GB RAM | 10 Mbps | 14.6 | 0.101 | 4 × 2 Ghz CPU,
8 GB RAM | 100 Mbps | 14.5 | 0.137 | 4 × 2 Ghz CPU,
8 GB RAM | 300 Mbps | 14.3 | 0.215 |
|
|
