You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Next »

1. Original schema

1.1. Experiment database

1.2. List of available experiments (separate database schema)

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 data
  • entry_data contains column for holding complex data

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 

4. Refined schema (step 3)

4.1. Experiment database

  • scheduler table is now called request
  • all the plural names of tables were changed to singular ones
  • all the indexes are now unified (naming convention is the same across all the indexes)

  • No labels