Rockset Announces Real-Time SQL Analytics on Amazon DynamoDB NoSQL Database Service California’s Rockset announced that its serverless search engine and analytics engine now performs real-time SQL analysis on the NoSQL Amazon DynamoDB data service. This functionality is what the company specializes in, so it points its SQL-based analysis engine to NoSQL storage stores like Kafka and S3 storage bins, as well as Amazon DynamoDB. Amazon DynamoDB, a key-value, document and key-value database that Amazon Web Services Inc. (AWS), touts for its many capabilities, including backing Web-scale apps such as social networks and gaming, media sharing and the Internet of Things (IoT), but not for performing analytical queries, Rockset stated in an announcement. The company stated that DynamoDB usage is maturing in organizations. “There is an increasing need to operational analytics and real time business reporting on it. This requires the ability search transactional data and run aggregations, and join the data with others.” Rockset pointed out that DynamoDB was not designed for large-scale data fetches or scan operations. AWS wrote about DynamoDB in a blog post. Complex queries against DynamoDB are also limited by limitations, such as the inability to support powerful SQL functions like group by, having and intersect, joins, and joins. Developers have the opportunity to use Rockset’s ability for SQL analytical queries to be run on NoSQL data.