View source for Petrological Database of the Ocean Floor

The '''Petrological Database of the Ocean Floor''' (PetDB)<ref name=autogenerated1>{{Cite web |url=http://www.petdb.org/ |title=PetDB |access-date=2020-05-05 |archive-url=https://web.archive.org/web/20080820010048/http://www.petdb.org/ |archive-date=2008-08-20 |url-status=dead }}</ref> is a [[Relational database|relational database]] for global geochemical data on igneous and [[Earth:Metamorphic rock|metamorphic]] rocks generated at mid-ocean ridges including back-arc basins, young seamounts, and old oceanic crust, as well as ophiolites and terrestrial xenoliths from the mantle and lower crust and diamond geochemistry. These data are obtained by analyses of whole rock powders, volcanic glasses, and minerals by a wide range of techniques including [[Physics:Mass spectrometry|mass spectrometry]], atomic emission spectrometry, [[Physics:X-ray fluorescence|x-ray fluorescence]] spectrometry, and wet chemical analyses. Data are compiled from the scientific literature by PetDB data managers, and entered after methodical metadata review. Members of the scientific community can also suggest entry of specific data that has been entered into the EarthChem Library. PetDB is administered by the EarthChem group under the IEDA facility at LDEO headed by K. Lehnert. PetDB is supported by the U.S. [[Organization:National Science Foundation|National Science Foundation]].
== About ==

Developments of PetDB<ref>{{cite web |url=http://www.petdb.org/ |title=PetDB - Home |website=www.petdb.org |access-date=30 June 2022 |archive-url=https://web.archive.org/web/20080820010048/http://www.petdb.org/ |archive-date=20 August 2008 |url-status=dead}}</ref> began in 1995, by Lamont–Doherty Earth Observatory (LDEO)<ref>{{cite web |url=http://www.ldeo.columbia.edu/ |title=Home |website=ldeo.columbia.edu}}</ref> scientists C. Langmuir (now at Harvard University), W. Ryan, and A. Boulanger, when they realized what impact the World Wide Web and relational databases could have on the use of scientific data in research and in the classroom.

The initial funding phase of PetDB (1996–2001) supported the development of the database structure and population with data values. Renewed funding (2002–2007) permitted the migration of the database into an ORACLE-based environment administered by the Center for International Earth Science Information Network (CIESIN)<ref>{{cite web |url=http://www.ciesin.columbia.edu/ |title=Home |website=ciesin.columbia.edu}}</ref> of Columbia University,<ref>{{cite web |url=http://www.columbia.edu/ |title=Home |website=columbia.edu}}</ref> continued data entry, and enhancement of the web-interface with a more user-friendly design.

PetDB is now maintained by EarthChem and funded by the [[Organization:National Science Foundation|US National Science Foundation]], and is governed by the Interdisciplinary Earth Data Alliance facility as part of an ecosystem of related projects, including The System for Earth Sample Registration (SESAR), and the Astromaterials Data System (AstroMat).

Since its inception, PetDB has supported a wide array of scientific endeavors, providing easy access to a comprehensive global dataset of geochemical data for [[Earth:Mid-ocean ridge|mid-ocean ridge]] basalts, [[Earth:Abyssal zone|abyssal]] peridotites and also [[Earth:Xenolith|xenolith]] samples from the Earth's mantle and lower crust.

The relational database structure of PetDB is a sample-based implementation, and designed to accommodate chemical, isotopic and mineralogical data for any type of rock sample, along with essential [[Metadata|metadata]], which provide information about each sample (e.g. location and time of collection, taxonomy, petrographic description) and the data quality, including analytical procedure, reference standard measurements etc. (Lehnert et al. 2000<ref>{{cite journal | url=https://agupubs.onlinelibrary.wiley.com/doi/full/10.1029/1999GC000026 | doi=10.1029/1999GC000026 | title=A global geochemical database structure for rocks | year=2000 | last1=Lehnert | first1=K. | last2=Su | first2=Y. | last3=Langmuir | first3=C. H. | last4=Sarbas | first4=B. | last5=Nohl | first5=U. | journal=Geochemistry, Geophysics, Geosystems | volume=1 | issue=5 | page=1012 | bibcode=2000GGG.....1.1012L | s2cid=134706218 | doi-access=free }}</ref>).

Initially developed for PetDB and its European counterpart, GEOROC,<ref>{{cite web | url=https://georoc.mpch-mainz.gwdg.de//georoc/ | title=Geochemical Rock Database-Query }}</ref> this relational data model has demonstrated utility and flexibility by its application in subsequent geochemical database projects including several collaborations that PetDB has also fostered, including EARThD Project, which focuses on tephra samples from the East African Rift; the US Polar Rock Repository housed at Ohio State University, which includes metadata from Antarctic rock samples; and the collaboration with the University of Kansas, which has resulted in the inclusion of North American granitic pluton samples’ data as well. This project evolved from the NAVDAT project.

PetDB has been cited in more than 1500 peer-reviewed scientific articles.<ref>{{cite web | url=https://earthchem.org/about/statistics/earthchem-citations/ | title=EarthChem- Citations for EarthChem Systems }}</ref>

PetDB is committed to data that follow: FAIR (Findable, Accessible, Interoperable, and Reusable), TRUST (Transparency, Responsibility, User focus, Sustainability and Technology), and CARE principles for Indigenous Data Governance (Collective benefit, Authority to Control, Responsibility, Ethics), and strives to demonstrate the importance of openly available digital resources across all scientific disciplines.

== Contents ==

In its current application, PetDB contains and provides on-line access to a complete set of chemical parameters (currently over 250 elements, oxides, isotopes and isotope ratios), as well as petrographic (mode) data through a sophisticated query interface. New data are continuously being added to the database as it is published and submitted to PetDB by authors. Data for a specific sample that is generated by different laboratories or published by various authors are linked and integrated through the use of a unique sample identifier generated by the database application.

== Statistics ==

As of May 15, 2023, PetDB holdings consist of:

* References: 3,568
* Samples:   136,832
* Bulk rock data points: 1,722,849
* Minerals: 3,316,363
* Volcanic glasses: 911,766
* Melt inclusions: 323,365
* Total individual values: 6,276,656

== Data output ==

Data from PetDB can be viewed in HTML tables and downloaded in spreadsheets in XLS format. During selection of chemical parameters a user can choose to retrieve data as individual values (each row in the data table contains values measured on the same sample with the same method and linked to the same reference) or in precompiled format. The precompiled format arranges all data associated with a sample in a single row, even when data is sourced from multiple publications. In cases where there is more than one data value for a particular chemical item, the precompilation algorithm selects the most recent analysis and the most precise method available. Links in the HTML table permit the user to access more detailed information about the sample, reference or data value (analytical procedure). The final spreadsheet output contains two worksheets. The first contains queried chemical data, geospatial coordinates, and abridged methods and references, while the second contains [[Metadata|metadata]] on analytical methods and publication information.

== References ==
{{Reflist|30em}}

== Further reading ==

* Alemayehu M, Zhang H-, Sakyi PA. Nature and evolution of lithospheric mantle beneath the southern Ethiopian rift zone: evidence from petrology and geochemistry of mantle xenoliths. International Journal of Earth Sciences. 2016. {{doi|10.1007/s00531-016-1342-z}}
*Braun, M. G. and P. B. Kelemen (2002). "Dunite distribution in the Oman Ophiolite: Implications for melt flux through porous dunite conduits" G-CUBED 3(11): 8603. {{doi|10.1029/2001GC000289}}
*Chavrit, D., Humler, E., Grasset, O.(2014)."Mapping modern CO2 fluxes and mantle carbon content all along the mid-ocean ridge system"  EPSL 387:229-39.{{doi|10.1016/j.epsl.2013.11.036}}
* Cipriani, A., H. K. Brueckner, et al. (2004). "Oceanic crust generated by elusive parents: Sr and Nd isotopes in basalt-peridotite pairs from the Mid-Atlantic Ridge." GEOLOGY 32: 657-660. {{doi|10.1130/G20560.1}}
*Horsburgh JS, Aufdenkampe AK, Mayorga E, Lehnert KA, Hsu L, Song L, et al. Observations Data Model 2: A community information model for spatially discrete Earth observations. Environmental Modelling & Software. 2016;79:55-74.{{doi|10.1016/j.envsoft.2016.01.010}}
* Lehnert, K.A., Su, Y., Langmuir, C.H., Sarbas, B., Nohl, U., "A global geochemical database structure for rocks", G-CUBED, Volume 1, 2000. {{doi|10.1029/1999GC000026}}
*McNutt M, Lehnert K, Hanson B, Nosek BA, Ellison AM, King JL. Liberating field science samples and data. Science. 2016;351(6277):1024-6.{{doi|10.1126/science.aad7048}}
* Salters, V. J. M. and A. Stracke (2004). "Composition of the depleted mantle." G-CUBED 5(5). {{doi|10.1029/2003GC000597}}
* Spiegelman, M. and P. B. Kelemen (2003). "Extreme chemical variability as a consequence of channelized melt transport " G-CUBED 4. {{doi|10.1029/2002GC000336}}
* Thirlwall, M. F., M. A. M. Gee, et al. (2004). "Mantle components in Iceland and adjacent ridges investigated using double-spike Pb isotope ratios." GEOCHIM COSMOCHIM ACTA 68: 361-386. {{doi|10.1016/S0016-7037(03)00424-1}}
* van de Flierdt, T., M. Frank, et al. (2004). "Tracing the history of submarine hydrothermal inputs and the significance of hydrothermal hafnium for the seawater budget -- a combined Pb-Hf-Nd isotope approach." EARTH PLANET SCI LETT 222: 259-273. {{doi|10.1016/j.epsl.2004.02.025}}
* Weyer, S., C. Muenker, et al. (2003). "Nb/Ta, Zr/Hf and REE in the depleted mantle: implications for the differentiation history of the crust-mantle system." EARTH PLANET SCI LETT 205: 309-324. {{doi|10.1016/S0012-821X(02)01059-2}}

[[Category:Petrology]]
[[Category:Scientific databases]]

{{Sourceattribution|Petrological Database of the Ocean Floor}}