Re: Complex select query
- From: "Steve" <no.one@xxxxxxxxxxx>
- Date: Thu, 26 Oct 2006 11:23:57 -0500
"Pankaj" <panahuja@xxxxxxxxx> wrote in message
news:1161850268.732776.196440@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
|I am trying to book rooms in a hotel. A user searches for booking from
| 1st through 10th of a month, and if I already have a booking for 5th of
| that month, then the user should get a message that booking is not
| available.
|
| What is the best way of doing this? One method I can think about it
| checking the value of all records and if any of the fields contains a
| value, the results are not displayed. However, I do not find this
| method to be very efficient. Can this be done through a single query ?
|
| Thanks
| Pankaj
just an afterthought - having worked in lodging industry before. unless you
are booking at a resort with a *very* limited number of rooms or you're
booking a "special" room (presidential suite, governer's suite, etc.). you
will NEVER be reserving a SPECIFIC room for anyone.
hotels OVERBOOK so that they can maximize occupancy (and in turn, revenue).
they only book a certain TYPE of room (ns-k, s-q-k, etc.). they know from
benchmarking that x% of people who book will either cancel or just not show
up...or show up a day earlier/later than stated. the x% can be as precise as
seasonal, monthly, or any given day...x% could, and should, be dynamic. most
hotel software adjusts x% based on trends. hotels use a formulaic "buffer"
that is basically: actual number of rooms of typeA * buffer (where buffer
would be like 0.1)...this means they will allow typeA rooms to oversell by
10%. if typeA rooms were 50 and you wanted to use a 10% buffer, you'd allow
the reservations personnel reserve up to 55 typeA rooms total.
while hotel lingo calls this overbooking, it simply means in management
terms, we want to get as close as possible to having EVERY room filled on
the night(s) of...
hope that helps your architecture.
.
- References:
- Complex select query
- From: Pankaj
- Complex select query
- Prev by Date: Re: non session/cookie login
- Next by Date: Strange results for foreach loop
- Previous by thread: Re: Complex select query
- Next by thread: Re: Diary Script
- Index(es):
Relevant Pages
|
