EPIC Database Management Programs
EPIC in-situ data residing on UNIX workstation disks can
be managed with any SQL database system such as Ingres,
mSQL, postgreSQL,
or MySQL database. The EPIC
metadata, the information about the data, stored in the databases,
can be accessed using a command-line interactive program,
World Wide Web browsers,
or a Motif-based X-window
application that allows users to locate data in the underlying
databases by specific selection constraints such as geographic,
time, depth range, etc. These applications communicate with
back-end databases, making it easy and convenient for remote
users as well as local users to access EPIC data.
We have developed EPIC database software version 1.0 which
supports Ingres, mSQL, and postgreSQL databases. Recently
we have re-designed database system (EPIC database version
2.0) and chosen MySQL database as our primary database
management system. Please refer to EPIC
Database Management Using MySQL presentation for
more information about MySQL.
The EPIC database management programs include (1) a suite
of scripts used to create EPIC database and data tables;
(2) 'loader program' which read EPIC formatted data files,
extract metadata, and enter that metadata into the database
along with the Unix path and data file name; (3) 'select'
program which prompts the user for selection criteria such
as geographic range and time range, and then searches the
database to locate the data files meeting the selection
criteria; and (4) other utilities, for example, programs
update web page for EPIC
Web Browser to reflect most recent status of the database.
For more information about EPIC database management programs,
please visit EPIC documentation page.
The EPIC database management programs are freely available
from EPIC download area.