List:General Discussion« Previous MessageNext Message »
From:Claudio Nanni Date:February 20 2012 7:20pm
Subject:Re: Design advice for hotel availability program
View as plain text  
Hi,

Nobody answers because this is a very wide question about software
engineering,
Trust me, It seems like a simple question but it is not.

The only advice I can give you is to try to imagine all possible
scenarios/use-cases before starting the design.

Cheers

Claudio

2012/2/20 Jan Steinman <Jan@stripped>

> Where are your domain experts? You *are* consulting with them, no?
>
> If you don't know the answers, and don't have access to domain experts to
> help you, I would design for the most general case, and factor out
> exceptions as they prove to be so. "Pre-optimization" for exceptions almost
> always turns out to be a bad choice.
>
> > From: Tompkins Neil <neil.tompkins@stripped>
> >
> > ....  Am
> > I best using the following pattern
> >
> > (1) Default rates/rooms stored in a generic table
> > (2) Any exceptions/changes/closed days to the daily rates are store in
> > a separate table.
> > (3) Any special offer exceptions are stored as a rule
> >
> > All, should I consider that for any hotel, for any room, for any day I
> have
> > a record in a huge single table ???
>
> ----------------
> Everything we think we know about the world is a model... None of these is
> or ever will be the real world. -- Donella H. Meadows
> :::: Jan Steinman, EcoReality Co-op ::::
>
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql
>
>


-- 
Claudio

Thread
Design advice for hotel availability programTompkins Neil17 Feb
  • Re: Design advice for hotel availability programChaim Rieger20 Feb
    • Re: Design advice for hotel availability programAndrĂ©s Tello21 Feb
Re: Design advice for hotel availability programJan Steinman20 Feb
  • Re: Design advice for hotel availability programClaudio Nanni20 Feb
  • Re: Design advice for hotel availability programNeil Tompkins20 Feb