Different Between OLTP and OLAP

	OLTP	OLAP
1	Application Oriented (e.g., purchase order it is functionality of an application)	Subject Oriented (subject in the sense customer, product, item, time)
2	Used to run business	Used to analyze business
3	Detailed data	Summarized data
4	Repetitive access	Ad-hoc access
5	Few Records accessed at a time (tens), simple query	Large volumes accessed at a time(millions), complex query
6	Small database	Large Database
7	Current data	Historical data
8	Clerical User	Knowledge User
9	Row by Row Loading	Bulk Loading
10	Time invariant	Time variant
11	Normalized data	De-normalized data
12	E – R schema	Star schema