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
|
March 20, 2016
difference between Online transaction processing ( OLTP )and online Analytical processing (OLAP)
Subscribe to:
Posts (Atom)