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 are familiar with the situation: Why is the overhead indicator showing a speed limit of 60 km/h right now? In order to be able to answer such inquiries even for a point in time longer in the past – for example in the case of inquiries by the executive – ASFiNAG will support the efficient processing of such questions with a modern data management system.
For this purpose, the switching of overhead indicators must be traceable. For this purpose, the correlations between the sensor data recorded along the route and the switching decisions of the overhead indicators are stored in a database. Examples of situations that can trigger switching are the detection of the end of a traffic jam or wetness on the road, which can lead to a dynamic restriction of the permissible speed. Central questions are also which switching operations occur most frequently on certain sections of the freeways or which situations and measures lead to certain indications. Another use case is the evaluation of the local distribution of the circuits.
Furthermore, the understanding of the correlations between situations and measures is essential for the control and parameterization of the Traffic Management and Information System 2.0 (VMIS). Only by analyzing this data, ASFiNAG has the knowledge whether VMIS 2.0 works correctly and how to parameterize the automatic programs.
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