Merge branch 'feat/database-metrics' into '2.x'

Add database integration for experimental results

Closes #57

See merge request opendc/opendc-simulator!65

1 files changed, 22 insertions, 0 deletions

diff --git a/opendc/opendc-experiments-sc20/schema.sql b/opendc/opendc-experiments-sc20/schema.sql
new file mode 100644
index 00000000..51990a75
--- /dev/null
+++ b/opendc/opendc-experiments-sc20/schema.sql
@@ -0,0 +1,22 @@
+DROP TABLE IF EXISTS host_reports;
+CREATE TABLE host_reports (
+    id                      BIGSERIAL PRIMARY KEY   NOT NULL,
+    experiment_id           BIGINT                  NOT NULL,
+    time                    BIGINT                  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,
+    image_count             INTEGER                 NOT NULL,
+    server                  TEXT                    NOT NULL,
+    host_state              TEXT                    NOT NULL,
+    host_usage              DOUBLE PRECISION        NOT NULL,
+    power_draw              DOUBLE PRECISION        NOT NULL,
+    total_submitted_vms     BIGINT                  NOT NULL,
+    total_queued_vms        BIGINT                  NOT NULL,
+    total_running_vms       BIGINT                  NOT NULL,
+    total_finished_vms      BIGINT                  NOT NULL
+);