Cassandra - Time Series

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.