Calorimeter Calibration Calibration procedure and Database Definition Ursula

Calorimeter Calibration: Calibration procedure and Database Definition Ursula Bassler, Dhiman Chakraborty, Mrinmoy Bhattacharjee, Leslie Groer, Evelyne Lebreton, Dean Schamberger, Moustapha Thioye, Vicky White Calib Meeting Lyon 14/11/00 1

Calibration Constants Calorimeter Electronics Trig. sum Bank 0 Calibration Calorimeter SCA (48 deep) Preamp/ Driver Filter/ Shaper x 1 x 8 SCA (48 deep) BLS SCA Output Buffer SCA (48 deep) Bank 1 Trigger: no calibration Base. Line. Subtractor: integer values - ped , , 0 -suppr. L 3: “golden sample” - ped , , 0 -suppr. , gain 1, gain 8 Reco: ped , , 0 -suppr. , gain 1, gain 8 Calib Meeting Lyon 14/11/00 2

Calorimeter Read-Out Structure 1 crate 12 (preamp-box) 1 card 96 (motherboard) 1 channel 48 (4 towers 12 ”layers” ) 12 preamp -boxes 96 preamp-motherboards 4 towers 12 “layers” 12 BLS-crates 96 BLS-motherboards 48 channels 12 ADC-crates 96 ADC-cards 48 channels smallest unit to be calibrated: 1 crate Calib Meeting Lyon 14/11/00 3

Online Calibration System Taka Yasuda Online Calibration System Taker Configure Request start run COOR Start run Calibration Manager End Run Data Crates Calib Meeting Lyon 14/11/00 Status Comparis on Results Validator Pedestals Gains Pedestals Start run Gains COMICS Commit, Calib Manager Abort GUI Database Access Calib. Data Processor Database Interface Calibration Database 4

Calibration Data Flow CALIBRATION PROCEDURES: 2/3 times a week • pedestal runs: ped , • pulser runs: gain 1, gain 8 after validation ONLINE DATABASE: • constants ordered copy by crate#, card#, channel # BLS: • integers for 0 suppression • constants updated Calib Meeting Lyon 14/11/00 L 3: • “golden sample” TRIGGER: • no calibration OFFLINE DATABASE: • optimized format for reco possible RECONSTRUCTION: • 0 -suppression parameters • channel and gain intercalibration • constants updated 5

Database Tables Structure - Online Mustapha Thioye, Mrinmoy, Dhiman cal_ped_values ped_col_id channel_id mean sigma Calib Meeting Lyon 14/11/00 cal_calibration_run Calibration_run_id ped_col_id pul_col_id start comments • following Taka’s suggestions • + table to map unique channel id with crate, card, channel. . • design completed cal_pul_values pul_col_id channel_id mean(step) sigma(step) coeff_1 coeff_2 coeff_3 6

Database Tables Structure - Offline Cal_ped_collection ped_cal_id ped_col_id crate _id cal_ped_values ped_col_id crate_id card_id channel_id mean sigma Calib Meeting Lyon 14/11/00 cal_calibration_id ped_cal_id pul_cal_id start • tables for online/offline should follow the same structure • one additional table keeping calibration run information Cal_pul_collection pul_cal_id pul_col_id crate _id cal_pul_values pul_col_id crate_id card_id channel_id coeff_1 coeff_2 coeff_3 7

Online/Offline Transfer Jeremy Simmons ONLINE DB OTHER CAILB DB TABLES PEDS GAINS ETC Onl_cal. Db. Transfer OFFLINE DB PEDS Stage GAINS Stage ETC Calib Meeting Lyon 14/11/00 Offline Translation Process to be produced for eqch subdetector 8

Online/Offline translation process: • drop some information (pattern_number…) • channel order and id stays the same • assembling cal_pxx_collection tables: • copying cal_ped values and cal_pul_values • defining which units have been updated • increment pxx_cal_id and pxx_col_id for updated units • assembling cal_calibration table: • increment calibration_id and pxx_cal_id Calib Meeting Lyon 14/11/00 9

Calibration in the Reconstruction raw data chunk: packed format ADC hits, crate #, card #, tower #, layers# cal_unpack_package FE data chunk: unpacked format ADC hits, crate #, card #, tower #, layers# cal_calib_package Calibrated data chunk: keeps ordering energies, crate #, card #, tower #, layers# cal_geom_package Reconstructed data chunk: physics units energies, , Calib Meeting Lyon 14/11/00 OFFLINE DATABASE: • crate #, card #, tower #, layers# • ped , , 0 -suppr. , gain 1, gain 8 calibration manager: access to database for all subdetectors cal_calibrator: fills calorimeter calibration classes 10

Steps towards review: • finalizing database design with Oracle Designer • generating database tables • population of online-offline tables • transfer and translate online-offline tables • definition and creation of calibration classes • similar to SMT • automatic procedure? • adapt calibration_db_server and calibration_db packages Calib Meeting Lyon 14/11/00 11