title: Importance of data management in a long-term biological monitoring program.
abstract: The long-term Biological Monitoring and Abatement Program (BMAP) has always needed to collect and retain high-quality data on which to base its assessments of ecological status of streams and their recovery after remediation. Its formal quality assurance, data processing, and data management components all contribute to meeting this need. The Quality Assurance Program comprehensively addresses requirements from various institutions, funders, and regulators, and includes a data management component. Centralized data management began a few years into the program when an existing relational database was adapted and extended to handle biological data. The database's main data tables and several key reference tables are described. One of the most important related activities supporting long-term analyses was the establishing of standards for sampling site names, taxonomic identification, flagging, and other components. The implemented relational database supports the transmittal of data to the Oak Ridge Environmental Information System (OREIS) as the permanent repository. We also discuss some limitations to our implementation. Some types of program data were not easily accommodated in the central systems, and many possible data-sharing and integration options are not easily accessible to investigators. From our experience we offer data management advice to other biologically oriented long-term environmental sampling and analysis programs.
authors.affiliation: Oak Ridge National Laboratory, Environmental Sciences Division, TN 37831, USA. christensen1@ornl.gov
authors.forename: Sigurd W
authors.initials: SW
authors.lastname: Christensen
authors.forename: Craig C
authors.initials: CC
authors.lastname: Brandt
authors.forename: Mary K
authors.initials: MK
authors.lastname: McCracken
mesh_terms: D001109:Archives; D003628:Database Management Systems; D001330:Electronic Data Processing; D004784:Environmental Monitoring / Q000379:methods* / Q000592:standards; D052918:Environmental Restoration and Remediation; D016247:Information Storage and Retrieval; D014877:Water Pollution, Chemical / Q000706:statistics & numerical data