Research Article
Evolutionary Multiobjective Query Workload Optimization of Cloud Data Warehouses
Table 1
Response time and monetary costs of TPC-H query 3 (QP1) with 6 different virtual resource configurations.
| Virtual machine
configuration | Network
bandwidth | Response time (sec.) | Price |
| | 1 × 2 Ghz CPU, 768 MB RAM | 10 Mbps | 57.0 | 0.048 | | 1 × 2 Ghz CPU, 768 MB RAM | 100 Mbps | 16.5 | 0.055 | | 1 × 2 Ghz CPU, 768 MB RAM | 300 Mbps | 15.7 | 0.140 | 4 × 2 Ghz CPU,
8 GB RAM | 10 Mbps | 58.2 | 0.404 | 4 × 2 Ghz CPU,
8 GB RAM | 100 Mbps | 13.5 | 0.128 | 4 × 2 Ghz CPU,
8 GB RAM | 300 Mbps | 13.1 | 0.197 |
|
|
