Sure, First of all thanks a lot everyone for very quick reply.
We have a Ordering system which has a lakhs of records so far in a normalized RDBMS tables, say Order, Item, Details etc. We are planning to have a offline database (star schema) and develop reports, data analytical charts with drill down, dashboard with data from offline database. I am planning to propose solr as a solution instead of a offline database ie through DIH to import data from DB into solr indexes. Since Solr indexes are stored denormalized manner and querying is faster, faceting search, i assumed that solr can be used to solve my requirement. Please correct me if i am wrong. Thanks, Pradeep On Tue, Jun 25, 2013 at 3:43 AM, Otis Gospodnetic < otis.gospodne...@gmail.com> wrote: > Yeah, perhaps.... yet people keep using it for this. So, Pradeep, it > may work for you and if you share some numbers with us we may be able > to tell you "no way" or "very likely OK". :) > > > Otis > -- > Solr & ElasticSearch Support -- http://sematext.com/ > Performance Monitoring -- http://sematext.com/spm > > > > On Mon, Jun 24, 2013 at 4:14 PM, Walter Underwood <wun...@wunderwood.org> > wrote: > > I expect it won't be fast enough for general use. Most analytics stores > implement functions inside the server to aggregate large amounts of data. > There is always some query that returns the whole database in order to > calculate an average. > > > > I'm sure it will work fine for some things and for small data sets, but > it probably won't scale for most real analytics applications. > > > > wunder > > > > On Jun 24, 2013, at 12:47 PM, pradeep kumar wrote: > > > >> Hello everyone, > >> > >> Apart from text search, can we use Solr as data store to serve data to > form > >> analytics with drilldown charts or charts to add as widgets on > dashboards? > >> > >> Any suggestion, examples? > >> > >> Thanks, > >> Pradeep > > > > > > > > >
