DataStax Touts Storage-Attached Indexing
for Apache Cassandra
September 24, 2020
released Storage-Attached Indexing (SAI), fundamentally advancing
indexing in Apache Cassandra. Storage-Attached Indexing is a highly
scalable, globally-distributed index for Apache Cassandra available on
Astra and DataStax Enterprise (DSE).
DataStax has also opened a Cassandra Enhancement Proposal (CEP) with the
Apache Cassandra project to share this with the open source community so
all users of the popular, open source database can benefit.
Developers require a simple experience to leverage the power of Apache
Cassandra for application development. Apache Cassandra is the proven
open-source, NoSQL database of the internet’s largest applications and
hardened by the world's top enterprises.
Storage-Attached Indexing is a robust and powerful index in Apache
Cassandra, making the open-source, scale-out, cloud-native NoSQL
database more usable. With Storage-Attached Indexing, developers now
have accessibility to familiar indexing and queries - such as WHERE
clauses - in Apache Cassandra.
"Developers have typically faced a tradeoff between scalability, ease of
use, and operations when choosing NoSQL,” said Ed Anuff, Chief Product
Officer at DataStax. "Storage-Attached Indexing gives developers robust,
new indexing that eliminates many of these tradeoffs, making development
and data modeling in Apache Cassandra easier to use, while also
increasing stability and performance and giving architects and operators
fewer moving parts to manage."
“Cassandra has proven itself to be a very fast and useful solution for
us at GE Aviation. However, we have important use cases that require
ad-hoc queries. To get around the current limitations, we have been
using Solr with variable success. We are very excited about SAI. It has
the potential to eliminate a huge pain point for us. It will further
help the adoption of Cassandra and generally make the lives of many
developers easier. This is definitely a step in the right direction for
Cassandra,” said Julian Chultarsky, Principal Enterprise Applications
Engineer at GE Aviation.
Storage-Attached Indexing is an index implementation that enables users
to index multiple columns on the same table without scaling issues. It
is optimized for storage and helps with Apache Cassandra performance and
provides operational simplicity.
benefits of Storage-Attached Indexing include:
Significantly reduces disk usage
Improved numeric range performance
Releases constraints to data modeling
and barriers to scale-out
Features modern and expected indexing
features on Apache Cassandra
Storage-Attached Indexing is generally
available in Astra and DSE 6.8.3. DataStax has also opened a Cassandra
Enhancement Proposal (CEP) with the Apache Cassandra project.