Master Data Hub (MDH) for DB Regio Bus

As part of the Master Data Hub for DB Regio Bus, master data was to be optimized and consolidated on a central platform. This involved integrating around 1 million network points from 14,000 routes into one platform and connecting them to 10 systems.

The Customer

Regio Bus Mitte consists of the companies ORN Omnibusverkehr Rhein-Nahe GmbH, RMV Rhein-Mosel Verkehrsgesellschaft mbH, DB Regio Bus Rhein-Mosel GmbH and DB Regio Bus Mitte GmbH. As subsidiaries of DB Regio AG, the company as a bus transport service provider places particular emphasis on regional ties and local presence.

450 Mio. Travelers
11,000 busses
9,500 employees

Projectdescription

Challenge

Heterogeneous data storage in a wide variety of data formats

The impetus for the project was the goal of introducing a data lake in order to achieve data consolidation. The challenge for DB Regio Bus was the complexity and variety of data in local public transport. This includes various data types such as network points, network point quantities (e.g. stops, masts and depots), corporate bodies, tariffs, tariff systems, concessions (including award procedures, contract data and tender data) and lines. The difficulty lay in the heterogeneity and the lack of standardized processes for data entry, modification and provision. The data was recorded in different systems, with various identification systems being used. This led to challenges in consolidating and integrating the data. The aim of the project was to be able to maintain and provide the different data classes centrally.

Solution

A central master data platform

The optimal master data consolidation on a single data platform for many DB Regio Bus data as a central data supplier required careful planning and implementation. First, a needs analysis was carried out to identify all critical master data and all data sources inside and outside DB Regio Bus. Standards were developed for the structure and formatting of the data to ensure uniform presentation and thus seamless integration and use of the data. Regular measures were implemented for quality control and data cleansing. Pimcore was established as a central platform to consolidate the data and serves as a single data source for other systems via standardized APIs. To protect the data, a separate user management system was introduced to restrict access to the data for individuals and systems. Comprehensive documentation was created and training was provided for up to 1,200 users.

Result

Manage and provide master data efficiently

The result is a central platform based on Pimcore, which serves as a single source of truth for all relevant DB Regio Bus master data. In 80 import processes, one million network points were adapted to uniform standards and integrated into the new system. Consolidation has not only increased efficiency, but also contributed to higher data quality and seamless integration of the bus systems. The implementation meets the requirements for effective, secure and scalable master data management.

Success Parameters

1,200 users
over 10 connected systems
80 import processes
1 Mio. network points

Base data

Industry Public Transport

Pimcore products MDM, PIM

Technologies Pimcore, PHP, MySQL, AWS Cloud Hosting, Symfony, Nginx, Redis, Sencha ExtJS

Services Tech Operations, Services Desk

Solution Product Information Management, Master Data Management

Competencies Strategy Consulting, Product Ownership, Projectmanagement, Data Modeling, Digital Implementation support, Process Modeling

Check us out - we got more to offer

DB Regio AG