[ome-devel] List of DB updates

[Chris Allan]

On Tue, Mar 29, 2005 at 11:32:39AM -0500, Ilya Goldberg wrote:
> This is an attempt to finalize a list of DB changes we would like to 
> see in the forthcoming 2.4.1 release.
> Please consider these, prioritize them, suggest which should be 
> implemented in a later release, etc.
> Probably only the first five are seriously needed in 2.4.1.
> 
> * Change CONFIGURATION.VALUE to type text (bug 460).
> * Change ST FilenamePattern.Basename to text to allow storing comma 
> separated values rather than integer (to get the full basename from 
> several RE 'parts').  Requested by Nico Stuurman to support his 
> filename naming scheme from a Beckman screening scope (Bug 484)
> * Add group owner to MODULE_EXECUTIONS, fix bug 469 (attribute 
> ownership inherits from MEX)
> * Not NULL constraint on attribute's MEX column (bug 485).
> * Not NULL constraint on MEX experimenter column (bug 468).
> * ST foreign key constraints for references (PKs already declared) (Bug 
> 486).
> * ST constraints (not NULL, specifically) (Bug 393)
> * Normalize "Plane" and "Stack" STs (i.e. finalize data model).  Use a 
> reference to it for PlaneStatistics.  Do the same for "Stack" ST.  When 
> this is done, convert plane/stack stats to class-per-table.  Clean up 
> back-end code that deals with non-class-per-table.  Consider 
> eliminating table/column specification from STs by adopting a 
> table/column naming convention.
> * USER_STATE => key-value (like CONFIGURATION).  New table with 
> session_id referring to OME_SESSIONS?  If so, remove extra columns from 
> OME_SESSIONS.

By the end of the week we (the Dundee crew) will also have a series of
proposals for Plate, Screen and Well changes which we'd like people to
vet.

> 
> 
> -Ilya

Ciao.

-Chris