Oak Ridge National Laboratory, Environmental Sciences Division, TN 37831, USA.
Environ Manage. 2011 Jun;47(6):1112-24. doi: 10.1007/s00267-010-9576-1. Epub 2011 Feb 20.
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.
长期生物监测和减排计划（BMAP）一直需要收集和保留高质量的数据，以便对溪流的生态状况及其修复后的恢复情况进行评估。其正式的质量保证、数据处理和数据管理组件都有助于满足这一需求。质量保证计划全面满足了各种机构、资助者和监管者的要求，并包括数据管理组件。集中的数据管理在计划进行几年后开始，当时对现有的关系数据库进行了改编和扩展，以处理生物数据。描述了数据库的主要数据表和几个关键参考表。支持长期分析的最重要相关活动之一是为采样点名称、分类鉴定、标记和其他组件建立标准。实施的关系数据库支持将数据传输到橡树岭环境信息系统（OREIS）作为永久存储库。我们还讨论了我们实施的一些限制。某些类型的计划数据不容易在中央系统中容纳，并且许多可能的数据共享和集成选项不容易被调查人员访问。根据我们的经验，我们为其他面向生物的长期环境采样和分析计划提供数据管理建议。
