Advances in the Integration of Large Data Sets for Seismic Monitoring of Nuclear Explosions

Abstract

The National Nuclear Security Administration (NNSA) Ground-Based Nuclear Explosion Monitoring Research and Engineering (GNEMRE) program has been integrating large sets of seismic events and their associated measurements for almost a decade to support nuclear explosion monitoring. During that time the integration process has changed significantly, generally becoming more complex and more automated as the number of events and the range of associated measurements has steadily grown. In this paper, we explain the methodology for integrating database tables from different products that are part of a Knowledge Base (KB) release. The major effort of KB integration is merging events and their associated information in Oracle database tables. We have developed a substantial foundation of structure and software to assure data integrity in the integration of diverse data sets. The structural part of this foundation utilizes Oracle data dictionary tables along with complementary custom database tables. These custom tables contain information specifically related to how KB database objects are built. Information such as descriptions and database types are stored in these custom tables so that the KB structure is easily modifiable making it more flexible than it would be following a traditional database design. This "metadata" of the supporting structures is called the "schema schema," and all the integration tools are based on this structure. Los Alamos National Laboratory (LANL) has developed a tool to make sure the information in the product database tables is accurate and valid. Called the Quality Control Tool (QCTool), this tool checks that the database tables conform to the database structures found in the "schema schema" and that the values in the database tables are reasonable. Database tables are not merged together until the errors generated by QCTool are either corrected or explained.

Open PDF

Document Details

Document Type
Technical Report
Publication Date
Sep 01, 2007
Accession Number
ADA519416

Entities

People

  • Bion J. Merchant
  • Dorthe B. Carr
  • Elaine M. Martinez
  • Jeff W. Hampton
  • Jennifer E. Lewis
  • John J. Dwyer
  • Jorge Roman-nieves
  • Michelle Crown
  • Richard J. Stead
  • Sandy Ballard

Organizations

  • Sandia National Laboratories

Tags

Communities of Interest

  • Materials and Manufacturing Processes

DTIC Thesaurus Topics

  • Abstracts
  • Air Force Research Laboratories
  • Data Sets
  • Databases
  • Dictionaries
  • Engineering
  • Explosions
  • Ground Based
  • Metadata
  • Monitoring
  • Nuclear Explosions
  • Quality Control
  • Relational Database Management Systems
  • Relational Databases
  • Security
  • Standards
  • Waveforms

Fields of Study

  • Computer science

Readers

  • Artificial Intelligence
  • Business Analytics
  • Software Engineering.