SiPM Database
From GlueXWiki
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
The table stores the quantities of SiPM arrays extracted from the data: PDE, gain, dark rate and cross-talk. List of columns:
- 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_cell
The table stores the extracted quantities of individual cells. List of columns:
- 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