--%>
Assignment Help - homework help

OLAP and OLTP

Explain the difference between OLAP and OLTP?

E

Expert

Verified

 OLTP

a) It focuses on the day to day transaction.
b) Dynamic
c) Data Stability
d) Highly normalized.
e) Access Frequency High.

OLAP

a) Static until refreshed
b) It focus on future predictions and decisions
c) Demoralized and replicated data
d) Medium to low.

   Related Questions in Biology

  • Q : Meaning and Definition of Perception -

    Human beings are constantly attacked by numerous sensory stimulations including noise, sight, smell, taste etc, the critical question In the study of perception is why the same universe is viewed differently by different persons? The answer is the perception. Different people perceive the univers

    		•
  • Q : Coacervates in emergence of life How

    How coacervates could have facilitated in the emergence of life upon the earth?

    		•
  • Q : ORGANIZING ORGANIZING Meaning &

    ORGANIZING Meaning & definition: organization refers to the process of bringing together physical financial and human res

    		•
  • Q : Limitations of the contingency approach

    Limitations of the contingency approach In spite of the various contributes contingency approach has not been acknowledged as a unified theory of the management beca

    		•
  • Q : Characterization of arthropod

    Name the three main arthropod groups characterized according to the presence of antennae? Answer: The Crustaceans contain two pairs of antennae; insects have one pai

    		•
  • Q : Goal-setting theories - Motivation -

    Goals lay down targets to be achieved in future. They influence the behavior of employees and also their motivation. When the employees participate in goal setting, they see how their efforts will lead to performance, rewards and personal satisfaction. Thus, goals provide a sense of direction to

    		•
  • Q : Explain International Licensee

    International Licensee: It is the contractual agreement among two business entities in which the licensor allows the licensee to utilize a brand name, patent, or other proprietary right, in exchange for a royalty or fee. Licensing facilitates the lice

    		•
  • Q : How does the amoeboid movement take

    How does the amoeboid movement take place? What are illustrations of beings and cells which use these movements for locomotion?

    		•
  • Q : Evolutionary novelty represented by

    Describe the main evolutionary novelty represented by annelids?

    		•
  • Q : Effect of price regulation on producers

    Assume the government regulates price of a good to be no lower than some minimum level. Can such a minimum price make producers as a whole worse off? Describe.Since a higher price increases revenue and decreases demand, some of the consumer su

    		•