CMS GEM Database Group

Charge

Build Database (DB) Oracle based used to store:

• Detector construction data
• Detector conditions data (online & also offline conditions)
• Detector configuration data

Design and Develop Interfaces to Insert/Retrieve data and automate the process of Loading

• Construction GUI
• OMS
• Scripts to integrate with test programs

Communication

GEM Database Team:

E-groups:

Meetings: Weekly

Every Tuesday at 15.30 GVA.

Organization and Workplan

GEM DB Framework – Database, OMS, Interfaces (GUI)

• Muhammad Imran – Database, GUI, & others
• Valdas Rapsevicius, Aivaras – Database loader, OMS, & others
• Umesh Joshi – Database & others

GEM Construction DB – Database, interfacing with detector construction

• Muhammad Imran – DB & main interface with detector construction
• experts – Brian Dorney, Michele Bianco, Jeremie Merlin

GEM Quality Control (QCs) – Database, interfacing for various QCs

• Muhammad Imran, Adeel – DB & main interface for various QCs
• experts – Jeremie Merlin, Giovanni, Brian Dorney

GEM Configuration DB – Database, interfacing with GEM DAQ

• Muhammad Imran –DB & main interface with detector construction
• experts – Jared Sturdy, Mykhailo Dalchenko

GEM Conditions DB – Offline Database, interfacing with DPG & Offline

• Muhammad Imran, – DB & main interface with DPG
• experts – DPG people

GEM OMS– Database, interfacing with DPG, DCS & Offline

• Rao Atif & Aivaras – OMS
• experts – Valdas Rapsevicius (OMS), experts from various systems

Construction Graphical User Interface ( GUI )

GEM Database Graphical user interface

• Version: Dev 0.1
• Technologies: PHP5, Ajax, javascript, HTML, CSS.
• Repository: https://github.com/muhammadimranfarooqi/GEM_GUI_PROD

This GUI is to automate the process of loading GEM construction data into database. Data producers can do the following through it:

• Add parts ( PCBs, Foils, Vfats, GEB, Optohybrid,, etc..).
• Build chambers & super chambers
• Edit data * De-attach/Attach parts from/to chamber * De-attach/Attach chamber from/to super chamber

The Application backend generates XML files and automatically load it to the spool Area where the dbloader map it to the database.

To Access the GUI you must have a CERN account

• Subscribed to e-group: cms-gem-db-group, cms-gem-db-prod-gui
• Development >> https://gemdb.web.cern.ch/gemdb
• Production>> https://gemdb-p5.web.cern.ch/gemdb-p5

For Developers

DBLoader:

Instructions:

# Copy xml or zip file to spool area

• scp filename.xml username@gem-machine-b:/home/dbspool/spool/gem/int2r

# Check state of the job (0 - success, not 0 - error, No such file or directory - pending)

• scp username@gem-machine-b:/home/dbspool/state/int2r/filename.xml /dev/stdouts

# Job log

• scp username@gem-machine-b:/home/dbspool/logs/int2r/filename.xml /dev/stdout | less

Documentation

• GEM_Database_Documentation_V1.2.pdf: GEM_Database_Documentation_V1.2.pdf