Description
SAM was developed as a data handling system for Run II at Fermilab. SAM is a
collection of services, each described by metadata. The metadata are modeled on a
relational database, and implemented in ORACLE. SAM, originally deployed in
production for the D0 Run II experiment, has now been also deployed at CDF and is
being commissioned at MINOS. This illustrates that the metadata decomposition of its
services has a broader applicability than just one experiment. A joint working group
on metadata with representatives from ATLAS, BaBar, CDF, CMS, D0, and LHCB in
cooperation with EGEE has examined this metadata decomposition in the light of
general HEP user requirements.
Greater understanding of the required services of a performant data handling system
has emerged from Run II experience. This experience is being merged with the
understanding being developed in the course of LHC experience with data challenges
and user case discussions. We describe the SAM schema and the commonalities of
function and service support between this schema and proposals for the LHC
experiments. We describe the support structure required for SAM schema updates, the
use of development, integration, and production instances. We are also looking at
the LHC proposals for the evolution of schema using keyword-value pairs that are
then transformed into a normalized, performant database schema.
Primary authors
A. Baranovski
(Fermilab)
A. Kreymer
(FERMI NATIONAL ACCELERATOR LABORATORY)
A. Lyon
(FERMI NATIONAL ACCELERATOR LABORATORY)
A. Sill
(Texas Tech University)
Dr
C. Cioffi
(Oxford University)
C. Nicholson
(UNIVERSITY OF GLASGOW)
F. Ratnikov
(Rutgers University)
G. Garzoglio
(FERMI NATIONAL ACCELERATOR LABORATORY)
G. McCance
(CERN)
I. Terekhov
(Fermilab)
J. Fulachier
(LPSC, Grenoble)
J. Trumbo
(FERMILAB)
K. Nienartowicz
(CERN)
L. Loebel Carpenter
(Fermilab)
L. Lueking
(FERMI NATIONAL ACCELERATOR LABORATORY)
M. Burgon-Lyon
(Glasgow University)
M. Leslie
(Oxford University)
M. Zimmler
(Fermilab)
P Vokac
(Fermilab)
P. Kunszt
(CERN)
P. Millar
(UNIVERSITY OF GLASGOW)
R. Herber
(FERMI NATIONAL ACCELERATOR LABORATORY)
R. Illingworth
(FERMI NATIONAL ACCELERATOR LABORATORY)
R. Kennedy
(FERMI NATIONAL ACCELERATOR LABORATORY)
R. Rocha
(CERN)
R. St.Denis
(University of Glasgow)
S. Albrand
(Grenoble)
S. Belforte
(INFN/Trieste)
S. Hanlon
(Glasgow University)
S. Stonjek
(Fermilab)
S. Veseli
(Fermilab)
S. White
(Fermilab)
T. Barrass
(University of Bristol)
T. Doyle
(Glagow University)
U. Kerzel
(Karlsruhe University)
V. Bartsch
(Oxford University)
W. Merritt
(FERMI NATIONAL ACCELERATOR LABORATORY)