skip to main content
OSTI.GOV title logo U.S. Department of Energy
Office of Scientific and Technical Information

Title: Schema for the LANL infrasound analysis tool, infrapy

Abstract

The purpose of this document is to define the schema used for the operation of the infrasound analysis tool, infrapy. The tables described by this document extend the CSS3.0 or KB core schema to include information required for the operation of infrapy. This document is divided into three sections, the first being this introduction. Section two defines eight new, infrasonic data processing-specific database tables. Both internal (ORACLE) and external formats for the attributes are defined, along with a short description of each attribute. Section three of the document shows the relationships between the different tables by using entity-relationship diagrams.

Authors:
ORCiD logo [1]; ORCiD logo [1]
+ Show Author Affiliations
  1. Los Alamos National Lab. (LANL), Los Alamos, NM (United States)
Publication Date:
Research Org.:
Los Alamos National Lab. (LANL), Los Alamos, NM (United States)
Sponsoring Org.:
USDOE National Nuclear Security Administration (NNSA)
OSTI Identifier:
1352404
Report Number(s):
LA-UR-17-23067
DOE Contract Number:
AC52-06NA25396
Resource Type:
Technical Report
Country of Publication:
United States
Language:
English
Subject:
97 MATHEMATICS AND COMPUTING; 96 KNOWLEDGE MANAGEMENT AND PRESERVATION

Citation Formats

Dannemann, Fransiska Kate, and Marcillo, Omar Eduardo. Schema for the LANL infrasound analysis tool, infrapy. United States: N. p., 2017. Web. doi:10.2172/1352404.
Copy to clipboard
Dannemann, Fransiska Kate, & Marcillo, Omar Eduardo. Schema for the LANL infrasound analysis tool, infrapy. United States. doi:10.2172/1352404.
Copy to clipboard
Dannemann, Fransiska Kate, and Marcillo, Omar Eduardo. Fri . "Schema for the LANL infrasound analysis tool, infrapy". United States. doi:10.2172/1352404. https://www.osti.gov/servlets/purl/1352404.
Copy to clipboard
@article{osti_1352404,
title = {Schema for the LANL infrasound analysis tool, infrapy},
author = {Dannemann, Fransiska Kate and Marcillo, Omar Eduardo},
abstractNote = {The purpose of this document is to define the schema used for the operation of the infrasound analysis tool, infrapy. The tables described by this document extend the CSS3.0 or KB core schema to include information required for the operation of infrapy. This document is divided into three sections, the first being this introduction. Section two defines eight new, infrasonic data processing-specific database tables. Both internal (ORACLE) and external formats for the attributes are defined, along with a short description of each attribute. Section three of the document shows the relationships between the different tables by using entity-relationship diagrams.},
doi = {10.2172/1352404},
journal = {},
number = ,
volume = ,
place = {United States},
year = {Fri Apr 14 00:00:00 EDT 2017},
month = {Fri Apr 14 00:00:00 EDT 2017}
}
Copy to clipboard
Technical Report:
View Technical Report
DOI:  10.2172/1352404
Save / Share:
Export Metadata
Save to My Library
You must Sign In or Create an Account in order to save documents to your library.

  • ;
    In this document we describe schema design and translation tool called SDT.SDT takes as input Extended Entity-Relationship (EER) schemas and generates relational database management (RDBMS) schemas. SDT consists of three main parts: (1) The first part maps EER schemas into abstract relational schemas, (2) the second part maps abstract relational schemas into schema definitions for RDBMSs; and (3) the third part generates the metadata regarding EER schemas, relational schemas, and their mappings. SDT 4.1 targets SYNBASE 4.0, INGRES 6.3, and INFORMIX 4.0. Compared with SDT 3.1, SDT 4.1 has the following additional features: (1) a graphical editor for specifying andmore » modifying EER schemas, called ERDRAW; (2) SDT 4.1 generates procedures for verifying the consistency of an existing database with regard to a set of referential integrity constraints associated with that database; (3) attributes and object-sets (entity-sets or relationship-sets) can be described using new description fields; (4) SDT 4.1 allows the specification of hierarchically organized subject terms for object-sets, attributes, and the association of subject terms with object-sets and attributes; and, (5) SDT 4.1 generates metadata describing EER schemas, relational schemas and their mappings. SDT was implemented using C, LEX, and YACC on Sun 3 and Sun 4 workstations under Sun Unix OS 4.0.3. and Sun Unix OS 4.1. 9 refs., 8 figs.« less

  • ;
    This document describes an X-window based tool called ERDRAW that support graphical specifications of conceptual database schemas. ERDRAW is based on an Extended Entity--Relationship (EER) model; an overview of this model is provided in appendix B. ERDRAW generates an output file that can be used as input to a database schema design and translation tool, called SDT. A full description of SDT can be found in the SDT reference manual issued as technical report LBL-27843. ERDRAW was implemented using C, and X11 based Xlib and Xview toolkit, on Sun 3 and Sun 4 workstations under Sun Unix OS 4.0.3 andmore » Sun Unix OS 4.1. This document consist of the following sections: User's manual, written following the format of Unix manual entries; screen images illustrating the work with ERDRAW; a pictorial tutorial on how to use ERDRAW; a sample postscript output; the SDT command, input format, and a sample input file; a sample report listing attributes; a sample report listing subject terms.« less

  • MatSeis's infrasound analysis tool, Infra Tool, uses frequency slowness processing to deconstruct the array data into three outputs per processing step: correlation, azimuth and slowness. Until now, an experienced analyst trained to recognize a pattern observed in outputs from signal processing manually accomplished infrasound signal detection. Our goal was to automate the process of infrasound signal detection. The critical aspect of infrasound signal detection is to identify consecutive processing steps where the azimuth is constant (flat) while the time-lag correlation of the windowed waveform is above background value. These two statements describe the arrival of a correlated set of wavefrontsmore » at an array. The Hough Transform and Inverse Slope methods are used to determine the representative slope for a specified number of azimuth data points. The representative slope is then used in conjunction with associated correlation value and azimuth data variance to determine if and when an infrasound signal was detected. A format for an infrasound signal detection output file is also proposed. The detection output file will list the processed array element names, followed by detection characteristics for each method. Each detection is supplied with a listing of frequency slowness processing characteristics: human time (YYYY/MM/DD HH:MM:SS.SSS), epochal time, correlation, fstat, azimuth (deg) and trace velocity (km/s). As an example, a ground truth event was processed using the four-element DLIAR infrasound array located in New Mexico. The event is known as the Watusi chemical explosion, which occurred on 2002/09/28 at 21:25:17 with an explosive yield of 38,000 lb TNT equivalent. Knowing the source and array location, the array-to-event distance was computed to be approximately 890 km. This test determined the station-to-event azimuth (281.8 and 282.1 degrees) to within 1.6 and 1.4 degrees for the Inverse Slope and Hough Transform detection algorithms, respectively, and the detection window closely correlated to the theoretical stratospheric arrival time. Further testing will be required for tuning of detection threshold parameters for different types of infrasound events.« less

  • A detailed ion-exchange procedure for the separation of chemical elements in eight groups suitable for subsequent gamma spectrometric analysis is described. The separation time for inorganic samples is usually about 11/2 hours and for organic samples at least 2 hours. One man can separate and count three samples per day. In comparative measurements of short-lived isotopes in biological material, 10 to 12 elements can be analyzed, thus making possible 30 to 35 determinations per day for one man. (auth)