Write difference between OLTP and OLAP.

32views

written 9.7 years ago by

aartisahitya • 170

OLTP	OLAP
Hold current data.	Hold historical data.
Stores detailed data.	Stores detailed,lightly and highly summarized data.
Data is dynamic.	Data is largely static.
Repetitive processing.	Ad-hoc, unstructured and heuristic processing.
High level of transaction throughput.	Medium to low level of transaction throughput.
Predictable pattern usage.	Unpredictable pattern usage.
Transaction …

Create a free account to keep reading this post.

and 2 others joined a min ago.

ADD COMMENT EDIT