Mastering the (industrial) Data (EN)
How improved manufacturing is created from industrial and production process data.
mehr erfahren
Forschungsprojekt TRAPH: Traffic Management and Information System
TRAPH aimed to design and prototype the data management of ASFiNAG’s new traffic management and information system 2.0.
As a motorist on Austria’s freeways and expressways, you often ask: Why does the overhead indicator show 60 km/h right now? To answer such inquiries even for points in the past – for example in official investigations – ASFiNAG needs a modern data management system. This system ensures the efficient processing of such questions.
For this purpose, the switching of overhead indicators must remain traceable. Therefore, the correlations between the sensor data recorded along the route and the switching decisions of the overhead indicators are stored in a database. Situations that can trigger switching include the detection of the end of a traffic jam or wet road conditions. These can lead to a dynamic restriction of the permissible speed. Central questions are, for example, which switching operations occur most frequently on certain freeway sections. It is also relevant which situations and measures lead to certain indications. Another important use case is the evaluation of the local distribution of the circuits.
Furthermore, the understanding of these correlations is essential for controlling and parameterizing the Traffic Management and Information System 2.0 (VMIS). Only through continuous data analysis does ASFiNAG gain the knowledge of whether VMIS 2.0 works correctly. In addition, the data show how to parameterize the automatic programs in a reliable way.
Problem
The traceability of the circuits on the overhead indicators on expressways and highways is only available for a short time.
Selected methodology
Due to scalability and planned integration into the system defined by ASFiNAG, the open source graph database JanusGraph was chosen for the implementation.
Results
Using the selected graph database technology and based on the technical requirements, a suitable data model is created. A prototypical installation and configuration of the graph database as well as the import and storage of the relevant VMIS2 data from different data sources allows to map the relationships of the data and to provide them in a performant way.
Conclusions
With the implementation of TRAPH, the defined scenarios for the traceability of the circuits can be displayed on the overhead indicators.
Project partner
RISC Software GmbH won the FFG Transport Infrastructure Research 2019 tender due to its data engineering expertise as well as its experience in NoSQL databases and was commissioned with the selection and design of the database solution as well as the implementation of the data transfer.
The Autobahnen- und Schnellstraßen-Finanzierungs-Aktiengesellschaft (ASFiNAG) is owned by the Austrian federal government and is entrusted with the financing, planning, construction and maintenance of federal highways as well as the collection of time and mileage-based tolls.
This project was funded by the FFG (No. 879353).
Project partner
Project details
- Project short title: TRAPH
- Projectlong title: High Performance Traffic Management Information System
- Funding call: Mobilität der Zukunft (FFG)
- Project partner:
- Autobahnen- und Schnellstraßen-Finanzierungs-Aktiengesellschaft (ASFINAG)
- Budget volume (total): 168.000 EUR
- thereof subsidy (total): 168.000 EUR
- Duration: 6 Monate (09/2020-02/2021)
Contact
Project management
DI Paul Heinzlreiter
Senior Data Engineer
Read more
Data quality in practice
One of the central goals of data engineering is the preparation of data sets according to the requirements of the users or the subsequent process steps. The use of data can range from model training in the field of machine learning to improved internal company reporting based on an integrated database.
mehr erfahren
Data Engineering – the solid basis for effective data utilization
Data engineering integrates data from a wide variety of sources and makes them effectively usable. This makes it a prerequisite for effective data science, machine learning and artificial intelligence, especially in the big data area.
mehr erfahren
Data Understanders: Leveraging enterprise data through intelligent Graph Databases
Graph databases enable intuitive mapping of many real-world scenarios such as industrial manufacturing, traffic data analysis or IT infrastructure monitoring. This makes data not only more efficiently stored, but also much more usable.
mehr erfahren
Graph databases in practice
Graph databases enable the mapping of many real-world scenarios such as: Traffic data analysis or IT infrastructure monitoring.
mehr erfahren