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 #7848 (closed)

Opened 8 years ago

Closed 8 years ago

Project/Dataset model-database investigation

Reported by: ajpatterson Owned by: ajpatterson
Priority: major Milestone: OMERO-4.4
Component: Specification Version: n.a.
Keywords: n.a. Cc: jburel
Resources: n.a. Referenced By: n.a.
References: n.a. Remaining Time: 0.0d
Sprint: 2012-01-31 (7)

Description


Change History (15)

comment:1 Changed 8 years ago by jburel

  • Cc jburel added

comment:2 Changed 8 years ago by ajpatterson

  • Sprint set to 2012-01-31 (7)

comment:3 Changed 8 years ago by ajpatterson

  • Status changed from new to accepted

comment:4 Changed 8 years ago by ajpatterson

[Incorrect point - please ignore]
There is some discrepancy between Dataset objects. In the model it has an experimenter ref and a group ref. In the DB you just have links to an experimenter(owner) but not to a group.

Last edited 8 years ago by ajpatterson (previous) (diff)

comment:5 Changed 8 years ago by ajpatterson

There is some discrepancy between Group objects. In the model it has a leader and a contact. In the DB this might be modelled by groupexperimentermap but I am not sure the behaviour is the same.

comment:6 Changed 8 years ago by ajpatterson

There is some discrepancy between Experimenter objects. In the model the required information is more lax.

comment:7 Changed 8 years ago by ajpatterson

There is some discrepancy between Experiment objects. In the DB you have an experiment number in microbeammanipulation, from the DB I think this should be an experiment ID. Or there should be an experimenter/microbeammanupulation link table.

(Oh this just seams to be a naming issue, the foreign key constraint is correct.)

Last edited 8 years ago by ajpatterson (previous) (diff)

comment:8 Changed 8 years ago by jmoore

Couple of points:

  • Datasets do have a link to group in the DB (datasets.details.group)
  • Group does not have a contact, but does have multiple leaders.
  • microbeammanipulation.experiment is a link. I.e. a ref. What should it be called?

comment:9 Changed 8 years ago by ajpatterson

  • Status changed from accepted to closed

comment:10 Changed 8 years ago by ajpatterson

  • Status changed from closed to reopened

comment:11 Changed 8 years ago by ajpatterson

In some of the DB tables external ID columns are named othertable_id, others are just named othertable.

comment:12 Changed 8 years ago by ajpatterson

  • Remaining Time set to 0.25

comment:13 Changed 8 years ago by ajpatterson

  • Status changed from reopened to accepted

comment:14 Changed 8 years ago by ajpatterson

  • Remaining Time changed from 0.25 to 0.1

comment:15 Changed 8 years ago by ajpatterson

  • Remaining Time changed from 0.1 to 0
  • Resolution set to fixed
  • Status changed from accepted to closed

Differences added to OmeModel/DatabaseComparison

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.83442 sec.)

© 2000-2014 University of Dundee & Open Microscopy Environment. Creative Commons Attribution 3.0 Unported License
OME source code is available under the GNU General public license or through commercial license from Glencoe Software

We're Hiring!