Revision as of 20:34, 7 March 2012

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 a Connection Name at your choice, Hostname and Username, (Optional) set default Schema to halld_sipm and leave everything else unchanged.
4. Once everything configured, click "Test Connection" to test the configuration, and a new window will prompt you for password, hopefully you will see a success message at the end. Then click "OK"s to close all these windows, and go back to the main window. Now 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.
6. Select halld_sipm schema if it's now already selected, then double click the table you'd like to access to query it's data.

Microsoft Access

Microsoft Excel