[InterMine Dev] Questions on production database schema
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?
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.
> 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!
>>> dev mailing list
>>> dev at intermine.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the dev