Notice: In order to edit this ticket you need to be either: a Product Owner, The owner or the reporter of the ticket, or, in case of a Task not yet assigned, a team_member"

Task #5630 (new)

Opened 9 years ago

Last modified 6 years ago

Nullable (RType) columns

Reported by: jamoore Owned by: spli
Priority: critical Milestone: Unscheduled
Component: General Version: 5.0.5
Keywords: n.a. Cc: szwells
Resources: n.a. Referenced By: n.a.
References: n.a. Remaining Time: 1.0d
Sprint: n.a.

Description

Currently all omero.column types are not nullable. A signpost value (-1, -INF, etc) must be used to mark a null value. Instead, a secondary column per nullable column (or a single "Nulls" matrix for all nullable columns) should be added to the OmeroTables to mark nulls. The values in the columns themselves will be most likely be Ice's default values (0, 0.0) but should be considered UNDEFINED. In reading the data, null RType instances will be inserted into the RType lists.

Change History (3)

comment:1 Changed 6 years ago by jamoore

  • Owner set to spli
  • Version set to 5.0.5

Added this to #1638 after closing #4650

comment:2 Changed 6 years ago by spli

I implemented something similar on the client-side in https://github.com/ome/omero-wndcharm/blob/8c7eecf318c3efee6e77c4941139bd601a43abbc/OmeroWndcharm/TableConnection.py#L379
though it's not actually used.

Doing this server side implies changing the API (or adding new NullableXXXColumns) so the values field of each column returns lists of rtypes instead of primitives e.g. LongColumn?.values will be list(rlong) instead of list(long).

The bigger question is the balance between the Tables API vs the Tables storage format, i.e. Do we actively encourage people to use Tables because it (currently) uses HDF5 so they can download and open it outside OMERO, or is it there as an option but the main purpose is that people access it via OMERO?

comment:3 Changed 6 years ago by jamoore

I would say the latter. I.e. we want to provide an API which provides us flexibility. If users want to then get an HDF5 file, hopefully we can offer it, but most likely they could do it themselves pretty easily.

Note: See TracTickets for help on using tickets. You may also have a look at Agilo extensions to the ticket.

1.3.13-PRO © 2008-2011 Agilo Software all rights reserved (this page was served in: 0.214695 sec.)

We're Hiring!