Opened 10 years ago

Last modified 10 years ago

#1616 closed task

Clone reporter information to per-experiment tables in the dynamic database — at Initial Version

Reported by: Nicklas Nordborg Owned by: everyone
Priority: critical Milestone: BASE 3.1
Component: core Version:
Keywords: Cc:

Description

The idea is to increase performance issues arising from a large reporter table when joining this with analyzed data in the dynamic database. The cloned table should contain only the reporters that have been used in the experiment. It should be possible to manually synchronize the cloned table with the master table to update the annotations or to add more reporters after adding raw bioassays (that may reference reporters that wasn't referenced before).

This ticket is related to #1280 (Versioned annotations of reporters).

An advanced feature would be to clone only a selected set of reporter annotations. For simplicity reasons and to avoid user confusion an administrator should be responsible for setting up presets that regular users can choose between when setting up the experiment. It should be possible to select a different preset when synchronizing (which means that the existing table needs to be dropped and re-created with the new columns).

Change History (0)

Note: See TracTickets for help on using tickets.