Mailing List Archive

Indexing structure with a one to many relationship
Hi all,

We are currently trying to implement a Lucene search engine using
Lucene.NET. We have, up to this point, been importing views from our SQL
database that are one to one relationships. We are now looking at adding
items that can be one to many relationships. I am aware that Lucene can
handle appendable fields, so the structure is in place. What I am curious
about is we need to also know how many times that field appears in the
database (i.e. how many times a user selected that option). How do we
maintain the relationship between the ID of the field that the user has
chosen and the count of that field. We could combine them into one field,
but then sorting becomes an issue. Please let me know if any of you have
had any experience in this department.

Thanks,
Jared
--
View this message in context: http://www.nabble.com/Indexing-structure-with-a-one-to-many-relationship-tf2809178.html#a7838382
Sent from the Lucene - General mailing list archive at Nabble.com.