Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Create experiment meta data table/tables. #1

Open
slawrence87544 opened this issue May 17, 2022 · 0 comments
Open

Create experiment meta data table/tables. #1

slawrence87544 opened this issue May 17, 2022 · 0 comments
Assignees
Labels
enhancement New feature or request

Comments

@slawrence87544
Copy link
Collaborator

In order to help track experiments and experiment settings, we will create two tables; a experiment registration table, an experiment settings table, and an experiment metrics table.

The experiment registration table will be comprised of at least the following columns
Experiment id (primary key integer or big integer auto incrementing)
Experiment name (str 64 to 128 char)
Experiment start (datetime)
Experiment end (datetime)
OwnerId (str 64, example: Henry Winterbottom)
GroupId (str 16, example: 'FMD'
ExperimentType (str: )
Wallclock StartTime (datetime)
Wallclock EndTime (datetime)
Platform (str: example 'hera', 'orion', 'azv1-pw', 'awv2-pw')
Experiment Description

Experiment configuration table
ExperimentID (foreign key from experiment registration table)
Namespace (str: lowercase setting grouping)
Name (str: lowercase setting name)
type (str: data type of value, i.e. string, integer, float, json object?)
value (str: representation of setting value, numbers will be represented by strings)
insertedAt

Experiment metrics table
ExperimentID (foreign key from exp reg table)
namespace
name
type
name
metric_valid_time
value
source_filename
insertedAt

@slawrence87544 slawrence87544 added the enhancement New feature or request label May 17, 2022
@slawrence87544 slawrence87544 self-assigned this May 17, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant