- bouchet's home page
- Posts
- 2016
- 2015
- December (1)
- November (3)
- October (2)
- September (2)
- August (2)
- June (2)
- April (5)
- March (2)
- February (3)
- January (2)
- 2014
- December (2)
- November (2)
- October (3)
- September (2)
- August (3)
- July (1)
- June (3)
- May (6)
- April (6)
- March (1)
- February (2)
- January (1)
- 2013
- December (2)
- November (3)
- October (3)
- September (4)
- August (1)
- July (1)
- May (4)
- April (6)
- March (4)
- February (3)
- 2012
- 2011
- December (2)
- November (2)
- October (4)
- September (1)
- August (2)
- July (6)
- June (2)
- May (3)
- April (3)
- March (2)
- 2010
- 2009
- December (2)
- November (1)
- October (3)
- September (1)
- August (1)
- July (1)
- June (2)
- April (1)
- March (2)
- February (2)
- January (1)
- 2008
- My blog
- Post new blog entry
- All blogs
SSD DB tables
Geometry/ssd
1) slsCtrl : control parameters/constants.--> no need to update
2) clusterControl : control parameters/constants.
--> no need to update
3) ssdBarrelPosition : seems not to be used in SSD code
--> no need to update
4) ssdConfiguration : # of sectors, ladders, wafers and an array of present/active ladders. The last entry is valid up to 2007-08-08 where 5 ladders were disabled (see below)
| 2007-08-08 19:22:29 | 2007-01-01 00:00:01 | 0000000001,0000000001,0000000002,0000000002,0000000002,0000000000,0000000000,0000000000,0000000002,0000000003,0000000003,0000000003,0000000004,0000000004,0000000004,0000000004,0000000004,0000000004,0000000004,0000000001 |-->It should be updated for y2014 with all ladders active
5) ssdDimensions : control parameters/constants.
--> no need to update
6) ssdLaddersPosition : seems not to be used in SSD code
--> no need to update
7) ssdSectorPosition :seems not to be used in SSD code
--> no need to update
8) ssdPedStrip : internal table used in SSD code
--> no need to update
9) SsdOnGlobal : place the SSD on global/frame (unitary matrix)
Last entry is 2007-05-02
+---------------------+---------------------+ | entryTime | beginTime | +---------------------+---------------------+ | 2004-10-30 00:00:00 | 2004-10-30 00:00:00 | | 2004-12-01 00:00:00 | 2004-10-29 00:00:00 | | 2007-03-21 18:14:23 | 2005-01-01 00:00:00 | | 2007-03-21 18:14:23 | 2005-01-20 00:00:00 | | 2007-03-21 18:14:24 | 2005-02-17 00:00:00 | | 2007-03-21 18:14:24 | 2005-03-10 00:00:00 | | 2007-12-18 17:15:18 | 2007-03-21 00:00:31 | | 2007-12-05 20:28:00 | 2007-05-24 00:00:31 | 2007-05-02 21:49:59 | 2019-01-01 00:00:04 | +---------------------+---------------------+--> will be renamed OscOnGlobal
--> need to be initialized for y2014
10) SsdLaddersOnSectors : place the SSD ladders on Sectors (4).
Last entry is 2007-05-02
--> will not be used anymore
11) SsdSectorsOnGlobal : place the SSD sectors on Global (unitary matrix)
Last entry is 2007-05-02
--> will not be used anymore
12) SsdWafersOnLadders : place the SSD wafers on the ladder (along Z axis)
Last entry is 2007-05-02
--> need to be updated with Jim's survey
--> to be renamed SsdSensorsOnLadder (so need to be created in StarDb)
Tables 10 and 11 will be merged in 1 table : SsdLaddersOnOsc
--> need to be created in StarDb
--> need to be initialized with Jim's survey
13) ssdWafersPosition :
internal table used in SSD code
--> no need to update because it is created each time StSsdDbMaker is run to built the Global-to-Local matrix
Calibration/ssd
1) ssdStripCalib : old table to store strip data (pedestal, rms, signal)
--> should not be used because it crashed StarDB
2) ssdGainCalibWafer : ratio of side-N cluster charge over side-P cluster charge.
320 rows (1 per wafer)
Last entry is 2007-08-06
| 2007-01-01 00:00:05 | 2007-08-06 22:25:02 | 1.0000000000 | +---------------------+---------------------+--------------+ 1600 rows in set (0.01 sec)--> should be initialized with 1 for y2014
3) ssdNoise : new table to store strip data (pedestal, rms, signal)
--> will be updated with pedestal runs
4) ssdWaferConfiguration : table used to active/de-active reconstruction in a given wafer.
320 rows
Last entry is 2008-01-11 with nStatus =1 for all wafers
--> need to be re-initialized with nStatus =1 but with updated beginTime
Groups:
- bouchet's blog
- Login or register to post comments