Data Aggregation using Columnar Database ClickHouse with Sayed Alesawy - Tech Podcast بالعربي

Data Aggregation using Columnar Database ClickHouse https://sayedalesawy.hashnode.dev/   / sayed_alesawy     / ahmdelemam   Summary Performance data is very raw and vast. Powerful high cardinality aggregations have to be performed in order to make sense of the data. Columnar databases are better for analytics use cases because they: Allow reading smaller chunks of data. Implement data compression. Implement vectorized query execution. Support for lots of analytical functions out of the box. Incremental aggregations is key achieving high performance. Using aggregation states can unlock immense performance gains. It’s important to always consider business trade-offs vs performance. It’s okay to have different representations of the same data set to serve different query patterns, don’t be afraid from data duplication. ClickHouse vs. Elasticsearch