Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.media.kyoto-u.ac.jp!newsfeed.news2me.com!wns13feed!worldnet.att.net!207.35.177.252!nf3.bellglobal.com!ursa-nb00s0.nbnet.nb.ca!53ab2750!not-for-mail From: Bob Badour User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.2) Gecko/20040804 Netscape/7.2 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 Newsgroups: comp.databases.theory Subject: Re: Impossible Database Design? References: <1147793576.656483.275490@j73g2000cwa.googlegroups.com> <1147795937.343358.117380@u72g2000cwu.googlegroups.com> In-Reply-To: <1147795937.343358.117380@u72g2000cwu.googlegroups.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Lines: 23 Message-ID: Date: Tue, 16 May 2006 16:20:56 GMT NNTP-Posting-Host: 142.176.114.132 X-Complaints-To: abuse@aliant.net X-Trace: ursa-nb00s0.nbnet.nb.ca 1147796456 142.176.114.132 (Tue, 16 May 2006 13:20:56 ADT) NNTP-Posting-Date: Tue, 16 May 2006 13:20:56 ADT Organization: Sympatico-Subscriber Xref: dp-news.maxwell.syr.edu comp.databases.theory:39588 Nikolai Onken wrote: > Well though there are calendar applications which support 'infinite' > entries... Not really. I have yet to see one that uses an infinite representation for time, which means they are inherently finite. > Only that would mean that they can't support overlapping of events at > any time (does this event overlap another one at some point..)... > So I guess I have to fundamentally decide whether I want to support a > feature like "you already have a gig in 3056" or whether "I have a > something every january until forever".. > hmm... Why would you stop at 3056? Many systems should not encounter problems until 9999/12/31 at the minimum. I reiterate my suggestion to read the existing literature on temporal databases. I assume you could not possibly have obtained a copy of the Date/Darwen/Lorenzos book and read it in the seven minutes it took you to reply.