Difference between revisions of "SiPM Database"
From GlueXWiki
(→MySQL Workbench) |
m (→Microsoft Access) |
||
Line 105: | Line 105: | ||
==== Microsoft Access ==== | ==== Microsoft Access ==== | ||
+ | |||
+ | # Install 32-bit MySQL ODBC Connector [http://dev.mysql.com/downloads/connector/odbc/ download page]. You need 32-bit to fit your 32-bit Microsoft Office Software even if you run a 64-bit operation system. | ||
+ | # Create an ODBC database linked to MySQL database in Access. | ||
+ | # In MS Access tool bar, select "External Data" tab | ||
+ | # In the "Import" section, click "More" and then select "ODBC Database" | ||
+ | # In the "Get External Data - ODBC Database" window, choose "Link to the data source by creating a linked table", click "OK" | ||
+ | # In the "Select Data Source" window select "Machine Data Source" tab | ||
+ | # If you haven't created a MySQL-ODBC data source yet, follow these steps to create one: | ||
+ | ## Click "New...", acknowledge the following warning if you do not have Administrative privilege. | ||
+ | ## In the "Create New Data Source" window, select the type of data source preferred, choose "User Data Source" then click "Next>" | ||
+ | ## Choose "MySQL ODBC 5.x Driver" then click "Next>", then "Finish" | ||
+ | ## 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. | ||
+ | # Select the Data Source you created for the halld_sipm database, click "OK" | ||
+ | # Select the table(s) you want to access then click "OK" | ||
+ | # You can now operate the MySQL database through Access | ||
==== Microsoft Excel ==== | ==== Microsoft Excel ==== |
Revision as of 20:42, 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
How-To Access MySQL Databalse
Windows Platform
MySQL Workbench
- Install the lastest MySQL Workbench download page.
- Start MySQL Workbench, in the SQL Development section, click "New Connection".
- Type in a Connection Name at your choice, Hostname and Username, (Optional) set default Schema to halld_sipm and leave everything else unchanged.
- 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.
- Double click the newly created connection to bring up the query window.
- 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
- 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.
- Create an ODBC database linked to MySQL database in Access.
- In MS Access tool bar, select "External Data" tab
- In the "Import" section, click "More" and then select "ODBC Database"
- In the "Get External Data - ODBC Database" window, choose "Link to the data source by creating a linked table", click "OK"
- In the "Select Data Source" window select "Machine Data Source" tab
- If you haven't created a MySQL-ODBC data source yet, follow these steps to create one:
- Click "New...", acknowledge the following warning if you do not have Administrative privilege.
- In the "Create New Data Source" window, select the type of data source preferred, choose "User Data Source" then click "Next>"
- Choose "MySQL ODBC 5.x Driver" then click "Next>", then "Finish"
- 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.
- Select the Data Source you created for the halld_sipm database, click "OK"
- Select the table(s) you want to access then click "OK"
- You can now operate the MySQL database through Access