[Babase] MPI data testing
Susan Alberts
alberts at duke.edu
Fri Jan 8 09:55:00 EST 2010
great news, i will log onto papio and test drive it a bit later today.
thanks
s
On Jan 8, 2010, at 9:28 AM, Lacey Maryott Roerish wrote:
> Hey All,
>
> Since we got the MPI data all uploaded into test, I have been
> trying out some queries to ensure that the structure we came up with
> is conducive to data extraction. Using a couple of queries that I
> came up with as well as some provided by susan, it seems like using
> the MPI_events view, we are able to get everything we want the way
> the data is currently structured!
>
> For example... I asked the db how many requests for help failed...
>
> select count(mpidid) from mpi_events where helped is FALSE;
> of those, I Asked how many were failed due to the fact that the
> actee was unknown
> select count(mpidid) from mpi_events where helped is FALSE and actee
> is null;
>
> (I could have also worded the query in the following way to get the
> same result)
>
> select count(mpidid) from mpi_events where helped is FALSE and
> unkactee is not null;
>
> I also asked things like how many of our MPI's are in the context of
> a consort (228 is the answer)
>
> and there are currently a total of 2409 MPI's in the DB!
>
> At any rate, it seems like we can use the data like we hoped we
> could! yay!
>
> Karl, shall we initiate migration of the data structure over to
> babase, and I will re-upload the data (should only take me about 5
> min)?
>
> Cheers!
> Lacey
> --
> - -
> Lacey K. Maryott Roerish
> Alberts Lab
> Department of Biology
> Duke University
> ph: 919-660-7306
> fax: 919-660-7293
> Lacey.Maryott at duke.edu
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase
------------------------------------------------------------
Susan Alberts, Dept of Biology, Duke University, Box 90338, Durham NC
27708. Phone 919-660-7272, FAX 919-660-7293
More information about the Babase
mailing list