Design question [too many fields?]

2005-06-29 Thread Naimdjon Takhirov
Hi, We are porting our search functionality over to lucene in our hotel solution which is java based. Today search is done directly against the database. There is a date search, i.e tourist would like to search for free rooms fromDate and toDate. The documents are added to the index pr hotel room(p

Vedr. Re: Design question [too many fields?]

2005-06-29 Thread Naimdjon Takhirov
Hi Jian, Thanks for your inputs. The (DB) datamodel is quite complex with rooms and room units (I skipped it to make the case easier to understand), so I guess the easiest and actually best way to do it is with the filter. Mark: yes, there are a lot of text fields the user should be able to searc

Vedr. Re: Design question [too many fields?]

2005-06-30 Thread Naimdjon Takhirov
Hi Chris, It is anyway going to be too many fields then? Days of year for the whole year ahead? Since the fromDate and toDate can be across two months and the customer wants the data be available for one year. Naimdjon --- Chris Lu <[EMAIL PROTECTED]> skrev: > Mark, your suggestion will incur a

Vedr. Re: Design question [too many fields?]

2005-07-01 Thread Naimdjon Takhirov
Guys, thanks for your inputs. I think the solution Mark has suggested does solves the problem in an acceptable way. Its actually gonna be a little better than the solution the customer is has right now. Apart from the availability we have to also check if there is any price for room units saved in