Sunday, 24 November 2013

OLTP and OLAP

What is the Difference between OLTP and OLAP?


OLAP - On-line Analytical Process
OLTP - On-line Transactional Process


1)OLTP: This stores current data
   OLAP: This stores current + History data for analysis.

2)OLTP:More no of Users
  OLAP:Less no of Users

3)OLTP:E-R model for data modeling
   OLAP:Dimension model for data modeling

4)OLTP:Its contains parent and child table
   OLAP:Its contains Dimension table and Fact Table

5)OLTP:Designed for daily Transaction Purpose
   OLAP:Designed for Queuing and reporting.

6)OLTP:data is present in 2d format
   OLAP: 6.data is present in muti dim format

7)OLTP:No of index Few.
   OLAP:No of index Many.

8)OLTP:Volatile data behavior
   OLAP:Non-volatile data behavior

1 comment:

  1. I got a good answer from the above description,but it still requires some more update to be made. Please share more content on MSBI Online Training

    ReplyDelete