Experiment (ID/name, Status, User)
|
|-----------> Workflow* (Workflow Template Name)
|
Following is the registry data structure from Airavata 0.5 upwards.
Gateway *
|- Descriptors *
|- Published Workflows *
|- Users *
| |- Workspace
| | |- Workflows
| | |- Projects *
| | |- Experiments *
| |
| |
|
|
|
|- Name
|- ---------> Service Node* (name)
|
|-----------> (I/O)* (name, value)
Owner
|
|
* - Denotes many
According to the above structure, below table structure is designed for database.
Gateway
gateway_name
owner
Configuration
config_key
config_val
expire_date
Users
user_name
password
Gateway_Worker
gateway_name
user_name
Project
gateway_name
user_name
project_name
Published_Workflow
gateway_name
created_user
publish_workflow_name
version
published_date
path
workflow_content
User_Workflow
gateway_name
owner
template_name
last_updated_date
path
workflow_graph
Host_Descriptor
gateway_name
updated_user
host_descriptor_ID
host_descriptor_xml
Service_Descriptor
gateway_name
updated_user
service_descriptor_ID
service_descriptor_xml
Application_Descriptor
gateway_name
updated_user
application_descriptor_ID
host_descriptor_ID
service_descriptor_ID
application_descriptor_xml
Experiment
project_name
gateway_name
user_name
experiment_ID
submitted_date
Experiment_Metadata
experiment_ID
metadata
Experiment_Data
experiment_ID
name
user_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
local_Job_ID* - Denotes many