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 : Line or staff organization Line or

    Line or staff organization The line or staff organization refers to an organization in which two types of authority relationships coexist. They are direct or line au

  • Q : Colors of electromagnetic spectrum

    Describe the colors of the electromagnetic spectrum which is absorbed by plants? What would occur to photosynthesis when the green light waves that reach a vegetable were obstructed?

  • Q : Beliefs - Perception Factor

    A person's belief has profound influence on his perception. Thus, a fact is conceived not on what it is but what a person believes it to be. The individual normally censors stimulus inputs to avoid disturbance of his existing beliefs.

  • Q : Constant return to scale with an

    Normal 0 false false

  • Q : Selecting a strategy - Taxonomy of

    The strategies of research my in be fact finding and casual. The control, manipulation, realism, scope and precision are considered for selecting a strategy. The researcher can study job satisfaction, leadership, performance level, moral level, etc, with certain precision and accuracy. The validi

  • Q : Question on minimum price to generate

    Normal 0 false false

  • Q : Number of chambers does the bird and

    Determine the number of chambers does the bird heart and the mammalian heart consists of? Regarding temperature maintenance what is the benefit of the double and complete circulation of such animals?

  • Q : Assess Risk-Risk Management Process

    Assess Risk-Risk Management Process:A) Once risks have been identified, these need to be sifted through and analysed for severity and implications. B) There are many methods for doing this, including:

  • Q : Morphological features of birds List

    List out the main morphological features of birds?

  • Q : Gesture Communication - Organization

    Expression through body parts is known as gesture communication. Successful communicators make a very effective us of facial expressions and gestures. A good boss, while scolding a subordinate for some serious mistake, will not show anger on his face; instead his face will register a feeling of c

©TutorsGlobe All rights reserved 2022-2023.