Clickhouse

Clickhouse is an open-source column-oriented database management system that allows generating analytical data reports in real-time using SQL queries. It is capable of processing hundreds of millions to more than a billion rows and tens of gigabytes of data per single server per second.

Features

• Column-oriented storage: Clickhouse stores data in columns rather than rows, which allows it to read only the necessary columns when executing a query. This results in faster query execution times.
• Real-time data analysis: Clickhouse is designed to process analytical queries on large volumes of data in real-time. It can handle hundreds of millions to more than a billion rows and tens of gigabytes of data per single server per second.
• SQL support: Clickhouse supports SQL queries, which makes it easy to use for developers and data analysts.