Re: Design advice for hotel availability program

2012-02-21 Thread Andrés Tello
Verify the regulation that a Hotel should submit, read the part of the occupation reports, information gathering, ask management for their currents report... Remember the data output should came from the data stored... On Mon, Feb 20, 2012 at 4:42 PM, Chaim Rieger wrote: > On 2/17/2012 4:01 AM

Re: Design advice for hotel availability program

2012-02-20 Thread Chaim Rieger
On 2/17/2012 4:01 AM, Tompkins Neil wrote: Hi, I'm in the process of starting to design a hotel booking system that will eventually consist of over 10,000 hotels all with different room types, rates and availability for different dates. My question is does anyone have any experience with regard

Re: Design advice for hotel availability program

2012-02-20 Thread Neil Tompkins
Hi I am trying to get some background information with regards the design. I have a fair idea but would like advice from anyone that has previously worked on similar projects. On 20 Feb 2012, at 17:22, Jan Steinman wrote: > Where are your domain experts? You *are* consulting with them, no

Re: Design advice for hotel availability program

2012-02-20 Thread Claudio Nanni
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

Re: Design advice for hotel availability program

2012-02-20 Thread Jan Steinman
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

Re: Design advice

2010-10-10 Thread Shawn Green (MySQL)
On 10/8/2010 3:31 PM, Neil Tompkins wrote: Hi Shawn Thanks for your response. In your experience do you think I should still retain the data used to generate the computed totals ? Or just compute the totals and disregard the data used ? In my experience, the details matter. Also in my experie

Re: Design advice

2010-10-08 Thread Neil Tompkins
Hi Shawn Thanks for your response. In your experience do you think I should still retain the data used to generate the computed totals ? Or just compute the totals and disregard the data used ? Regards Neil On 8 Oct 2010, at 19:46, "Shawn Green (MySQL)" wrote: Hi Neil, On 10/5/2010

Re: Design advice

2010-10-08 Thread Shawn Green (MySQL)
Hi Neil, On 10/5/2010 5:07 AM, Tompkins Neil wrote: Hi I have a number of tables of which I use to compute totals. For example I have table : players_master rec_id players_name teams_id rating I can easily compute totals for the field rating. However, at the end of a set period within my ap

Re: Design Advice?

2004-03-01 Thread Chris Boget
> If you are not using 5.0 and don't want to switch to 5.0, then using > database "view" will also work. This link tells how to create views: > http://www.mysql.com/documentation/maxdb/6d/117c44d14811d2a97400a0c9449261/content.htm What version does this work for? We're using 4.0.14 and it doesn'

RE: Design Advice?

2004-02-27 Thread Zhao, Charles
tation/maxdb/6d/117c44d14811d2a97400a0c94492 61/content.htm -Original Message- From: Ed Lazor [mailto:[EMAIL PROTECTED] Sent: Friday, February 27, 2004 7:18 AM To: 'Zhao, Charles' Subject: RE: Design Advice? Hi Charles, Thought of a question... the stored procedure sounds like

RE: Design Advice?

2004-02-26 Thread Zhao, Charles
Your business requirement is not quite clear. Here are some questions that you need to answer before you finalize your design: 1. How often will the invoice be viewed (and I assume the viewers must be your web site users?) 2. What's the approximate traffic volume? 3. Will each time the users vie

RE: Design Advice?

2004-02-26 Thread Ed Lazor
Hi Charles, Answers: 1. Frequent web viewers 2. Medium... internal website 3. An invoice will get frequent views while it's active, but very few views after it's completed. 4. About 1200 entries a month. Are there approaches other than what I described? -Ed -Original Message- Your

RE: Design Advice?

2004-02-26 Thread Ted . A . Gifford
ry 26, 2004 12:16 PM To: 'Zhao, Charles'; [EMAIL PROTECTED] Subject: RE: Design Advice? Hi Charles, Answers: 1. Frequent web viewers 2. Medium... internal website 3. An invoice will get frequent views while it's active, but very few views after it's completed. 4. About 12

RE: Design Advice?

2004-02-26 Thread Zhao, Charles
erver, or blob data in a separate table. Partitioning your invoice table based on time periods would also be an idea. -Original Message- From: Ed Lazor [mailto:[EMAIL PROTECTED] Sent: Thursday, February 26, 2004 12:16 PM To: 'Zhao, Charles'; [EMAIL PROTECTED] Subject: RE: Desi