1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
|
-- An experiment represents a collection of portfolios.
DROP TABLE IF EXISTS experiments CASCADE;
CREATE TABLE experiments
(
id BIGSERIAL PRIMARY KEY NOT NULL,
creation_time TIMESTAMP NOT NULL DEFAULT (now())
);
-- A portfolio represents a collection of scenarios tested.
DROP TABLE IF EXISTS portfolios CASCADE;
CREATE TABLE portfolios
(
id BIGSERIAL PRIMARY KEY NOT NULL,
experiment_id BIGINT NOT NULL,
name TEXT NOT NULL,
FOREIGN KEY (experiment_id) REFERENCES experiments (id)
ON DELETE CASCADE
ON UPDATE CASCADE
);
-- A scenario represents a single point in the design space (a unique combination of parameters)
DROP TABLE IF EXISTS scenarios CASCADE;
CREATE TABLE scenarios
(
id BIGSERIAL PRIMARY KEY NOT NULL,
portfolio_id BIGINT NOT NULL,
repetitions INTEGER NOT NULL,
topology TEXT NOT NULL,
workload_name TEXT NOT NULL,
workload_fraction DOUBLE PRECISION NOT NULL,
allocation_policy TEXT NOT NULL,
failures BOOLEAN NOT NULL,
interference BOOLEAN NOT NULL,
FOREIGN KEY (portfolio_id) REFERENCES portfolios (id)
ON DELETE CASCADE
ON UPDATE CASCADE
);
DROP TYPE IF EXISTS run_state CASCADE;
CREATE TYPE run_state AS ENUM ('wait', 'active', 'fail', 'ok');
-- An experiment run represent a single invocation of a trial and is used to distinguish between repetitions of the
-- same set of parameters.
DROP TABLE IF EXISTS runs CASCADE;
CREATE TABLE runs
(
id INTEGER NOT NULL,
scenario_id BIGINT NOT NULL,
seed INTEGER NOT NULL,
state run_state NOT NULL DEFAULT 'wait'::run_state,
submit_time TIMESTAMP NOT NULL DEFAULT (now()),
start_time TIMESTAMP DEFAULT (NULL),
end_time TIMESTAMP DEFAULT (NULL),
PRIMARY KEY (scenario_id, id),
FOREIGN KEY (scenario_id) REFERENCES scenarios (id)
ON DELETE CASCADE
ON UPDATE CASCADE
);
-- Metrics of the hypervisors reported per slice
DROP TABLE IF EXISTS host_metrics CASCADE;
CREATE TABLE host_metrics
(
id BIGSERIAL PRIMARY KEY NOT NULL,
scenario_id BIGINT NOT NULL,
run_id INTEGER NOT NULL,
host_id TEXT NOT NULL,
state TEXT NOT NULL,
timestamp TIMESTAMP NOT NULL,
duration BIGINT NOT NULL,
vm_count INTEGER NOT NULL,
requested_burst BIGINT NOT NULL,
granted_burst BIGINT NOT NULL,
overcommissioned_burst BIGINT NOT NULL,
interfered_burst BIGINT NOT NULL,
cpu_usage DOUBLE PRECISION NOT NULL,
cpu_demand DOUBLE PRECISION NOT NULL,
power_draw DOUBLE PRECISION NOT NULL,
FOREIGN KEY (scenario_id, run_id) REFERENCES runs (scenario_id, id)
ON DELETE CASCADE
ON UPDATE CASCADE
);
DROP INDEX IF EXISTS host_metrics_idx;
CREATE INDEX host_metrics_idx ON host_metrics (scenario_id, run_id, timestamp, host_id);
-- Metrics of the VMs reported per slice
DROP TABLE IF EXISTS vm_metrics CASCADE;
CREATE TABLE vm_metrics
(
id BIGSERIAL PRIMARY KEY NOT NULL,
scenario_id BIGINT NOT NULL,
run_id INTEGER NOT NULL,
vm_id TEXT NOT NULL,
host_id TEXT NOT NULL,
state TEXT NOT NULL,
timestamp TIMESTAMP NOT NULL,
duration BIGINT NOT NULL,
requested_burst BIGINT NOT NULL,
granted_burst BIGINT NOT NULL,
overcommissioned_burst BIGINT NOT NULL,
interfered_burst BIGINT NOT NULL,
cpu_usage DOUBLE PRECISION NOT NULL,
cpu_demand DOUBLE PRECISION NOT NULL,
FOREIGN KEY (scenario_id, run_id) REFERENCES runs (scenario_id, id)
ON DELETE CASCADE
ON UPDATE CASCADE
);
DROP INDEX IF EXISTS vm_metrics_idx;
CREATE INDEX vm_metrics_idx ON vm_metrics (scenario_id, run_id, timestamp, vm_id);
-- Metrics of the provisioner reported per change
DROP TABLE IF EXISTS provisioner_metrics CASCADE;
CREATE TABLE provisioner_metrics
(
id BIGSERIAL PRIMARY KEY NOT NULL,
scenario_id BIGINT NOT NULL,
run_id INTEGER NOT NULL,
timestamp TIMESTAMP NOT NULL,
host_total_count INTEGER NOT NULL,
host_available_count INTEGER NOT NULL,
vm_total_count INTEGER NOT NULL,
vm_active_count INTEGER NOT NULL,
vm_inactive_count INTEGER NOT NULL,
vm_waiting_count INTEGER NOT NULL,
vm_failed_count INTEGER NOT NULL,
FOREIGN KEY (scenario_id, run_id) REFERENCES runs (scenario_id, id)
ON DELETE CASCADE
ON UPDATE CASCADE
);
DROP INDEX IF EXISTS provisioner_metrics_idx;
CREATE INDEX provisioner_metrics_idx ON provisioner_metrics (scenario_id, run_id, timestamp);
|
