According to a new press release, “Rockset, the serverless search and analytics company, today announced the availability of real-time SQL on NoSQL data from Amazon DynamoDB — a key-value and document database that delivers single-digit millisecond performance at any scale. Hundreds of thousands of AWS customers have chosen DynamoDB as their key-value and document database for mobile, web, gaming, ad tech, Internet of Things (IoT) and other applications that need low-latency data access at any scale. With DynamoDB usage maturing in organizations, there is an increasing need for operational analytics and real-time business reporting on it, which requires the ability to search transactional data, run aggregations and join the data with other datasets. As stated in the Amazon Web Services blog, ‘DynamoDB is not suitable for running scan operations or fetching a large volume of data because it’s designed for fast lookup using partition keys. Additionally, there are a number of constraints (like lack of support for powerful SQL functions such as group by, having, intersect and joins) in running complex queries against DynamoDB’.”
The release continues, “Rockset is an operational analytics engine that is entirely serverless, which means it does not require provisioning, capacity planning or server administration in the cloud. Developers and data engineers can run complex queries with the full power of SQL and choose to visualize the data in live dashboards such as Tableau, or build custom applications using Rockset’s real-time SQL. ‘Once provided with read access to a DynamoDB table, Rockset reflects changes as they occur in DynamoDB by making use of changelogs in DynamoDB streams. This gives users an up-to-date (within a few seconds) indexed version of their DynamoDB table in Rockset,’ said Venkat Venkataramani, CEO of Rockset. ‘And each SQL query against this table is distributed and executed in parallel to ensure that query results return in milliseconds’.”
Read more at Globe Newswire.
Image used under license from Shutterstock.com