Database
This topic is a divided into the following sections:-
Databases play a central role in an HEP experiment. They record
detector constants such as:-
- Survey and Alignment The positions sizes and orientations of the detector elements.
- Signal Routing The way signals are routed out of the detector into the DAQ.
- Calibration Constants The constants required to turn raw signals into timing, spatial and
charge information.
Many of these constants, particularly the last in the above list, are time dependent so
a database has to record time tagged multiple sets of constants.
A Database may also to hold inventories of component parts and, where
appropriate, their properties assembled during detector construction
and book-keeping of the data collected during detector operation.
There are a number of commercial and open source Database products.
The most important in HEP are:-
At Oxford we use MySQL and Microsoft's Access.
See the MySQL Tutorial
The MySQL Home page
has a
book list.
OUCS runs courses on Access.
None.
None.
See the MySQL Reference Manual
None.
If you have any comments about this page please send them to
Nick West