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 : Star fish and sea urchin To what order

    To what order does each of the echinoderm species Star fish and sea urchin belong? Describe why they are classified under that order.

  • Q : Maximum price which video rental

    Assume that Bill is a big movie buff & enjoys renting movies from the local video rental outlet. Suppose that he is eager to pay $5 for the first movie he rents for the weekend but would pay only $4 for a second and yet only $3 for a third movie. If the vi

  • Q : Digestion of lipids Explain how the

    Explain how the pancreatic juice helps in the digestion of lipids? Name some of the involved enzyme?

  • Q : Perception - Individual Behavior -

    This factor is the viewpoint by which one interprets a situation. for instance, a railway booking clerk facing a well-dressed person perceives him to be of a high status and talks to him nicely, whereas he may tend to ignore an ill-dressed person, or make him wait, though both the passengers want

  • Q : Type of nitrogen waste that birds

    Name the type of nitrogen waste that birds produce? Why does this characteristic, besides being an adaptation to terrestrial atmosphere, as well mean an adaptation to flight?

  • Q : What is sarcomeres What do you mean by

    What do you mean by the “sarcomeres”?

  • Q : Explain ABC analysis ABC analysis : It

    ABC analysis: It is an inventory management technique wherein the items are classified and clubbed according to their value. The items including the top 5-10% of the total value of inventory are known as "Class A", next 10-15% is classified as "Class

  • Q : Characteristics of protozoans What are

    What are the various characteristics of protozoans which make them look like animals?

  • Q : Some significant neurotransmitters

    Write down some significant neurotransmitters?

  • Q : Initial phases of the embryonic

    What are the main initial phases of the embryonic development?

2015 ©TutorsGlobe All rights reserved. TutorsGlobe Rated 4.8/5 based on 34139 reviews.