OLTP is nothing but OnLine Transaction Processing which contains a normalised tables and online data which have frequent insert/updates/delete.

But OLAP(Online Analtical Programming) contains the history of OLTP data which is non-volatile acts as a Decisions Support System and is used for creating forecasting reports.

Hey add this point also

Index

OLTP : FEW

OLAP : MANY

JOINS

OLTP : MANY

OLAP : FEW

Deepa

Hi deepa

thanks.

Warm Regards

Sahadevan

from GE Healthcare

good answer.

In Oltp's Data Can be insert update and Delete.Follows ER Modeling

In OLap's Data cannot be insert update and Detete. Follows Dimensional Modeling.

Hi swetha

I read your answer about Difference between OLTP and OLAP . its good and it was very useful for me. like i need the Difference between EXEC and SP_EXECUTE?

Thanks & Regards

R.Rajakrishnan

oltp:


1.current data only

2.insert update delete operations are possible

3.continous changing of data

4.1 year data is present

5.only one record is processed at a time


6.data is present in 2d format


olap:

1.current+historical data

2.used for reprting and analysis

3.non volatile in nature

4.5-30 yrs of data is stored

5.group of records processed at a time

6.data is present in muti dim format