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
meda Selected answer as best 20/10/2022