Data Management

DDMS Overview

Introduction

Basic Elements

Data Objects

Communications

User Applications

Manipulating Data

Installation

Further Info

Data Management

Detailed Information About the JGOFS Distributed Database Management System (DDMS)

Putting Data on the system

To add a new data object to the system, one needs a translator/method which can properly interpret the data. The options are:
  • Write a new translator to conform to the data. If there is a large, established database with existing programs for updating and access, this may be the best procedure. Often this translator may also glue together a number of different files to form a full database.
  • Transform the data into a form compatible with an existing translator/method. This may be the easiest thing to do when a measurement program is just beginning.
Two existing methods, shipped with the system, are the default method, def, and the method for reading output from the list program, nm.

def

This is intended for data with each station (or mooring, etc.) in a single file, with header files linking them. Thus a hydrographic data set might look like:
Header file
# Gulf Stream Cruise Stations 3-5
# p<1000
station lat lon >    [variable names for this file's data]
 press  temp sal o2 sigth [variable names for the next level files] 
  3     38.28 -73.53  s3
  4     38.19 -73.52  s4
  5     38.16 -73.26  s5
file s3
# Station 3
# lat=38.28, lon=-73.53
# This data prepared by someone
# Measurement at station 21 decibars contaminated
# 2/18/93
depth   temp    sal     oxy
 1.000  21.800  25.380   5.700
 3.300  nd      nd        nd
 5.000  21.800  25.580   5.600
10.000  21.400  25.670   5.400
13.000  21.000  25.850   5.000
15.000  20.500  26.020   5.000
21.000  19.900  26.400   5.000
The # sign indicates comments; the > in the header variable name list indicates that item points to a subfile containing more detailed information.

nm

This method is for a single file with multiple stations.
# Gulf Stream Cruise Stations 3-5
# p<1000

 station = 3    lat = 38.28,    lon = -73.53

  press,   temp,    sal,     o2,  sigth
  5.000, 18.334, 33.570,  5.970, 24.096
 25.000, 12.848, 34.159,  6.990, 25.773
 49.000, 11.070, 34.523,  6.060, 26.394
 99.000, 11.093, 35.090,  5.340, 26.831
149.000, 11.906, 35.487,  5.020, 26.990
199.000, 10.819, 35.435,  4.210, 27.152

station =       4,    lat =   38.19,    lon =  -73.52

  press,   temp,    sal,     o2,  sigth

  5.000, 17.516, 33.160,  5.840, 23.981
 25.000, 12.315, 33.958,  7.090, 25.721
 49.000,  9.612, 34.192,  6.020, 26.387
 99.000, 12.095, 35.402,  5.340, 26.887
149.000, 12.407, 35.625,  5.290, 27.000
199.000, 11.287, 35.487,  4.340, 27.108

station = 5,    lat=38.16,    lon=-73.26

  press,   temp,    sal,     o2,  sigth

  5.000, 18.382, 33.647,  5.770, 24.143
 25.000, 12.040, 34.196,  6.660, 25.959
 49.000, 11.951, 34.925,  5.510, 26.543
 99.000, 11.914, 35.390,  5.100, 26.912
149.000, 12.045, 35.547,  5.070, 27.010
149.000, 12.045, 35.547,  5.070, 27.010
199.000, 11.976, 35.589,  4.940, 27.057
Comment lines begin with #. The lines with an equals sign = contain assignments for variables at level 0 (comma or space separated). The assigments need only be done when the variable changes. The first line without an equals sign contains the names of the level 1 variables (comma or space separated).

 


 

back to top