Re: Is OLAP essentially for Large Enterprises

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 - 11:43:47 CST