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

Edit This Case Study Record

	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 Infrastructure as a Service (IaaS) - Cloud Databases Platform as a Service (PaaS) - Data Management Platforms
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
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. Read More
About 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. Read More
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. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Real Time Analytics

Infrastructure as a Service (IaaS) - Cloud Databases

Platform as a Service (PaaS) - Data Management Platforms

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

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 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.

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.

Impact #1	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.
Impact #2	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.
Impact #3	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.

Impact #1

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.

Impact #2

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.

Impact #3

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.

Benefit #1	99.999% SLA for uptime from AWS.
Benefit #2	DynamoDB can handle more than 10 trillion requests per day and can support peaks of more than 20 million requests per second.

Benefit #1

99.999% SLA for uptime from AWS.

Benefit #2

DynamoDB can handle more than 10 trillion requests per day and can support peaks of more than 20 million requests per second.

Download PDF Version

Overview

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

Operational Impact

Quantitative Benefit