--%>

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 : Classes in which phylum Arthropoda is

    Name the classes in which phylum Arthropoda is divided? Write down the three main ones and some of their representative species?

  • Q : Classification of circulatory system of

    How circulatory system of the reptiles is characterized? Specify the basic difference between heart of the reptile and the amphibian?

  • Q : Characterization of Birds How birds are

    How birds are characterized according to illustrations of representing beings, fundamental morphology, respiration, skin, circulation, nitrogen waste, thermal control and kinds of reproduction?

  • Q : Animal and vegetal pole of the

    What are the animal and vegetal pole of the vertebrate egg?

  • Q : What are blastopore and archenteron

    What are blastopore and archenteron? What is the phase of the embryonic development in which such structures are formed? And what are the aims of the archenteron and blastopore?

  • Q : Personality Development in

    The term personality has been derived from Latin word 'personae' ,  which means 'to speak through' . Thus personality is used in terms of influencing others through external appearance. Sum total of ways in which an individual reacts and interacts with others. Personality is

  • Q : Do amphibians have direct growth Do

    Do amphibians have direct growth? Answer: In amphibians, the embryonic growth is indirect (there is a larval phase).

  • Q : Define the term acquired immunity

    Briefly define the term acquired immunity?

  • Q : Describe utilization of production

    Describe utilization of production limits in practice to raise the prices of the following goods or services (1) drinks in a restaurant or bar, (2) wheat or corn? State authorities typically regulate the number of

  • Q : Describe the function of feet in

    Describe the function of feet in molluscs? How is the mollusc foot associated to the name specified to the groups of phylum?