Re: Checking data consistency in the context of from-to-dimensions

Hans Mayr wrote:
> Hello,
>
> I was analyzing the problem of logic in connection with ranges like a
> price for a certain article which is valid from a certain date till a
> certain date. Especially in cases where there is not only one from-to-
> dimension but several I found some results quite interesting to me. I
> would like to summarize them here to share my results and to see if I
> get any feedback from experts, any easier solution than the ones I
> found.

<snip>

> My only problem is: This seems pretty complicated for something I
> would consider a standard task of checking data consistency. So does
> anybody have any comments or know an easier way to perform such a
> test?
>
> I am looking forward to your answers.
>
> Best,
>
> Hans

I found what you wrote too long to bother reading entirely. The Lorentzos, Date and Darwen book on Temporal Databases provides a theoretical framework for dealing with intervals and interval type generators. Snodgrass has an earlier book length treatment of the topic in SQL. Received on Sun Jun 28 2009 - 21:53:26 CEST