Clickhouse
ClickHouse is an open source column-oriented database management system capable of real time generation of analytical data reports using SQL queries.
官网：https://clickhouse.yandex/
中文社区：http://clickhouse.com.cn
官方博客：https://yandex.com/blog/clickhouse
- Blazing Fast
- Linearly Scalable
- Hardware Efficient
- Fault Tolerant
- Feature Rich
- Highly Reliable
- Simple and Handy
Key Features
- True column-oriented storage
- Vectorized query execution
- Data compression
- Parallel and distributed query execution
- Real time query processing
- Real time data ingestion
- On-disk locality of reference
- Cross-datacenter replication
- High availability
- SQL support
- Local and distributed joins
- Pluggable external dimension tables
- Arrays and nested data types
- Approximate query processing
- Probabilistic data structures
- Full support of IPv6
- Features for web analytics
- State-of-the-art algorithms
- Detailed documentation
- Clean documented code
When to use ClickHouse
For analytics over stream of clean, well structured and immutable events or logs. It is recommended to put each such stream into a single wide fact table with pre-joined dimensions.
Some examples of viable applications:
- Web and App analytics
- Advertising networks and RTB
- Telecommunications
- E-commerce and finance
- Information security
- Monitoring and telemetry
- Time series
- Business intelligence
- Online games
- Internet of Things
When NOT to use ClickHouse
- Transactional workloads (OLTP)
- Key-value access with high request rate
- Blob or document storage
- Over-normalized data
更多介绍可以查看:
- https://clickhouse.yandex/
- clickhouse 中文社区的ClickHouse 基础介绍