MemSQL > Case Studies > Dell Transforms PRISM Inventory System with SingleStore for Real-Time Efficiency

Dell Transforms PRISM Inventory System with SingleStore for Real-Time Efficiency

MemSQL Logo
 Dell Transforms PRISM Inventory System with SingleStore for Real-Time Efficiency - IoT ONE Case Study
Technology Category
  • Analytics & Modeling - Real Time Analytics
  • Application Infrastructure & Middleware - Data Visualization
Applicable Industries
  • Buildings
  • Construction & Infrastructure
Applicable Functions
  • Procurement
  • Warehouse & Inventory Management
Use Cases
  • Picking, Sorting & Positioning
  • Real-Time Location System (RTLS)
  • Cloud Planning, Design & Implementation Services
  • System Integration
The Challenge
Enterprise procurement and third-party logistics systems have many moving parts, and data disconnects can lead to inefficiencies and wasted resources. Dell's existing inventory and enterprise resource planning (ERP) system, Glovia, provided batch data updates, with reports available every 30 minutes, and was not integrated with Dell's supply chain systems. These factors led to data disconnects and did not support the needs of a fast-paced global enterprise. Glovia reporting queries were taking too much compute power, and its storage needs were exploding. Dell needed to streamline its data footprint and optimize its inventory processes by modernizing PRISM and moving from batch data updates to real-time streaming reports.
The Customer

Dell Technologies

About The Customer
Dell Technologies, founded by Michael Dell in 1984, is one of the largest companies in the world, with more than 165,000 employees. It delivers solutions that help customers prepare for anything, anytime. Dell needed to optimize its inventory processes and streamline its data footprint to support its fast-paced global enterprise.
The Solution
Dell Technologies chose SingleStore, a multi-model relational database built for speed, scale, and agility, to modernize its PRISM inventory system. SingleStore supports all major data types, including JSON objects, and ingests data directly from Apache Kafka, enabling real-time data delivery. It offers ultra-fast ingest, low latency, high-performance queries, and the ability to handle petabyte-scale data volumes. Dell runs SingleStoreDB Self-Managed in its virtual machine farms to maintain control over sensitive data. PRISM runs on a 20-node SingleStore cluster deployed across data centers for business continuity. SingleStore powers real-time operational analytics and reporting for PRISM.
Quantitative Benefit
  • The implementation of SingleStore has significantly improved the speed and efficiency of Dell's PRISM inventory system. Analytic reports that previously took 30 minutes to load now load within a minute, providing near real-time reporting. Additionally, the use of SingleStore's columnstore compression has helped Dell save a massive amount of data storage. The exact quantitative benefits in terms of cost savings and performance improvements are not mentioned in the case study.

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

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.

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