[InterMine Dev] Questions on production database schema

JD Wong jdmswong at gmail.com
Fri Aug 2 21:01:31 BST 2013


Come to think of it, I think this relationship is mapped in the
bioentitiesdatasets table.  I'm curious, is there another way records are
mapped to datasets ( besides tracker ), like for non-bioentity classes?

Thanks!
-JD


On Fri, Aug 2, 2013 at 1:32 PM, JD Wong <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> 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
>>> http://mail.intermine.org/cgi-**bin/mailman/listinfo/dev<http://mail.intermine.org/cgi-bin/mailman/listinfo/dev>
>>>
>>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.intermine.org/pipermail/dev/attachments/20130802/024a5a1e/attachment.html>


More information about the dev mailing list