Detector Databases

1
Detector Databases

• Andres Sandoval

2
Databases in ALICE

• detector construction db
• Wiktor Peryt Warsaw
• calibration db
• ROOT files in AliEn catalog
• cables db Pierluigi Barberis Access
• INB database Oracle?
• run, simulation and analysis catalog AliEn
  catalog

3
Warsaw Group

• central db CERN Oracle
• satellite db each project PostgreSQL or Oracle
• XML to exchange data
• Dictionaries defining
• Components and Processes,
• processed in Central db.
• Data of components and processes
• entered by the user

Central database
XML
Satellite databases
4
Satellite Database data structures
5
Satellite Database data structures

• Dictionaries
• Maintained in central repository
• Supplied from central database to labs
• Read-only in satellite databases

6
Satellite Database data structures

• Components data
• Created and updated in satellite databases at
  labs
• Copied to central repository

7
Dictionary wizard

• Example of TPC IROC
• detector
• TPC components
• IROC
• IROC long term test
• IROC planarity measurement

8
Detector Lab has the IROC and OROC data in excel
tables
9
electron microscope pictures of wires
10
How to move test data from existing files into a
satellite database
Jacek Wojcieszukjwojcies_at_elka.pw.edu.pl
Warsaw University of Technology
11
Step by step - parameters
Data to transform Parameter1 Components
user_code HAL25_TEST_UC Parameters name
WAFERNO Components type name
SDDAMBRA Parameters valid_from attribute
2002-10-10
23215400 Parameters value
34 Parameter2 Components user_code
HAL25_TEST_UC Parameters name
Location Components type name
SDDAMBRA Parameters valid_from attribute
2002-10-10
23215400 Parameters valid_to attribute
2003-02-10
23215400 Parameters value Int_lab
Result of the transformation ltsubordinate_table
name"PARAMETERS"gt ltsrowgt ltlookup
name"COMPONENT_ID" source_table"COMPONENTS"
connect_by"USER_CODE"gtHAL25_TEST_UClt/look
upgt ltlookup name"PARAMETER_CODE"
source_table"DEFINITION_OF_PARAMETERS"
connect_by"NAME"gtWAFERNOlt/lookupgt
ltlookup name"TYPE_CODE"
source_table"COMPONENT_TYPES"
connect_by"NAME"gtSDDAMBRAlt/lookupgt
ltcolumn name"VALID_FROM"gt 2002-10-10
23215400lt/columngt ltcolumn
name"VALUE"gt34lt/columngt lt/srowgt ltsrowgt
ltlookup name"COMPONENT_ID"
source_table"COMPONENTS"
connect_by"USER_CODE"gtHAL25_TEST_UClt/lookupgt
ltlookup name"PARAMETER_CODE
source_table"DEFINITION_OF_PARAMETERS"
connect_by"NAME"gtLocationlt/lookupgt
ltlookup name"TYPE_CODE"
source_table"COMPONENT_TYPES"
connect_by"NAME"gtSDDAMBRAlt/lookupgt
ltcolumn name"VALID_FROM"gt
2002-10-10 23215400lt/columngt ltcolumn
name"VALID_TO"gt 2003-02-13
23215400lt/columngt ltcolumn
name"VALUE"gtInt_lablt/columngt
lt/srowgt lt/subordinate_tablegt
12
Application

• home page
• IROC
• So far we have not managed to get the dictionary
  of the TPC with the IROC and FEE processed and
  implemented in an Oracle test database to be able
  to load data

13
Parallel Approach

• Last month with Michael Dahlinger and Holger
  Brandt from the GSI computer center started to
  develop an Oracle db like they did for Hades.
• Thomas Lehmann and Rainer Schicker (TRD ROC) main
  focus on Labview to Oracle data transfer
• Marc Stockmeier DCS construction db tables
• Antoine Lebrun (TRD) learn TOAD and Oracle to
  create ROC tables for TPC and TRD
• Rainer Renfordt same for FEE
• Killian Schwarz installed Oracle and TOAD tools
  in his PC, licenses at GSI

14
Labview

• Holger and Thomas created in an afternoon a
  Labview - Oracle client readout prototype

Test PC
Labview
Oracle database server
SQL toolset
ODBC
Oracle client
15
Bigger Things

• Dahlinger pointed out that more important than
  designing tables we need to
• Agree on an unique detector decomposition
• Agree on naming conventions
• Agree on rules for numbering pieces
• Document coordinate systems and their
  transformations
• strategy to place physical objects into
  geometrical objects (FEC138 into
  InnerSector16Slot6)

16
From Hades

• example

17
(No Transcript)
18
(No Transcript)
19
TPC -1

• FC field cage
• ROC read-out chambers
• FEE front-end electronics
• GAS gas system
• COO cooling system
• HV high voltage system
• LV low voltage system
• DCS detector control system

20
TPC - 2

• LSRS laser system
• CBL cables and busbars
• REE read-out electronics
• HLT high level trigger
• CLB calibration
• SML simulation

21
FC
back

• ICV inner containment vessel
• OCV outer containment vessel
• IFC inner field cage
• OFC outer field cage
• CMB central membrane
• ECP end caps
• ROD rods

22
ROC
back

• IRC inner readout chamber
• ORC outer readout chamber
• ALB aluminum body
• SVP survey points
• PDP pad plane
• AWP anode wire plane
• AW anode wire
• W wire
• CWP cathode wire plane
• GGP gating grid plane

23
LSRS
back

• LSRD laser rods
• MMB micro mirror bundle
• SPL beam splitters
• LSR laser

24
TPC TRD Detector Database meeting on Thursday

• Worms Sebastian Bablok, Christian Kofler
• Dahlinger, Killian, Lefebre, Stockmeier, Lehmann,
  Renfordt,
• Lennart Jirden TB global naming and numbering
  scheme in Alice