Future growth and expansion

In the realm of NoSQL systems, a well-recognized and widely accepted trade-off involves sacrificing query flexibility to achieve predictable performance and high scalability. While the horizontal scaling of NoSQL databases can deliver exceptional performance at scale, they are not optimized to seamlessly support read queries with numerous optional and unknown filters. Furthermore, in the context of databases such as DynamoDB, the requirement to have knowledge of 60-70% of your application’s access patterns upfront may prove to add an additional layer of complexity for users.

For tables implementing non-overloaded partition key and sort key attribute names instead of the generic PK and SK, evolving the table schema may be an involved process. This evolution may require creating a new table with the evolved key schema and migrating data from the current table, often involving varying degrees of downtime requirements. This highlights a significant...