Information Management System Design
Summary: The Bonanza Creek (BNZ) site stores their metadata in a database using mySQL Structured Query Language database. The database is the center piece of the BNZ site metadata management system, and the transactions with the public and the users are coded in PHP. The scripts allow users to query, view and download metadata and data.
Detail: A custom mySQL relational database stores all related info to datasets. This database tracks changes in data and metadata and allows data sets to be viewed using CFM scripts. Some of the data are in raw text files and the remaining data are stored in a database. Some climate data is streaming directly from the field instruments into the database. There is an ARC-IMS server for geospatial files. Most of the metadata is managed with custom files. EML is generated with a one touch Perl script (SQL dump --> parsing --> generate EML and harvest list).