Difference between revisions of "SiPM Database"
From GlueXWiki
m |
m (→Tables) |
||
Line 59: | Line 59: | ||
* '''remark''': remarks | * '''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 |
Revision as of 19:10, 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
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