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

1. Install 32-bit MySQL ODBC Connector download page. You need 32-bit to fit your 32-bit Microsoft Office Software even if you run a 64-bit operation system.
2. Create an ODBC database linked to MySQL database in Access.
3. In MS Access tool bar, select "External Data" tab
4. In the "Import" section, click "More" and then select "ODBC Database"
5. In the "Get External Data - ODBC Database" window, choose "Link to the data source by creating a linked table", click "OK"
6. In the "Select Data Source" window select "Machine Data Source" tab
7. If you haven't created a MySQL-ODBC data source yet, follow these steps to create one:
   1. Click "New...", acknowledge the following warning if you do not have Administrative privilege.
   2. In the "Create New Data Source" window, select the type of data source preferred, choose "User Data Source" then click "Next>"
   3. Choose "MySQL ODBC 5.x Driver" then click "Next>", then "Finish"
   4. In the "MySQL Connector/ODBC Data Source Configuration" Windows, give a new "Data Source Name", type in halldweb1.jlab.org for "TCP/IP Server", halld for "User" and corresponding password. If everything goes correctly, you should be able to select halld_sipm database in the pull-down menu. Click "OK" to finish the configuration.
8. Select the Data Source you created for the halld_sipm database, click "OK"
9. Select the table(s) you want to access then click "OK"
10. You can now operate the MySQL database through Access

Microsoft Excel

Unlike MySQL Workbench and MS Access, you can only import data to MS Excel but not change the values on the fly. Here are steps to import data from a MySQL database.

1. You first need to create a ODBC User Data Source in the ODBC Data Source Administrator, if you're running a 32-bit Windows, you can find the manager in the Control Panel. If you're unfortunately running a 64-bit Windows, you need to dig more, the one you can find in Control Panel is not what you want to use since it can only create 64-bit sources. Here is the location for the 32-bit manager:

C:\Windows\SysWOW64\odbcad32.exe

1. Once you open the ODBC Data Source Administrator, in the "User DSN" tab, click "Add" to add a new user data source.