--%>

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 : Copulation of the female animal

    Explain, how does male animal realize that female is receptive for the copulation?

  • Q : What were black codes Black Codes were

    Black Codes were the laws passed by the southern government which imposed severe restrictions on freed slaves. They were not permitted to vote.They were also not allowed to carry weapons in public places.They were forced to work in certain occupations

  • Q : Meaning of Management Meaning of

      Meaning of Management (1) Management as a process: Management is regarded as a process because i

  • Q : Recognized Trends-Knowledge Management

    Two general trends have emerged to represent Knowledge Management in the literature and actual practice: I. Tangible knowledge assets captured and retained in organization structures and systems. For example, R & D (research and development) outcomes, patents, copyrights, royalties, l

  • Q : Legislation and Lawsuits -

    Another pragmatic reason for diversity in today's organizations stems from legislation and lawsuits. The political and legal systems have compelled organizations to hire more broadly and to provide equal opportunity for all employees. Although legislation going as far back as the civil rights act

  • Q : Is mitosis or meiosis significant

    For biological diversity, is mitosis or meiosis the more significant process?

  • Q : Fungal diseases transmit by animal feces

    Write down the some fungal diseases transmitted by the animal feces?

  • Q : What are the biological importance of

    what are the biological importance of water?

  • Q : Main endocrine functions of the placenta

    What are the main endocrine functions of the placenta?

  • Q : Name the molecules release in aerobic

    On considering the chemical equation of the aerobic cellular respiration, name the molecules which the cell requires and which molecules does it release in the process?