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

Housing Metadata for the Common Physicist Using a Relational Database

Sep 29, 2004, 4:30 PM
Theatersaal (Interlaken, Switzerland)


Interlaken, Switzerland

oral presentation Track 4 - Distributed Computing Services Distributed Computing Services


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)

Presentation materials