[Babase] ranker again
Susan Alberts
alberts at duke.edu
Mon Oct 9 08:33:44 EDT 2006
Karl, Leah, Tabby,
There is the concern here that neither Leah nor Tabby have ever
really worked with ranker. For a long time we couldn't get ranker to
work at Duke so all of it was done at Princeton. I gather that the
last time females were done in Princeton, Catherine did them. I don't
believe that we used ranker for the males at Duke the last time we
did them -- they were done for us at Princeton, but we have not yet
(sorry to admit this) done the 2005 male ranks so its been a while
even if we did do them.
I think perhaps the best thing is if Leah and Tabby get together and
see what they do and don't understand about ranker. Presumably and
hopefully ranker is well documented and presumably Catherine and
Tabby did some work on this together so we are not starting from
scratch. Given that Leah is leaving soon and we still don't have a
replacement for her, I am not sure how best to optimize her time.
Perhaps she and i can sit down today and talk about this. We
envisioned that we would have substantial overlap but this will not
happen. So, first the two of you should talk and then Leah and I
should talk and then we should go from there.
Susan
>Hi Susan,
>
>I'll go with whatever Leah says. I've worked with ranker exactly
>once and have never considered the rules behind it and am only
>understanding about 1/4 of these emails. If she thinks it's fine,
>then I'm sure I can learn whatever I need to learn, but I really
>don't know enough about this to give a real answer. Sorry!
>
>
>Tabby
>
>Karl O. Pinc wrote:
>>
>>On 10/06/2006 11:56:07 AM, Susan Alberts wrote:
>>>Karl, should you update the rnktypes table with the new types and
>>>remove FYM or can Leah/Tabby do this at this point? I think that
>>>you need to update the definition queries? I am not sure what
>>>these are.
>>
>>Leah/Tabby can do it, and they can update the queries after
>>each conversion run too, although I could do it also if you want me
>>to for some reason.
>>
>>By way of example, here's the old and new RNKTYPES.Query for ALF:
>>
>>Old:
>>SELECT DISTINCT biograph.sname
>> FROM biograph, members
>> WHERE biograph.sname = members.sname
>> AND members.date >= %s
>> AND members.date <= %f
>> AND members.grp = %g
>> AND biograph.sex = "F"
>> AND NOT(EMPTY(matured))
>> AND matured <= %f
>>
>>New:
>>SELECT DISTINCT biograph.sname
>> FROM biograph, members, maturedates
>> WHERE biograph.sname = members.sname
>> AND members.date >= '%s'
>> AND members.date <= '%f'
>> AND members.grp = %g
>> AND biograph.sex = 'F'
>> AND maturedates.sname = biograph.sname
>> AND maturedates.matured <= '%f';
>>
>>(Note that I have gone ahead and put some of the %
>>substitutions inside single quotes because I believe
>>this makes more sense and is simpler for the ranker
>>program to deal with because it won't have to think
>>about what datatype things are and whether or not
>>it needs to put quotes around things. The final
>>design is up to Jun and Dongdong.)
>>
>>Karl <kop at meme.com>
>>Free Software: "You don't pay back, you pay forward."
>> -- Robert A. Heinlein
>>
>>_______________________________________________
>>Babase mailing list
>>Babase at www.eco.princeton.edu
>>http://www.eco.princeton.edu/mailman/listinfo/babase
>
>--
>Tabby Fenn
>Research Assistant
>
>Dept of Ecology and Evolutionary Biology
>401 Guyot Hall
>Princeton University
>Princeton, NJ 08544
>
>609 258-6898 (Ph)
>609 258-2712 (Fx)
>
>_______________________________________________
>Babase mailing list
>Babase at www.eco.princeton.edu
>http://www.eco.princeton.edu/mailman/listinfo/babase
--
--------------------------------------------------------------------------------------------------------------------------------------
Susan Alberts, Department of Biology, Duke University, Box 90338,
Durham NC 27708
919-660-7272 (phone), 919-660-7293 (FAX)
More information about the Babase
mailing list