CMS GEM Database Group


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


GEM Database Team:

Name Institute
Muhammad Imran (NCP) [Convener]
Umesh Joshi (Fermilab)
Rao Atif (NCP)
Adeel (NCP)
Aivaras Silale (Vilnius)
Valdas Rapsevicius (Vilnius)


resource name/link description
egroups cms-gem-db-prod-gui Group for production instance of GUI
cms-gem-db-group GEM detector database group
cms-gem-vm-admin Group for administration openstack projects

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

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

For Developers



# Copy xml or zip file to spool area

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

# Job log


Topic attachments
I Attachment History Action Size Date Who Comment
PDFpdf GEM_Database_Documentation_V1.1.pdf r1 manage 6909.8 K 2015-08-25 - 17:31 UnknownUser it is a documentation for GEM database (v1) specifically about construction part which will help detector experts to have an overview about how the database maps the detector.
PDFpdf GEM_Database_Documentation_V1.2.pdf r1 manage 6907.3 K 2015-11-03 - 09:21 UnknownUser  
PDFpdf gem_db_1st_review_20150827.pdf r1 manage 178.0 K 2015-09-22 - 14:20 UnknownUser dbLoader and xml formate
Edit | Attach | Watch | Print version | History: r17 < r16 < r15 < r14 < r13 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r17 - 2019-12-12 - AivarasSilale
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    MPGD All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright &© 2008-2023 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback