Difference between revisions of "SiPM Database"
From GlueXWiki
(→MySQL Database At Jefferson Lab) |
m |
||
| Line 32: | Line 32: | ||
* '''voltage''': Voltage of individual channels for a 7.5×105 gain at 25C (V) | * '''voltage''': Voltage of individual channels for a 7.5×105 gain at 25C (V) | ||
* '''dark_rate''': Dark rate of individual channels (MHz) | * '''dark_rate''': Dark rate of individual channels (MHz) | ||
| + | |||
| + | === sipm_data === | ||
| + | |||
| + | The table stores the info of the production test. List of columns: | ||
| + | |||
| + | * '''sn''': serial number | ||
| + | * '''time''': date and time the data were taken | ||
| + | * '''temperature_a''': average temperature reading from sensor A (C), bottom, upstream | ||
| + | * '''temperature_b''': average temperature reading from sensor B (C), top, downstream | ||
| + | * '''filter_1''': filter 1 setting | ||
| + | * '''filter_2''': filter 2 setting | ||
| + | * '''frequency''': pulse frequency (Hz) | ||
| + | * '''position''': position of SiPM on the cooling plate (1-1 - 4-4) | ||
| + | * '''voltage_channel''': channel number of HV power supply (0-15) | ||
| + | * '''voltage_25C''': operational voltage at 25C given by Hamamatsu (V) | ||
| + | * '''voltage_offset''': offset on bias voltage (V) | ||
| + | * '''voltage_set''': set voltage (V) | ||
| + | * '''voltage_read''': average read voltage (V) | ||
| + | * '''current''': average current (uA) | ||
| + | * '''gate''': gate width for QDC (ns) | ||
| + | * '''daq_module''': V792 module used (4-20) | ||
| + | * '''daq_first_channel''': V792 channel used for first cell (0 or 16) | ||
| + | * '''event''': total number of events | ||
| + | * '''data_directory''': sub-directory on farm work disk: /work/halld/Subsystems/SiPM/production/data/[sub-directory] | ||
| + | * '''replayed''': whether the data have been replayed (-1 not replayed, 0 submitted to farm, 1 replayed, >1 replayed but will not be used in PDE extraction) | ||
| + | * '''remark''': remarks | ||
| + | |||
| + | SiPM PDE table: sipm_pde | ||
| + | |||
| + | sn: serial number | ||
| + | temperature: average(targeting) temperature of for the whole set of measurements (C) | ||
| + | voltage_offset: targeting bias voltage offset from nominal operational voltage (V) | ||
| + | gate: gate width for QDC (ns) | ||
| + | voltage: average read voltage (V) | ||
| + | dark_rate: average dark rate per cell (MHz) | ||
| + | dr_var: dark rate variation | ||
| + | pde: average PDE | ||
| + | pde_var: PDE variation | ||
| + | gain: average gain (×105) | ||
| + | gain_var: gain variation | ||
| + | x_talk: average probability of cross talk | ||
| + | xt_var: cross talk variation | ||
| + | remark: remarks | ||
| + | |||
| + | SiPM PDE per CELL table: sipm_pde_cell | ||
| + | |||
| + | sn: serial number | ||
| + | temperature: average(targeting) temperature of for the whole set of measurements (C) | ||
| + | voltage_offset: targeting bias voltage offset from nominal operational voltage (V) | ||
| + | gate: gate width for QDC (ns) | ||
| + | dark_rate: dark rate of the cell (MHz) | ||
| + | pde: PDE of the cell | ||
| + | gain: gain of the cell (×105) | ||
| + | x_talk: cross talk of the cell | ||
Revision as of 18:27, 7 March 2012
Contents
MySQL Database At Jefferson Lab
A copy can be found in HallD-ELOG.
MySQL Server
- halldweb1.jlab.org
- login: halld
- password: the normal "halld" password as linux boxes, or ask Yi to get it
- port: 3306 (MySQL default)
- database name: halld_sipm
Tables
sipm_spec
The table stores the Hamamatsu specifications for SiPM arrays. List of columns:
- sn: Serial Number
- voltage: Average voltage at 25C (V)
- vol_var: Standard deviation in voltage of individual channels (mV)
- m_var: Variation of gain (%, from Hamamatsu spec sheet)
- dark_rate: Total dark rate (MHz)
- dr_var: Relative standard deviation in dark rate of individual channels (%)
- remark: Remarks
sipm_spec_tile
The table stores the Hamamatsu specifications for individual 3×3 mm2 cells. List of columns:
- sn: Serial Number
- cell: Cell number (1-16)
- voltage: Voltage of individual channels for a 7.5×105 gain at 25C (V)
- dark_rate: Dark rate of individual channels (MHz)
sipm_data
The table stores the info of the production test. List of columns:
- sn: serial number
- time: date and time the data were taken
- temperature_a: average temperature reading from sensor A (C), bottom, upstream
- temperature_b: average temperature reading from sensor B (C), top, downstream
- filter_1: filter 1 setting
- filter_2: filter 2 setting
- frequency: pulse frequency (Hz)
- position: position of SiPM on the cooling plate (1-1 - 4-4)
- voltage_channel: channel number of HV power supply (0-15)
- voltage_25C: operational voltage at 25C given by Hamamatsu (V)
- voltage_offset: offset on bias voltage (V)
- voltage_set: set voltage (V)
- voltage_read: average read voltage (V)
- current: average current (uA)
- gate: gate width for QDC (ns)
- daq_module: V792 module used (4-20)
- daq_first_channel: V792 channel used for first cell (0 or 16)
- event: total number of events
- data_directory: sub-directory on farm work disk: /work/halld/Subsystems/SiPM/production/data/[sub-directory]
- replayed: whether the data have been replayed (-1 not replayed, 0 submitted to farm, 1 replayed, >1 replayed but will not be used in PDE extraction)
- remark: remarks
SiPM PDE table: sipm_pde
sn: serial number temperature: average(targeting) temperature of for the whole set of measurements (C) voltage_offset: targeting bias voltage offset from nominal operational voltage (V) gate: gate width for QDC (ns) voltage: average read voltage (V) dark_rate: average dark rate per cell (MHz) dr_var: dark rate variation pde: average PDE pde_var: PDE variation gain: average gain (×105) gain_var: gain variation x_talk: average probability of cross talk xt_var: cross talk variation remark: remarks
SiPM PDE per CELL table: sipm_pde_cell
sn: serial number temperature: average(targeting) temperature of for the whole set of measurements (C) voltage_offset: targeting bias voltage offset from nominal operational voltage (V) gate: gate width for QDC (ns) dark_rate: dark rate of the cell (MHz) pde: PDE of the cell gain: gain of the cell (×105) x_talk: cross talk of the cell
