Re: Product index schema for solr

[Ajay Patel]

i am posting this question again.

as per your suggestion my final schema will be like
{
    id:<unique_id>
    ...
    ...
    [PRODUCT RELATED DATAS]
    ...
    ...
    ...
    min_qty: 1
    max_qty: 50
    price: 4
}
....
....
[OTHER SAME LIKE ABOVE DATA]
....


now i want to create range facet field by combing min_qty and max_qty.

i hope you have understood what i want to say :).
thanks a lot in adavance :)


Thanks & Regards
Ajay Patel.


On Tuesday 01 April 2014 10:47 AM, Ajay Patel wrote:

as per your suggestion my final schema will be like
{
    id:<unique_id>
    ...
    ...
    [PRODUCT RELATED DATAS]
    ...
    ...
    ...
    min_qty: 1
    max_qty: 50
    price: 4
}
....
....
[OTHER SAME LIKE ABOVE DATA]
....


now i want to create range facet field by combing min_qty and max_qty.

i hope you have understood what i want to say :).
thanks a lot in adavance :)


Thanks & Regards
Ajay Patel.

On Mon, Mar 31, 2014 at 8:42 AM, Ajay Patel <apa...@officebeacon.com> wrote:

On Monday 31 March 2014 06:07 PM, Erick Erickson wrote:

What do you mean by "generalized range facet"? How would
they differ from standard range faceting? Details are important...

Best.
Erick

On Mon, Mar 31, 2014 at 7:44 AM, Ajay Patel <apa...@officebeacon.com> wrote:

Hi Erick

Thank for the reply :). your solution help me to denormalize my data. now i have one another question can i create a generalize range facet according to

min_qty and max_qty?

Thanks & Regards
Ajay Patel.


On Saturday 29 March 2014 08:54 PM, Erick Erickson wrote:

The usual approach is to de-normalize the tables, so you'd store docs like

(all your product data) min_qty, max_qty, price_per_qty

So the above example would have 4 documents, then it all "just works"

You have to insure that the id (<uniqueKey>) is different for each, and

probably store the product ID in a field other than "id" for this reason.

Best,
Erick

On Fri, Mar 28, 2014 at 10:27 AM, Ajay Patel <apa...@officebeacon.com>
wrote:

Hi Solr user & developers.

i am new in the world of solr search engine. i have a complex product
database structure in postgres.

Product has many product_quantity_price attrbutes in range

For e.g Product iD 1 price range is stored in product_quantity_price
table in following manner.

min_qty max_qty price_per_qty
1            50        4
51          100      3.5
101        150        3
151        200      2.5

the range is not fixed for any product it can be different for different

product.

now my question is that how can i save this data in solr in optimized
way so that i can create facets on qty and prices.

Thanks in advance.
Ajay Patel.