This is a good list. Based on the list, I slightly modified to make sure we
cover all the scenarios Airavata gets used in. Here is a modified list:
Experiment_Data
experiment_ID
experiment_name
experiment_desc
user_id (I did not see any other place where we have the handle to the owner)
Workflow_Data
experiment_ID
workflow_instanceID;
workflow_template_name;
start_time;
last_known_workflow_status;
last_update_time;
Node_Data
workflow_instanceID;
node_id;
node_type;
job_desc;
inputs;
outputs;
last_known_node_status;
start_time;
last_update_time*;
Job_Data*
workflow_instanceID;
node_id;
job_desc;
computational_host;
local_job_id;
working_directory;
last_known_node_status;
last_update_time*;
Comments, Barps??
Suresh
On Aug 22, 2012, at 4:50 PM, Lahiru Gunathilake <[email protected]> wrote:
>>
>> Hi All,
>>
>
> I think we need to remove rsl data from Node_data table and put them in to
> Gram_data table.
>
> So please find the correct structure below.
>
>
>> Experiment_Data
>> experiment_ID;
>> name;
>>
>> Workflow_Data
>> experiment_ID
>> workflow_instanceID;
>> template_name;
>> status;
>> start_time*;
>> last_update_time;
>>
>> Node_Data
>> workflow_instanceID;
>> node_id;
>> node_type;
>> inputs;
>> outputs;
>> status*;
>> start_time*;
>> last_update_time*;
>>
>> Gram_Data*
>> workflow_instanceID;
>> node_id;
>> rsl;
>> invoked_host;
>>
>> Lahiru
>
>
>
> --
> System Analyst Programmer
> PTI Lab
> Indiana University
