OiDbTechnicalSpecs < Jmmc/Software

This topic aims to describe the specification from a technical point of view.

%TOC%

---+ 1.3 Granularity

The following discussion apply to data extraction from individual OIFits files.

Subgrouping must be done in the following order : target(OI_TARGET), instrument(OI_WAVELENGTH), night (OI_DATA rows) 

---++ Group by targets
Function: extract a list of targets %BR%
Inputs: OI_TARGET table / coords, coords+name, name %BR%
Outputs: List of targets %BR%
         with catalog ID (HD HIP TBD1 TBD2)

Warning: target names are case sensitive

---+++ Use cases
   * target name resolved   
      * invalids
         * wrong coordinates vs simbad resolution
   * target name unresolved
      * invalids
         * 0 0 as given coords
   * valids
      * duplicated targets : distinct name  & same coords , approximate coordinates (which radius ?)

---+++ Impact
   * jmcs (coords (with Epoch handling), name resolver)
   * oiexplorer-core 
      * new coordinates columns from simbad (deg J2000) (save a timestamp for the resolution, useful when running resolution later)
      * uuid build (using coords?) (cf oid simbad)
   * oidb
      * provide a proxy to retrieve target uuid replacing simbad above for target resolution

---+++ Examples

---+++ Questions 
   * which additional information should be retrieved by simbad resolver ?

---++ Group by instrument mode
Function: retrieve instrument modes %BR%
Inputs: OI_WAVELENGTH tables : INSNAME + EFF_WAVE_min/max + NB_EFF_WAVE + EFF_BAND %BR%
        knowledge instrument_mode database %BR%
Outputs: List of instrument modes


Do not presume that every data are sorted properly in OIFits files when searching for min/max values.

---+++ Use cases
   * same data with epsilon values should retrieve the same instrument mode  (may feed INSNAME aliases)

---+++ Impact
   * oiexplorer-core
   * oidb : 
      * insname aliases, knowledge database
      * instrument configurations

---+++ Examples

---+++ Questions:
   * how to handle data for unknown instrument ?
   * how to store an instrument_mode (single string, fields concatenation...)
   * How to solve ambiguity for MIDI (and MATISSE) between HIGH_SENS and SCI_PHOT ?



---++ Group by nights
Function: split by observation nights %BR%
Inputs: OI_DATA tables :  (DATE-OBS + TIME ) or  (MJD), ARRNAME %BR%
        OI_ARRAY tables %BR%
Outputs: List of observation nights

---+++ Use cases
   * handle oifits without OI_ARRAY

---+++ Impact
   * jmal : date, coords

---+++ Examples


---++ General
   * oiexplorer-core must provide for every table row : the targetId, nightId, targetUuid
   * do we have to refresh/compare data retrieved by simbad
This topic: Jmmc/Software > OiDbTechnicalSpecs
Topic revision: r2 - 2014-04-08 - PatrickBernaud