lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Óscar Marín Miró <oscarmarinm...@gmail.com>
Subject Re: SolR for time-series data
Date Sat, 03 Dec 2011 20:24:40 GMT
Hi Alan, at my job we had a really succesful implementation similar to what
you are proposing. With a classic RDBM, we hit serious performance issues
so, we moved to solr to display time series of data. The 'trick' was to
facet on a date field, to get 'counts' of data for a time series on a
specific field but don't know if you could be more specific about your data
schema to see it this applies.

Kind regards,

Oscar

On Sat, Dec 3, 2011 at 6:10 PM, Alan Miller <alan.miller3@gmail.com> wrote:

> Hi,
>
> I have a webapp that plots a bunch of time series data which
> is just a series of doubles coupled with a timestamp.
>
> Every chart in my webapp has a chart_id in my db and i am wondering if it
> would be
> effective to usr solr to serve the data to my app instead of keeping the
> data in my rdbms.
>
> Currently I'm using hadoop to calc and generate the report data and the
> sticking it in my
> rdbms but I could use solrj client to upload the data to a solr index
> directly.
>
> I know solr if for indexing text documents but would it be effective to use
> solr in this way?
>
> I want to query by chart_id and get back a series of timestamp:double
> pairs.
>
> Regards
> Alan
>



-- 
Whether it's science, technology, personal experience, true love,
astrology, or gut feelings, each of us has confidence in something that we
will never fully comprehend.
 --Roy H. William

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message