March 20, 2016

OLTP and OLAP



Difference between OLPT and OLAP system
OLTP
OLAP
Online Transaction Processing
Online Analytical Processing
We can see only current transaction, fresh data
relatively historical data
normalized
denormalized
detail level data available
summarized data available
type of media required to store the data is small
huge database / data warehouse required large media
data extraction : fast
slow