1 / 24

Detector Databases

Detector Databases. Andres Sandoval. 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. Warsaw Group.

leala
Download Presentation

Detector Databases

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Detector Databases Andres Sandoval GSI TPC meeting June 2nd

  2. Databases in ALICE • detector construction db • Wiktor Peryt Warsaw • calibration db • ROOT files in AliEn catalog • cables db: Pierluigi BarberisAccess • INB database: Oracle? • run, simulation and analysis catalog: AliEn catalog GSI TPC meeting June 2nd

  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 GSI TPC meeting June 2nd

  4. Satellite Database – data structures GSI TPC meeting June 2nd

  5. Satellite Database – data structures • Dictionaries • Maintained in central repository • Supplied from central database to labs • Read-only in satellite databases GSI TPC meeting June 2nd

  6. Satellite Database – data structures • Components’ data • Created and updated in satellite databases at labs • Copied to central repository GSI TPC meeting June 2nd

  7. Dictionary wizard • Example of TPC IROC • detector • TPC components • IROC • IROC long term test • IROC planarity measurement GSI TPC meeting June 2nd

  8. Detector Lab has the IROC and OROC data in excel tables GSI TPC meeting June 2nd

  9. electron microscope pictures of wires GSI TPC meeting June 2nd

  10. How to move test data from existing files into a satellite database Jacek Wojcieszukjwojcies@elka.pw.edu.pl Warsaw University of Technology GSI TPC meeting June 2nd

  11. Step by step - parameters Data to transform Parameter1: Component’s user_code =„ HAL25_TEST_UC” Parameter’s name = „WAFERNO” Component’s type name = „SDDAMBRA” Parameter’s valid_from attribute = „2002-10-1023:21:54+00” Parameter’s value = 34 Parameter2: Component’s user_code =„ HAL25_TEST_UC” Parameter’s name = „Location” Component’s type name = „SDDAMBRA” Parameter’s valid_from attribute = „2002-10-1023:21:54+00” Parameter’s valid_to attribute = „2003-02-1023:21:54+00” Parameter’s value = „Int_lab” Result of the transformation <subordinate_table name="PARAMETERS"> <srow> <lookup name="COMPONENT_ID" source_table="COMPONENTS" connect_by="USER_CODE">HAL25_TEST_UC</lookup> <lookup name="PARAMETER_CODE" source_table="DEFINITION_OF_PARAMETERS" connect_by="NAME">WAFERNO</lookup> <lookup name="TYPE_CODE" source_table="COMPONENT_TYPES" connect_by="NAME">SDDAMBRA</lookup> <column name="VALID_FROM"> 2002-10-1023:21:54+00</column> <column name="VALUE">34</column> </srow> <srow> <lookup name="COMPONENT_ID" source_table="COMPONENTS" connect_by="USER_CODE">HAL25_TEST_UC</lookup> <lookup name="PARAMETER_CODE” source_table="DEFINITION_OF_PARAMETERS" connect_by="NAME">Location</lookup> <lookup name="TYPE_CODE" source_table="COMPONENT_TYPES" connect_by="NAME">SDDAMBRA</lookup> <column name="VALID_FROM"> 2002-10-10 23:21:54+00</column> <column name="VALID_TO"> 2003-02-13 23:21:54+00</column> <column name="VALUE">Int_lab</column> </srow> </subordinate_table> GSI TPC meeting June 2nd

  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 GSI TPC meeting June 2nd

  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 GSI TPC meeting June 2nd

  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 GSI TPC meeting June 2nd

  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) GSI TPC meeting June 2nd

  16. From Hades • example GSI TPC meeting June 2nd

  17. GSI TPC meeting June 2nd

  18. GSI TPC meeting June 2nd

  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 GSI TPC meeting June 2nd

  20. TPC - 2 • LSRS laser system • CBL cables and busbars • REE read-out electronics • HLT high level trigger • CLB calibration • SML simulation GSI TPC meeting June 2nd

  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 GSI TPC meeting June 2nd

  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 GSI TPC meeting June 2nd

  23. LSRS back • LSRD laser rods • MMB micro mirror bundle • SPL beam splitters • LSR laser GSI TPC meeting June 2nd

  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 GSI TPC meeting June 2nd

More Related