90 likes | 190 Views
The BaBar Conditions Database Setup at SLAC. Igor A. Gaponenko Lawrence Berkeley National Laboratory ( IAGaponenko@LBL.Gov ). Topics. This talk covers a specific setup of the BaBar Conditions/DB at SLAC as of the date of this Workshop.
E N D
The BaBar Conditions Database Setup at SLAC Igor A. Gaponenko Lawrence Berkeley National Laboratory ( IAGaponenko@LBL.Gov )
Topics • This talk covers a specific setup of the BaBarConditions/DB at SLAC as of the date of this Workshop. • NOTE: The physical setup of Objectivity servers is excluded from the consideration. The accent is done on the logical layout of the database. • The multi-federations setup: • The “production” federations generate conditions data independently of each other: • IR2 • OPR, • REPRO • The “consumers” include the following federations: • Physics Analysis Federation at SLAC • users’ test federations at SLAC • federations at remote collaborations’ sites • Data flows between federations. • Some ideas on the technology which we use to split/assemble the conditions of multiple federations: • copy tools • merge tools • Problems…things2Do... Igor A. Gaponenko: The BaBar Conditions Database Setup at SLAC
The Role of Federations • The role of each “production” federation (the type of data it owns/generates): • IR2 Federation • online calibrations • other conditions under which the events are taken • OPR Federation • detector alignments • original “Rolling Calibration” constants • REPRO Federation • updated “Rolling Calibration” constants • Each of these federations is “responsible” for managing of its own set of conditions. • See the tables on the next pages... • Other “consumer” federations have: • a superposition of all conditions data produced in the previous three federations Igor A. Gaponenko: The BaBar Conditions Database Setup at SLAC
Statistics: Containers Igor A. Gaponenko: The BaBar Conditions Database Setup at SLAC
Statistics: Databases (from OPR) Igor A. Gaponenko: The BaBar Conditions Database Setup at SLAC
Data Flows between Federations copy copy IR2 OPR ANALBOOT2 copy copy & merge copy & merge copy into other federations REPRO Igor A. Gaponenko: The BaBar Conditions Database Setup at SLAC
Application Application IR2 OPR DBID Number Link Index Object Object Index Link 1024 copy Read-Only Area 512 ooRef “link” copy 64K Read-Only Area 0 16 Igor A. Gaponenko: The BaBar Conditions Database Setup at SLAC
Merge Tool Merge Tool Application Application OPR REPRO DBID Number Link Index Object Object Index Link 1536 2:read 3:merge 1:copy Read-Only Area 1024 3:merge 2:read 1:copy 64K Read-Only Area 0 16 Igor A. Gaponenko: The BaBar Conditions Database Setup at SLAC
Problems…Things2Do • The merging of data between OPR and REPRO needs to be fully automated. • The basic tools are already in place. • But the synchronization mechanisms needed to run these tools are still required. They (mechanisms) are different for: • OPR to REPRO: • The solution is more or less trivial: use the bookkeeping information about the last operation stored in ORACLE database. • REPRO to OPR: • Trivial approaches do not work. The merging must “keep the pace” with the reprocessing using the lists of re-processed runs or something equivalent. • This work is in progress. Igor A. Gaponenko: The BaBar Conditions Database Setup at SLAC