java - Create Facets based on generic data model in Hibernate Search -
our task implement application uses faceted search on hibernate search 4.6. our database model unfortunately mix of relational , generic tables , not possible change that.
this simplified diagram of our model. our index based on entity of data stored key/value pairs in other 2 tables. key in table propertytype
while value in table entityproperty
.
this leads these fields in index:
entityname entityproperties.propertyvalue entityproperties.propertytypes.propertyname
the field propertyname
contain facet name while propertyvalue
contains different possibilities. problem association between propertyname
, propertyvalue
lost.
we considered move properties interested in faceting entity
table not possible many of our entityproperties
. stuck here , suggestion how solve issue highly appreciated.
Comments
Post a Comment