Cassandra Ad Hoc SQL Queries Using In-Memory Computing

In-memory computing can enable Cassandra ad hoc SQL queries. 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
  • 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.