Provide an example of when you would use OLAP instead of OLT

Provide an example of when you would use OLAP instead of OLTP. Describe what makes it a better choice for the circumstance.

Solution

OLTP, the On Line Transaction Processing is a data modeling approach typically used to make easy and run normal business applications. Most of the applications are OLTP based.

OLAP, the On Line Analytic Processing and is an approach to answer multi-dimensional queries. OLAP was visualized for Management Information Systems and Decision Support Systems but is still broadly underused.

With the stable growth of data examination and business intelligence applications understanding OLAP degree and if a suitable and useful analytics are provided to the organization it must benefit.

Insead of regular backup some enviroments may consider simply reloading the OLTP data as a recovery method source then OLAP is used instead of OLTP.