Posted On: Feb 22, 2018
Difference between OLTP and OLAP
OLTP | 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.
There are three major types of data warehouses as-..
A data warehouse consists of data which is obtained from data sources or in other words, external sources...
Data analytics or simply DA is the science used for examining raw data with the purpose of concluding that information. This is mostly built to enable the Data Analytics..