Archives of the TeradataForum

Message Posted: Mon, 09 Dec 2002 @ 08:51:29 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: Real-time OLAP

From:		Wiingaard, Morten M

Hi Bob

Thanks for your feedback and just to comment on that.

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.

First of all, good point about comparing an index with a MOLAP structure. I agree that these two things can be seen as related.

I also agree that in time MOLAP tools, might be suited for Tactical/operational analysis, when the MOLAP software vendors are ready to cover this part of business intelligence with their cube technology, and not just add-on reporting tools (e.g. Cognos Impromptu).

Until then I think that you should consider your choice of end-user tools.

Just because you have a tool it doesn't necessary fulfill all of your business needs. I do know however, that this might be hard for some customers to understand.

Cheers,

Morten Wiingaard


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Attachments

Library

Quick Reference