Difference between revisions of "Data Monitoring Database"

From GlueXWiki
Jump to: navigation, search
(Tables =)
(Tables)
Line 6: Line 6:
  
 
=== Metadata tables ===
 
=== Metadata tables ===
** Runs - run id (internal), run number, run start time/date, run stop time/date, # of events, nominal beam current, nominal beam energy, target type, target location (?), trigger configuration (e.g. a file name), solenoid field current, radiator.  
+
* Runs - run id (internal), run number, run start time/date, run stop time/date, # of events, nominal beam current, nominal beam energy, target type, target location (?), trigger configuration (e.g. a file name), solenoid field current, radiator.  
** Versions - version id (internal), release, CCDB version, timestamp, data type
+
* Versions - version id (internal), release, CCDB version, timestamp, data type
  
 
=== Raw Data Tables ===
 
=== Raw Data Tables ===
 
* Common info - run id, version id, # of events recorded in detector
 
* Common info - run id, version id, # of events recorded in detector
* TAGH - pedestals, hit counts (mean, sigma), hit times (mean, sigma), minimum ionizing peak energies (mean, sigma)
+
* Detector Systems: Group by detector region
* TAGM - pedestals, hit rate (mean, sigma), hit times (mean, sigma), minimum ionizing peak energies (mean, sigma)
+
** TAGH - pedestals, hit counts (mean, sigma), hit times (mean, sigma), minimum ionizing peak energies (mean, sigma)
* SC - pedestals, hit rate (mean, sigma), hit times (mean, sigma), minimum ionizing peak energies (mean, sigma)
+
** TAGM - pedestals, hit rate (mean, sigma), hit times (mean, sigma), minimum ionizing peak energies (mean, sigma)
* CDC - pedestals, hit rate (mean, sigma), hit times (mean, sigma), minimum ionizing peak energies (mean, sigma)
+
** SC - pedestals, hit rate (mean, sigma), hit times (mean, sigma), minimum ionizing peak energies (mean, sigma)
* FDC - pedestals, hit rate (mean, sigma), hit times (mean, sigma), minimum ionizing peak energies (mean, sigma)
+
** CDC - pedestals, hit rate (mean, sigma), hit times (mean, sigma), minimum ionizing peak energies (mean, sigma)
* TOF - pedestals, hit rate (mean, sigma), hit times (mean, sigma), minimum ionizing peak energies (mean, sigma)
+
** FDC - pedestals, hit rate (mean, sigma), hit times (mean, sigma), minimum ionizing peak energies (mean, sigma)
* BCAL - pedestals, hit rate (mean, sigma), hit times (mean, sigma), minimum ionizing peak energies (mean, sigma)
+
** TOF - pedestals, hit rate (mean, sigma), hit times (mean, sigma), minimum ionizing peak energies (mean, sigma)
* FCAL - pedestals, hit rate (mean, sigma), hit times (mean, sigma), minimum ionizing peak energies (mean, sigma)
+
** BCAL - pedestals, hit rate (mean, sigma), hit times (mean, sigma), minimum ionizing peak energies (mean, sigma)
* PS  - pedestals, hit rate (mean, sigma), hit times (mean, sigma), minimum ionizing peak energies (mean, sigma)
+
** FCAL - pedestals, hit rate (mean, sigma), hit times (mean, sigma), minimum ionizing peak energies (mean, sigma)
 +
** PS  - pedestals, hit rate (mean, sigma), hit times (mean, sigma), minimum ionizing peak energies (mean, sigma)
  
 
=== Reconstruction Data Tables ===
 
=== Reconstruction Data Tables ===

Revision as of 00:12, 24 September 2014

Draft Requirements for data quality monitoring database

The main purpose of this database is to display time series summaries of variables useful for data quality monitoring

Tables

Metadata tables

  • Runs - run id (internal), run number, run start time/date, run stop time/date, # of events, nominal beam current, nominal beam energy, target type, target location (?), trigger configuration (e.g. a file name), solenoid field current, radiator.
  • Versions - version id (internal), release, CCDB version, timestamp, data type

Raw Data Tables

  • Common info - run id, version id, # of events recorded in detector
  • Detector Systems: Group by detector region
    • TAGH - pedestals, hit counts (mean, sigma), hit times (mean, sigma), minimum ionizing peak energies (mean, sigma)
    • TAGM - pedestals, hit rate (mean, sigma), hit times (mean, sigma), minimum ionizing peak energies (mean, sigma)
    • SC - pedestals, hit rate (mean, sigma), hit times (mean, sigma), minimum ionizing peak energies (mean, sigma)
    • CDC - pedestals, hit rate (mean, sigma), hit times (mean, sigma), minimum ionizing peak energies (mean, sigma)
    • FDC - pedestals, hit rate (mean, sigma), hit times (mean, sigma), minimum ionizing peak energies (mean, sigma)
    • TOF - pedestals, hit rate (mean, sigma), hit times (mean, sigma), minimum ionizing peak energies (mean, sigma)
    • BCAL - pedestals, hit rate (mean, sigma), hit times (mean, sigma), minimum ionizing peak energies (mean, sigma)
    • FCAL - pedestals, hit rate (mean, sigma), hit times (mean, sigma), minimum ionizing peak energies (mean, sigma)
    • PS - pedestals, hit rate (mean, sigma), hit times (mean, sigma), minimum ionizing peak energies (mean, sigma)

Reconstruction Data Tables

  • Tracking: # tracks (by PID), avg. resolutions
  • Showers: # showers, avg. resolutions
  • Beam Photons: # photons
  • SC/TOF: # hits

Parameters

  • Data types - types of monitoring data that we are saving (online, offline, MC) [better terms?]
  • Data version