Database Usage and Performance for the Fermilab Run II Experiments
Author(s) -
Lueking, L,
Bonham, D,
Box, D,
Gallas, E,
Guo, Y,
Jetton, R,
Kovich, S,
Kowalkowski, J B,
Kumar, A,
Litvintsev, D O,
Stanfield, N,
Trumbo, J,
Vittone-Wiersma, M,
White, S,
Wicklund, E,
Yasuda, T,
Maksimovic, P
Publication year - 2005
Language(s) - English
DOI - 10.5170/cern-2005-002.731
Subject(s) - computing and computers
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.
Accelerating Research
Robert Robinson Avenue,
Oxford Science Park, Oxford
OX4 4GP, United Kingdom
Address
John Eccles HouseRobert Robinson Avenue,
Oxford Science Park, Oxford
OX4 4GP, United Kingdom