While OLTP is generalized by a large number of short online transactions, OLAP involves relatively fewer transactions. Online Transaction Processing systems focus on putting very fast query processing, maintaining data integrity in multi-access environments. Their performance is measured by the number of transactions per second. Online Analytical Processing on the other hand, involves queries that are often very complex and include aggregations. For OLAP systems a response time is a vital performance indicator.
Blog contributed by
-Priyank Mathur, Marketing Associate, PARIS Technologies
What is Business Intelligence (BI)?
How to Transform Data into Intelligence that Promotes Growth
What is OLAP (Online Analytical Processing)?