[InterMine Dev] Questions on production database schema

Julie Sullivan julie at flymine.org
Mon Aug 5 11:32:48 BST 2013


On 02/08/13 21:01, JD Wong wrote:
> Come to think of it, I think this relationship is mapped in the
> bioentitiesdatasets table.

Yes, that's right!

I'm curious, is there another way records
> are mapped to datasets ( besides tracker ), like for non-bioentity classes?

No, not in the core model I don't think.

> Thanks!
> -JD
>
>
> On Fri, Aug 2, 2013 at 1:32 PM, JD Wong <jdmswong at gmail.com
> <mailto:jdmswong at gmail.com>> wrote:
>
>     Thanks Julie, that works well.  It would also be helpful to have the
>     "dataset" object query too if that wouldn't be a problem, just to
>     have that as a reference.
>
>     Cheers,
>     -JD
>
>
>     On Fri, Aug 2, 2013 at 10:34 AM, Julie Sullivan <julie at flymine.org
>     <mailto:julie at flymine.org>> wrote:
>
>         Dataset as in the InterMine "dataset" object? Or are you trying
>         to find out which data parser loaded which object?
>
>         If it's the latter, you can do this:
>
>         select distinct objectid from tracker where source_name = 'uniprot';
>
>         The object id is the InterMine ID.
>
>         The `bag` tables are created when a user makes a list. When the
>         user logs in the list is transferred to the userprofile, I think.
>
>
>         On 02/08/13 15:13, JD Wong wrote:
>
>             Hi Dev,
>
>             I'm looking more closely at my mine's production database,
>             and I was
>             wondering a few things I hope someone here can shed some
>             light on.
>
>             How are dataset tables linked to data, can i write an SQL
>             query along
>             the lines of " which records are in this dataset"?
>
>             There are also a bunch of bag tables like:
>             public | integer_bag_1019                        | table
>               | intermine
>                public | integer_bag_1020                        | table
>                 | intermine
>                public | integer_bag_1021                        | table
>                 | intermine
>                public | integer_bag_228                         | table
>                 | intermine
>                public | integer_bag_229                         | table
>                 | intermine
>                public | integer_bag_231                         | table
>                 | intermine
>
>             there many of these, and for string_bag too, does anyone
>             know what they
>             are for?
>
>             Thank you!
>             -JD
>
>
>             _________________________________________________
>             dev mailing list
>             dev at intermine.org <mailto:dev at intermine.org>
>             http://mail.intermine.org/cgi-__bin/mailman/listinfo/dev
>             <http://mail.intermine.org/cgi-bin/mailman/listinfo/dev>
>
>
>



More information about the dev mailing list