Why are sequenced queries and queries that deal with time periods so difficult to express in current RDBMS?
Related posts:
September 11th, 2006 at 11:44 pm
Why are sequenced queries and queries that deal with time periods so difficult to express in current RDBMS?
Related posts:
This is probably not even germane to what you want, but anyway, here’s my spur of the moment theory.
SQL was constructed not be as expressive as possible but to be human readable by non-S.W. devs, and some functionality had to be left out of the language in order to facilitate this this design decision. Successive iterations of the language have brought it incrementally towards some level of completeness, with a concomitant increase in complexity.
Basically, as far as I can tell SQL works with only atomic data elements (or “points”), not ranges or intervals (or “lines”). There’s no mechanism, that I remember offhand, to express an interval in SQL easily.
Yuck. Just a guess…
Senor Pablo - 14 Sep 06 at 4:48 am
Agreed, sql was only designed or points not ranges, I want it to be more useful working with temporal data because I find myself working with time sequenced data quiet often.
Shey's Rebellion - 14 Sep 06 at 4:08 pm