Skip to main content

7 posts tagged with "secondary index"

View All Tags

· 11 min read
Neel Phadnis

(Source: Photo by Jan Antonin Kolar on Unsplash Source: Photo by Jan Antonin Kolar on Unsplash

Queries, scans, indexes, pagination, and parallelism are common concepts in databases, but each database differs in specifics. It is vital to understand the specifics in order to get the most out of a database. In Aerospike, queries and indexes play a key role in realizing its speed-at-scale objective. The goal of this post is to help developers better understand the Aerospike capabilities in these areas.

· 11 min read
Neel Phadnis

(Source: Photo by Cameron Ballard on [Unsplash](https://unsplash.com/) ) Source: Photo by Cameron Ballard on Unsplash

The Collection Data Types (CDTs) in Aerospike are List and Map. They offer powerful capabilities to model and access your data for speed-at-scale. A major use of the CDTs is to store and process JSON documents efficiently. In the recent Aerospike Database 6.1 release, secondary index capabilities over the CDTs have been enhanced to make the CDTs even more useful and powerful for JSON documents in addition to other uses.

· 4 min read
Yevgeny Rizhkov

Speed up your SQL queries using Aerospike secondary indexes

With Aerospike Server 6.0, we have enhanced secondary index queries to allow for querying by partition, throttling, etc. The Trino connector now leverages this functionality to accelerate your secondary key queries at scale.

· 10 min read
Ronen Botzer

Aerospike is proud to announce Aerospike Database 6, our newest database server release, now generally available (GA). This version of Aerospike is full of exciting developer features, which open up new capabilities for application developers to build on.

· 6 min read
Ronen Botzer

Aerospike Database 6 is here, loaded with new developer features - partitioned queries, query pagination, batch anything and more. You can read a detailed overview in Aerospike Database 6: Partitioned Secondary Index Queries, Batch Anything, and JSON Document Models.

· 3 min read
Ronen Botzer

The soon-to-be-released Aerospike 5.7 includes the first milestone of a rewrite of Secondary Indexes. Among these new features are indexes which are 60% more memory efficient, faster queries, and a superior new garbage collection system. You can get a more comprehensive launch overview by reading the blog post Aerospike Database 5.7: Operational, Query, and Security Enhancements.

· 3 min read

Secondary indexes are on a non-primary key, which allows you to model one-to-many relationships. [https://www.aerospike.com/docs/architecture/secondary-index.html](https://www.aerospike.com/docs/architecture/secondary-index.html) Secondary indexes are on a non-primary key, which allows you to model one-to-many relationships. https://www.aerospike.com/docs/architecture/secondary-index.html

spring-data-aerospike supports creating secondary indexes in Aerospike out of the box.

There are two ways to accomplish this task:

  1. Using AerospikeTemplate createIndex method; or

  2. Using @Indexed annotation placed over the field in your entity.