--%>

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 : Write the gas exchange unit of

    Write the gas exchange unit of mammalian lungs? Answer: The gas exchange units of mammalian lungs are the alveoli.

  • Q : Psychological Dimensions of Jungian's

    Carl Jung's theories and personality types are very relevant to consumer behavior. Marketers are benefited by using Myers-Briggs type indicators that measures the following pairs of psychological dimensions: Sensing-intuiting. Thinking-feeling.

  • Q : Advanced biology homework help I have

    I have questions for advanced biology? how to get it done?

  • Q : Name the vessels which drain filtered

    Name the vessels which drain filtered blood from the kidneys?

  • Q : Explain Meta data Explain the Meta data?

    Explain the Meta data?

  • Q : Single and multi-seeded fruits Explain

    Explain why there are some plants which are having single-seeded fruits and some fruits having more than one seed?

  • Q : Bacterial Growth Curve Experiment

    Please see attachment for instruction in this assignment In general: 1)One graph logarithmic of time(x axis) vs transmittance(y axis) 2)One graph logarithmic of time(x axis) vs absorbance(y axis) 3)Answer the questions in the attachment of bacterial growth curve results.

  • Q : Use of ERP in six sigma implementation

    Use of ERP in six sigma implementation: In the late 1980’s, the focus on ERP packages was on manufacturing resource planning and attempted to improve processes  such as processing, manufacturing and distribution. Gradually, the packages ext

  • 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 : Explain Manufacturing Technology

    Manufacturing Technology: It provides the tools which enable production of all manufactured goods.  Such master tools of industry magnify the effort of individual workers and provide an industrial nation the power to turn raw materials into affor