OLAP vs OLTP



Transaction DatabaseData warehouse database
Dedicated database available for specific subject area or business applicationIntegrated from different business applications
It does not keep  historyIt keeps history of data for analyzing past performance
It allows user to perform the below DML operations (Select/Insert/Update/Delete)It allows only Select for end users
The main purpose is for using day to day transactionsPurpose is for analysis and reporting
Data volume will be lessData volume is huge
Data stored in normalized formatData stored in de-normalized format

Followers