下载PDF
Dell's Transformation of PRISM Inventory System with SingleStore for Real-Time Business Operations
技术
- 分析与建模 - 实时分析
- 应用基础设施与中间件 - 数据可视化
适用行业
- 建筑物
- 建筑与基础设施
适用功能
- 采购
- 仓库和库存管理
用例
- 拣选/分拣/定位
- 实时定位系统 (RTLS)
服务
- 云规划/设计/实施服务
- 系统集成
挑战
企业采购和第三方物流系统有许多活动部件，数据断开会导致效率低下和资源浪费。戴尔现有的库存和企业资源规划 (ERP) 系统 Glovia 提供批量数据更新，每 30 分钟提供一次报告，并且没有与戴尔的供应链系统集成。这些因素导致数据断开连接，无法满足快节奏的全球企业的需求。
Glovia 报告查询占用了过多的计算能力，并且其存储需求呈爆炸式增长。由于审计所需的最短保留期为 7 年，戴尔已经不得不在其 Teradata 企业数据仓库中存储大量历史数据，并遵守世界某些地区的区域法规——例如，最长保留时间要求为 30 年中国的数据——使其更具挑战性。
戴尔需要通过现代化 PRISM 以及从批量数据更新转向实时流式报告来简化其数据足迹并优化其库存流程。该团队希望通过创建一个速度和规模足以满足业务需求的实时库存应用程序，在一年内从其遗留应用程序迁移到现代技术堆栈。
客户
戴尔科技
关于客户
Dell Technologies由 Michael Dell 于 1984 年创立，是世界上最大的公司之一，在全球拥有超过 165,000 名员工。如今，戴尔科技公司在《财富》500 强中排名第 31 位，它在改变全球数字环境方面发挥了重要作用，提供的解决方案可帮助客户随时随地为任何事情做好准备。
解决方案
Dell Technologies 在其虚拟机 (VM) 场中运行 SingleStoreDB Self-Managed，因为它拥有支持此基础架构的技术专长和资源，并且它避免将包括库存数据在内的敏感数据移动到云中。
PRISM 在一个 20 节点的 SingleStore 集群上运行，巧妙地跨数据中心部署以确保业务连续性，并且使用 SingleStore，跨数据中心的复制现在可以实时进行。 PRISM 在内存中有 1.87 TB 的数据，在 SingleStore 集群的列存储中有 3.6 TB 的数据。
PRISM 将变更数据捕获和批处理数据发送到使用 Kafka、StreamSets 和 Oracle GoldenGate 的数据湖，并根据数据类型和速度划分其数据流：
- PRISM 使用 SingleStore 管理需要 1-2 年数据保留的实时数据流和运营报告。它将需要实时和近实时处理的数据发送到企业信息系统，该系统通过本地 Kafka 摄取将实时和操作数据流式传输到 SingleStore。 SingleStore 通过 VMware Pivotal Cloud Foundry、Oracle 和定制的微服务为 PRISM 的实时运营分析和报告提供支持。
- PRISM 将非实时和非操作数据发送到 Greenplum（现称为 VMware Tanzu Greenplum）。 Greenplum 通过 Microsoft Power BI、Salesforce Tableau 和 Microsoft SQL Server 支持 PRISM 历史报告。
运营影响
数量效益
相关案例.
Case Study
Energy Saving & Power Monitoring System
Recently a university in Taiwan was experiencing dramatic power usage increases due to its growing number of campus buildings and students. Aiming to analyze their power consumption and increase their power efficiency across 52 buildings, the university wanted to build a power management system utilizing web-based hardware and software. With these goals in mind, they contacted Advantech to help them develop their system and provide them with the means to save energy in the years to come.
Case Study
IoT System for Tunnel Construction
The Zenitaka Corporation ('Zenitaka') has two major business areas: its architectural business focuses on structures such as government buildings, office buildings, and commercial facilities, while its civil engineering business is targeted at structures such as tunnels, bridges and dams. Within these areas, there presented two issues that have always persisted in regard to the construction of mountain tunnels. These issues are 'improving safety" and "reducing energy consumption". Mountain tunnels construction requires a massive amount of electricity. This is because there are many kinds of electrical equipment being used day and night, including construction machinery, construction lighting, and ventilating fan. Despite this, the amount of power consumption is generally not tightly managed. In many cases, the exact amount of power consumption is only ascertained when the bill from the power company becomes available. Sometimes, corporations install demand-monitoring equipment to help curb the maximum power demanded. However, even in these cases, the devices only allow the total volume of power consumption to be ascertained, or they may issue warnings to prevent the contracted volume of power from being exceeded. In order to tackle the issue of reducing power consumption, it was first necessary to obtain an accurate breakdown of how much power was being used in each particular area. In other words, we needed to be able to visualize the amount of power being consumed. Safety, was also not being managed very rigorously. Even now, tunnel construction sites often use a 'name label' system for managing entry into the work site. Specifically, red labels with white reverse sides that bear the workers' names on both sides are displayed at the tunnel work site entrance. The workers themselves then flip the name label to the appropriate side when entering or exiting from the work site to indicate whether or not they are working inside the tunnel at any given time. If a worker forgets to flip his or her name label when entering or exiting from the tunnel, management cannot be performed effectively. In order to tackle the challenges mentioned above, Zenitaka decided to build a system that could improve the safety of tunnel construction as well as reduce the amount of power consumed. In other words, this new system would facilitate a clear picture of which workers were working in each location at the mountain tunnel construction site, as well as which processes were being carried out at those respective locations at any given time. The system would maintain the safety of all workers while also carefully controlling the electrical equipment to reduce unnecessary power consumption. Having decided on the concept, our next concern was whether there existed any kind of robust hardware that would not break down at the construction work site, that could move freely in response to changes in the working environment, and that could accurately detect workers and vehicles using radio frequency identification (RFID). Given that this system would involve many components that were new to Zenitaka, we decided to enlist the cooperation of E.I.Sol Co., Ltd. ('E.I.Sol') as our joint development partner, as they had provided us with a highly practical proposal.
Case Study
Intelligent Building Automation System and Energy Saving Solution
One of the most difficult problems facing the world is conserving energy in buildings. However, it is not easy to have a cost-effective solution to reduce energy usage in a building. One solution for saving energy is to implement an intelligent building automation system (BAS) which can be controlled according to its schedule. In Indonesia a large university with a five floor building and 22 classrooms wanted to save the amount of energy being used.
Case Study
Powering Smart Home Automation solutions with IoT for Energy conservation
Many industry leaders that offer Smart Energy Management products & solutions face challenges including:How to build a scalable platform that can automatically scale-up to on-board ‘n’ number of Smart home devicesData security, solution availability, and reliability are the other critical factors to deal withHow to create a robust common IoT platform that handles any kind of smart devicesHow to enable data management capabilities that would help in intelligent decision-making
Case Study
Splunk Partnership Ties Together Big Data & IoT Services
Splunk was faced with the need to meet emerging customer demands for interfacing IoT projects to its suite of services. The company required an IoT partner that would be able to easily and quickly integrate with its Splunk Enterprise platform, rather than allocating development resources and time to building out an IoT interface and application platform.
