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.