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.

---

---

• Are you posting in the right place? Check out Where do I post X? to know for sure.
• Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:

  <code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>

• Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
• Want more info? How to link or How to display code and escape characters are good places to start.