Amazon Keyspaces now helps you update and store common data between multiple rows efficiently by using static columns

Posted on: Nov 9, 2020

Amazon Keyspaces (for Apache Cassandra), a scalable, highly available, and fully managed Cassandra-compatible database service, now helps you update and store common data between multiple rows efficiently by using static columns. 

By using static columns, you can define a common column value for all rows in a logical partition. When you insert, update, or delete the value of a static column, the change applies to all rows in the logical partition automatically. For example, you can use a static column to store the text description of a unique identifier in your partition key, such as a customer, product, or device code. You then would have to perform only one write to update or delete this text description instead of coordinating writes across multiple rows. Static columns also help you store common data more efficiently and reduce costs by storing a single copy of the data for all rows in the logical partition. 

Support for static columns is available in all AWS Regions where Amazon Keyspaces is offered

For more information, see Static Columns in the Amazon Keyspaces Developer Guide.