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
Mastering Chained Joins In Clickhouse
ClickHouse Join

ClickHouse JOIN: Mastering Chained Joins

Shiv Iyer
Introduction Financial systems analytics demand sophisticated data manipulation, often involving multiple joins to extract valuable insights. In this guide, we will explore how to implement multiple joins, often referred to as chained joins, in ClickHouse, […]
Mastering Hash Joins In Clickhouse
ClickHouse Join

ClickHouse JOIN: Mastering Hash Joins

Shiv Iyer
Introduction In ClickHouse, Hash Joins are a powerful method for combining data from multiple tables efficiently. They fall under the category of “merge joins,” where ClickHouse takes advantage of sorted data structures to speed up the joining […]
Overview of Vectorized Query Processing in ClickHouse
ClickHouse Performance

Vectorized Query Processing for ClickHouse Performance

Shiv Iyer
Introduction: Vectorized query computing is a crucial optimization technique that significantly influences the performance of real-time analytics solutions. It transforms the way queries are processed by simultaneously operating on multiple data elements, maximizing hardware resources […]