How data may be submitted
|Data may be contributed to the DateView database in two ways:
|The first technique is the most robust in that it ensures that all referential integrity links are correct. This is most appropriate for small data sets. If you wish to contribute data in this way, you will need to email me your USERID so that I can give you permission to modify and insert records.
|The second technique is more convenient and faster for large data sets but requires more care from both the data compiler and the database administrator to ensure that there are no conflicts with data already in DateView. Compilers will need to ensure that values entered in the spreadsheets are the same as referential integrity values already in the database (or will need to organise for new key values to be added). Users may download spreadsheet summaries of the main lookup tables within DateView but a number of these are provided below for convenience. The most up-to-date values will, however, only be available direct from DateView. A main spreadsheet file, with columns suitable for most compilations, and a Microsoft Access database file are also provided below.
Of the two offline compilation methods, the Microsoft Access approach should be used whenever possible as it allows the compiler to check the integrity of the data during data capture. If necessary, lookup values may be downloaded from DateView and imported into the Access tables to ensure compatibility with existing records.
Compilers who intend to use both the StratDB and DateView databases should first compile the unit names and basic information in StratDB and then export the names and unique ID's to DateView, then download the unit names and import them to the MS Access DateView database. In this way, associations between the two databases will be automatic.
Main Submission Tables and Files
Using the MS Access database to compile data
It is relatively easy to compile data in the provided MS Access database but this approach does assume that you know your way around the program as one needs to work with individual tables and queries. No special interface has been created because users needing such an interface are expected to rather use the online web interface for DateView. If you are not sure of the relevance of some of the fields in the MS Access database, it may be useful running a few queries in DateView first and investigating values used for similar information.
It is often useful to change some of the default values for certain fields from the "design view" for specific tables so as to reduce the amount of typing needed. This is particularly useful if one person is compiling data for a single country in a given continent. Other fields which are usefully set as defaults in certain tables are IsotopeSystem and MaterialAbr
There is a logical sequence in which new data ought to be entered so as to avoid having to jump between tables and refresh data sets so as to have appropriate lookup values available. This sequence of activity is outlined below:
Your data are now ready to submit to the DateView database administrator for uploading to DateView. He will interact with you to check that all ID values are appropriate for the online database and do some basic data integrity checks prior to uploading the data, at which point you will be asked to check the new records in DateView.
Raw Isotope Data
|It is also possible to compile raw isotope data in DateView. Users wishing to do this should email me for specific instructions.
The layout in Excel spreadsheets for raw data is up to the user except that variables are expected in columns with a separate row for each sample aliquot analysis. A separate 'data definitions' spreadsheet needs to be compiled, linking specific variable ID values to the columns in which the data are stored. The variable ID values may be downloaded from the lookups section of DateView and example spreadsheets are available from the database administrator.
These raw data are used in various diagrams and recalculations in DateView; in StratDB, a lithostratigraphy unit database which also draws on information from DateView and in DepIso, a database for Pb and S isotope data for ore deposits. At this stage, detrital zircon U-Pb, Lu-Hf and O isotope data may be interrogated in DateView (for individual or multiple samples) and in StratDB (for multiple lithostratigraphic units). StratDB allows one to create a new form of probability distribution graph which illustrates grain age relative to deposition age while still capturing the essence of where major probability peaks occur.
If the ages for major peaks in probability distributions have been captured in DateView as summary detrital ages, it is also possible to extract all matching ages from selected regions from the DateView database, so obtaining a geospatial list of potential provenence sources which may then be plotted offline in a GIS package.
Any Other Issues?
|If you are not sure of anything, please contact Bruce Eglington. It is much easier to sort it out at the beginning of a compilation than to make changes later.|