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
Instructions for adding a table to the Database
pl/sql howto page (database scripting)
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.
Online Production Database User Access List
Calibration Task List
Calibration Database Simulation howto
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
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
Calibration Meetings No Coordinator since 3/01!!
Online calibration meetings were held at 9am in the CDF theater on off-weeks.
the CalibDB Schema
Entity Relationship Diagram from Reverse Engineering (1/23/02)
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, email@example.com