Describe the differences between Transactional & Analytical Systems

Transactional systems (OLTP): Deals with transactional/operational system data; frequently updated& queried. The transaction databases stores the current data in normalized format. So, the expected query response is very fast.

Analytical systems (OLAP): Deals with Historical long period of time data from OLTP system. It is a large volume of data; so the query response is slow.

	OLTP	OLAP
Business Purpose	Day to day business process	Business forecasting/Analysis/Decision making
Users	Application users	Data analysis Users
Data volume	Depends on the transactions	Large volume of data
Refresh	Immediate	Regular intervals
Data model	ER model	Dimensional model
Schema	Normalized	Star
Query Response	Fast	Slow
Orientation	Transaction	Analysis
Focus	Data in	Information out
Characteristic	Operational processing	Informational processing