Question: Discuss various OLAP Models and their architecture.
0

Mumbai University > Computer Engineering > sem 8> data warehouse and mining

Marks: 10M

mumbai university • 406 views
ADD COMMENTlink
modified 8 weeks ago  • written 9 weeks ago by gravatar for Ankit Pandey Ankit Pandey70
0

OLAP Model:

There are four OLAP Models

1) MOLAP,

2) ROLAP

3) HOLAP

4) DOLAP

1) MOLAP: This is the more traditional way of OLAP analysis. In MOLAP, data is stored in a multidimensional cube. The storage is not in the relational database, but in proprietary formats.

enter image description here

2) ROLAP:

This methodology relies on manipulating the data stored in the relational database to the the appearance of traditional OLAP's slicing and dicing functionality. In essence, each action of slicing and dicing is equivalent to adding a "WHERE" clause in the SQL statement.

enter image description here

3) HOLAP:

  • HOLAP technologies attempt to combine the advantages of MOLAP and ROLAP. For gummary-type information, HOLAP leverages cube technology for faster performance.
  • When detail information is needed, HOLAP can "drill through" from the cube into ane underlying relational data.
  • For example, a HOLAP server may allow large volumes of detail data to be stored in a relational database, while aggregations are kept in a separate MOLAP store. The Microsoft SQL Server 7.0 OLAP Services supports a hybrid OLAP server.

4) DOLAP:

It is Desktop Online Analytical Processing and variation of ROLAP. It offers portability to users of OLAP. For DOLAP, it needs only DOLAP software to be present on machine.Though this software, multidimensional data-sets are formed and transferred to desktop machine.

ADD COMMENTlink
modified 8 weeks ago by gravatar for Yashbeer Yashbeer160 written 8 weeks ago by gravatar for Ankit Pandey Ankit Pandey70
Please log in to add an answer.