1 / 8

CMS online database model and PVSS to ORACLE conditions writing

CMS online database model and PVSS to ORACLE conditions writing. 22.03.2005 Frank Glege. Database model. O nline M aster D ata S torage. Equipment Configuration Conditions. O ffline R econstruction C onditions DB ON line subset. Create rec conDB data set. Bat 513 . Calibration.

skule
Download Presentation

CMS online database model and PVSS to ORACLE conditions writing

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CMS online database modelandPVSS to ORACLE conditions writing 22.03.2005 Frank Glege

  2. Database model Online Master Data Storage Equipment Configuration Conditions Offline Reconstruction Conditions DB ONline subset Create rec conDB data set Bat 513 Calibration Conditions Master copy Offline Reconstruction Conditions DB OFfline subset Conditions Configuration Frank Glege

  3. OMDS Tag IOV Highly normalized Version Configurations Conditions Pixel Pixel Strips Strips EMDB ECAL ECAL HCAL HCAL DDD RPC RPC Logbook DT DT ES ES LHC data CSC CSC Trigger Trigger DAQ DAQ DCS DCS Frank Glege

  4. PVSS HISTORY_001 PVSS conditions writer PVSS DPT_NAME LASTVAL IOV DP_NAME DPE DPE DPT_NAME IOV DP_NAME DPE DPE DPT_NAME IOV DP_NAME DPE DPE Would be discarded if root DB access sufficient. Frank Glege

  5. PVSS HISTORY_001 PVSS conditions with custom tables PVSS LASTVAL MyTable IOV MyName MyVal MyVal Would be discarded if root DB access sufficient. Frank Glege

  6. OMDS to ORCON • The mechanism for exporting data from ODMS to ORCON must provide • A configuration in ODMS describing the complete export • A factorization of data and processing • Simple table copy • Basic transformations for parameters (smoothing, synchronization, etc) • A plug-in mechanism for specific transformations • History forwarding on configuration extension • A run mode relatable triggering function • A mechanism to ensure the synchronization • Conservation of identity in processing Frank Glege

  7. ECAL Strips Pixel Blob or record in Tables & Materialized Views OMDS to ORCON … • Merging • Smoothing • Synchronizing • Denormalizing • etc. Condition Configurations Conditions EMDB DDD Run/fill end, etc. Frank Glege

  8. ONE WAY ORCON is interface is ORCON is interface is ODMS to ORCON Condition Condition Condition Condition Condition Condition FIFO Condition Condition Materialized view Time range/object number Condition Condition Off line con DB Condition Condition Condition Condition Condition Condition Condition Condition Frank Glege

More Related