February 07, 2006

Data Warehouse Modes

A data warehouse can be designed and structured in three different ways:

1. ROLAP or Relational online analytical processing: Data in this mode is stored in relational databases.

2. MOLAP or Multidimensional online analytical processing: This is the traditionally used mode in OLAP analysis in which data is stored in the form of multidimensional cubes.

3. HOLAP or Hybrid online analytical processing: This mode combines the best features of both the ROLAP and MOLAP modes. MOLAP is used to provide summaries, while ROLAP is used to dig deep into the database for details.

--
Did you enjoy this post?

February 7, 2006 in Data Warehousing | Permalink




Comments

Post a comment






« The Value of Datamarts | Main | OLAP Survey 5 »