--%>

Various types of OLAP

Explain various types of the OLAP?

E

Expert

Verified

a) ROLAP or Relational OLAP - Users generally see their data organized within the cubes and dimensions  however, the data is really stored within the RDBMS. The performance is generally slow. A storage mode that uses tables in the relational database in order to store the multidimensional structures.

b) MOLAP or multidimensional OLAP – In this the data is organized in the cubes and dimensions however the data is really stored within the MDBMS. In this performance of the Query is fast.

c) HOLAP or Hybrid OLAP - It is combination of the ROLAP and HOLAP. Like HOLOs. In this, one will find the data queries on the aggregated data as well as the detailed data.

   Related Questions in Biology

  • Q : Kingdom Fungi Name the beings which

    Name the beings which form the kingdom Fungi? Answer: The kingdom Fungi is made by fungi.

  • Q : Name the hormones secreted by the

    Name the hormones secreted by the adrenal medulla? Describe their respective functions?

  • Q : List some non-price rationing systems

    List some non-price rationing systems. Queuing. Favored customers. Rationing coupons.  

  • Q : Prophylactic measures against HIV

    Write down the some prophylactic measures against the HIV infection?

  • Q : Advantages of project management

    Advantages of project management: For an organization view point it is ever challenging to include schedule management for all the work which they put in. Without appropriate schedule and maintenance all work and projects will fall apart. Just think a

  • Q : Why carbon-dioxide is a restrictive

    Why is the carbon-dioxide concentration a restrictive factor of the photosynthesis method? Whenever the carbon-dioxide concentration is raised indefinitely is photosynthesis as well raised indefinitely?

  • Q : Human diseases caused by virus Write

    Write down the some human diseases which are caused by the virus and what are their respective modes of the transmission?

  • Q : Explain about the goiter and endemic

    Explain these in detail, What is a goiter? Illustrate endemic goiter? How to solve this problem socially?

  • Q : Quantitative Methods in Business and

    General Instructions: Use the SPSS data file produced from the National Child Development Study (NCDS) to answer the following questions. Answer all 5 questions. Five ques

  • Q : What is Multiuser Interface Multiuser

    Multiuser Interface: The abbreviation is MUI, or Multi User Interface, is a term employed to explain an interface which runs over the top of an English version of the Microsoft Windows and supports various languages. This permits large companies to al