Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Scheduling Database - Design Help!

Re: Scheduling Database - Design Help!

From: <Trevor.D.Matthews_at_gmail.com>
Date: 19 Sep 2005 18:56:50 -0700
Message-ID: <1127181410.835147.280160@g47g2000cwa.googlegroups.com>


Thanks so much to everyone for the input. I'll try out a couple of the ideas and post back my results in case anyone wants to know how it played out.

Thanks again,
Trevor

Trevor.D.Matthews_at_gmail.com wrote:
> I need to develop a scheduling app and am having trouble with the
> database
> design. I can easily design a table hold appointments with start and
> finish
> times, but I always have an issue when it comes time to searching for
> free
> time.
>
> The search examples:
> Find the first available appointment in September
> Find the first afternoon appointment
> etc...
>
> Should appointments be linked similar to a linked list? Should I create
> a
> row for each 5 or 10 or 15 minute slice of the day for every day and
> then
> just search for null in a 'used' field? This could grow way to fast.
>
> If you need a more specific example to understand I can provide that,
> but I
> wanted to keep this as short as possible.
>
> If anyone has experience designing a scheduling DB then please post
> your
> expoeriences.
>
> Thanks
Received on Mon Sep 19 2005 - 20:56:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US