#
EARTHWORM DBMS MODULES LIST

April 17, 2002

## DBMS LOADING MODULES

##

Module name | Its function, briefly | more info (note 1)
--- | --- | ---
orareport | Inserts the parametric data from an Earthworm Message TYPE_HYP2000ARC into the database. | -------- | commands
ora_trace_save | Reads an Earthworm Message TYPE_TRIGLIST, retrieves the asssociated waveforms and inserts them into the database. | ------- | commands
mag2ora | mag2ora is an Earthworm module that reads magnitude messages(TYPE_MAGNITUDE) from an EW ring, and creates magnitudes in an EWDB and associates the Magnitudes with Events. | overview | commands
sm_ew2ora | Reads TYPE_STRONGMOTIONII messages from an earthworm ring, and writes them to an EW DBMS. | ------ | commands
nsn_pz2ora | Reads AUTODRM response output, and inserts the response parameters into the database. | overview | commands
stalist_hinv2ora | Reads station list in Hypoinverse foramt, and inserts the station parameters into the database. | ------ | commands
stalist_usnsn2ora | Reads station list in NEIC foramt, and inserts the station parameters into the database. | ------ | commands
usnsn_loc2ora | Reads an Earthworm message TYPE_USNSN and inserts the location and magnitude parameters into the database. | ------ | commands
concierge | Concierge is the name given to a new method of waveform archiving to the Earthworm database. The Concierge makes multiple attempts at archiving the data, and provides incremental results that improve over time. The previous versions of waveform archivers made only one attempt and were subject to incomplete data retrievals. | overview | ------
ora_trace_req (Part of Concierge) | Reads an Earthworm message TYPE_TRIGLIST2K, converts the channel-trigger lines to snippet requests, and inserts the snippet requests into the DB. (Front half of Concierge) | overview | commands
ora_trace_fetch (Part of Concierge) | Reads SnippetRequests from the database, and repeatedly attempts to retrieve snippets to fulfill the requests. It stuffs the snippets into the DB and updates/deletes the requests. (Back half of Concierge) | overview | commands

## DBMS RETRIEVAL MODULES

Module name | Its function, briefly | more info (note 1)
--- | --- | ---
shakemapfeed | Retreive strong motion from the database and creates a Shakemap2 format file. | overview | commands
gencatalog | Queries the database to obtain a formatted list of events | overview | ------

## ALARM MODULES

Module name | Its function, briefly | more info (note 1)
--- | --- | ---
email_sender | picks up TYPE_EMAIL_MSG messages from the ring, parses them and calls the SendMail() earthworm library routine to delivery the message. Then, it updates the appropriate entry in the AlarmsAudit table to indicate that the message has been delivered. | ------ | commands
qdds_sender | picks up TYPE_QDDS_MSG messages from the ring, parses them and writes the text of the message to the specified QDDS target directory. For now, this program only deals with placing the files in CUBE format into the correct directory, leaving the bulk of the delivery work to an outside QDDS-capable process. | ------ | commands

## INTERACTIVE DISPLAY PROGRAMS

Module name | Its function, briefly | more info (note 1)
--- | --- | ---
Jiggle | Jiggle was developed at USGS Pasadena for routine analysis of data collected on 150 broadband stations by TriNet in Southern California. The Golden development team has incorporated the Jiggle analysis package with the earthworm DBMS. | ------ | Installation
| Quick Review | Quick review is a web-based earthquake analysis tool. It is a customized version of SeisGram2K, a java applet written by Anthony Lomax (). | Overview | User Guide

## ARCHIVE and MAINTENANCE PROGRAMS

Module name | Its function, briefly | more info (note 1)
--- | --- | ---
archive | saves the contents of one or more DB Events to SAC directory(s). archive can then, optionally, delete the data for each Event from the database. | Usage Configuratin File
db_cleanup2 | db_cleanup2 is a catch-all, time based archiver. Based on rules set in the config file, it saves/deletes Events and unassociated data based on time limits. Rules schedule the archiving/deletion of data based on time, magnitude, and location of Events. | overview | commands
reaper | This program is meant to be run out of cron(or some other periodic invocation method). Its function is to keep the number of events in the database manageable, by deleting the oldest events. | ------ | commands

Note 1: The configuration files in this table should be verified by comparison with the configuration file examples in the source directory of each module.

U.S. Department of the Interior, U.S. Geological Survey, Reston, VA, USA Privacy Statement || Disclaimer || FOIA || Accessibility |

Date Last Modified: April 17, 2002