1 / 19

IceCube Offline Database Overview

IceCube Offline Database Overview. Georges Kohnen Université de Mons-Hainaut IceCube Workshops Oxford September 23rd, 2005. Today’s ride…. Introduction Database contents Filling the Database, now and in the future Reading from the Database, interaction with offline-software

Download Presentation

IceCube Offline Database Overview

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. IceCube Offline Database Overview Georges Kohnen Université de Mons-Hainaut IceCube Workshops Oxford September 23rd, 2005

  2. Today’s ride… • Introduction • Database contents • Filling the Database, now and in the future • Reading from the Database, interaction with offline-software • YOU can do it – practical information IceCube Offline Database Overwiew – Oxford – September 23rd, 2005 2

  3. Introduction • MySQL Database, “I3OmDb” • Contains / will contain all the non-physics information needed by offline-software, on the SouthPole, on a cluster or on your laptop: • Detector Geometry / Calibration / Status / Run / Monitoring / Trigger… information • Ice Properties • AMANDA information • Different “lookup” tables IceCube Offline Database Overwiew – Oxford – September 23rd, 2005 3

  4. Introduction • The stored information is time-based • Records are “stacked” on each other • Example: Geometry “Qualifier” Drilling01/2006 Corr02/2005 Drilling01/2005 Initial Drilling: lots of strings Better calibrations: only string 21 Drilling: only string 21 Planned Geometry, whole detector Time 01/2004 01/2005 01/2006 IceCube Offline Database Overwiew – Oxford – September 23rd, 2005 4

  5. Geometry tables • AMANDA Geometry • Planned geometry (IceCube + IceTop) • Drilling/Installation (string 21 and stations 21, 29, 30 and 39) • Corrections to these coordinates (from Kurt) • (= most “real” geometry presently available) IceCube Offline Database Overwiew – Oxford – September 23rd, 2005 5

  6. IceTop tables IceCube Offline Database Overwiew – Oxford – September 23rd, 2005 6

  7. AMANDA tables Contents of “old” AMANDA omdb used by Sieglinde IceCube Offline Database Overwiew – Oxford – September 23rd, 2005 7

  8. Charge (Calibration) tables from domcal .xml files IceCube Offline Database Overwiew – Oxford – September 23rd, 2005 8

  9. DOM Configuration table IceCube Offline Database Overwiew – Oxford – September 23rd, 2005 9

  10. DOM Configuration table • There are 64 variables in this table: for 5000 DOMs and 1 run = 1 day, there are 117 million entries for just one year → waaaaaay too much! • → Split this table up according to the frequency at which the variables change (once a run, once a year,…) • This is one of the cases where input / documentation / coordination is urgently needed! IceCube Offline Database Overwiew – Oxford – September 23rd, 2005 A

  11. DOM Monitoring table from Ignacio’s Monitoring files IceCube Offline Database Overwiew – Oxford – September 23rd, 2005 B

  12. Trigger tables • Different design: triggers do not all have the same parameters • Not filled yet IceCube Offline Database Overwiew – Oxford – September 23rd, 2005 C

  13. “Lookup” tables • OMId ↔ (string,tube) for AMANDA • DOM Serial number ↔ DOM location (string,tube) • DOM Serial number ↔ DOM name/nickname • RunId ↔ Run start date/time IceCube Offline Database Overwiew – Oxford – September 23rd, 2005 D

  14. Independent tables IceProperties: Effective Scattering length and Absorption length for different wavelengths (in 10 nm bins), for cos θ = 0.80 and 0.94, and for different depths: Z in 10 m bins (X and Y not (yet) available) IceCube Offline Database Overwiew – Oxford – September 23rd, 2005 E

  15. Filling the Database • Until now: filled from (text/.xml) files, database created from scratch each time • From this Pole season on: automatic update of Detector Calibration from DAQ for online use • Then, regular synchronization of SouthPole I3OmDb with a reference Database in the northern hemisphere, and overall synchronization with this reference DB IceCube Offline Database Overwiew – Oxford – September 23rd, 2005 F

  16. Using the I3OmDb Database at SouthPole Offline chain of modules SouthPole version Source modules Other modules DAQ … I3Db modules fill calibration information SouthPole I3OmDb Reference I3OmDb IceCube Offline Database Overwiew – Oxford – September 23rd, 2005 10

  17. Using the Database in offline-software • I3Db project in offline-software: new design: not one monolithic piece of code anymore, but • one module for each stream (geometry, calibration,…) • one database service, responsible for connecting to the Database, retrieving/caching the data,… • IceProperties / … are currently not used in offline-software, thus I3Db does not retrieve this information (yet) I3Db retrieves the information according to the date of the event I3Db modules I3OmDb Physics input Source modules Other modules Offline chain of modules … IceCube Offline Database Overwiew – Oxford – September 23rd, 2005 11

  18. YOU can do it - Practical Information • Primary Database server: icedb.umh.ac.be (containing this talk, information about the content, about the I3Db module and (soon) about how to set up your local copy of the Database) • Secondary Database Server: ppemons.umh.ac.be • Database Name: "I3OmDb" • Read-only login: username "www“ (> mysql -h "server" -u www) • Recommended tools: • MySql Query Browser • MySql Control Center • New I3Db module ready soon! IceCube Offline Database Overwiew – Oxford – September 23rd, 2005 12

  19. This is the end • Questions? • Comments? (The design will soon be considered “frozen” for the pole season)!!!! • Blame? • Praise? • Gifts? • Free drinks? • …?  IceCube Offline Database Overwiew – Oxford – September 23rd, 2005 13

More Related