Download PDF
Case Studies > Rockset’s real-time SQL on Amazon DynamoDB enables lifesaving IoT alerting device

Rockset’s real-time SQL on Amazon DynamoDB enables lifesaving IoT alerting device

Technology Category
  • Analytics & Modeling - Real Time Analytics
  • Platform as a Service (PaaS) - Data Management Platforms
  • Infrastructure as a Service (IaaS) - Cloud Databases
Applicable Industries
  • Consumer Goods
  • Healthcare & Hospitals
Applicable Functions
  • Business Operation
  • Product Research & Development
Use Cases
  • Predictive Maintenance
  • Real-Time Location System (RTLS)
  • Remote Asset Management
Services
  • Cloud Planning, Design & Implementation Services
  • System Integration
The Challenge
Many of the world’s fastest growing businesses are using Amazon DynamoDB, a fast and serverless NoSQL database service, because it delivers single-digit millisecond performance at any scale. However, building a data-intensive application that requires powerful SQL queries over data in DynamoDB requires months of pipeline development and database configuration as well as ongoing management and performance tuning. Using traditional methods, users would need to provision a SQL database to serve the application and set up a data pipeline to extract and transform the relevant data. The delay from updating data in DynamoDB to delivering actionable insights in the application could potentially be hours, which cannot meet the real-time requirements of most modern applications.
About The Customer
ido-data is a French connected devices company that specializes in building life-saving GPS-connected wristbands. These wristbands are designed to provide real-time location tracking and alerting capabilities, which are crucial for ensuring the safety and well-being of users. The company leverages advanced IoT technologies to create intelligent applications that can operate efficiently and effectively in real-time. By integrating with Rockset’s real-time SQL on DynamoDB, ido-data is able to enhance the performance and reliability of their devices, ensuring that they can deliver critical information with minimal latency. This integration allows ido-data to focus on innovation and improving their product offerings, while Rockset handles the complexities of real-time data processing and management.
The Solution
Rockset created a real-time database that allows users to power intelligent applications, such as personalization engines, gaming leaderboards, and IoT apps, on real-time data from DynamoDB. It runs on AWS architecture and uses DynamoDB Streams to consume data directly from DynamoDB—no ETL or data transformation required. Rockset makes the data from DynamoDB immediately available for queries using full-featured SQL via a REST endpoint. Using Rockset, developers can build new data applications in days, free from the burden of complex real-time data architectures. Rockset is able to help developers build scalable, real-time applications faster and more efficiently by leveraging the scalability, availability, agility, and security of AWS and serverless technologies.
Operational Impact
  • Rockset enables Amazon DynamoDB customers to unlock real-time data insights with fast SQL queries so they can build scalable, real-time applications, and increase developer velocity and efficiency.
  • Scales in real time by leveraging AWS architecture. Rockset enables customers to run complex SQL queries in real time at scale, without managing servers, clusters, or indexing. The success of their solution stems from the way they use AWS serverless architecture to enable microservices-based applications that perform at scale.
  • AWS serverless provides maximum flexibility for scaling by measuring units of consumption (e.g. throughput, memory) rather than servers. Serverless applications don’t require provisioning, maintaining, and administering servers for backend components such as compute, databases, storage, stream processing, message queueing, and more. AWS handles all of these capabilities, allowing Rockset to focus on product innovation while enjoying faster time-to-market.
Quantitative Benefit
  • 99.999% SLA for uptime from AWS.
  • DynamoDB can handle more than 10 trillion requests per day and can support peaks of more than 20 million requests per second.

Related Case Studies.

Contact us

Let's talk!

* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.