[Babase] MPI data testing
Lacey Maryott Roerish
lroerish4 at gmail.com
Fri Jan 8 09:28:31 EST 2010
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://eeblistserv.Princeton.EDU/pipermail/babase/attachments/20100108/f1677ec4/attachment.html
More information about the Babase
mailing list