CDF Support Databases

All databases listed below are prototypes, all documents are drafts, and all presentations are preliminary descriptions unless otherwise noted.

Overview

• Support DB Overview Talk: Report to Von Ruden review committee by M. Lancaster on January 27, 1999.
• Support DB Overview Document: Support Database pages of report to Von Ruden review committee by M. Shapiro on January 27, 1999.
• Support DB Specification: CDF 5107: By J. Kowalkowski, J. Proudfoot, F. Semeria, L. Sexton and M. Shapiro on June 19, 1998.
• Database Coordination: Rick St. Denis' page of info, people, items for discussion and meetings.

Databases

1. Offline Server:
   • Data File Catalog : Description of the catalog of produced data files and their luminosity.
2. Offline and Online Server:
   • Calibration DB : Prototype description by J. Cranshaw of the databases containing calibrations, alignment, and other data corrections.
   • Trigger DB : Database that will describe all four levels of trigger: level 1, 2, 3 and production. This link is to the home page of Trigger Database working group, convened by S. Miller and K. Tollefson.
   • Run Conditions DB : Database containing conditions associated with the run that will need to be accessed by offline analysis code. No prototype available.
3. Online Server:
   • Online Hardware DB : Prototype description by G. Goeransson of database of online channels organized by hardware location.
   • CDF Conditions DB : Online database containing slow controls and other information that will likely *not* need to be accessed by the offline analysis code. Discussion of some of the quantities in this database from S. Segler and A. Savoy-Navarro.
   • Run Configuration DB : Online database containing the partitioning information for Run_Control. No prototype available.
4. Other Servers:
   • CDF Module DB : PREP Oracle database where CDF electronic equipment modules are tracked. Description by J Yoh.
   • Electronic Logbook : Electronic logbook for use by shift crew. Based on electronic logbook used by beams division. This currently does not reside in a relational database.
5. Notes on Databases:
   • Logical Interconnections: Description by R. Harris of the known and assumed logical interconnections among the databases.
   • Holes: Informal list by R. Harris of the known holes in database responsibility, design, and interconnection.
   • Run 1: Historical information about the run 1 CDF Databases collected by S. Hahn and R. Harris.
   • Debugging Database Connection Problems : A FAQ by Jack Cranshaw for how to troubleshoot your database connection error.

Database Clients

• Online : The online interacts with the Online Hardware, Run Configuration, Calibration, Run Conditions and CDF Conditions databases.
• Level 3 : Level 3 interacts with the Calibration, Run Conditions, and Trigger Table databases.
• Consumers : The consumer processes running online and monitoring the data stream interact with the Calibration, Run Conditions, CDF Conditions and Trigger Table databases.
• Stage0 : Stage0 processing of data at B0 for calibration interacts with the Calibration, Run Conditions, CDF Conditions, and Trigger Table databases.
• Production : Production and reprocessing of CDF data and MonteCarlo in the production farms interacts with the Data File Catalog, and the Calibration, Run Conditions and Trigger Table databases.
• Offline : Offline analysis at Fermilab and the remote institutions interacts with the Data File Catalog, and the Calibration, Run Conditions and Trigger Table databases.

Database Servers

• Online Server B0DAU30: Calib DB, Trigger Table DB, Online Hardware DB.
• Offline Server CDFORA : CDF Data File Catalog.

Mailing Lists

• Computing division support for CDF databases is cdfdb-support@fnal.gov
  
• Database managers, developers, users and support can be reached at cdfdb-users@fnal.gov which includes cdfdb-support@fnal.gov
  

This file is kept on cdfsga.fnal.gov at /cdf/www/offline/database/home.html
Last updated Aug. 23, 2000 by Robert M. Harris, 630-840-4932,   rharris@fnal.gov