OLTP OLAP
This is an Online Transactional System. This is an online analysis and data retrieving process.
It comprises of a large number of short online transactions. It comprises of a large volume of data.
This uses a traditional DBMS. This uses a Data Warehouse.
Here the tables are normalized Here, the tables are not normalized.
It is designed for real-time business operations due to its fast response rate. It is designed for the analysis of business measures via attributes and categories.
BY Best Interview Question ON 01 Jul 2020