[ome-devel] List of DB updates
Chris Allan
callan at blackcat.ca
Tue Mar 29 19:29:57 BST 2005
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
More information about the ome-devel
mailing list