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.

Data Compression in ClickHouse vs Cassandra

Shiv Iyer

Introduction ClickHouse and Cassandra: two different databases optimized for different use cases. ClickHouse is a columnar database designed for analytical queries, while Cassandra is a NoSQL database designed for write-heavy workloads and scalability. Because of these fundamental differences in design and use […]

Cassandra’s Indexing Limitations for Real-time Analytics

Shiv Iyer

Introduction Cassandra, a highly-scalable NoSQL database, is renowned for its write-optimized architecture and resilience. With its capacity to handle vast volumes of data across distributed systems, many consider it a go-to choice for various applications. […]

ClickHouse vs Hadoop for Real-time Analytics

Shiv Iyer

Introduction This article highlights why Hadoop may not be the best fit for real-time analytics and discusses how ClickHouse emerges as a more suitable solution. 10 Reasons Why Hadoop is Not Recommended for Real-Time Analytics: […]

ClickHouse vs Cassandra for Real-time Analytics

Shiv Iyer

Introduction ClickHouse and Cassandra are both powerful data management systems, but they are designed for different use cases. 1. Data Model 2. Query Language 3. Aggregation 4. Data Compression 5. Indices 6. Throughput Conclusion The […]

ClickHouse Performance: Mastering ClickHouse Thread Tuning

Shiv Iyer

Introduction ClickHouse is renowned for its high-speed data processing capabilities, making it a popular choice for real-time analytics and big data applications. To extract the maximum potential from ClickHouse, optimizing thread performance is crucial. Thread […]

🚀 Exciting Plans for MinervaDB Inc. and ChistaDATA Inc.! 🌟

Shiv Iyer

Empowering Data Management: The Vision for MinervaDB and ChistaDATA As the founder of MinervaDB Inc. and ChistaDATA Inc., I am thrilled to share our vision for the next two years. Our companies have been established […]

ChistaDATA's Expertise in ClickHouse Vulnerability Remediation

ClickHouse Security: ChistaDATA’s Expertise in Vulnerability Remediation

Shiv Iyer

Introduction ClickHouse is a robust and high-performance columnar database widely used for real-time analytics and big data processing. Like any software, ClickHouse may have vulnerabilities that could potentially expose organizations to security risks. Understanding the anatomy […]

ClickHouse Installation: Cluster Setup and Configuration

ClickHouse Resource Safety: Implementing RAII and Destructors

Shiv Iyer

Introduction In ClickHouse’s C++ codebase, efficient resource management and preventing resource leaks are crucial for ensuring stable and high-performance data processing. C++ provides the powerful RAII (Resource Acquisition Is Initialization) idiom, which allows resources to […]

ClickHouse Performance: Real-Time Monitoring of Expensive Queries

Shiv Iyer

Introduction Expensive queries in ClickHouse can have a significant impact on overall system performance, consuming valuable resources like CPU, memory, and disk I/O. These resource-intensive queries can lead to increased latency and reduced throughput, hampering […]

ClickHouse Troubleshooting: Deep Dive into ClickHouse Wait Events

Shiv Iyer

Introduction ClickHouse Wait Events are specific events or conditions that can cause the system to pause or wait during query execution. These events can significantly influence the performance of ClickHouse, as they impact query execution […]