What is OLAP , OLTP

⭐⭐⭐⭐⭐
What is #OLAP ?
OLAP is an acronym for Online Analytical Processing. OLAP performs multidimensional analysis of business data and provides the capability for complex calculations, trend analysis, and sophisticated data modeling.

advantages
Business-focused multidimensional data.
Business-focused calculations.
Trustworthy data and calculations.
Speed-of-thought analysis.
Flexible, self-service reporting

⭐⭐⭐⭐⭐
What is #OLTP ?

OLTP is an operational system that supports transaction-oriented applications in a 3-tier architecture. It administers the day to day transaction of an organization. OLTP is basically focused on query processing, maintaining data integrity in multi-access environments

advantages

Speedy response times
Indexed access to data
Frequent updates and queries
Transactions involving small amounts of data
Many users

#DataWarehouse #ETL #Datalake