MemSQL > Case Studies > Dell Transforms its PRISM Inventory System with SingleStore

Dell Transforms its PRISM Inventory System with SingleStore

MemSQL Logo
 Dell Transforms its PRISM Inventory System with SingleStore - IoT ONE Case Study
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. Since the minimum required holding period for audits is seven years, Dell already has to store substantial amounts of historical data in its Teradata enterprise data warehouse, and regional regulations in some parts of the world — e.g., minimum hold time requirements of up to 30 years of data in China — make it even more challenging.

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 team wanted to move from its legacy application to a modern technology stack within a year by creating a real-time inventory application with the speed and scale to meet the needs of the business.

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 across the globe. Today, Dell Technologies, which at the time of publication ranks #31 on the Fortune 500,  is instrumental in changing the digital landscape the world over, delivering solutions that help customers prepare for anything, anytime.

The Customer

Dell Technologies

The Solution

Dell Technologies runs SingleStoreDB Self-Managed in its virtual machine (VM) farms, because It has the technical expertise and resources to support this infrastructure and because it avoids moving sensitive data, including inventory data, into the cloud.

PRISM runs on a 20-node SingleStore cluster, adeptly deployed across data centers to ensure business continuity, and with SingleStore, replication across data centers now occurs in real-time. PRISM has 1.87TB of data in memory and 3.6 TB of data in column store within the SingleStore clusters.

PRISM sends Change Data Capture and Batch processed data to a data lake that uses Kafka, StreamSets, and Oracle GoldenGate and divides its dataflows based on data types and speeds:

  1. PRISM manages real-time dataflows and operational reporting that requires 1-2 years of data retention, with SingleStore. It sends data that requires real-time and near real-time processing into the Enterprise Information System, which streams real-time and operational data into SingleStore through native Kafka ingestion. SingleStore powers PRISM’s real-time operational analytics and reporting via VMware Pivotal Cloud Foundry, Oracle, and custom-built microservices.
  2. PRISM sends non-real-time and non-operational data into Greenplum (now branded as VMware Tanzu Greenplum). Greenplum supports PRISM historical reporting via Microsoft Power BI, Salesforce Tableau, and Microsoft SQL Server.

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

Contact us

Let's talk!

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