Difference in online analytical Processing System and Online Transaction processing system
Online analytical processing system and online transaction processing
system or both used for querying the database. OLTP queries are used
for live systems for transactions with real-time application.
In analytics queries need to be passed through with many where
sub query group by order by steps.
When these steps become many OLTP query engine not able to
performed query processing in expected time.This is a reason we need
OLAP. Microsoft Analysis services and Excel Pivot with Ryndata BI or
Visual studio data tools are common tolls.
Learn more