Big Data and Internet of Things (IoT) are the Source of Smart Maintenance
OXplus in Veghel is proud to present its contribution to a major International Metro Route. Managing Consultant Richard Noppert talks passionately about the ins and outs of this complex and unique project. Big Data and Internet of Things (IoT) are the source of Smart Maintenance. OXplus defines Smart Maintenance as a highly automated self-learning maintenance process.
Management Consultancy OXplus earned its spurs in the field of Enterprise Asset Management (EAM) in the transport sector and particularly in the rail sector. “An existing client approached us to ask whether we would, in the first instance, like to share ideas on a database solution for recording master data in conjunction with the construction of international metro lines. OXplus knows the world of transport and the processes of metro systems and smart maintenance very well. We have the necessary software and hardware related knowledge and skills to build a system in the right way and this enables operators and maintainers to do their work well. But this time, therefore, on the design and build (D&B) side instead of operate and maintain (O&M) and that is something unique for us”, Richard explains enthusiastically.
OXplus was commissioned for the D&B process of the IT systems required to record and validate all master data from the complete metro system as groundwork to be able to facilitate Smart Maintenance. “You can imagine that a metro route is a complex system of rolling stock, safety systems, power supply, signaling, communication, computer networks and passenger information systems. OXplus supplies the Technical Database (TDB), the software and the structure of the system and supports the customer in logging all the master data from the metro system. The aim is to enable the future operator and maintainer to carry out smart maintenance of the metro system as best as they possibly can. If, for some other reason, a system fails, the issue must be directly measurable, traceable and detectable”, explains Richard.
IoT and KPI’s
A logical consequence was the request for a database solution in which sensor data from the entire metro network can be stored in order to make smart maintenance a possibility. IoT plays a major role in this. “This SQL Database enables us to make trend analyses and improve systems on the basis of historical data.” The RAM (Reliability, Availability and Maintainability) performance management system then identifies all performance elements and provides an insight into Key Performance Indicators (KPI’s).
All three systems, namely TDB, SQL and RAM, are related to each other and offer a complete solution for the metro system. “We deliberately opted for a solution based on Oracle hardware and software, with Oracle Database Integrator, Oracle Business Intelligence and Oracle Database software providing the basis. This software is attuned to each other and that means we can achieve an optimal result”, explains Richard, the IT system architect. “Our greatest challenge was the complexity. So many parties are involved in the construction of the metro route that it is a real challenge to register all the data in the same format and to the same quality. A uniform way of storing Big Data had to be found for the SQL system. The collecting, linking and transforming of sensor data from various sources required an ELT (Extract, Load and Transform) tool. In the case of the RAM system, which establishes the relationship between performance and errors, the algorithms used to calculate the KPI’s were extremely complex. So every route has its own challenge and that, of course, makes it hugely interesting”, Richard explains with a laugh.
The project was started in 2013 with initial sketches and now the development environment in Veghel is finished. The production solution is soon going to be relocated abroad where the implementation and the configuration of the system is actually going to be tested. The aim is to organise a trial run with one of the metro lines in the last three months. As for as we are concerned this pre-trial run is the ultimate test of whether we fulfill all the contractual obligations”, Richard confidently explains. The metro lines and their Smart Maintenance systems have to be operational in 2021. OXplus is going to be involved in this project until at least 2022.