OLTP refers to the processing of operational databases. Updating, querying and inserting are performed on real time data.
OLAP refers to the general activity of querying and presenting. This mainly encompasses the act of presenting data from data warehouses and datamarts.It is a great decision support tool.
Usually organisations store the data in two different places and in different representations – one is for operation purposes (inventory monitoring or financial transaction record keeping) and the other one is for analyzing trends or patterns on the databases.And the operational databases can retrieve results faster when compared to analytical queries.
OLAP is built from OLTP databases except for the fact that OLAP has its own model so that it facilitates better understanding of the business problem at a broader perspective. The process of extracting the data from operational databases and transforming it into an analytical model that suits the business question and loading it on to the datamarts is called as ETL process.
I truly appreciate the time and work you put into sharing your knowledge. I found this topic to be quite effective and beneficial to me. Thank you very much for sharing. Continue to blog.
ReplyDeleteData Engineering Services
AI & ML Solutions
Data Analytics Services
Data Modernization Services