Download PDF
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
Quantitative Benefit
Related Case Studies.
Case Study
Improving Vending Machine Profitability with the Internet of Things (IoT)
The vending industry is undergoing a sea change, taking advantage of new technologies to go beyond just delivering snacks to creating a new retail location. Intelligent vending machines can be found in many public locations as well as company facilities, selling different types of goods and services, including even computer accessories, gold bars, tickets, and office supplies. With increasing sophistication, they may also provide time- and location-based data pertaining to sales, inventory, and customer preferences. But at the end of the day, vending machine operators know greater profitability is driven by higher sales and lower operating costs.
Case Study
Hospital Inventory Management
The hospital supply chain team is responsible for ensuring that the right medical supplies are readily available to clinicians when and where needed, and to do so in the most efficient manner possible. However, many of the systems and processes in use at the cancer center for supply chain management were not best suited to support these goals. Barcoding technology, a commonly used method for inventory management of medical supplies, is labor intensive, time consuming, does not provide real-time visibility into inventory levels and can be prone to error. Consequently, the lack of accurate and real-time visibility into inventory levels across multiple supply rooms in multiple hospital facilities creates additional inefficiency in the system causing over-ordering, hoarding, and wasted supplies. Other sources of waste and cost were also identified as candidates for improvement. Existing systems and processes did not provide adequate security for high-cost inventory within the hospital, which was another driver of cost. A lack of visibility into expiration dates for supplies resulted in supplies being wasted due to past expiry dates. Storage of supplies was also a key consideration given the location of the cancer center’s facilities in a dense urban setting, where space is always at a premium. In order to address the challenges outlined above, the hospital sought a solution that would provide real-time inventory information with high levels of accuracy, reduce the level of manual effort required and enable data driven decision making to ensure that the right supplies were readily available to clinicians in the right location at the right time.
Case Study
Gas Pipeline Monitoring System for Hospitals
This system integrator focuses on providing centralized gas pipeline monitoring systems for hospitals. The service they provide makes it possible for hospitals to reduce both maintenance and labor costs. Since hospitals may not have an existing network suitable for this type of system, GPRS communication provides an easy and ready-to-use solution for remote, distributed monitoring systems System Requirements - GPRS communication - Seamless connection with SCADA software - Simple, front-end control capability - Expandable I/O channels - Combine AI, DI, and DO channels
Case Study
Driving Digital Transformations for Vitro Diagnostic Medical Devices
Diagnostic devices play a vital role in helping to improve healthcare delivery. In fact, an estimated 60 percent of the world’s medical decisions are made with support from in vitrodiagnostics (IVD) solutions, such as those provided by Roche Diagnostics, an industry leader. As the demand for medical diagnostic services grows rapidly in hospitals and clinics across China, so does the market for IVD solutions. In addition, the typically high cost of these diagnostic devices means that comprehensive post-sales services are needed. Wanteed to improve three portions of thr IVD:1. Remotely monitor and manage IVD devices as fixed assets.2. Optimizing device availability with predictive maintenance.3. Recommending the best IVD solution for a customer’s needs.