FastFind »   Lastname: doi:10.1029/ Year: | Advanced Search  

G-Cubed: Geochemistry, Geophysics, Geosystems; an electronic journal of the Earth sciences

 

Keywords

  • database
  • petrology
  • geochemistry
  • data management

Index Terms

  • Geochemistry
  • Geochemistry: Instruments and techniques
Abstract
Cited By (12)
 

Abstract

A global geochemical database structure for rocks

K. Lehnert

Lamont-Doherty Earth Observatory of Columbia University, Palisades, New York 10964

Y. Su

Lamont-Doherty Earth Observatory of Columbia University, Palisades, New York 10964

C. H. Langmuir

Lamont-Doherty Earth Observatory of Columbia University, Palisades, New York 10964

B. Sarbas

Max-Planck-Institut füer Chemie, Abteilung Geochemie, Postfach 3060, Mainz, D-55020 Germany

U. Nohl

Max-Planck-Institut füer Chemie, Abteilung Geochemie, Postfach 3060, Mainz, D-55020 Germany

This technical brief describes a geochemical and petrological database structure based on the relational model that has broad applicability to chemical analyses of geological materials. Notable features of the database structure are its comprehensiveness and flexibility. The structure consists of 34 interrelated tables, which can accommodate any type of analytical values for all different materials of rock samples (volcanic glasses, minerals, inclusions, etc.) and for samples from any tectonic setting. A broad spectrum of supplementary information (metadata) is included that describes the quality of the analytical data and sample characteristics, such as petrography, geographical location, and sampling process, and that can be used to evaluate, filter, and sort the chemical data. All data in the database are linked to their original reference. The database structure can be implemented in any relational database management system (RDBMS). It is currently applied in two different rock database projects (RidgePetDB and GEOROC).

Received 27 October 1999; accepted 9 December 1999; published 24 May 2000.

Citation: Lehnert, K., Y. Su, C. H. Langmuir, B. Sarbas, and U. Nohl (2000), A global geochemical database structure for rocks, Geochem. Geophys. Geosyst., 1(5), 1012, doi:10.1029/1999GC000026.

Cited By

Please wait one moment ...