[InterMine Dev] Questions on production database schema

Julie Sullivan julie at flymine.org
Wed Aug 7 12:40:08 BST 2013


You could count the distinct object IDs in the tracker table by source name.

On 06/08/13 15:01, JD Wong wrote:
> Thanks Julie!
>
> I have a follow up question if you don't mind, do you know if there is a
> way to track the number of records added per source?  I'm interested in
> writing tests to make sure each source is adding the proper number of
> records, even for non-bioentity data types.
>
> Cheers!
> -JD
>
>
> On Mon, Aug 5, 2013 at 6:32 AM, Julie Sullivan <julie at flymine.org
> <mailto:julie at flymine.org>> wrote:
>
>
>     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>
>         <mailto: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>
>              <mailto: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>
>         <mailto: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>
>
>         <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