skip to main content
OSTI.GOV title logo U.S. Department of Energy
Office of Scientific and Technical Information

Title: Database usage and performance for the Fermilab Run II experiments

Abstract

The Run II experiments at Fermilab, CDF and D0, have extensive database needs covering many areas of their online and offline operations. Delivering data to users and processing farms worldwide has represented major challenges to both experiments. The range of applications employing databases includes, calibration (conditions), trigger information, run configuration, run quality, luminosity, data management, 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 used, for example, in monitoring. Tools employed for monitoring the operation and diagnosing problems are also described.

Authors:
; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;
Publication Date:
Research Org.:
Fermi National Accelerator Lab. (FNAL), Batavia, IL (United States)
Sponsoring Org.:
USDOE
OSTI Identifier:
15016958
Report Number(s):
FERMILAB-CONF-04-469-CD
TRN: US0605167
DOE Contract Number:  
AC02-76CH03000
Resource Type:
Conference
Resource Relation:
Conference: Prepared for Computing in High-Energy Physics (CHEP '04), Interlaken, Switzerland, 27 Sep - 1 Oct 2004
Country of Publication:
United States
Language:
English
Subject:
43 PARTICLE ACCELERATORS; 99 GENERAL AND MISCELLANEOUS//MATHEMATICS, COMPUTING, AND INFORMATION SCIENCE; CALIBRATION; CONFIGURATION; FARMS; FERMILAB; FERMILAB COLLIDER DETECTOR; LUMINOSITY; MANAGEMENT; MONITORING; PERFORMANCE; PHYSICS; PROCESSING; Computing

Citation Formats

Bonham, D., Box, D., Gallas, E., Guo, Y., Jetton, R., Kovich, S., Kowalkowski, J., Kumar, A., Litvintsev, D., Lueking, L., Stanfield, N., Trumbo, J., Vittone-Wiersma, M., White, S.P., Wicklund, E., Yasuda, T., /Fermilab, Maksimovic, P., and /Johns Hopkins U. Database usage and performance for the Fermilab Run II experiments. United States: N. p., 2004. Web.
Bonham, D., Box, D., Gallas, E., Guo, Y., Jetton, R., Kovich, S., Kowalkowski, J., Kumar, A., Litvintsev, D., Lueking, L., Stanfield, N., Trumbo, J., Vittone-Wiersma, M., White, S.P., Wicklund, E., Yasuda, T., /Fermilab, Maksimovic, P., & /Johns Hopkins U. Database usage and performance for the Fermilab Run II experiments. United States.
Bonham, D., Box, D., Gallas, E., Guo, Y., Jetton, R., Kovich, S., Kowalkowski, J., Kumar, A., Litvintsev, D., Lueking, L., Stanfield, N., Trumbo, J., Vittone-Wiersma, M., White, S.P., Wicklund, E., Yasuda, T., /Fermilab, Maksimovic, P., and /Johns Hopkins U. Wed . "Database usage and performance for the Fermilab Run II experiments". United States. https://www.osti.gov/servlets/purl/15016958.
@article{osti_15016958,
title = {Database usage and performance for the Fermilab Run II experiments},
author = {Bonham, D. and Box, D. and Gallas, E. and Guo, Y. and Jetton, R. and Kovich, S. and Kowalkowski, J. and Kumar, A. and Litvintsev, D. and Lueking, L. and Stanfield, N. and Trumbo, J. and Vittone-Wiersma, M. and White, S.P. and Wicklund, E. and Yasuda, T. and /Fermilab and Maksimovic, P. and /Johns Hopkins U.},
abstractNote = {The Run II experiments at Fermilab, CDF and D0, have extensive database needs covering many areas of their online and offline operations. Delivering data to users and processing farms worldwide has represented major challenges to both experiments. The range of applications employing databases includes, calibration (conditions), trigger information, run configuration, run quality, luminosity, data management, 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 used, for example, in monitoring. Tools employed for monitoring the operation and diagnosing problems are also described.},
doi = {},
journal = {},
number = ,
volume = ,
place = {United States},
year = {2004},
month = {12}
}

Conference:
Other availability
Please see Document Availability for additional information on obtaining the full-text document. Library patrons may search WorldCat to identify libraries that hold this conference proceeding.

Save / Share: