Ad Hoc Cassandra SQL Queries Using In-Memory Computing

In-memory computing can enable ad hoc Apache Cassandra SQL queries. 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 Cassandra ad hoc SQL 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-99 SQL compliance to run ad hoc and Cassandra SQL queries and structured SQL queries
  • Up to a 1,000x improvement in query speed
  • 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 about accelerating Cassandra query speeds.