--- title: "#olap articles | Hashnode" description: "Explore 45 articles tagged #olap on Hashnode. Tutorials, guides, and how-tos from the community." url: "https://hashnode.com/tag/olap" --- Tag # #olap 45 posts · 3 followers [Soham Gaichor](https://hashnode.com/@soham111) · [Oct 14](https://hashnode.com/posts/the-cashier-and-the-ceo-a-tale-of-two-database-worlds-oltp-vs-olap/6acfb01f1b7c7ffa439d5e26) ### [The Cashier and the CEO: A Tale of Two Database Worlds (OLTP vs. OLAP)](https://soham111.hashnode.dev/the-cashier-and-the-ceo-a-tale-of-two-database-worlds-oltp-vs-olap?utm_source=hashnode&utm_medium=feed) Master the core differences between OLTP (transactions) and OLAP (analytics). Discover how databases handle fast updates and multi-dimensional reports 5 min read · [soham111.hashnode.dev](https://soham111.hashnode.dev/the-cashier-and-the-ceo-a-tale-of-two-database-worlds-oltp-vs-olap?utm_source=hashnode&utm_medium=feed) [Manu Shukla](https://hashnode.com/@mr-manushukla) · [Jul 27](https://hashnode.com/posts/real-time-analytics-in-2026-lakehousert-vs-clickhouse-druid-and-pinot/6a67398c85aa4afd5bb97197) ### [Real-time analytics in 2026: Lakehouse//RT vs ClickHouse, Druid and Pinot](https://ecorpit.hashnode.dev/real-time-analytics-in-2026-lakehousert-vs-clickhouse-druid-and-pinot?utm_source=hashnode&utm_medium=feed) Real-time analytics in 2026: Lakehouse//RT vs ClickHouse, Druid and Pinot Summary. On 16 June 2026 Databricks launched Lakehouse//RT, a real-time query engine (code-named Reyden) that Databricks says 15 min read · [ecorpit.hashnode.dev](https://ecorpit.hashnode.dev/real-time-analytics-in-2026-lakehousert-vs-clickhouse-druid-and-pinot?utm_source=hashnode&utm_medium=feed) [Ravi Mistry](https://hashnode.com/@ravimistry) · [Jul 8](https://hashnode.com/posts/trade-offs-in-data-systems-architecture/6a4e5a68552cf7ebd415b4a5) ### [Trade-Offs in Data Systems Architecture](https://ravimistry.hashnode.dev/trade-offs-in-data-systems-architecture?utm_source=hashnode&utm_medium=feed) Choosing What Matters Most: Speed, Reliability, Scalability or Simplicity? 14 min read · [ravimistry.hashnode.dev](https://ravimistry.hashnode.dev/trade-offs-in-data-systems-architecture?utm_source=hashnode&utm_medium=feed) [Fahad Shah](https://hashnode.com/@fahadshah) · [Apr 8](https://hashnode.com/posts/clickhouse-vs-risingwave-2026/69d5a00a36bba76421ff548c) ### [ClickHouse vs RisingWave in 2026: OLAP vs Streaming SQL](https://risingwave.com/blog/clickhouse-vs-risingwave-2026?utm_source=hashnode&utm_medium=feed) ClickHouse is the fastest OLAP database for historical analytics. RisingWave is the leading streaming SQL database for real-time data. They solve different problems -- here is how to choose. 15 min read · [risingwave.com](https://risingwave.com/blog/clickhouse-vs-risingwave-2026?utm_source=hashnode&utm_medium=feed) [Md. Amirul Islam](https://hashnode.com/@amir006) · [Feb 2](https://hashnode.com/posts/ddia-chapter-3/69801ba0ffb4a0445a4588a7) ### [DDIA: Chapter-3](https://ainahid.hashnode.dev/ddia-chapter-3?utm_source=hashnode&utm_medium=feed) Storage and Retrieval 36 min read · [ainahid.hashnode.dev](https://ainahid.hashnode.dev/ddia-chapter-3?utm_source=hashnode&utm_medium=feed) [Kiruthiga Jaiganesh](https://hashnode.com/@KIRUTHIGA1427) · [Jul 29, 2025](https://hashnode.com/posts/fast-replacing-of-millions-of-rows-daily-in-clickhouse-a-partitioned-merge-tree-solution/6888e1a9541c6cb69d5f2bfa) ### [⚡️ Fast Replacing of Millions of Rows Daily in ClickHouse – A Partitioned Merge Tree Solution](https://clickhouse-partition-swap-trick.hashnode.dev/fast-replacing-of-millions-of-rows-daily-in-clickhouse-a-partitioned-merge-tree-solution?utm_source=hashnode&utm_medium=feed) Optimize ClickHouse performance by using partitioned MergeTree and partition swaps to replace large datasets quickly—no FINAL or slow merges needed. 2 min read · [clickhouse-partition-swap-trick.hashnode.dev](https://clickhouse-partition-swap-trick.hashnode.dev/fast-replacing-of-millions-of-rows-daily-in-clickhouse-a-partitioned-merge-tree-solution?utm_source=hashnode&utm_medium=feed) [Abhishek Chandra](https://hashnode.com/@abhishekchandra) · [Jul 21, 2025](https://hashnode.com/posts/oltp-vs-olap-understanding-the-key-differences/687df61980bef604c37bc1f6) ### [OLTP vs OLAP: Understanding the Key Differences](https://abhishekchandra.hashnode.dev/oltp-vs-olap-understanding-the-key-differences?utm_source=hashnode&utm_medium=feed) OLTP vs OLAP: Understanding the Key Differences 2 min read · [abhishekchandra.hashnode.dev](https://abhishekchandra.hashnode.dev/oltp-vs-olap-understanding-the-key-differences?utm_source=hashnode&utm_medium=feed) [Sofiya Parvez Pathan](https://hashnode.com/@sfy) · [Jun 14, 2025](https://hashnode.com/posts/clickhouse-the-columnar-powerhouse-for-real-time-analytics/684d82697326833861ec7506) ### [ClickHouse: The Columnar Powerhouse for Real-Time Analytics](https://clickhouse-sfy.hashnode.dev/clickhouse-the-columnar-powerhouse-for-real-time-analytics?utm_source=hashnode&utm_medium=feed) In today’s data-driven world, the demand for high-performance, low-latency analytics systems has grown exponentially. Traditional databases often crumble under the weight of massive data volumes. Enter ClickHouse: an open-source, high-performance, co... 5 min read · [clickhouse-sfy.hashnode.dev](https://clickhouse-sfy.hashnode.dev/clickhouse-the-columnar-powerhouse-for-real-time-analytics?utm_source=hashnode&utm_medium=feed) [Juanjo Requena](https://hashnode.com/@juanjorequena) · [Jun 1, 2025](https://hashnode.com/posts/motores-de-bases-de-datos/683bcbed6bca800444bba4bd) ### [⚙️Motores de bases de datos: OLTP vs OLAP](https://juanjorequena.hashnode.dev/motores-de-bases-de-datos?utm_source=hashnode&utm_medium=feed) Vamos a hablar de algo un poco más amplio: los motores de bases datos. Los podemos dividir en dos grandes categorías: OLTP y OLAP. 3 min read · [juanjorequena.hashnode.dev](https://juanjorequena.hashnode.dev/motores-de-bases-de-datos?utm_source=hashnode&utm_medium=feed) [SIDDHANT BOBDE](https://hashnode.com/@siddhantbobde) · [May 4, 2025](https://hashnode.com/posts/clickhouse-csv-ingestion-with-python-explicit-schema/68170b15472c9aa0a085c0bc) ### [ClickHouse CSV Ingestion with Python: Explicit Schema](https://blog.siddhantbobde.com/clickhouse-csv-ingestion-with-python-explicit-schema?utm_source=hashnode&utm_medium=feed) create table in clickhouse, using python, explicit schema 3 min read · [blog.siddhantbobde.com](https://blog.siddhantbobde.com/clickhouse-csv-ingestion-with-python-explicit-schema?utm_source=hashnode&utm_medium=feed)