Hi Chathuri, This is a very good list. Few suggestions, I think Descriptors and published workflows should be moved outside and right within Gateways. Also each user might have multiple projects and 1 project is owned by a single user. So I think it should be Users and then multiple projects within it.
Suresh On Aug 31, 2012, at 5:02 PM, Chathuri Wimalasena <[email protected]> wrote: > Hi All, > > We had a discussion on how airavata registry data should be categorized and > came up with the following structure. > > Gateway > |- Project1 > | |- Descriptors > | |- Published workflows > | |- User A > | |- unpublished workflows > | |- experiments > | |- workflow > | |- nodes > | > | > | > | > |- Project2 > | |- user A > | > | > > According to the above structure, below table structure was designed for > the mysql database which will be replacing existing backend jackrabbit > database. > > Gateway > gateway_ID > gateway_name > > Projects > gateway_ID > project_ID > > Public_Workflow > project_ID > workflow_name > version > content > published_date > > User_Workflow > project_ID > user_ID > workflow_name > last_update_date > > Host_Descriptor > project_ID > host_descriptor_ID > host_descriptor_xml > > Service_Descriptor > project_ID > service_descriptor_ID > service_descriptor_xml > > Application_Descriptor > project_ID > service_descriptor_ID > host_descriptor_ID > application_descriptor_xml > > Experiment > project_ID > user_ID > experiment_ID > submitted_date > > All suggestions and feedbacks are most welcome. > > Thanks and Regards, > Chathuri
