Apache Cassandra Ad Hoc SQL Queries with GridGain

In-Memory Computing Speeds and SQL Functionality

Apache Cassandra is a commonly used NoSQL database. Cassandra is scalable and can be highly available and can be configured for high-availability. However, Cassandra is lacking in a few key areas – particularly speed. Cassandra is not fast enough for many of today’s demanding OLTP workloads because it stores data on disk. In addition, Cassandra is limited by:

  • No ad hoc query capabilities
  • 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

However, inserting the GridGain in-memory computing platform between Apache Cassandra and an application provides the following capabilities for the portion of the data stored in GridGain:

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