Pages

Tuesday 24 June 2014

Difference between OLTP and OLAP?


OLTP : IT is a Online Transaction Processing. This is maintained current transactional data. That means insert, update and delete must be fast.


OLAP(On-line Analytical Processing)): It deals with Historical Data or Archival Data. Historical data are those data that are archived over a long period of time.
Data from  OLTP are collected over a period of time and store it in a very large database called Data warehouse.

No comments:

Post a Comment