Are parallel plans good or bad for ClickHouse Performance?

Parallel query execution in ClickHouse can have both positive and negative effects on performance, depending on the specific use case and the characteristics of the data set. Here’s an explanation of the potential impact of parallel plans on ClickHouse performance using real-life data set examples: For example, consider a scenario where you need to perform […]

How does modern banking use ClickHouse for real-time fraud detection and analytics?

The modern banking industry faces significant challenges related to fraud prevention. Fraudsters are becoming increasingly sophisticated, and traditional fraud detection methods are often insufficient to detect and prevent fraudulent activities. Real-time fraud analytics is an essential tool for banks to detect and prevent fraud in real-time. ClickHouse is an ideal platform for real-time fraud analytics […]

How do Data Scientists use Black-Scholes model on ClickHouse?

The Black-Scholes model is a mathematical formula used to estimate the price of European-style options, which are financial contracts that give the holder the right, but not the obligation, to buy or sell an underlying asset at a predetermined price within a specified time period. The formula was developed by Fischer Black and Myron Scholes […]

Why must modern banking migrate from traditional OLAP to real-time analytics on ClickHouse for increased customer satisfaction and success?

The migration from traditional Online Analytical Processing (OLAP) systems to real-time analytics on ClickHouse is driven by the growing need for faster and more cost-effective data processing in the modern banking industry. As customer expectations and competition increase, banks must leverage advanced analytics to gain insights, optimize operations, and enhance customer satisfaction. There are several […]

Why do you need great investor teams when you are serious about building a large corporation?

I very rarely write blogs outside Tech., This blog is my experience with Sequoia Capital (investor in both MinervaDB and ChistaDATA); during the worst scenario, any business owner/Founder/CEO can be in. Yes, We have massive exposure in Silicon Valley Bank. Last week was the toughest for many people (founders/investors/employees/SVB teams ) associated with SVB as […]

How sorting algorithm is implemented in ClickHouse?

ClickHouse uses a merge-sort algorithm to sort data internally. The merge-sort algorithm works by dividing the data into smaller blocks, sorting each block individually, and then merging the sorted blocks together to produce the final sorted output. In ClickHouse, the sorting algorithm is implemented in a way that is optimized for performance and scalability. When […]

Understanding CPU usage by ClickHouse Server

ClickHouse is designed to be highly optimized for performance and scalability, with a focus on efficient use of system resources, including CPU usage. Understanding the CPU usage by a ClickHouse server can be important for optimizing performance and resolving any performance bottlenecks. ClickHouse utilizes a parallel query execution engine that distributes workloads across multiple cores, […]

Overview of Clickhouse-compressor

Image Source ClickHouse is an open-source column-oriented database management system developed by Yandex. One of the critical features of ClickHouse is its ability to compress data in order to save storage space and increase query performance. This article will provide an overview of the different compression methods used in ClickHouse and how they impact performance […]