27 September 2004 to 1 October 2004
Interlaken, Switzerland
Europe/Zurich timezone

Database Usage and Performance for the Fermilab Run II Experiments

29 Sep 2004, 10:00
Coffee (Interlaken, Switzerland)


Interlaken, Switzerland

Board: 37
poster Track 4 - Distributed Computing Services Poster Session 2


L. Lueking (FERMILAB)


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)

Presentation Materials