What is the difference between OLAP and OLTP

Question

Solved626 views20/10/2022Data Warehouse

0

Ezana886 29/01/2022 0 Comments

What is the difference between OLAP and OLTP?

meda Selected answer as best 20/10/2022

Write your answer.

score 0 · Answer 1 · 2022-01-29T13:05:48+00:00

Differences between relational database (OLTP) and Analytic data warehouse (OLAP):

OLTP provides primitive and detail data but OLAP provides summarization and consolidated data
OLTP based on relational data model but OLAP multidimensional model( star, snowfake, fact) schema
OLTP useful in running the business but OLAP useful to Analyze the business
OLTP contains current data but OLAP historical data