HGCAL Database Current Status Current Responsible People Vilnius
HGCAL Database Current Status Current Responsible People Vilnius University - Valdas Rapsevicius, Aivaras Silale, Artiom Poluden OMS (online Monitoring System) DB Loaders Fermilab – Umesh Joshi Database & Related We would like to have more people from HGCAL (setup HGCAL DB group) Aug 21, 2018 HGCAL DB Meeting Aug 21, 2018 1
HGCAL Database – Current Status 3 instances of the CMS HGCAL Database Deployed Development: INT 2 R DB (CERN IT) Production: OMDS DB (P 5) Integration: CMSINTR (P 5) Load Data in DB Data encapsulated in XML files copied over to spool areas in designated machines DB Loader process picks up data from files and loads in DB DB Loader processes hosted in 2 machines deployed in CERN IT hgcal-machine-a 188. 184. 86. 93 hgcal-machine-b 188. 184. 86. 34 1 machine deployed in P 5 (for production & integration DB loaders only) srv-s 2 f 17 -20 -01. cms 10. 176. 7. 155 OMS pages (development) deployed https: //cmsomsdet. cern. ch/hgcal/index Aug 21, 2018 HGCAL DB Meeting Aug 21, 2018 2
HGCAL Database – Current Status Spool Area in machines - Please ask Aivaras (aivaras. silale@cern. ch) for permission /home/dbspool/hgcal/int 2 r (development DB) /home/dbspool/hgcal/cmsr (production DB) Some details about data loading Aug 21, 2018 XML files used to load data XML file templates to load data will be provided After DB tables have been deployed, templates will be provided A table in the DB , DB_CONDITIONS_DATA_AUDITLOG, provides status of data loading Data in DB is published in the HGCAL OMS page HGCAL DB Meeting Aug 21, 2018 3
HGCAL Database – Current Status (cont. ) Sensors (from UCSB & CERN) HPK Six Inch 135 Cell Silicon Sensor (180 registered in the DB) o HPK Six Inch 135 Sensor Cell o HPK Six Inch 135 Sensor Calib Cell o HPK Six Inch 135 Sensor Guard Ring HPK Six Inch 239 Cell Silicon Sensors (registered 56 in the DB) HPK Eight Inch 271 Cell Silicon Sensor (28 registered in the DB) • PCBs, Plates (from UCSB) Modules “constructed” in DB using data from UCSB Module (parent) Sensor, Plate, PCB (children) Total of 75 modules registered in the DB 1 with top layer as plate – module 72 3 with top layer as sensor – modules 11, 18, 23 17 with Kapton as top layer – modules 32 34, 36, 37, 40, 52, 56 58, 65, 67 70, 73, 74 The rest have base plate + sensor + PCB Aug 21, 2018 HGCAL DB Meeting Aug 21, 2018 4
HGCAL Database – Current Status (cont. ) Naming Scheme Currently in use Module: Sensor: PCB: Base Plate UCSB_HGC_TST_MOD_75 HPK_6 in_135_1083 HGC_PCB_17 NCU_HGC_PLT_10 IV & CV Curves in DB Aug 21, 2018 HGCAL DB Meeting Aug 21, 2018 5
- Slides: 5