Just thinking a little bit on it, I should investigate more the . SpatialRecursivePrefixTreeFieldType .
Each value of that field is it a Point ? Actually each of our values must be the rectangle. Because the time frame and the price are a single value ( not only the duration of the price 'end date - start date'). Could you give an example of the indexing as well ? Cheers 2015-05-21 17:28 GMT+01:00 Alessandro Benedetti <benedetti.ale...@gmail.com> : > The geo-spatial idea is brilliant ! > Do you think translating the date into ms ? > Alex, you should try that approach, it can work ! > > Cheers > > 2015-05-21 16:49 GMT+01:00 Holger Rieß <holger.ri...@werkzeug-eylert.de>: > >> Give geospatial search a chance. Use the >> 'SpatialRecursivePrefixTreeFieldType' field type, set 'geo' to false. >> The date is located on the X-axis, prices on the Y axis. >> For every price you get a horizontal line between start and end date. >> Index a rectangle with height 0.001(< 1 cent) and width 'end date - start >> date'. >> >> Find all prices that are valid on a given day or in a given date range >> with the 'geofilt' function. >> >> The field type could look like (not tested): >> >> <fieldType name="price_date_range" >> class="solr.SpatialRecursivePrefixTreeFieldType" >> geo="false" distErrPct="0.025" maxDistErr="0.000009" >> units="degrees" >> worldBounds="1 0 366 100000000" /> >> >> Faceting possibly can be done with a facet query for every of your price >> ranges. >> For example day 20, price range 0-5$, rectangle: <field name="pdr">20.0 >> 0.0 21.0 5.0</field>. >> >> Regards Holger >> >> > > > -- > -------------------------- > > Benedetti Alessandro > Visiting card : http://about.me/alessandro_benedetti > > "Tyger, tyger burning bright > In the forests of the night, > What immortal hand or eye > Could frame thy fearful symmetry?" > > William Blake - Songs of Experience -1794 England > -- -------------------------- Benedetti Alessandro Visiting card : http://about.me/alessandro_benedetti "Tyger, tyger burning bright In the forests of the night, What immortal hand or eye Could frame thy fearful symmetry?" William Blake - Songs of Experience -1794 England