Cassandra - Time Series

Data Modeling Chebotko Logical

About

This page is about time series in Cassandra.

They are stored in a wide partition, where the time is used as part of the partition key.

Usage

  • measurements at specific time intervals: business analysis, sensor data management, and scientific experiments.
  • transactional aggregate calculation. Example: balance.
    • Cassandra way: Each transaction is a timestamped row and the current balance is calculated by the application.
    • Old way: Aggregate field: Store each customer’s balance in a row increase contention
      • as various customers make transactions
      • as a transaction is needed around writes to protect the balance from being updated in error.







Share this page:
Follow us:
Task Runner