[Back]

E. Pucher, J. Litzka, J. Haberl, J. Girard:
"Report on Database Structure for Other Noise Abatement Measures";
Report for EU Projekt SILVIA (Sustainable road surfaces for traffic noise control); 2003; 41 pages.

This document is submitted in fulfilment of Deliverable 04 of the SILVIA EU research project. The goal of this document is to describe the structure of the database for other noise abatement measures. This work has been carried out as part of work package 5: Integration of low-noise pavements with other noise abatement measures. This report gives details on the structure of the database to be used in work package 5.

The database will include reports and results of experiments and modelling efforts related to the combination of low noise road surfaces with other noise abatement measures. The database was created using Microsoft ACCESS 2000 TM software. The database divides the data into multiple tables of related fields, and the tables are all linked. The use of multiple linked tables is one way in which the database orders and indexes the stored results. The database structure created for WP5 is capable of storing raw measurement/simulation results, or of storing statistical data or analysis results, such as SPB indices. Thus, if the dataset is moderate in size, the raw data can be stored in the database. For very large datasets, the statistical results can be stored, either with or without including the raw data.

This database will be used throughout SILVIA work package 5 to analyse the potential benefits of combining low noise road surfaces with other noise reducing measures. The results of this analysis will be a report on "The Integration of Low-Noise Pavements with Other Noise Abatement Measures" including CD-ROM noise samples of investigated surfaces with different types of tyres and vehicles to demonstrate the progress in cutting down noise pollution. It will include recommendations to road administrations as well as to vehicle and tyre industries with a view to future regulation. In addition, it has been agreed that a similar database structure will be used for the entire SILVIA project.