well, how much data are we talking about here? If your index
is already 100G, your options are much more limited than if
it's 1M...
Essentially, you have several choices:
1> de-normalize your data to whatever extent is "sufficient"
and index it.
2> Try to do what amount to joins. If your needs aren't too complex,
you can probably do some interesting things with
TermEnum/TermDocs, but I should emphasize the word *simple*
in the relationships or else you'll be re-inventing an RDBMS <G>.
3> You can mix-n-match. That is, use Lucene to index searchable
data and use the database for some portion of your joins.
Best
Erick
On 4/15/07, Mohammad Norouzi <[EMAIL PROTECTED]> wrote:
Thanks Karl,
sorry I was on business vacation and could not reply soon.
Ok, I want to index my database and search through the indexes, and the
tables in database are more than 50 and it's hard to joining them and then
indexing. so I was thinking of indexing each table in a document but in
one
index file and then make relations between them
I know that Lucene is not a relational database but it really helps us to
improve accessing our information and even generating reports.
Even if this feature decline the performance, still it is better than
generating reports from SQL statements and the speed up accessing
information. now our users are very satisfied by this. but we need to
create
some relationship between documents.
On 4/11/07, karl wettin <[EMAIL PROTECTED]> wrote:
>
>
> 11 apr 2007 kl. 11.19 skrev Mohammad Norouzi:
>
> > is it possible (or a trickery way) to search with a given query in
> > which we
> > can set an equality for two fields
> > for example:
> >
> > Document:
> > field1 field2 field3 field4
> >
> > Query:
> > field1:"test phrase" AND field2:"test" AND field3:field4
> >
> > in this query we said that do search where field3 is equal to
> > field4 ...
> > (and rest of the query)
> >
> > if it is not possible, can we ask it as a new feature from Lucene
> > developers?
>
> It could probably be done, but would be quite an expensive query to
> place.
>
> However, a request like this usually tiggers questions about the
> design of an index with such needs. There is probably a better
> solution. Start by telling us about the data you have inserted to the
> index, and what it is you try to achieve.
>
> In essence, Lucene is not a relational database.
>
> --
> karl
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
--
Regards,
Mohammad
