CTPPS Database (Revised)

This page contains the information for the development of the CmsTotemPrecisionProtonSpectrometer (CTPPS) online and offline.

General Information

People Involved

• Clemencia MORA HERRERA -- offline conditions
• Helena MALBOUISSON -- offline conditions
• Umesh JOSHI -- online conditions
• Diego Figueiredo
• Wagner Carvalho
• Laurent Forthomme

With support from:

• Valdas Rapsevicius
• Jan Kaspar (Proton Reco)
• Leszek Grzanka
• Valentina Avati (Offline SW)
• Fabrizio Ferro (Offline SW)
• Fabio Ravera (Pixels)
• Enrico Robutti (Pixels)
• Andrea Bellora (Pixels)
• Antonio Vilela Pereira (Protons POG)
• Helio Nogima
• Gabrielle Hugo (Geometry DD4hep)
• Carl Vuolsalo (Geometry DD4hep)
• Ianna Osborne (Geometry DB)
• Gustavo Silveira (Geometry PPS)

Content Requirements

The CTPPS database should store the information related to :

• Roman pot postitions (raw and distance to beampipe center) (wip) %COMPLETE2%
• Roman pot alignment corrections %COMPLETE5%
• DAQ mapping and information %COMPLETE5%
• LHC optics (wip) %COMPLETE3%
• Beam conditions (wip) %COMPLETE3%
• Calibration constants (gains and pedestals for pixels)%COMPLETE5%
• Timing calibration parameters %COMPLETE5%

Offline Condition Classes Development

We are following the step-by-step instructions from 2 tutorials SWGuideCondObjectsTutorial and SWGuideCondSystemLayout.

• The detailed directory layout in the Cond system is shown in the following table:

  Subsystem	Package	directory	content	owner
  CondFormats	CTPPSObjects	interface	persistent object definition [objectname].h	this object
  		src	persistent object implementation [objectname].cc(if necessary)	this object
  		src	T_EventSetup_[objectName].cc EventSetup data registration macro	this object
  		src	classes.h dictionary include file	this task
  		src	classes_def.xml dictionary generator selection file	this task
  	DataRecord	interface/src	EventSetup record registrations	all tasks
  CondCore	CTPPSPlugins	interface	None
  		plugins src	plugin.cc EventSetup data proxy registration macros	this task
  	Utilities	src	CondDBFetch.cc, CondDBImport.cc, CondFormats.h	all tasks

• ATTENTION: Notice that in order to register the data object to the event setup system in src/T_EventSetup_[classname].cc, the statement changed from what is in the SWGuideCondSystemLayout tutorial. For example for pixel gain calibrations:

    #include "CondFormats/PPSObjects/interface/CTPPSPixelGainCalibrations.h"
    #include "FWCore/Utilities/interface/typelookup.h"
    TYPELOOKUP_DATA_REG(CTPPSPixelGainCalibrations);
   

PPS Conditions

Overview

Summary table showing the PPS conditions record/label names:

With only two exceptions, all the above classes are defined/implemented in the CondFormats/PPSObjects package of CMSSW. The exceptions are PDetGeomDesc defined/implemented in CondFormats/GeometryObjects and LHCInfo managed by the AlCaDB group and defined/implemented in CondFormats/RunInfo.

The records are all defined/implemented in CondFormats/DataRecord with the single exception of VeryForwardIdealGeometryRecord, defined/implemented in Geometry/Records.

CTPPSPixelGainCalibrations

History

Documentation table for tags: CTPPSPixelGainCalibrations.

Building software

To be added.

Recipe for Zero-level testing of sqlite before uploading to prod

Show... Hide

Recipe for checking content of payload in DB

These are the instructions to "dump" the information saved about PPS Pixel Gains and Pedestals in the DB to a root file containing 2D histograms of the pedestals and gains for each plane.

1. Setup an environment with CMSSW_10_5_X_2019-02-07-2300 or above
2. Get the package

    git cms-addpkg CondTools/CTPPS
   

3. Go to CondTools/CTPPS/test
4. Execute (choose the sqlite file, runnumber and tag name as appropriate) :

     cmsRun retrieve_sqlite_PixGainCalib_cfg.py ctppspixgains.db CTPPSPixelGainCalibrations_v23Jun18 309100  output_v23Jun18.root 

5. Check the output_v23Jun18.root file which contains a 2d histogram of gains and another of pedestals for each detId (i.e. per detector plane)

CTPPSDAQMapping and CTPPSAnalysisMask

History

Documentation table for tags: CTPPSDAQMapping

Documentation table for tags: CTPPSAnalysisMask

Building software

The configuration file to produce both conditions, DAQ mapping and analysis mask, for the pixel detectors is

CondTools/CTPPS/test/write-ctpps-pixel-daqmap_cfg.py

which loads

CalibPPS/ESProducers/python/CTPPSPixelDAQMappingESSourceXML_cfi.py

with the mapping and mask from the corresponding XML files located at CondFormats/PPSObjects/xml. The latest versions are:

Map	Mask
CondFormats/PPSObjects/xml/rpix_mapping_2022.xml	CondFormats/PPSObjects/xml/rpix_channel_mask_220_far.xml

CTPPSRPAlignmentCorrectionsData

History

Documentation table for tags and input XML files: CTPPSRPAlignmentCorrectionsData.

Building software

To be added.

Recipe for checking content of payload in DB

In order to check the content of a sqlite file, follow the setup above as it was done for gain calibrations and execute:

cmsRun retrieve-sqlite-rpalignment_cfg.py CTPPSRPRealAlignment_table.db 309100 CTPPSRPAlignment_real_table

An example configuration file to print out and check the content of a payload for a given run, in a tag present in the frontier development DB, is attached. This cfg can be used like this:

cmsRun retrieve-frontierdev-rpalignment_cfg.py 309100 CTPPSRPAlignmentCorrections_real_test

PPSOpticalFunctions

History

Documentation table for tags: PPSOpticalFunctions.

Building software

To be added.

PPSGeometryConditions

History

Documentation table for tags: PPSGeometryConditions.

Building software

To be added.

Tags for Run 3

PPSTagsRun3

Open developments with AlCaDB group: https://docs.google.com/document/d/1SRrfyvMxYMZj3zFmDSUVpf5OftMzOM1JGDOeDr-InKc/edit

PPS Tags for Simulation

Documentation table for tags: PPSTagsMC.

Additional Material

Proton Reconstruction Calibrations

Documentation table for tags used in standard proton reconstruction: optics, alignment, and LHCInfo (Work In Progress).

Tool For Querying CTPPS OMS Tables

Here you can test your queries on CTPPS on-line database. Please, not overload the system.

Extras

Here are some of Clemencia's GitRecipes.

Presentations

• RPAlignments presentation at AlCaDB meeting 28/Jan/2019
• Timing calibrations presentation at AlCaDB meeting 28/Jan/2019
• Status report at CTPPS offline SW meeting 04 July, 2016
• Slides with comments from discussion with AlCaDB conveners on April 15, 2016
• Presentation of plans and requirements in AlCaDB meeting, March 21, 2016
• Second presentation at CTPPS Offline SW meeting March 14, 2016
• First presentation at CTPPS Offline SW meeting March 07, 2016

Obsolet Material

Serialization testing

Show... Hide

#include "CondFormats/Serialization/interface/Test.h"

#include "../src/headers.h"

int main()
{
  
  testSerialization<CTPPSAlignmentCorrections>();
  return 0;
}

<bin file="testSerializationCTPPSObjects.cpp">
    <use   name="CondFormats/CTPPSObjects"/>
</bin>

% ./test/slc6_amd64_gcc530/testSerializationCTPPSObjects 

SQlite creation

Show... Hide

% conddb --db myctpps_xml.db list myctppsRPpos_test0
[2016-10-31 17:58:50,386] INFO: Connecting to myctpps_xml.db [sqlite:///myctpps_xml.db]
[2016-10-31 17:58:50,416] INFO: Listing with a limit of 500 IOVs, starting from the highest since. If you need to see more, please increase the limit of returned results.
Since: Run   Insertion Time              Payload                                   Object Type       
-----------  --------------------------  ----------------------------------------  ----------------  
1            2016-10-31 13:49:55.680067  68ed4457c10846a4a8d3ab0004262b83397b855e  CTPPSRPPositions  
1            2016-10-31 13:49:55.681336  18c2f114ed1b4436e28c749a4da0ab08d9fb21ce  CTPPSRPPositions  
5            2016-10-31 13:49:55.682248  b3c240997ed895c81959acdede2dc4b576e78515  CTPPSRPPositions