Articles by Shiv Iyer

About Shiv Iyer
Open Source Database Systems Engineer with a deep understanding of Optimizer Internals, Performance Engineering, Scalability and Data SRE. Shiv currently is the Founder, Investor, Board Member and CEO of multiple Database Systems Infrastructure Operations companies in the Transaction Processing Computing and ColumnStores ecosystem. He is also a frequent speaker in open source software conferences globally.
Website Facebook Twitter LinkedIn
ChistaDATA

Open Source Data Warehousing and Analytics

Shiv Iyer
Open Source Data Warehousing and Analytics: ChistaDATA’s Expert ClickHouse Support Executive Summary In an era where data has become the lifeblood of modern enterprises, organizations are increasingly recognizing the critical importance of robust, scalable, and […]
Analytics

Connecting ClickHouse to Kafka: A Practical Guide

Shiv Iyer
Connecting ClickHouse® to Apache Kafka®: A Complete Technical Guide Introduction Apache Kafka and ClickHouse form a powerful combination for real-time analytics and data processing. ClickHouse, a high-performance columnar database, excels at analytical workloads, while Kafka […]
Cassandra

ColumnStore vs. Modern Data Warehousing

Shiv Iyer
ColumnStore vs. Modern Data Warehousing: Optimizing Real-Time Analytics Performance Introduction Real-time analytics has become the cornerstone of data-driven decision making, demanding storage architectures that can handle massive volumes while delivering sub-second query performance. This technical […]
ClickHouse Performance

Eliminating Expensive JOINs in ClickHouse

Shiv Iyer
Eliminating Expensive JOINs in ClickHouse: Advanced JSON and Array Optimization Techniques for High-Performance Analytics Introduction In the world of high-performance analytics, JOIN operations often represent the most significant bottleneck in query execution. ClickHouse, the open-source […]
ClickHouse Performance

ClickHouse Thread Architecture

Shiv Iyer
Mastering ClickHouse Thread Architecture: A Deep Dive into High-Performance Query Execution ClickHouse’s reputation as one of the fastest analytical databases stems largely from its sophisticated thread management system. Understanding how ClickHouse orchestrates threads can help […]
ClickHouse Query Performance

Troubleshooting Suboptimal ClickHouse Queries

Shiv Iyer
Troubleshooting Suboptimal ClickHouse Queries To troubleshoot and optimize slow ClickHouse queries, follow these steps: 1. Use EXPLAIN to Analyze Query Plans EXPLAIN syntax SELECT * FROM table WHERE condition Available syntax options: EXPLAIN PLAN – […]