Aggregated Data, Analytics Application and Data Preparation

Comparing ClickHouse vs Rockset for Event and CDC Streams

Rockset

OCTOBER 4, 2022

Streaming data feeds many real-time analytics applications, from logistics tracking to real-time personalization. Event streams, such as clickstreams, IoT data and other time series data, are common sources of data into these apps. ClickHouse has several storage engines that can pre-aggregate data.

MySQL

MySQL Kafka Aggregated Data Architecture

Elasticsearch or Rockset for Real-Time Analytics: How Much Query Flexibility Do You Have?

Rockset

FEBRUARY 25, 2021

Joins are often used in real-time analytics applications to combine streaming data (usually representing events) with static data (like customer information). With Elasticsearch, joins are not a first class citizen and many teams end up denormalizing their data to model relationships.

SQL

SQL Data Pipeline Kafka Database

Data Engineering Digest

Comparing ClickHouse vs Rockset for Event and CDC Streams

Elasticsearch or Rockset for Real-Time Analytics: How Much Query Flexibility Do You Have?

Stay Connected