The two major business technologies are: OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing). Despite falling in the same category of Business Intelligence tools, they are considerably different from one another.

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.

OLAP VS OLTP

[Original post Feb 2/25/13] Blog contributed by-Priyank Mathur, Marketing Associate, PARIS Technologies

Related Posts

What is Business Intelligence (BI)?
How to Transform Data into Intelligence that Promotes Growth
OLAP Implementation
What is OLAP (Online Analytical Processing)?