[Babase] Proofing CYCLES

Catherine Markham amarkham at princeton.edu
Tue May 30 13:41:44 EDT 2006


Hi Karl,

I've gotten back into the proofing today and wanted to follow-up on the 
views we talked about over the weekend.  I took at quick look at 
CYCPOINTS_CYCLES after talking/reading your email.  This is similar to 
the old CYCLES, but not quite what I was looking for.

Am I missing something?  Would it be hard to set up something that 
looked exactly like the old CYCLES?  In particular, I find it really 
helpful to have one row for each cid, so columns are sname, seq, mdate, 
tdate, ddate, etc.

Also, do you want to talk in next hour or so?  If you're free, I'm at 
the point now where it would help to touch base again and plan the next 
step.

Thanks,
Catherine

>> P.S.  Nearly forgot - how difficult would it be to create a table in  
>> the new system from CYCPOINTS that looks like the old CYCLES?  Would  
>> be quite helpful, but no problem if it is troublesome to do.
> 
> 
> There is already a view for that:
> 
> select * from CYCPOINTS_CYCLES;
> 
> I hesitated before making that view because I think it's something of
> a crutch and working with CYCLES and CYCPOINTS themselves allows
> for more powerful queries.  But I decided to because I wanted an
> easy introduction, otherwise working with sexual cycle information
> might be too hard for the novice.  Check out the other views,
> particularly MATERNITIES and ACTOR_ACTEES and see what you
> think regards introducing people to the system.
> Feel free to make a list if you think there should be
> others.  (You can actually make your own views in the sandbox
> schema for everybody to use, but if everybody really is using
> them then we ought to move them into Babase itself so they
> can be part of the official documention.)
> 
> The one problem with the views is that they don't show up
> in the ER diagrams that give an overview of how to link
> things.  I don't know exactly what to do about this,
> there seem to be too many different diagrams they might
> show up in.  Apparently there's a way to draw in the wiki,
> maybe the answer is to have you guys draw what you need?
> The people who enter data need to understand the underlying
> database.  Everybody else can have their life made easy
> with views etc.
> 
> 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


More information about the Babase mailing list