This is one of 3224 IT projects that we have successfully completed with our customers.How can we support you?
Migration of an ETL line to determine CO2 emissions in CEP logistics
Project duration: 2 months
Brief description
The goal of the project is the conversion of an ETL line (extraction, transformation, loading) to determine CO2 emissions on the basis of the Oracle Data Integrator and the PTV xServer (xRoute). The replacement of the old system considers the following aspects: Improvement of the accuracy of the CO2 emission calculation by using the HBEFA 3.1 standard and current vehicle profiles on the basis of the Euro 6 emission standard; encapsulation of the business logic in procedures; conversion to the asynchronous, RESTful API of the PTV xServer; runtime optimization of the ETL route by parallelization of the API requests.
Subject description
The Handbook Emission Factors for Road Transport (HBEFA) provides emission factors for all current vehicle categories (PC, LDV, HGV, urban buses, coaches and motor cycles), each divided into different categories, for a wide variety of traffic situations. Emission factors for all regulated and the most important non-regulated pollutants as well as fuel consumption and CO2 are included. (Source: http://www.hbefa.net/e/index.html)
Overview
- Industries traffic / transport / logistics
- Specialist tasks business intelligence, data warehouse, environmental engineering, environmental protection
- DV tasks Data Warehouse
- System environment Business Intelligence
- Procedure model iterative procedure
- Databases Oracle Data Integrator
- Development/ test tools Aqua Data Studio
Project period01.04.2018 - 31.05.2018
Contact
PTA GmbH Head Office
Weberstraße 2-4
D-68165 Mannheim
© Copyright 2024 PTA GmbH | All rights reserved | Imprint | Privacy | Legal notice | Values & Code of Conduct
