Re: a question about indexing database tables

2007-02-26 Thread Erick Erickson
You'll get no hits since there is no document in the index that has both fields. On 2/26/07, Mohammad Norouzi <[EMAIL PROTECTED]> wrote: Thank you very much Erick. Really I didnt know about this. I've just thought we can not add two different documents. now my question is, if I index the data i

Re: a question about indexing database tables

2007-02-26 Thread Mohammad Norouzi
Thank you very much Erick. Really I didnt know about this. I've just thought we can not add two different documents. now my question is, if I index the data in the way you said and now I have a query say, "(table1_name:john) AND (table2_address:Adam street)" using MultiFieldQueryParser, what is th

Re: a question about indexing database tables

2007-02-26 Thread Erick Erickson
No, that's not what I was talking about. Remember that there's no requirement in Lucene that each document have the same fields. So, you have something like... Document doc = new Document() doc.add("table1_id", id); doc.add("table1_name", name); IndexWriter.add(doc); Document doc = new Document

Re: a question about indexing database tables

2007-02-25 Thread Mohammad Norouzi
Hi Erick thank you and sorry for taking long my reply. I am involving in a project. I was thinking of your idea about storing all tables in the same field. it seems to me a good idea, but some vague issues. first, how to create a lucene's document. did you mean, storing all tables by joining all

Re: a question about indexing database tables

2007-02-22 Thread Erick Erickson
OK, I was off on a tangent. We've had several discussions where people were effectively trying to replace a RDBMS with Lucene and finding out it that RDBMSs are very good at what they do ... But in general, I'd probably approach it by doing the RDBMS work first and indexing the result. I think th

Re: a question about indexing database tables

2007-02-22 Thread Mohammad Norouzi
Thanks Erick but we have to because we need to execute very big queries that create traffik network and are very very slow. but with lucene we do it in some milliseconds. and now we indexed our needed information by joining tables. it works fine, besides, it returns the exact result as we can get

Re: a question about indexing database tables

2007-02-22 Thread Erick Erickson
don't do either one Search this mail archive for discussions of databases, there are several long threads discussing this along with various options on how to make this work. See particularly a mail entitled *Oracle/Lucene integration -status- *and any discussions participated in by Marcelo O