Data Storage in an OLAP Database
Remember that the multidimensional databases created in Analysis Services are all based on underlying source data that resides in other relational data stores. In most instances, this underlying relational data store is a data warehouse or data mart. When you process a cube, that source data must be stored in such a way that it can be retrieved by Analysis Services and returned as a resultset to a client application. Analysis Services supports three storage modes:
Multidimensional OLAP (MOLAP)
Relational OLAP (ROLAP)
Hybrid OLAP (HOLAP)
Over the years there has been a heated debate within the OLAP community as to which of these storage methods is the superior way to store data for OLAP purposes. In the following ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
