Community Research and Development Information Service - CORDIS

Abstract

The database described in this document, was started as part of a research activity on the transportation of dangerous goods. The first data collection started in 1986, and the first results, based on an analysis of the accident case history collection was published in 1990. The database was written using the SQL*Plus program in conjunction with the SQL database language. The SQL database language allows the storage and retrieval of data in the Oracle corporation relational database management system, the ORACLE RDMS. Substantial use was also made of the connected program SQL*Forms, both in inputting and updating data. Chemax is a system of 4 tables within a database. These tables are called Ax, Cheminfo, Placeinfo and Dupl. The information in Ax is intended to be a complete but not overly detailed account of the general situation before, during and after a large number of chemical accidents. The information has been, as widely as possible, split into separate fields, thus allowing one to easily look at the parts which are of interest and to bypass those which are irrelevant. To this end most of the fields contain just a single word or numerical entry. The remaining fields are intended for more thorough research into a particular accident.

Additional information

Authors: HAARSTRUP P, JRC Ispra (IT);ELWOOD C T, JRC Ispra (IT);RØMER H, JRC Ispra (IT)
Bibliographic Reference: EUR 15970 EN (1994) 35pp., FS
Availability: Available from the Public Relations and Publications Unit, JRC Ispra, I-21020 Ispra (IT)
Record Number: 199411392 / Last updated on: 1995-03-21
Category: PUBLICATION
Original language: en
Available languages: en
Follow us on: RSS Facebook Twitter YouTube Managed by the EU Publications Office Top