Solr User Group - Was wondering if anybody had any suggestions/best practices around a requirement for storing a dynamic category structure that needs to have the ability to facet on and maintain its hierarchy Some context:
A product could belong to an undetermined amount of product categories that contain a logical hierarchy. In other-wards, depending on a vendor being used, each product could contain anywhere from 1-N levels deep of product categories. These categories do have a hierarchy that would need to be maintained such that the website could drill down those category facets to find the appropriate product. Examples:Product A is associated to : Category , Subcategory 1, Subcategory 2, Subcategory 3, Subcategory 4 Product B is associated to: Category , subcategory 1, Subcategory 2Product C is associated to: Category, subcategory 1etc. If the category structure was a bit more predictable, it would be easy to load the data into Solr and understand from a UI perspective how best to create a faceted hierarchy. However, because this category structure is dynamic and different for each product, I'm trying to plan for the best course of action in terms of how to manage this data into Solr and be able to provide category facets and guide the UI to how best to query the data in the appropriate hierarchy. I'm thinking of loading the category structure using dynamic fields, but any good approaches on how best to facet and derive a hierarchy on those dynamic fields? Or other thoughts around this. Hope that makes sense. Thanks,
