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
- OLTP database has only one data source whereas data warehouse(OLAP) has many data sources.
- The data model of OLTP database is static but OLAP’s data model is dynamic.
- The number of users for OLTP database is larger than data warehouse users.
- The response time for OLTP database is <1 second whereas for data warehouse <10 second.
- We can only do read only transactions on OLAP but on OLTP we can also do insert/update/delete transactions.
- The availability of OLTP database should be 24/7 whereas OLAP can be 8/5.
- The data volume of OLAP database ( data warehouse) is huge whereas the OLTP is small/medium.
Amen Answered question 09/07/2022