OLTP AND OLAP

[rjyadav94]

Can anyone please give me the difference between oltp and olap therotical concept as well as practically.

[Gysbert_Wassenaar]

I'm sorry to hear your internet search engine is broken. I hope you find a new one soon.

In the mean time here are some links to information you can find with any decent internet search engine:

• https://www.guru99.com/oltp-vs-olap.html
• https://www.datawarehouse4u.info/OLTP-vs-OLAP.html
• https://academy.vertabelo.com/blog/oltp-vs-olap-whats-difference/
• https://techdifferences.com/difference-between-oltp-and-olap.html
• https://www.quora.com/What-is-the-difference-between-OLTP-and-OLAP
• http://www.rfwireless-world.com/Terminology/difference-between-OLTP-and-OLAP.html
• https://wiki.scn.sap.com/wiki/display/BI/OLAP+vs+OLTP

[scantante]

In short:

OLTP refers to Online Transaction Processing. It's often used to mention databases that store and manage data relevant to the day-to-day operations of a system or company; OLAP refers to Online Analytical Processing, and is often used to mention databases that store and manage data relevant for data analysis and decision making.

Longer version:

The data from the upper part is usually processed in batch via a process called Extract, Transform and Load (ETL). It's the name given to the operation that collects data from several OLTP sources and puts it in an OLAP data warehouse, allowing cross-system analysis. In the lower part you can see that the data was properly stored and organised in the OLAP cube.

If you want to deepen it any further, check the following article: OLTP vs OLAP: what's the difference?

[hdelgadinho]

Hi, OLPT (online transaction processing)  is used to mention databases that store and manage data relevant to the day-to-day  operations of a system  or company. OLAP (online analytical processes) is used to mention databases that store and manage data relevant for data analysis and decision making. OLTP and OLAP are not competing approaches to the same issue but processes that complement each other. More on this here https://www.imaginarycloud.com/blog/oltp-vs-olap/