Distinguish between Analytic Databases and Operational Databases.

S. No. Analytical Database Operational database 1 It supports Online analytical processing It supports Online Transactional processing 2. These are primarily static, read only database which stores archived historical data for analysis These are used to manage more dynamic bits of data. These database will allow users to simply view archived data. 3. These are designed specifically for business analytics; big data and business intelligence solutions. These are designed to support day to day operations of an organisation. 4 An analytical database stores business or projected data used in business analysis and forecasting. Operational database might contain fact and dimension, data describing transactions