The Tale of OLTP, OLAP, and HTAP in Data Warehousing - The Backend Engineering Show with Hussein Nasser

The Backend Engineering Show with Hussein Nasser

Episode | Podcast

Date: Sun, 09 May 2021 05:01:21 GMT

<p>In this show, I discuss why we have 3 data models in database systems, OLTP (Online Transactional Processing) OLAP (Online Analytical Processing), and HTAP (Hybrid Transactional Analytical Processing). I’ll also explain the difference between them, the use of ETL tools (extract transform load) to load data from transactional to analytical databases, and what is the future of HTAP.</p> <p><br /></p> <p>Support my work on PayPal</p> <p><a href="https://bit.ly/33ENps4">https://bit.ly/33ENps4</a></p> <p>Become a Member on YouTube</p> <p><a href="https://www.youtube.com/channel/UC_ML5xP23TOWKUcc-oAE_Eg/join">https://www.youtube.com/channel/UC_ML5xP23TOWKUcc-oAE_Eg/join</a></p> <p><a href="https://emojipedia.org/teacher/">🧑‍🏫</a><strong> </strong>Courses I Teach</p> <p>https://husseinnasser.com/courses</p>