OLAP vs OLTP

OLTP	OLAP
OLAP stands for Online Transaction Processing.	OLTP stands for Online Analytical Processing.
It is  a  Database.	It is a Data ware House.
It stores Operational data.	It stores consolidated data.
It maintains data particular to a location or a branch.	It maintains information about the complete Organization.
They store current data. May be 1 month, 6 months or max 1 year.	They store historical data. May be 5 years, 10 years, 20 years.
They are mostly used for        -          Fast online transactions.         -          Maintain data integrity in multiple  environments.        -          Effective no of transactions per second etc..	They are mostly used for          -          Less volume of transactions.          -          Complex queries involving aggregations.          -          Response time is the effective measure.
Its main purpose is to run the business tasks.	Its main purpose is to plan, problem solving, decision support.
It is highly normalized with many tables.	It is Typically de-normalized with fewer tables, uses start or snow flake schema.
It can be relatively small if historical data is achieved.	It must be large due to historical data, requires more indexes than OLTP.
Short and Fast insert / updates by the end user.	Periodically running batch jobs will refresh the Data.