Download "user manual"

Transcript
May 2006
Volume 7
Issue 2
Modification to
Interrogation Data Loader (IDL)
DOUG CLOUGH (Synergetics Engineered Systems)
Two modifications have been made in the pre-processing
of interrogation records by the Interrogation Data Loader
FIGURE 1 • Storing Tranceiver ID in cksm column
(IDL). These changes are not retroactive, and therefore only
Տ̈«iÝi`
/À>˜ÃViˆÛiÀ
apply to data received on or after 27 February 2006.
1. Store transceiver identifiers
For data arriving in Minimon, MobileMon, or M4 files, store
the transceiver identifier in the cksm column of the obs_data
database table (Figure 1). Note that this value is available
only if the interrogation was captured by a multiplexing
transceiver, for example a Digital Angel FS1001M.
If the interrogation was captured by a non-multiplexing
transceiver, such as a Digital Angel FS1001A, store the coil
identifier (redundantly) in the cksm column (Figure 2).
8£
Ó £
Teqc qcdiAdqceTi5qq5qA
i
FIGURE 2 • Storing Coil ID (redundantly) in cksm column
œ˜‡ÕÌˆ«iÝi`
/À>˜ÃViˆÛiÀ
œLÃÊ`>Ì>
œLÃÚ`>Ìi
œLÃÚÈÌi
Ì>}ڈ`
VŽÃ“
Vœ˜ÌÀ
˜Ài>`ÃÊ
Vœˆ£
œœœ
œLÃÚvˆiÊ
œœœÊ
Alters the processing of all interrogation files
PTAGIS is always open to correspondence. If you have any
comments, questions or suggestions please contact
ptagis. [email protected]
T
"˜iʘÌiÀÀœ}>̈œ˜Ê,iVœÀ`
˜ÊˆiÊ---99°* ÊÊÊ
2. Store identical-record counts
As a file is pre-processed in preparation for loading to
the database, count the number of identical copies of
each record. For every set of duplicates found in the
file, load a single interrogation record into the database,
storing the identical-record count in the nreads column
of the obs_data table (Figure 3). Note that in this context,
“identical” interrogation records may actually differ slightly:
a “millisecond” component of the interrogation timestamp,
present at the end of some records, will differ record-torecord within “a set of duplicates.” However, the millisecond
values are not stored in the database, and are ignored for
purposes of counting “identical” records.
hQYT:h
Ó
Teqc qcdiAdqceTi5qq5qA
hQYT:h
i
i
"˜iʘÌiÀÀœ}>̈œ˜Ê,iVœÀ`
˜ÊˆiÊ---99°* ÊÊÊ
FIGURE 3 • S
toring Identical-Record Count in nreads column
/À>˜ÃViˆÛiÀÊ-iÌ
̜ʼ1˜ˆµÕiÊ"vv½
œLÃÊ`>Ì>
Ó
œLÃÚ`>Ìi
œLÃÚÈÌi
Ì>}ڈ`
VŽÃ“
Vœ˜ÌÀ
˜Ài>`ÃÊ
Vœˆ£
œœœ
œLÃÚvˆiÊ
œœœÊ
Does not alter the processing of Multimon files
œLÃÚ`>Ìi
œLÃÚÈÌi
Ì>}ڈ`
VŽÃ“
Vœ˜ÌÀ
˜Ài>`ÃÊ
Vœˆ£
œœœ
œLÃÚvˆiÊ
œœœÊ
œLÃÊ`>Ì>
Î
Teqc qcdiAdqceTi5qq5qA
hQYT:h
i
i
Teqc qcdiAdqceTi5qq5qA
hQYT:h
i
i
Teqc qcdiAdqceTi5qq5qA
hQYT:h
i
i
ÎÊ`i˜ÌˆV>Ê˜ÌiÀÀœ}>̈œ˜Ê,iVœÀ`ÃÊÊ