✍ Kashif M
Trends

Sunday, 17 November 2013


Difference Between OLTP and OLAP


By on November 17, 2013



OLTP: Online transactional transaction processing

It is characterized by large number of rows of data’s per second.

For each and every transaction of data will get store for time to time.

In OLTP database there is detailed and current data, and schema used to store transactional databases is the entity model (usually 3NF).

All the transaction in OLTP normally will consider as Normalized.

OLAP: Online Analytical Processing

It is characterized by very low volume of transactional data.

Normally OLAP will consider as De-normalized.

All the transactions are aggregated to view in very less rows of data.

In OLAP database there is aggregated, historical data, stored in multi-dimensional schemas (usually star schema).

Kashif
mkashu: Difference Between OLTP and OLAP
Review : Kashif | Kashif
Update: November 17, 2013 | Rating: 4.5

Comment for "Difference Between OLTP and OLAP"

1 comments:

  1. Hi this is Kathiresan i am having 3 years of experience as a dot net developer and i am certified. i have knowledge on OOPS concepts in .NET but dont know indepth. After learning android will be enough to get a good career in IT with good package? and i crossed Android Training in Chennai website where someone please help me to identity the syllabus covers everything or not??

    Thanks,
    kathiresan

    ReplyDelete