 |
 |
Archives of the TeradataForum
Message Posted: Fri, 07 Dec 2002 @ 01:35:19 GMT
| Subj: | | Re: Real-time OLAP |
| |
| From: | | Robert Doss |
Hi Morten,
Just a thought for your consideration in response to your very good comments:
| | Personally, what you are asking for is in my humble opinion a contradiction in terms, since multidimensional cubes weren't build for
these kind of data load, but for more traditional weekly or monthly loads, which the analysts could then use to twist and turn data.
Analysts and accounting people often like these multidimensional models, because it enables them to look at data in a variety of different
ways. | |
| | Looking at data in a multidimensional cube, I think was build for strategical decision making, not for operational / tactical
descision making where reports, event messages etc. is much more relevant. | |
If we think of MOLAP a little differently - as a data structure to improve query performance - how is it qualitatively different
from an index with the same caveats on update performance / latency etc...?
As hardware gets faster and cheaper and software smarter, the MOLAP update constraints become less of a factor and perhaps we can
consider MOLAP for 'Active Data Warehouse' and 'Tactical Queries' etc.... as well as it's traditional niches, especially if the cost of
MOLAP is reasonable.
Cheers,
Bob Doss
| |
