Agata Construction DataBase

1
Agata Construction DataBase

• Agata Week, 08/07/08
• C.Aufranc, O.Stezowski

2
Outlines

1. Introduction
2. Overview
3. Snapshots
4. Adaptation of BigBrother
5. Initialization of the DataBase
6. Actionsmeasures in the DB
7. Conclusion

3
Introduction

• Oracle DataBase (the server) and a graphical
  interface BigBrowser (java client) conceived and
  developed by the CMS Team Tracker
• This tool has been accepted by the Agata
  Management Board  the official Agata
  construction DataBase
• The Computer Center of the IN2P3 hosts the
  database part a test DB and a production DB
  have been created
• The Infrastructure group began to work with us to
  define the structure of the database

4

1. Overview

5
Structure of objects in the BD
6
Registration of an object
7
Assembly of a crystal in a capsule
8
Transfer of an object
9
Insertion of data via an XML file
10
Connection between 2 objects
11
History of a crystal
12
Report for a specific center
13
Actions available for a crystal
14
Adaptation of BigBrother

• BigBrotherportable application few
  modifications for Agata purpose (DataBase access,
  CMS specific vocabulary)
• Conversion of numerical barcodes to
  alphanumerical ones not a difficult work but
  modifications everywhere in the code. Development
  is finished and tested, but bugs can remain
  report me any problem (cecile.aufranc_at_ipnl.in2p3.f
  r)
• Construction DataBase Agata Web Site
  http//agata.in2p3.fr/DB/
• BigBrowser download ftp//lyoftp.in2p3.fr/AGATA/A
  gataDB

15

1. Initialization of the DataBase

• We must define a structure for the objects to
  insert in the DB which objects, with which
  hierarchy?
• Fondamental questions
• What is meaningfull to put in the DataBase?
• gtmust we put the beam line, the chambers which
  are specific to each laboratory and not belong to
  AGATA?...
• With which degree of details?
• gt must we put the racks in the DB, the heat
  exchangers?...
• And we must be as homogeneous as possible!
• gtthe TCluster corresponds in the DB to the
  support, to the cryostat, to an abstract
  component?...must we create it?

16

1. Initialization of the DataBase

• Definition of objects to insert in the DataBase
• gtname, type (specie), version, isacable
• ex TCluster, Assymetric TC, version 1, not a
  cable
• Definition of the assembly rules between those
  objects
• gtFather/son and number of max sons in the
  father
• ex father Asym TCgtson Asym Cryostat
• gt1 Asym TC is composed of only one Asym
  Cryostat
• Ive sent a more precise documentation to each
  team leader and working group leader

17

1. Policy of barcodes

• Common format for barcodes has been fixed
• gt 16 digits, xxx_xxx_xxx_xxxx
  group_type_specificity_numbering
• ex DET_TCL_ASY_0001
• If stamps cant be put find another
  identification method (serial number)
• Becarefull to the confusion and mistakes between
  objects

18

1. Actions in the DataBase

• Actions in the DB measures on objects
• gt the resolution at 122keV Resolution122keV
• Composite actions (on single objects or on
  composite objects)
• gt the Resolution which is composed of 2 base
  actions the Resolution122keV and the
  Resolution1MeV
• The objects have a status (reference, valid,
  notvalid), and actions can invalidate some
  objects
• Consequences a faulty object cant be
  assembled for instance/ but this object can be
  repaired by ordinary actions or special actions

19

1. Actions

• Examples
• An  Initialization  action can be necessary
  serial number, producer, purchaser
• Some specifications
• Measures of resolutions
• Scannings of crystals
• NB the binary files cant be inserted in the BD,
  but you can create links on files stored on an
  external media (ex at the CCIN2P3, storage under
  HPSS of big files and automatized access via SRB)

20

1. Conclusion

• The urgency to fix the structure of the database
• After that define actions on those objects
• See you at the Detector parameter DB meeting
  Thursday at 1600

21
Necessary information to define an action

• Action name, version
• Object name
• Description a short description of the action
• Results on the action name, type, unity
• Composite Action? Yes/No
• Input values for the test value, unity,
  description
• Tool tool used for a specific center
• Operator name of the operator

08/07/08
21
22
Exemple

• Action RESOLUTION122kev, 1
• Object CRYSTAL
• Description Give the resolution of a crystal and
  its 36 segments for 122keV
• Results resCrystal float, resSegments Array of
  36 floats
• Composite Action? No
• Input 122, keV, Energy
• Tool test
• Operator Cecile
• gtex of composite action Resolution which
  contains 2 base actions Resolution122keV and
  Resolution1MeV

08/07/08
22