下载PDF
DPD Polska's Real-Time Data Replication for Enhanced Parcel Delivery
技术
- 分析与建模 - 实时分析
- 基础设施即服务 (IaaS) - 云数据库
适用行业
- 国家安全与国防
- 运输
适用功能
- 物流运输
- 质量保证
用例
- 边缘计算与边缘智能
- 实时定位系统 (RTLS)
服务
- 系统集成
- 测试与认证
挑战
波兰快递市场的领导者 DPD Polska 面临着现有数据管理系统的挑战。该公司使用一系列本地 PostgreSQL 和 Microsoft SQL Server 数据库来跟踪其卡车、包裹和人员。然而,一系列自定义 SQL 数据库阻碍了 DPD 及时生成报告、满足灾难恢复时间目标、测试新数据和分析产品、扩大收入并增加客户群。例如,DPD 的数据库之一具有三种不同的使用上下文。该公司需要一种不会影响其源系统的基于日志的复制解决方案。主要痛点是复制时间滞后、手动数据分发出错的风险,以及需要更大的灵活性、更高的可靠性和更高的操作可扩展性。
关于客户
DPD Polska 隶属于第二大国际快递网络 DPDGroup。作为波兰快递市场的领导者,DPD Polska 每年递送 2 亿件包裹。该公司拥有超过 50,000 名员工,从事航运和物流行业。 DPD Polska 使用一系列本地 PostgreSQL 和 Microsoft SQL Server 数据库来跟踪其运营。然而,该公司面临着数据复制、灾难恢复和扩大运营规模的挑战。
解决方案
为了应对这些挑战,系统和数据集成商 Goldenore 部署了 Fivetran,这是一种大容量复制(本地数据处理)解决方案。这使得 DPD 能够近乎实时地将数据从多个源复制到本地 Oracle DB、本地 PostgreSQL 和 MS Azure,而不会影响源数据库性能。该解决方案为 DPD 提供基于日志的变更数据捕获、近实时复制、数据验证和数据移动的可视化统计。因此,DPD 能够有效、安全地将关键业务数据复制到 Azure 及其本地报告和测试环境。该公司目前正致力于使用 Fivetran 的解决方案复制一系列新的 Microsoft SQL Server 数据库、PostgreSQL 的零停机迁移以及将业务应用程序迁移到 MS Azure。
运营影响
数量效益
相关案例.
Case Study
Airport SCADA Systems Improve Service Levels
Modern airports are one of the busiest environments on Earth and rely on process automation equipment to ensure service operators achieve their KPIs. Increasingly airport SCADA systems are being used to control all aspects of the operation and associated facilities. This is because unplanned system downtime can cost dearly, both in terms of reduced revenues and the associated loss of customer satisfaction due to inevitable travel inconvenience and disruption.
Case Study
IoT-based Fleet Intelligence Innovation
Speed to market is precious for DRVR, a rapidly growing start-up company. With a business model dependent on reliable mobile data, managers were spending their lives trying to negotiate data roaming deals with mobile network operators in different countries. And, even then, service quality was a constant concern.
Case Study
Digitize Railway with Deutsche Bahn
To reduce maintenance costs and delay-causing failures for Deutsche Bahn. They need manual measurements by a position measurement system based on custom-made MEMS sensor clusters, which allow autonomous and continuous monitoring with wireless data transmission and long battery. They were looking for data pre-processing solution in the sensor and machine learning algorithms in the cloud so as to detect critical wear.
Case Study
Cold Chain Transportation and Refrigerated Fleet Management System
1) Create a digital connected transportation solution to retrofit cold chain trailers with real-time tracking and controls. 2) Prevent multi-million dollar losses due to theft or spoilage. 3) Deliver a digital chain-of-custody solution for door to door load monitoring and security. 4) Provide a trusted multi-fleet solution in a single application with granular data and access controls.
Case Study
Vehicle Fleet Analytics
Organizations frequently implement a maintenance strategy for their fleets of vehicles using a combination of time and usage based maintenance schedules. While effective as a whole, time and usage based schedules do not take into account driving patterns, environmental factors, and sensors currently deployed within the vehicle measuring crank voltage, ignition voltage, and acceleration, all of which have a significant influence on the overall health of the vehicle.In a typical fleet, a large percentage of road calls are related to electrical failure, with battery failure being a common cause. Battery failures result in unmet service agreement levels and costly re-adjustment of scheduled to provide replacement vehicles. To reduce the impact of unplanned maintenance, the transportation logistics company was interested in a trial of C3 Vehicle Fleet Analytics.
Case Study
3M Gains Real-Time Insight with Cloud Solution
The company has a long track record of innovative technology solutions. For example, 3M helps its customers optimize parking operations by automating fee collection and other processes. To improve support for this rapidly expanding segment, 3M needed to automate its own data collection and reporting. The company had recently purchased the assets of parking, tolling, and automatic license plate reader businesses, and required better insight into these acquisitions. Chad Reed, Global Business Manager for 3M Parking Systems, says, “With thousands of installations across the world, we couldn’t keep track of our software and hardware deployments, which made it difficult to understand our market penetration.” 3M wanted a tracking application that sales staff could use to get real-time information about the type and location of 3M products in parking lots and garages. So that it could be used on-site with potential customers, the solution would have to provide access to data anytime, anywhere, and from an array of mobile devices. Jason Fox, Mobile Application Architect at 3M, upped the ante by volunteering to deliver the new app in one weekend. For Fox and his team, these requirements meant turning to the cloud instead of an on-premises datacenter. “My first thought was to go directly to the cloud because we needed to provide access not only to our salespeople, but to resellers who didn’t have access to our internal network,” says Fox. “The cloud just seemed like a logical choice.”