Re: Is OLAP essentially for Large Enterprises

Thanks for the answer.

I am still not clear whether SQL Server/Oracle will try to optimize normal SQL sum query if the summary tables have been maintained corresponding to the query data?

"Mike Bayliss" <mike338_at_hotmail.com> wrote in message news:7cfa7ef9.0110280943.3683edfa_at_posting.google.com...
> So, if what you want are summaries in your production system then
> create them. Your production application will have to be aware of
> these summary table and such, but there is nowhere that it is written
> that you can't include summary tables in a production system.
> Typically an OLAP database/application is doing the calculations on a
> different system simply because of the overhead incurred when doing
> live calculations. You don't want someone browsing your production
> database and doing all sorts of summaries while people are trying to
> use the system to input data.
>
> "Puneet Agarwal" <NOSPAM__puneetagarwal_at_india.com> wrote in message
 news:<9rgmgq$tne7f$1_at_ID-99266.news.dfncis.de>...
> > I have been exploring OLAP for a few days and I see that it is a great
> > technology targeted at large enterprises for analysis of the
 information. It
> > has also been stressed that OLAP data is maintained separately of the
 OLTP
> > data and updated periodically.
> >
> > But one of the features of OLAP is maintaining indexes to facilitate
 quick
> > summing / Max over some dimensions of cubes. I need this feature even in
 the
> > core database i.e. I want to maintain totals of trasactions over a
 period on
> > day/month/year basis so that I can very quickly calculate the balances
 and
> > sums on any given date. I feel that OLAP can help me do this but I could
 not
> > find anywhere that OLAP may be used in this regard. Also, I feel if sums
 are
> > maintained this way, It is possible for the RDBMS to execute nomal
> > sum/avg/count queries very quickly taking the advantage of the sums etc.
> > maintained in the cubes. I could not find any such mention in both SQL
> > Server and Oracle documentation.
> >
> > Please guide me about this.
> > Please also refer me some good resource where I can learn more.
> >
> > Thanks in advance.
Received on Sun Oct 28 2001 - 12:29:51 CST