Difference between revisions of "CSEP1 Status"

From SCECpedia
Jump to navigationJump to search
Line 3: Line 3:
  
 
== Introduction ==
 
== Introduction ==
The CSEP1 system has been in production for over a decade with dozens of models running prospectively during this time period. Currently, we do not have an understanding of the status of the operational system with respect to missing forecasts and their evaluations. This page outlines our work towards understanding the status of the CSEP1 operational system.  
+
The CSEP1 system has been in production for over a decade with dozens of models running prospectively during this time period. Currently, we do not have an understanding of the status of the operational system with respect to missing forecasts and their evaluations. This page provides the status of the CSEP1 system and outlines our work toward understanding the status of the CSEP1 operational system.  
  
The operational system
+
== CSEP1 Data Model ==
 +
CSEP1 simulation meta data represented as SQL schema.
 +
 
 +
    CREATE TABLE IF NOT EXISTS ScheduledForecasts (
 +
        scheduled_forecast_id INTEGER PRIMARY KEY,
 +
        date_time TEXT NOT NULL
 +
    );
 +
 
 +
    CREATE TABLE IF NOT EXISTS ScheduledEvaluations (
 +
        scheduled_evaluation_id INTEGER PRIMARY KEY,
 +
        date_time TEXT NOT NULL
 +
    );
 +
 
 +
    CREATE TABLE IF NOT EXISTS Dispatchers (
 +
        dispatcher_id INTEGER PRIMARY KEY,
 +
        script_name TEXT NOT NULL,
 +
        config_file_name TEXT NOT NULL
 +
    );
 +
 
 +
    CREATE TABLE IF NOT EXISTS ForecastGroups (
 +
        forecastgroup_id INTEGER PRIMARY KEY,
 +
        group_name TEXT NOT NULL,
 +
        config_filepath TEXT NOT NULL,
 +
        dispatcher_id INTEGER NOT NULL,
 +
        FOREIGN KEY(dispatcher_id) REFERENCES Dispatchers
 +
    );
 +
 
 +
    CREATE TABLE IF NOT EXISTS Forecasts (
 +
        forecast_id INTEGER PRIMARY KEY,
 +
        schedule_id INTEGER NOT NULL,
 +
        group_id INTEGER NOT NULL,
 +
        name TEXT NOT NULL,
 +
        filepath TEXT,
 +
        meta_filepath TEXT,
 +
        waiting_period TEXT,
 +
        logfile TEXT,
 +
        status TEXT,
 +
        FOREIGN KEY(schedule_id) REFERENCES ScheduledForecasts,
 +
        FOREIGN KEY(group_id) REFERENCES ForecastGroups
 +
    );
 +
 
 +
    CREATE TABLE IF NOT EXISTS Evaluations (
 +
        evaluation_id INTEGER PRIMARY KEY,
 +
        scheduled_id INTEGER NOT NULL,
 +
        forecast_id INTEGER NOT NULL,
 +
        compute_datetime TEXT,
 +
        filepath TEXT,
 +
        name TEXT,
 +
        status TEXT,
 +
        FOREIGN KEY(scheduled_id) REFERENCES ScheduledEvaluations,
 +
        FOREIGN KEY(forecast_id) REFERENCES Forecasts
 +
    );

Revision as of 19:27, 4 June 2018

CSEP Working Group Home Page

Introduction

The CSEP1 system has been in production for over a decade with dozens of models running prospectively during this time period. Currently, we do not have an understanding of the status of the operational system with respect to missing forecasts and their evaluations. This page provides the status of the CSEP1 system and outlines our work toward understanding the status of the CSEP1 operational system.

CSEP1 Data Model

CSEP1 simulation meta data represented as SQL schema.

   CREATE TABLE IF NOT EXISTS ScheduledForecasts (
       scheduled_forecast_id INTEGER PRIMARY KEY,
       date_time TEXT NOT NULL
   );
   CREATE TABLE IF NOT EXISTS ScheduledEvaluations (
       scheduled_evaluation_id INTEGER PRIMARY KEY,
       date_time TEXT NOT NULL
   );
   CREATE TABLE IF NOT EXISTS Dispatchers (
       dispatcher_id INTEGER PRIMARY KEY,
       script_name TEXT NOT NULL,
       config_file_name TEXT NOT NULL
   );
   CREATE TABLE IF NOT EXISTS ForecastGroups (
       forecastgroup_id INTEGER PRIMARY KEY,
       group_name TEXT NOT NULL,
       config_filepath TEXT NOT NULL,
       dispatcher_id INTEGER NOT NULL,
       FOREIGN KEY(dispatcher_id) REFERENCES Dispatchers
   );
   CREATE TABLE IF NOT EXISTS Forecasts (
       forecast_id INTEGER PRIMARY KEY,
       schedule_id INTEGER NOT NULL,
       group_id INTEGER NOT NULL,
       name TEXT NOT NULL,
       filepath TEXT,
       meta_filepath TEXT,
       waiting_period TEXT,
       logfile TEXT,
       status TEXT,
       FOREIGN KEY(schedule_id) REFERENCES ScheduledForecasts,
       FOREIGN KEY(group_id) REFERENCES ForecastGroups
   );
   CREATE TABLE IF NOT EXISTS Evaluations (
       evaluation_id INTEGER PRIMARY KEY,
       scheduled_id INTEGER NOT NULL,
       forecast_id INTEGER NOT NULL,
       compute_datetime TEXT,
       filepath TEXT,
       name TEXT,
       status TEXT,
       FOREIGN KEY(scheduled_id) REFERENCES ScheduledEvaluations,
       FOREIGN KEY(forecast_id) REFERENCES Forecasts
   );