What do you think of this post?
  • Awesome 
  • Interesting 
  • Useful 

-- Download OLTP, OLAP as PDF --


 

OLTP (On-Line Transaction Processing)

This system is an application that modifies data the instance it receives and has a large number of concurrent users

 

OLAP (On-Line Analytical Processing)

This system is an application that collects, manages, processes and presents multidimensional data for analysis and management purposes

 

Different types of OLAP

 

  • ROLAP
  • MOLAP
  • DOLAP
  • HOLAP
OLTP vs OLAP
OLTP
  • Current data
  • Short database transactions
  • Online Insert/Update/Delete
  • Normalization is promoted 
  • Simple quick running queries ran by users
  • High volume transactions
  • Transaction recovery is necessary
OLAP
  • Current and Historical data
  • Long database transactions
  • Batch Insert/Update/Delete
  • Denormalization is promoted
  • Complex long running queries by system to update the aggregated data
  • Low volume transactions
  • Transaction recovery is not necessary

 

 

 

What do you think of this post?
  • Awesome 
  • Interesting 
  • Useful 

Leave a Reply

Your email address will not be published. Required fields are marked *


*