Re: Impossible Database Design?

From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Tue, 16 May 2006 16:05:13 GMT
Message-ID: <ZKmag.8428$A26.214148@ursa-nb00s0.nbnet.nb.ca>

Nikolai Onken wrote:

> Hey,
>
> I was just wondering if it is possible to create a database design
> where you can have
>
> 1. Infinite repeating events like "every year, every last monday,..."
>
> 2. The possibility to test whether events overlap other events
>
> I would say it is not possible since I would need to run an infinite
> query to catch a singular event..
> Any ideas?
> What would be the 'nearest' approach?
> Cheers,
>
> Nikolai

The word "infinite" renders the answer trivial when dealing with finite computers. Otherwise, I suggest you read the temporal database book by Date, Darwen and Lorenzos. Or Lorenzos' other work. Received on Tue May 16 2006 - 11:05:13 CDT