Difference between revisions of "Transversity MySQL database"
From Hall A Wiki
(→Search the run you want to find) |
|||
| (17 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| + | ==Display== | ||
| + | ===Search the run you want to find=== | ||
| + | *A search tool, using the transversity MYSQL database, is found here: | ||
| + | [http://hallaweb.jlab.org/experiment/transversity/db_yawei/index.php E06010 Run Search] | ||
| + | *Run Flag in AnalysisInfo | ||
| + | -10 data file does not exist: skipped run number or data file lost in data disk crash | ||
| + | -5 junk run, not useful for anything | ||
| + | 5 secondary run, target is not in 3He position, for example:cosmics, BPM/BCM calibration... | ||
| + | 10 secondary run, target is in 3He position, but for other purpose, for example:cosmics, test... | ||
| + | 15 primary run with some problems, run taken for physics analysis but some problem: roc problem, short run time... | ||
| + | 20 primary run with no obvious problems logged in HALOG/shift summary/paper summary | ||
| + | |||
==Available Tables== | ==Available Tables== | ||
* RunInfo | * RunInfo | ||
| − | ** From the "start of run" | + | ** From the "start of run" halla e-log entries |
* EndRunInfo | * EndRunInfo | ||
| − | ** From the "end of run" | + | ** From the "end of run" halla e-log entries |
* AnalysisInfo | * AnalysisInfo | ||
| − | ** Primary information is from the "start of run" and "end of run" | + | ** Primary information is from the "start of run" and "end of run" halla e-log entries |
** Further information is filled in by those doing the analysis (online and offline) | ** Further information is filled in by those doing the analysis (online and offline) | ||
| + | |||
| + | ==Script for adding entries to the AnalysisInfo table== | ||
| + | Here is the script for adding your own analysis information to the AnalysisInfo table | ||
| + | /adaqfs/home/adaq/transversity/mysql/setAnalysisInfo.pl | ||
| + | *setAnalysisInfo.pl | ||
| + | -r, --runnum [LOW NUMBER]-[HIGH NUMBER] | ||
| + | Specify the range of runnumbers to modify. One number will work for single run modifications. | ||
| + | -u, --username [USERNAME] | ||
| + | Specify the name of the person making the modification, input your name, please. | ||
| + | -t, --type [RUNTYPE] | ||
| + | Specify the type of run, e.g: production, cosmics... | ||
| + | -b, --beampol [BEAM POLARIZATION] | ||
| + | Specify the beam polarization. | ||
| + | -f --flag [FLAG] | ||
| + | Specify the run quality. | ||
| + | -1 data file does not exist | ||
| + | 0 junk run | ||
| + | 5 target is not in 3He position, e.g: BCM/BPM... | ||
| + | 10 target is in 3He position, but for other purpose, e.g: test... | ||
| + | 15 production run with some problems, e.g: roc problem... | ||
| + | 20 production run with no obvious problems | ||
| + | -c, --comment "[COMMENT]" | ||
| + | Add a comment. For best results, put the entire comment in quotation marks. | ||
| + | -v, --verbose | ||
| + | Be verbose. | ||
| + | |||
==Table Descriptions== | ==Table Descriptions== | ||
===RunInfo=== | ===RunInfo=== | ||
| Line 34: | Line 72: | ||
| RasterWidthY | float | YES | | NULL | | | | RasterWidthY | float | YES | | NULL | | | ||
| WienAngle | float | YES | | NULL | | | | WienAngle | float | YES | | NULL | | | ||
| − | | | + | | BeamHalfWavePlate | varchar(50) | YES | | NULL | | |
| SmallCoilCurrent | float | YES | | NULL | | | | SmallCoilCurrent | float | YES | | NULL | | | ||
| VerticalCoilCurrent | float | YES | | NULL | | | | VerticalCoilCurrent | float | YES | | NULL | | | ||
| Line 52: | Line 90: | ||
| ShiftWorkerComment | longtext | YES | | NULL | | | | ShiftWorkerComment | longtext | YES | | NULL | | | ||
+-------------------------+-------------+------+-----+---------+-------+ | +-------------------------+-------------+------+-----+---------+-------+ | ||
| − | |||
===EndRunInfo=== | ===EndRunInfo=== | ||
| Line 128: | Line 165: | ||
| BeamCharge_d3_mp | float | YES | | NULL | | | | BeamCharge_d3_mp | float | YES | | NULL | | | ||
+--------------------+---------+------+-----+---------+-------+ | +--------------------+---------+------+-----+---------+-------+ | ||
| − | |||
===AnalysisInfo=== | ===AnalysisInfo=== | ||
Latest revision as of 02:39, 19 February 2009
Contents
Display
Search the run you want to find
- A search tool, using the transversity MYSQL database, is found here:
E06010 Run Search
- Run Flag in AnalysisInfo
-10 data file does not exist: skipped run number or data file lost in data disk crash -5 junk run, not useful for anything 5 secondary run, target is not in 3He position, for example:cosmics, BPM/BCM calibration... 10 secondary run, target is in 3He position, but for other purpose, for example:cosmics, test... 15 primary run with some problems, run taken for physics analysis but some problem: roc problem, short run time... 20 primary run with no obvious problems logged in HALOG/shift summary/paper summary
Available Tables
- RunInfo
- From the "start of run" halla e-log entries
- EndRunInfo
- From the "end of run" halla e-log entries
- AnalysisInfo
- Primary information is from the "start of run" and "end of run" halla e-log entries
- Further information is filled in by those doing the analysis (online and offline)
Script for adding entries to the AnalysisInfo table
Here is the script for adding your own analysis information to the AnalysisInfo table
/adaqfs/home/adaq/transversity/mysql/setAnalysisInfo.pl
- setAnalysisInfo.pl
-r, --runnum [LOW NUMBER]-[HIGH NUMBER]
Specify the range of runnumbers to modify. One number will work for single run modifications.
-u, --username [USERNAME]
Specify the name of the person making the modification, input your name, please.
-t, --type [RUNTYPE]
Specify the type of run, e.g: production, cosmics...
-b, --beampol [BEAM POLARIZATION]
Specify the beam polarization.
-f --flag [FLAG]
Specify the run quality.
-1 data file does not exist
0 junk run
5 target is not in 3He position, e.g: BCM/BPM...
10 target is in 3He position, but for other purpose, e.g: test...
15 production run with some problems, e.g: roc problem...
20 production run with no obvious problems
-c, --comment "[COMMENT]"
Add a comment. For best results, put the entire comment in quotation marks.
-v, --verbose
Be verbose.
Table Descriptions
RunInfo
+-------------------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------------+-------------+------+-----+---------+-------+ | RunNumber | int(11) | | PRI | 0 | | | RunStartTime | datetime | YES | | NULL | | | TargetName | varchar(50) | YES | | NULL | | | TargetPolarizeDirection | varchar(50) | YES | | NULL | | | Prescale1 | int(11) | YES | | NULL | | | Prescale2 | int(11) | YES | | NULL | | | Prescale3 | int(11) | YES | | NULL | | | Prescale4 | int(11) | YES | | NULL | | | Prescale5 | int(11) | YES | | NULL | | | Prescale6 | int(11) | YES | | NULL | | | Prescale7 | int(11) | YES | | NULL | | | Prescale8 | int(11) | YES | | NULL | | | RichHV16 | float | YES | | NULL | | | RichCurrent16 | float | YES | | NULL | | | RichHV17 | float | YES | | NULL | | | RichMethaneFlow | float | YES | | NULL | | | UpstreamBCMCurrent | float | YES | | NULL | | | DownstreamBCMCurrent | float | YES | | NULL | | | Energy | float | YES | | NULL | | | RasterWidthX | float | YES | | NULL | | | RasterWidthY | float | YES | | NULL | | | WienAngle | float | YES | | NULL | | | BeamHalfWavePlate | varchar(50) | YES | | NULL | | | SmallCoilCurrent | float | YES | | NULL | | | VerticalCoilCurrent | float | YES | | NULL | | | LargeCoilCurrent | float | YES | | NULL | | | He3FlipID | int(11) | YES | | NULL | | | TargetPolarization | float | YES | | NULL | | | TargetPosition | float | YES | | NULL | | | BBChamber1Threshold | float | YES | | NULL | | | BBChamber2Threshold | float | YES | | NULL | | | BBChamber3Threshold | float | YES | | NULL | | | BBShowerThreshold | float | YES | | NULL | | | BBPreShowerThreshold | float | YES | | NULL | | | BBShower2Threshold | float | YES | | NULL | | | BBCherenkovThreshold | float | YES | | NULL | | | CodaConfig | varchar(50) | YES | | NULL | | | HappexRunNumber | int(11) | YES | | NULL | | | ShiftWorkerComment | longtext | YES | | NULL | | +-------------------------+-------------+------+-----+---------+-------+
EndRunInfo
+--------------------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------------+---------+------+-----+---------+-------+ | RunNumber | int(11) | YES | MUL | NULL | | | Events_0 | int(11) | YES | | NULL | | | Events_pp | int(11) | YES | | NULL | | | Events_mm | int(11) | YES | | NULL | | | Events_pm | int(11) | YES | | NULL | | | Events_mp | int(11) | YES | | NULL | | | Time_0 | float | YES | | NULL | | | Time_pp | float | YES | | NULL | | | Time_mm | float | YES | | NULL | | | Time_pm | float | YES | | NULL | | | Time_mp | float | YES | | NULL | | | DeadTime_0 | float | YES | | NULL | | | DeadTime_pp | float | YES | | NULL | | | DeadTime_mm | float | YES | | NULL | | | DeadTime_pm | float | YES | | NULL | | | DeadTime_mp | float | YES | | NULL | | | T1real_0 | int(11) | YES | | NULL | | | T2real_0 | int(11) | YES | | NULL | | | T3real_0 | int(11) | YES | | NULL | | | T4real_0 | int(11) | YES | | NULL | | | T5real_0 | int(11) | YES | | NULL | | | T6real_0 | int(11) | YES | | NULL | | | T7real_0 | int(11) | YES | | NULL | | | T8real_0 | int(11) | YES | | NULL | | | T1real_pp | int(11) | YES | | NULL | | | T2real_pp | int(11) | YES | | NULL | | | T3real_pp | int(11) | YES | | NULL | | | T4real_pp | int(11) | YES | | NULL | | | T5real_pp | int(11) | YES | | NULL | | | T6real_pp | int(11) | YES | | NULL | | | T7real_pp | int(11) | YES | | NULL | | | T8real_pp | int(11) | YES | | NULL | | | T1real_mm | int(11) | YES | | NULL | | | T2real_mm | int(11) | YES | | NULL | | | T3real_mm | int(11) | YES | | NULL | | | T4real_mm | int(11) | YES | | NULL | | | T5real_mm | int(11) | YES | | NULL | | | T6real_mm | int(11) | YES | | NULL | | | T7real_mm | int(11) | YES | | NULL | | | T8real_mm | int(11) | YES | | NULL | | | T1real_pm | int(11) | YES | | NULL | | | T2real_pm | int(11) | YES | | NULL | | | T3real_pm | int(11) | YES | | NULL | | | T4real_pm | int(11) | YES | | NULL | | | T5real_pm | int(11) | YES | | NULL | | | T6real_pm | int(11) | YES | | NULL | | | T7real_pm | int(11) | YES | | NULL | | | T8real_pm | int(11) | YES | | NULL | | | T1real_mp | int(11) | YES | | NULL | | | T2real_mp | int(11) | YES | | NULL | | | T3real_mp | int(11) | YES | | NULL | | | T4real_mp | int(11) | YES | | NULL | | | T5real_mp | int(11) | YES | | NULL | | | T6real_mp | int(11) | YES | | NULL | | | T7real_mp | int(11) | YES | | NULL | | | T8real_mp | int(11) | YES | | NULL | | | AverageCurrent_x1 | float | YES | | NULL | | | AverageCurrent_x3 | float | YES | | NULL | | | AverageCurrent_x10 | float | YES | | NULL | | | BeamCharge_u3_0 | float | YES | | NULL | | | BeamCharge_u3_pp | float | YES | | NULL | | | BeamCharge_u3_mm | float | YES | | NULL | | | BeamCharge_u3_pm | float | YES | | NULL | | | BeamCharge_u3_mp | float | YES | | NULL | | | BeamCharge_d3_0 | float | YES | | NULL | | | BeamCharge_d3_pp | float | YES | | NULL | | | BeamCharge_d3_mm | float | YES | | NULL | | | BeamCharge_d3_pm | float | YES | | NULL | | | BeamCharge_d3_mp | float | YES | | NULL | | +--------------------+---------+------+-----+---------+-------+
AnalysisInfo
+-----------+------------+------+-----+-------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------+------+-----+-------------------+----------------+ | anaID | int(11) | | PRI | NULL | auto_increment | | EntryTime | timestamp | YES | | CURRENT_TIMESTAMP | | | RunNumber | int(11) | YES | MUL | NULL | | | UserName | longtext | YES | | NULL | | | RunType | longtext | YES | | NULL | | | Flag | tinyint(4) | YES | | NULL | | | Comment | longtext | YES | | NULL | | +-----------+------------+------+-----+-------------------+----------------+
