[jira] [Commented] (AIRAVATA-994) Craft Airavata Execution Management API

[Chathuri Wimalasena (JIRA)]

    [ 
https://issues.apache.org/jira/browse/AIRAVATA-994?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13885462#comment-13885462
 ] 

Chathuri Wimalasena commented on AIRAVATA-994:
----------------------------------------------

Hi Suresh, 

According to Thrift definitions for Experiment, here are the database tables I 
came up with. 

CREATE TABLE EXPERIMENT_METADATA
(
        EXPERIMENT_ID VARCHAR(255) NOT NULL,
        EXPERIMENT_NAME VARCHAR(255) NOT NULL,
        DESCRIPTION VARCHAR(255),
        SUBMITTED_DATE TIMESTAMP DEFAULT CURRENT TIMESTAMP,
        EXECUTION_USER VARCHAR(255),
        GATEWAY_NAME VARCHAR(255),
        SHARE_EXPERIMENT BOOL,
        PRIMARY KEY (EXPERIMENT_ID),
        FOREIGN KEY (GATEWAY_NAME) REFERENCES GATEWAY(GATEWAY_NAME) ON DELETE 
CASCADE,
        FOREIGN KEY (EXECUTION_USER) REFERENCES USERS(USER_NAME) ON DELETE 
CASCADE
);

CREATE TABLE EXPERIMENT_SUMMARY
(
          EXPERIMENT_ID VARCHAR(255),
          STATUS VARCHAR(255),
          LAST_UPDATED_TIME TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
          PRIMARY KEY(EXPERIMENT_ID),
          FOREIGN KEY (EXPERIMENT_ID) REFERENCES 
EXPERIMENT_METADATA(EXPERIMENT_ID) ON DELETE CASCADE
);

CREATE TABLE EXPERIMENT_CONFIGURATION_DATA
(
        EXPERIMENT_ID VARCHAR(255) NOT NULL,
        WORKFLOW_INPUT_KEY VARCHAR (255),
        WORKFLOW_INPUT_VAL VARCHAR (255),
        RESOURCE_HOST_ID VARCHAR (255),
        TOTAL_CPU_COUNT INT(11),
        NODE_COUNT INT(11),
        NUMBER_OF_THREADS INT(11),
        QUEUE_NAME VARCHAR (255),
        WALLTIME_LIMIT INT(11),
        JOB_START_TIME TIMESTAMP DEFAULT '0000-00-00 00:00:00',
        TOTAL_PHYSICAL_MEMORY INT(11),
        COMPUTATIONAL_PROJECT_ACCOUNT VARCHAR(255),
        AIRAVATA_AUTO_SCHEDULE BOOL,
        OVERRIDE_MANUAL_SCHEDULE_PARAMS BOOL,
        WORKING_DIR VARCHAR(255),
        STAGE_INPUT_FILES_TO_WORKING_DIR BOOL,
        OUTPUT_DATA_DIR VARCHAR(255),
        DATA_REG_URL VARCHAR (255),
        PERSIST_OUTPUT_DATA BOOL,
        CLEAN_AFTER_JOB BOOL,
        EXPERIMENT_CONFIG_DATA BLOB,
        PRIMARY KEY (EXPERIMENT_ID),
        FOREIGN KEY (EXPERIMENT_ID) REFERENCES 
EXPERIMENT_METADATA(EXPERIMENT_ID) ON DELETE CASCADE
);

Please give feedback. I will start working on OpenJPA mapping objects then. 


> Craft Airavata Execution Management API 
> ----------------------------------------
>
>                 Key: AIRAVATA-994
>                 URL: https://issues.apache.org/jira/browse/AIRAVATA-994
>             Project: Airavata
>          Issue Type: Sub-task
>          Components: Airavata API
>            Reporter: Suresh Marru
>             Fix For: 1.0
>
>




--
This message was sent by Atlassian JIRA
(v6.1.5#6160)