Reference Database (ERR)
Development and Maintenance by the Database Team

Detailed Reference Information
Lehnert et al. 2000
Lehnert, K., Su, Y., Langmuir, C.H., Sarbas, B. and Nohl, U. (2000). A global geochemical database structure for rocks. Geochemistry Geophysics Geosystems 1: doi: 10.1029/1999GC000026. issn: 1525-2027.
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).


Entire Document PDF

Geochemistry, Geochemistry, Instruments and techniques
Geochemistry Geophysics Geosystems
American Geophysical Union
2000 Florida Avenue N.W.
Washington, D.C. 20009-1277
Click to clear formClick to return to previous pageClick to submit