OLAP vs OLTP

Recent days I have been identified most of the candidates are not clear about the differences between OLAP & OLTP; so thought of preparing a article for this. Hope this will be useful.


OLTP: On Line Transactional Processing
OLTP is transactional based systems
OLTP systems are used to handle large amounts of short online transactions.
Operations performed by OLTP are INSERT, UPDATE & DELETE
OLTP systems maintain data integrity and also provide fast query processing in environments having multiple accesses.
Transactions per second determine the efficiency of the system
Detailed data is stored in entity model usually in 3NF.
OLTP data bases in general stores transactional data.

OLAP: On Line Analytical Processing
OLAP is Analytical based systems.
Capable of analyzing large amounts of data
OLAP systems have less number of transactions compared to OLTP.
Response time determines the efficiency of the system.
Queries from this type system are more complex
Data mining techniques also applied on OLAP systems.
These systems store data in Star or snow flake schema in their databases.