What is the Difference between OLTP and OLAP?
OLTP - On-line Transactional Process
1)OLTP: This stores current data
OLAP: This stores current + History data for analysis.
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
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