Modeling Financial Data In Cassandra To Serve Real Time And Batch Workloads
summary
Capital One uses Apache Cassandra plus Apache Spark and Spring microservices to store rewards so one Cassandra schema serves both real‑time customer views and batch monthly statements for millions of customers. Design duplicates rows into a customer_account partition key table for millisecond reads by web/mobile and a customer_account + timeframe table for time‑bucketed Spark aggregation, keeps the two tables in sync at write time, and runs in production in cloud with tunable consistency (local quorum) successfully.
AI-written summary · about
chapters (7)
- 0:00Introduction
- 1:08About Me
- 2:23Agenda
- 8:05Use Case Driven Data Modeling
- 10:51Rewards Use Case
- 13:03RealTime Use Case
- 17:12Numerical Use Case
related talks
38mReal-time analytics with Apache Cassandra & Apache Spark
35mMission Critical Data, and Evaluating the Community in OSS Tech
35mThe What and Why of Cassandra Datamodelling at Scale
46mApache Cassandra: 8 years in production
32mMigrating Workloads from Mainframes to Cassandra - Problems, Experience and Learnings
26mReal time Platform for Second Look Business Use Case Using Spark & Kafka
26mUnleash the Power of Apache Cassandra: Scalable Recommendation Systems, Real-time Fraud Detection
54mHarnessing the Power of Spark & Cassandra within your Spring App