Posted On: Feb 22, 2018
Difference between OLTP and OLAP
|The transaction system that collects the business data is called as OLTP.||OLAP tends to report and analyze the system on that data.|
|OLTP systems are usually optimized for INSERT and UPDATE operations, hence they are highly normalized in general.||When it comes to OLAP, systems are made denormalized for faster data retrieval through the operation of SELECT.|
Never Miss an Articles from us.
A data warehouse consists of data which is obtained from data sources or in other words, external sources...