You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 7
Next »
1. Original schema
1.1. Experiment database
![](/download/attachments/28218931/schema.png?version=1&modificationDate=1586343263934&api=v2)
1.2. List of available experiments (separate database schema)
![](/download/attachments/28218931/scheduler_db.png?version=1&modificationDate=1586352427941&api=v2)
2. Refined schema (step 1)
2.1. Experiment database
- there is no intervals table anymore
- redundant columns in
entry
table where removed scheduler
table no longer keeps info related to MDSPlus
based notation of source dataentry_data
contains column for holding complex data
![](/download/attachments/34476930/schema_step_1.png?version=1&modificationDate=1586937881453&api=v2)
3. Refined schema (step 2)
3.1. Experiment database
- complex types are stored as real and imaginary
- variables contain
ids
in the name instead of cpo
![](/download/attachments/34476930/schema_step_2.png?version=1&modificationDate=1588756753550&api=v2)