1 / 2

Database

Database. Conditions database. There is a test “online” database, installed on CMSR server (IT server for CMS). Data saved as arrays of given values (gain, crosstalk, …) attached to device identification. Measurement is identified by run number and version.

mick
Download Presentation

Database

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. Database Conditions database. There is a test “online” database, installed on CMSR server (IT server for CMS). Data saved as arrays of given values (gain, crosstalk, …) attached to device identification. Measurement is identified by run number and version. All different variables are written into the same set of tables. There is a number of C++ methods to write in and read from DB and a Web interface to view entered data. Calibration and monitoring values are defined. All calibration values are produced and written into the database, they are used in analysis of slice test data.Calibration objects are created in CMSSW for offline analysis. Now the DB is under conversion into production database. New structure of tables is created in OMDS (online database), which are adopted for measured objects (separate set of tables for each object). Offline tables are created with POOL/ORA tools from defined calibration objects. Checks of online to offline (O2O) data transfer are performed both for old and new table structures. Data to new structure were copied with PL/SQL procedures. The C++ methods to write data directly into OMDS are almost ready. CSC Online SW Review

  2. Database Configuration database. Currently configuration is read from XML files. Configuration database is under development. Preliminary schema (structure of tables) is created following the structure of configuration XML files. Mapping database. Mapping database converts crate number and DMB number into geometrical position of chamber and trigger sector (and vice versa). There is Web interface and C++ methods (with direct access to database). An object should be created, which will be transferred to offline. Run-log database. Information on slice test is written into common CMS e-log and into EMU Run-log database. CSC Online SW Review

More Related