Company attributes
Other attributes
ClickHouse is a company offering an online, open-source, column-oriented, analytical processing (OLAP) database management system to enable users generate analytical reports using SQL queries in real-time. The company claims the technology works 100 to 1000 times faster than traditional database management systems and is capable of processing hundreds of millions to over a billion rows and tens of gigabytes of data per server per second.
The OLAP data management system is built to offer efficient performance which can, according to ClickHouse, reduce storage requirements through the platforms use of columnar storage and compression. The platform is built to scale in production with linear and horizonal scalability from single-server deployments to clusters with thousands of nodes, and intended to be able to scale with companies.
Further, the platform is built to offer reliability, without single points of failure, and with an architecture built to support multi-master replication and to perform in multi-region configuration. ClickHouse's platform is also built to include enterprise grade security features and fail-safe mechanisms to protect against application bugs and human errors.
Features of the ClickHouse platform includes features, including data compression, which works to play a key role in the platforms ability to achieve its state performance. This data compression is done with general-purpose compression codecs with different trade-offs between disk space and CPU consumption, and includes codecs built by ClickHouse for specific kinds of data common to the platform.
The platform also uses parallel processing on multiple cores in order to take advantage or larger multi-core processors and especially for the parallelization of larger queries. And ClickHouse's platform supports distributed processing on multiple servers, and data in ClickHouse can reside on different shards, with each shard capable of being a group of replicas used for fault tolerance.
In independent testing on the performance of ClickHouse, especially in comparison to competitors PostgreSQL and Timescale, found the platform was capable of ingesting data at very fast rats, beating the competitors software, and capable of complex query ingestion and complex grouping aggregations also faster than those platforms.
The testing also found the architectural decisions, when compared to PostgreSQL and Timescale, had some limitations, for example poor inserts and higher disk usage at small batch sizes, worse query performance in benchmarking, and non-standard SQL-like query language.
ClickHouse’s technology was first developed at Yandex, an internet service corporation in Europe. It was initially created to power Yandex.Metrica, a web analytics platform. The power and utility of ClickHouse was clarified; by providing a column-based DBMS, it allowed systems to generate reports from petabytes of raw data with sub-second latencies. In 2016, ClickHouse was made available as an open source solution in 2016, and has been adopted by companies like Uber, Comcast, eBay, and Cisco. ClickHouse was incorporated in 2021 to incorporate to house the open source technology with an initial investment from Index Ventures and Benchmark Capital. The company continues to open source project and engineering the cloud technology.
