Solid overview of the title question. I sort-of disagree on the demarcation between OLAP and OLTP, because the “OLTP” databases mentioned are perfectly capable of serving OLAP workloads for many use cases, but for workloads involving scans over large datasets I’d agree with making the same categorizations.
https://www.startdataengineering.com/post/what-is-a-data-warehouse/