Sunday January 21st 2018

Categories

Insider

Archives

OLAP Vrs OLTP

Online-Line analytic Processing is optimized for questions like for example What sales people
generate revenues or make sales more than $45,000 during the Christmas and there sales
orders were not returned during first 45 days of making sales. Olap is highly summarized and aggregated data.
In Olap Data is stored and accessed from multidimensional structures named cubes.

Where as in In OLTP or Online transaction processing question may be like – what is the Account balance of Vendor # 12345.