SiPM Database

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 mm² 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

How-To Access MySQL Databalse

Windows Platform

MySQL Workbench

1. Install the lastest MySQL Workbench download page
2. Start MySQL Workbench, in the SQL Development section, click "New Connection"
3. Type in Hostname, Username and Password, (Optional) set default Schema to be halld_sipm and leave everything else unchanged
4. Once everything configured, click "Test Connection" to test the configuration, then click "OK" to close the window, you should now see a new connection available in your connection list.
5. Double click the newly created connection to bring up the query window