meta data for this page
  •  

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
applications:add-special-cases [2023/01/13 16:55] – gregbalcoapplications:add-special-cases [2023/01/13 17:39] (current) – gregbalco
Line 9: Line 9:
  
 -- Aliquot handling. Because there are sometimes situations in Cl-36 chemistry where multiple target fractions can be extracted from the same whole rock sample, it is necessary to make sure that Cl-36 measurements on target fractions are matched up with correct chemistries for the target fractions and for the whole rock. The way we handle this in the database is that each entry in the Cl-36 table must contain something in the 'aliquot' field. Then, there must be entries in the major element and trace element tables that contain the same value in the aliquot field. Sometimes, this requires duplicating data. For example, consider a situation in which you made one major element chemistry measurement and one trace element measurement on a rock sample, and then you extracted two target fractions. Each target fraction then has one Cl-36 measurement and one major element measurement. Representing this will require the following: (i) make two entries in the Cl-36 table for aliquots a and b; (ii) make two entries in the major elements table for the 'target' analyses, also identified as aliquots a and b; (iii) enter the whole rock major element data as 'WR' in the major elements table TWICE, with different aliquot names; (iv) enter the trace element data for the whole rock in the trace elements table TWICE, with different aliquot names. Of course this involves duplicating data, which is undesirable, but it is needed to make it unambiguous which chemistry data should be associated with which Cl-36 concentration. This can probably be explained better with a more detailed example.  -- Aliquot handling. Because there are sometimes situations in Cl-36 chemistry where multiple target fractions can be extracted from the same whole rock sample, it is necessary to make sure that Cl-36 measurements on target fractions are matched up with correct chemistries for the target fractions and for the whole rock. The way we handle this in the database is that each entry in the Cl-36 table must contain something in the 'aliquot' field. Then, there must be entries in the major element and trace element tables that contain the same value in the aliquot field. Sometimes, this requires duplicating data. For example, consider a situation in which you made one major element chemistry measurement and one trace element measurement on a rock sample, and then you extracted two target fractions. Each target fraction then has one Cl-36 measurement and one major element measurement. Representing this will require the following: (i) make two entries in the Cl-36 table for aliquots a and b; (ii) make two entries in the major elements table for the 'target' analyses, also identified as aliquots a and b; (iii) enter the whole rock major element data as 'WR' in the major elements table TWICE, with different aliquot names; (iv) enter the trace element data for the whole rock in the trace elements table TWICE, with different aliquot names. Of course this involves duplicating data, which is undesirable, but it is needed to make it unambiguous which chemistry data should be associated with which Cl-36 concentration. This can probably be explained better with a more detailed example. 
 +
 +== Linking photos to samples ==
 +
 +== Linking other documentation to samples ==
 +
 +== Cores/subsurface data and core samples ==
 +
 +