Fermilab Computing Division

CS Document 487-v1

Database Usage and Performance for the Fermilab Run II Experiments

Document #:
Document type:
Submitted by:
Marcia A Teckenbrock
Updated by:
Lee Lueking
Document Created:
20 Sep 2004, 14:56
Contents Revised:
23 Sep 2004, 17:04
Metadata Revised:
20 Jan 2005, 09:53
Viewable by:
  • Public document
Modifiable by:
  • Same as Viewable by

Quick Links:
Latest Version

Other Versions:
20 Sep 2004, 14:56
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.
Files in Document:
  • Run II Database Paper (DatabaseRunIIOverviewCHEP04.pdf, 550.4 kB)
  • pdf (CHEP04_RunII_Database_Poster.pdf, 1.7 MB)
  • ppt (CHEP04_RunII_Database_Poster.ppt, 953.0 kB)
Notes and Changes:
Fermilab Publication number CONF-04-469-CD
Associated with Events:
CHEP2004 held from 27 Sep 2004 to 01 Oct 2004 in Interlaken, Switzerland
DocDB Home ]  [ Search ] [ Authors ] [ Events ] [ Topics ]

DocDB Version 8.8.9, contact Document Database Administrators