Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister

Re^2: modeling overlapping generations

by punkish (Priest)
on Nov 26, 2011 at 18:39 UTC ( #940199=note: print w/ replies, xml ) Need Help??

in reply to Re: modeling overlapping generations
in thread modeling overlapping generations

Sorry, don't have ready access to my sql queries as I am in a cafe for the next several hours. But, the way we store the data are as "periods" which have starting age and ending age. Once again, the following may describe the dataset well -- 'a' lies completely within 'b'. However, 'b' started sometime during 'c' and ended sometime during 'd'. 'c', in turn, lies completely within 'e'... and so on.

I am looking for alternative ways to store such data, and then use Perl to query it so that given a "period", I can find the most nearest period that completely contains it.

If the above is not enough to convey the question clearly, I will submit more information, probably toward the end of the day, or tomorrow, with hopefully some of the sql queries.

when small people start casting long shadows, it is time to go to bed

Comment on Re^2: modeling overlapping generations

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://940199]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (6)
As of 2014-08-21 05:09 GMT
Find Nodes?
    Voting Booth?

    The best computer themed movie is:

    Results (127 votes), past polls