diff options
| author | Georgios Andreadis <g.andreadis@student.tudelft.nl> | 2018-02-06 11:59:54 +0100 |
|---|---|---|
| committer | Fabian Mastenbroek <mail.fabianm@gmail.com> | 2018-08-14 19:15:20 +0200 |
| commit | 1e7e32cf7c65a5c9138c54495f1cc3f277529dd1 (patch) | |
| tree | 5725373579192bd573c2678e595fb8a7870b61cf /database/schema.sql | |
| parent | dfddb6c25c96598295ad8b50092c9f4dd946e560 (diff) | |
feat: Add GWF conversion script
This change adds a conversion script that allows users to import traces
from the Grid Workload Archive (see http://gwa.ewi.tudelft.nl/) into the
OpenDC database.
Diffstat (limited to 'database/schema.sql')
| -rw-r--r-- | database/schema.sql | 12 |
1 files changed, 5 insertions, 7 deletions
diff --git a/database/schema.sql b/database/schema.sql index 15dbf043..aa0ad1e5 100644 --- a/database/schema.sql +++ b/database/schema.sql @@ -185,11 +185,11 @@ CREATE TABLE jobs ( -- A task that's defined in terms of how many flops (floating point operations) it takes to complete DROP TABLE IF EXISTS tasks; CREATE TABLE tasks ( - id INTEGER PRIMARY KEY NOT NULL AUTO_INCREMENT, - start_tick INTEGER NOT NULL CHECK (start_tick >= 0), - total_flop_count INTEGER NOT NULL, - job_id INTEGER NOT NULL, - parallelizability VARCHAR(50) NOT NULL, + id INTEGER PRIMARY KEY NOT NULL AUTO_INCREMENT, + start_tick INTEGER NOT NULL CHECK (start_tick >= 0), + total_flop_count BIGINT NOT NULL CHECK (total_flop_count >= 0), + core_count INTEGER NOT NULL CHECK (core_count >= 0), + job_id INTEGER NOT NULL, FOREIGN KEY (job_id) REFERENCES jobs (id) ON DELETE CASCADE @@ -236,7 +236,6 @@ CREATE TABLE task_states ( DROP TABLE IF EXISTS machine_states; CREATE TABLE machine_states ( id INTEGER PRIMARY KEY NOT NULL AUTO_INCREMENT, - task_id INTEGER, machine_id INTEGER NOT NULL, experiment_id INTEGER NOT NULL, tick INTEGER NOT NULL, @@ -244,7 +243,6 @@ CREATE TABLE machine_states ( in_use_memory_mb INTEGER, load_fraction REAL CHECK (load_fraction >= 0 AND load_fraction <= 1), - FOREIGN KEY (task_id) REFERENCES tasks (id), FOREIGN KEY (machine_id) REFERENCES machines (id) ON DELETE CASCADE ON UPDATE CASCADE, |