Hi All,
We're trying to create a schema that will allow us to provide facetted search
for documents that may have an arbitrary set of attributes and values. In an
RDBMS model, this would typically be an Entity Attribute Value scheme.
Here's an example of one type of document, with trait_type for Variant, Rank,
Chest, Face, Hands.
{
"name": "Name here.",
"description": "Text here...,
"attributes": [
{
"trait_type": "Variant",
"value": "Service Unit"
},
{
"trait_type": "Rank",
"value": 5861
},
{
"trait_type": "Chest",
"value": "Robe",
"occurrence": 10.0
},
{
"trait_type": "Face",
"value": "Shades",
"occurrence": 9.8
},
{
"trait_type": "Hands",
"value": "Handheld Console",
"occurrence": 2.6
}
]
}
We have 10,000 documents that are of the above 'document type'.
Another document type may have different traits.
In the case of the document above, we'd like a facetted browser that looks like
this:
Variant
Service Unit(122)
Combat Unit(100)
Other (231)
Chest
Robe (122)
Amber (231)
Diamond (100)
Face
Shades(123)
VR (23)
Hands
Handheld Console (23)
Sword (87)
Gun (12)
etc...
As an experiment, we imported these documents into a 'schemaless' and managed
schema core, and this is the resulting Solr document:
{
"name":["Name here"],
"description":["Description here..."],
"attributes.trait_type":["Variant",
"Rank",
"Antenna",
"Chest",
"Face",
"Head",
"Hands"],
"attributes.value":["Automaton",
"309",
"Boosted Signal",
"Gold",
"Glowering",
"Baseball Cap",
"Baseball Bat"],
"attributes.occurrence":[8.7,
3.4,
9.6,
4.7,
4.7],
"id":"4a972d2a-df0b-4112-90f2-eef8d153d874",
"_version_":1723919631435956224},
There's an older Stackoverflow question and answer here, which describes a
similar problem....
https://stackoverflow.com/questions/7512392/facet-dynamic-fields-with-apache-solr/14529566#14529566
... but I was wondering if anyone could suggest another approach? We're
unlikely to have very many document types, and so a completely 'generalized'
solution might not be necessary, i.e. we could 'normalize' the documents as
they are indexed to known fields like variant, chest, face, hands - creating
new fields as they might be required (and then filter by document type).
Thoughts or suggestions greatly appreciated.
Best,
Tony
Anthony Bouch
[email protected]
