Apache Cassandra Ad Hoc SQL Queries with GridGain

In-Memory Computing Speeds and SQL Functionality

Apache Cassandra can be a high performance solution for structured queries in which your data is modeled such that each pre-defined query results in one row retrieval. However, this requires that you know your queries before you model your data. In addition, Cassandra is limited by:

  • Not offering an in-memory computing option
  • Not supporting transactions, ACID or otherwise
  • Lack of support for SQL and no ability to perform joins, aggregations, groupings or usable indexes
  • No ad hoc query capabilities

However, when Apache Cassandra is used with the GridGain In-Memory Data Fabric, Cassandra users can:

  • See a 1,000x query speed improvement from in-memory computing
  • Leverage ANSI SQL-99 compliance to run ad hoc and structured queries
  • Use ACID compliant transactions to read and write data to their Cassandra database
Read the white paper, Super Power Apache® Cassandra™ for Extreme OLTP Workloads with GridGain, to learn more.