Skip to content

Database for Inter-Instrument Transformation

For the Inter-Instrument Transformation, the database is used to query EUV Images and LBC Fit Parameters to apply the correction. 1D Intensity Histograms are created and stored in the database. After calculation, fit parameters are stored in the database then queried to apply the IIT Correction.

Tables

Histogram

This table stores histogram and information associated with IIT Histograms.
The histograms are created in Step One of Inter-Instrument Transformation Correction.

Columns:

hist_id: auto-incremented integer id associated with the histogram (Primary Key, Integer)
image_id: integer id associated with image (Foreign Key: EUV Images, Integer)
meth_id: auto-incremented integer id associated with the specific method (Foreign Key: Method Defs, Integer)
date_obs: time of image observation (DateTime)
wavelength: observation wavelength (Integer)
n_mu_bins: number of mu bins (Integer)
n_intensity_bins: number of intensity bins (Integer)
lat_band: latitude band (Blob)
mu_bin_edges: array of mu bin edges from number of mu bins (Blob)
intensity_bin_edges: array of intensity bin edges from number of intensity bins (Blob)
hist: histogram associated with image (Blob)

Data Combos

This table stores information regarding the combination of images used to calculate the fit parameter.

Columns:

combo_id: auto-incremented integer id associated with that specific combination of images (Primary Key, Integer)
meth_id: auto-incremented integer id associated with the specific method (Foreign Key: Method Defs, Integer)
n_images: number of images in combination (Integer)
date_mean: mean date of images in image combination (DateTime)
date_max: maximum date of images in image combination (DateTime)
date_min: minimum date of images in image combination (DateTime)

Data Combo Assoc

This table stores specific image ids with the associated combo id.

Columns:

combo_id: auto-incremented integer id associated with that specific combination of images (Primary Key, Foreign Key: Image Combos, Integer)
image_id: integer id associated with image (Primary Key, Foreign Key: EUV Images, Integer)

Method Defs

This table stores information about a correction method and an associated integer method id.

Columns:

meth_id: auto-incremented integer id associated with the specific method (Primary Key, Integer)
meth_name: method name (String)
meth_description: description of method (String)

Var Defs

This table stores information about a variable and an associated integer variable id.

Columns:

var_id: auto-incremented integer id associated with the specific variable (Primary Key, Integer)
meth_id: auto-incremented integer id associated with the specific method (Foreign Key: Method Defs, Integer)
var_name: variable name (String)
var_description: description of variable (String)

Var Vals

This table stores variable values with the associated variable, method, and image combination.
These values are calculated from the IIT fit analysis (IIT Step Two).
These values are queried during the application of the correction (IIT Step Three) and during the creation of histogram plots (IIT Step Four).

Columns:

combo_id: auto-incremented integer id associated with that specific combination of images (Primary Key, Foreign Key: Image Combos, Integer)
meth_id: auto-incremented integer id associated with the specific method (Foreign Key: Method Defs, Integer)
var_id: auto-incremented integer id associated with the specific variable (Primary Key, Foreign Key: Var Defs, Integer)
var_val: variable value (Float)