olap vs oltp

on January 17, 2019 data warehousing and mining 1 comment

OLAP	OLTP
olap involves historical processing of information.	oltp involves day-today processing.
olap is used to analyze the business.	oltp is used to run business.
olap focuses on information out.	oltp focuses on data in.
olap contains historical data.	oltp contains current data.
olaps are highly flexible.	oltp provides high performance.
100 MB to 100 GB.	100 GB to 100 TB.
Data model:-Multi dimensional operates data.	Normalized
Source of data:-oltp are the source of olap data. First data comes in oltp and then olap	oltp are the original source of data.
Processing speed:-Depends upon the amount of data involved.	Typically fast.
Quarries:-Often complex queries involving aggregations.	Relatively standardized and simple queries.
Insert and updates:-periodic long running batch jobs refresh the data.	Fast insert , updates done by end user itself
Database design:-Typically denormalized with fewer tables.	Highly normalized with many tables.