The CDF Run II Calibration Database

USER VERSION OF THIS PAGE (UNDER CONSTRUCTION)


This page is meant to give a snapshot of the status of implementing the CDF calibration database fro Run II and some useful links for learning about relational databases and associated software. It was last updated 11/19/02.

Contact People: Dustin McGivern (offline), Retired (online), Jack Cranshaw (designer) (online), Petar Maksimovic (operations) Mat Martin (operations)

 Database Status  :  Tools  :  Minutes of Meetings  :  Help and Examples  :  Links and Information 

Calibration Primer

Instructions for adding a table to the Database

pl/sql howto page (database scripting)

Conceptual Structure

    There are three environments where the calibration database will have to be available: Online (B0), Offline (FCC), and Remote (not B0, not FCC). The diagram below illustrates this. The current plan is to use Oracle for the Online and Offline databases.

    The data are stored in relational databases made of tables and keys. The data will therefore be stored in tables. Current plans are that the tables would correspond to attribute-component pairs and contain all the runs and versions associated with that pair. Note that in this schema a different definition of the data stored means that you need a different table, so there will be of order 400 data tables.

   There are different types of information in the calibration database and not all of the Online database need be mirrored to the Offline database. In fact, it is hoped that the largest volume calibrations can be applied before the data is written to tape. I have identified 5 categories of calibrations which are needed in the Online database.

The borders between these categories are somewhat porous, and their composition will undoubtedly evolve with time, but I find them useful for understanding. The Online Operational Aspects of how calibrations are taken and how this interacts with the database was headed by Rick St. Denis and Jack Cranshaw while the offline operational aspects are headed by Rob Snihur.
 
    The Online and Offline database servers will have separate backup and partitioning systems. For the Online as many runs as possible will be kept on disk. Although details have yet to be worked out it is not foreseen to mirror calibrations which are used ONLY in the Online to the Offline database. Oracle has software which allows for the synchronization of the Online and the Offline databases. Storage details for Online and Offline have yet to be worked out. Also whether Remote mirrors of the Offline will exist, or whether remote users will pull off subsets of the Offline database as needed has not been worked out.

Currently Defined Calibration Tables

Online Production Database User Access List

Calibration Task List

Calibration Database Simulation howto


Database Tools

        Code Generation  For databases with many table/datatypes with similar access methods, code generation will
        be used to derive them from a single set of data definitions.
       DBANA: A ROOT-based Analysis Tool for Calibrations.  Used by the control room and detector groups to
         validate calibrations.
        Beginner's Guide to the Database Browser.
       The Database Browser.  VERY flexible.
        A Second B0-based Database Browser.

 
Prototypes and Examples
 
       A bit out of date Debugging Database Connection Problems
       Consumer Status  (11/19/02)
       X-mode Calibration Consumers (3/28/00)
       D-mode Calibration Consumer Template  (11/19/02) Also see note  CDF5503

       Note Containing Use Cases for Calibrations

       Online Calibration Meetings  No Coordinator since 3/01!!
               Online calibration meetings were held at 9am in the CDF theater on off-weeks.

        Note Describing the CalibDB Schema
        Entity Relationship Diagram from Reverse Engineering (1/23/02)

Useful Links

CDF Run II Data Format and Related Issues  - CDF internal document

Oracle Documentation Library

MySQL Home Page

Java Database API - JDBC

Page maintained by Jack Cranshaw, cranshaw@fnal.gov