difference between oltp and olap

DIFFERENCE BETWEEN OLTP AND OLAP

              OLTP                                                                             OLAP




source of data                                                                source of data                                             

Any user interface is the                                               All the OLTP' s are source for OLAP    
source data for OLTP


purpose                                                                           purpose

The mainpurpose of OLTP                                           The main purpose of OLAP is to analysis the
is to run the business                                                     business


operations                                                                   operations 

OLTP is the area where the frequently                        OLAP is the area where frequently select
perform transactions which means                               operation to be performed
INSERT ,UPDATE ,DELETE


Amount of data                                                        Amount of data

All ways OLTP contains less                                   OLAP contains large amount of data as we
amount of data with comparing                               are dapping the complete data from OLTP's into
to OLAP                                                                   OLAP

size                                                                          size
the size of OLTP is upto 400 GB                           The size of the OLAP is rang from 600 GB to 2 TB