GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Business Intelligence

 Print  |  
Question:  What is OLAP, MOLAP, ROLAP, DOLAP, HOLAP? Examples?



November 11, 2006 07:46:35 #4
 SWARNA   Member Since: Visitor    Total Comments: N/A 

RE: What is OLAP, MOLAP, ROLAP, DOLAP, HOLAP? Examples...
 

 OLAP(ONLINE ANALYTICAL PROCESSING):It is a set of specifications which allows the client applications in retriving the data from the DataWareHouse for analytical process.

There r 4 types of OLAPS we have

 1.DOLAP(DESKTOP OLAP)

2.ROLAP(RELATIONAL OLAP)

3.MOLAP(MULTIDIMENSTIONAL OLAP)

4.HOLAP(HYBRID OLAP)

1.DOLAP: The OLAP which communicates with DESKTOP DATABASES to retrive the data is called DOLAP.

ex:cognos,business object tools.

2.ROLAP: The OLAP which communicates with RELATIONAL DATABASES to retrive the data is called ROLAP.

ex:COGNOS REPORT NET,BUSINESS OBJECTS,MICROSTRATAGY,HYPERION

3.MOLAP: The OLAP which communicates with MULTI DIMENSIONAL DATABASES to retrive the data is called MOLAP.

ex:COGNOS ,HYPERION

4.HOLAP: The OLAP  which uses the combined features of ROLAP,MOLAP is called HOLAP.

ex:COGNOS  

hai vishwanatha

   Report net belongs to ROLAP, beacause it communicates with the relational sources

     

 

Back To Question