Task 1 - Deliverable 1: Database structure

Abstract

The Italian strong motion data base (Italian Strong Motion Data Base) is a joint product of the agreement between the Dipartimento della Protezione Civile – Ufficio Valutazione Prevenzione e Mitigazione del Rischio Sismico ed Attività ed Opere Post-Emergenza (Department of Civil Protection – Evaluation, Prevention and Mitigation of Seismic Risck and Post-Emergency Works) and the Istituto Nazionale di Geofisica e Vulcanologia (National Institute of Geophysics and Volcanology). The data base is handled through two different relational data base management system: Ms Access® 2003, of major use among research institutions and public administrations, for CD-ROM release, and MySQL for the web distribution. The selection of the former product is driven by the simplicity of the software, the worldwide diffusion and the possibility of being linked to software’s for the management of spatial data, such as ESRI ArcGis® and Arcview®, and software for the scientific calculation such as Matlab ®. The data base will store the information regarding the seismic events, the recording stations, the installed instruments, the main features of the recordings and the engineering parameters. The structure is based on a previous version of the Italian strong-motion data base created by ENEA in collaboration with Department of Civil Protection, which stores the information regarding the accelerometric recordings in the time span 1972-1993. This manuscript will explain the structure of the tables containing the information, the data base architecture, the relationships existing among tables and the technical features for data input.