LDAS Database

• Table definitions

The concept of the LDAS database tables listed here is described in Technical Note LIGO-T990101-010E, Table Definitions for LDAS Metadata/Event Database.

The tables can be categorized by type of information stored into the following groups:

Process | Metadata about Raw Data | Summary Information | AstroPhysics Events and GDS Triggers | Data Runs
A brief description of each table is given, with the sql defintion for the creation of the table, an example of an LDAS ilwd format file to insert 10 rows of the table into the database via the LDAS system and the corresponding XML format which is the external input to LDAS

•  Process

The process table stores information about a specific invocation of a program; the input parameters for a given process is stored in the process_params table.

process	ilwd example	xml example
process_params	ilwd example	xml example

•  MetaData about Raw Data

• Framesets 

  The Framesets tables hold information about frames which are built from raw data; basic information is stored in frameset table, while information about its orgin is stored in frameset_writer, its contents in frameset_chanlist and locations in frameset_loc.

  frameset_chanlist	ilwd example	xml example
  frameset_writer	ilwd example	xml example
  frameset	ilwd example	xml example
  frameset_loc	ilwd example	xml example

• Segments 

  The Segment tables contains information for logical construct of data based on common property e.g. duration when an inferometer is locked; segment_definer and segment tables are analogous to frameset_writer and frameset tables.

  segment_definer	ilwd example	xml example
  segment	ilwd example	xml example

•  Summary Information

The Summary tables store various summary information about intervals of data: scalar values, statistics, spectra, text comments and arbitrary binary objects.

summ_value	ilwd example	xml example
summ_statistics	ilwd example	xml example
summ_spectrum	ilwd example	xml example
summ_comment	ilwd example	xml example
summ_csd	ilwd example	xml example
summ_mime	ilwd example	xml example
search_summary	ilwd example	xml example
search_summvars	ilwd example	xml example

•  Astrophysics events and GDS Triggers

The event tables hold results of astrophysics searches of defined sources such as inspiral, bursts, ringdowns, directedperiodic, and unmodeled-sources. The filters applied for the searches are stored in the filters tables. The simulation parameters and calibration information are also stored in tables.

• Filters 

  filter	ilwd example	xml example
  filter_params	ilwd example	xml example

• Simulation 

  sim_type	ilwd example	xml example
  sim_type_params	ilwd example	xml example
  sim_inst	ilwd example	xml example
  sim_inst_params	ilwd example	xml example

• Calibration 

  calib_info	ilwd example	xml example

• GDS Trigger 

  gds trigger	ilwd example	xml example
  exttrig_search	ilwd example	xml example

• Single-Inferometer Astrophysics Events 

  sngl_burst	ilwd example	xml example
  sngl_dperiodic	ilwd example	xml example
  sngl_inspiral	ilwd example	xml example
  sngl_ringdown	ilwd example	xml example
  sngl_unmodeled	ilwd example	xml example
  sngl_unmodeled_v	ilwd example	xml example
  sngl_datasource	ilwd example	xml example
  sngl_transdata	ilwd example	xml example
  sngl_mime	ilwd example	xml example
  sngl_block	ilwd example	xml example
  waveburst	ilwd example	xml example
  waveburst_mime	ilwd example	xml example

• Multi-Inferometer Astrophysics Events 

  multi_inspiral	ilwd example	xml example
  multi_burst	ilwd example	xml example

• Data Runs 

  This table contains the list of data runs.

  runlist	ilwd example	xml example

•  Table relations

The cross-reference relationship among the ldas tables is depicted in this diagram.

•  Data Insertion formats

1. Directly using ILwd (LIGO Internal Light Weight objects)
2. Indirectly using XML (via ligolwAPI)

---

Last modified Oct 4th, 2001


Suggestions or Comments? Please Contact  mlei@ligo.caltech.edu