Speaker
L. Lueking
(FERMILAB)
Description
The Run II experiments at Fermilab, CDF and D0, have extensive database needs
covering many areas of their online and offline operations. Delivery of the data to
users and processing farms based around the world has represented major challenges to
both experiments. The range of applications employing databases includes data
management, calibration (conditions), trigger information, run configuration, run
quality, luminosity, and others. Oracle is the primary database product being used
for these applications at Fermilab and some of its advanced features have been
employed, such as table partitioning and replication. There is also experience with
open source database products such as MySQL for secondary databases. A general
overview of the operation, access patterns, and transaction rates is examined and the
potential for growth in the next year presented. The two experiments, while having
similar requirements for availability and performance, employ different architectures
for database access. Details of the experience for these approaches will be compared
and contrasted, as well as the evolution of the delivery systems throughout the run.
Tools employed for monitoring the operation and diagnosing problems will also be
described.
Primary authors
A. Kumar
(Fermilab)
D. Bonham
(Fermilab)
D. Box
(Fermilab)
D. Litvintsev
(FNAL)
E. Gallas
(Fermilab)
E. Wicklund
(Fermilab)
J. Kowalkowski
(Fermilab)
J. Trumbo
(Fermilab)
L. Lueking
(FERMILAB)
M. Vittone-Wiersma
(Fermilab)
N. Stanfield
(Fermilab)
P. Maksimovic
(John Hopkins University)
R. Jetton
(Fermilab)
S. Kovich
(Fermilab)
S.P. White
(Fermilab)
T. Yasuda
(Fermilab)
Y. Guo
(Fermilab)
