--%>
Assignment Help - homework help

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 : What is type fourth hypersensitivity

    What do you mean by type IV hypersensitivity?

    		•
  • Q : Disadvantage of MBO Disadvantage of MBO

    Disadvantage of MBO 1 pressure oriented: MBO may prove to be self defeating in the long since it is tied with a reward punishment psychology. It is

    		•
  • Q : How are neural networks distinct than

    How are neural networks distinct than Bayesian belief networks all along the following dimensions: (A) Inspect capability of knowledge, (B) Requirement for probabilities obtained from "domain" experts, (C) Requirement for data to train the system, and (D

    		•
  • Q : Rough endoplasmic reticulum and Golgi

    How do rough endoplasmic reticulum and Golgi apparatus act in the production and liberation of proteins?

    		•
  • Q : What is International Subsidiary

    International Subsidiary: The subsidiaries of companies give a critical link to local cultures, business techniques and efficient marketing strategies. Fruitfully operating an international subsidiary needs reliance on the local duty completion of acc

    		•
  • Q : How calcium ions participate in the

    How calcium ions participate in the muscle contraction? Why do both muscle contraction and muscle relaxation use energy?

    		•
  • Q : Rings present on cross section of stem

    How can the age of the tree be estimated from analysis of rings present on the cross section of stem?

    		•
  • Q : Factors affecting the degree of

    Factors affecting the degree of decentralization Nature of growth: if the enterprise has grown through internal expansion, it will continue to retai

    		•
  • Q : Features of Perception - Organizational

    Some of its features are as follows: I. Perception is the intellectual process through which a person selects the data from the environment, organizes it, and obtains meaning from it. II. Perception is a basic cognitive or psychological process. The manner in which a person percei

    		•
  • Q : Features of the nervous system of

    Explain the noteworthy features of the nervous system of arthropods?

    		•