Configuration Database Lana Abadie, LHCb week, May 25 Part I The - - PowerPoint PPT Presentation

Configuration Database

Lana Abadie, LHCb week, May 25

• The configuration database
• DB Design Methodology (ex: the TFC system)

– TFC dataflow – TFC system : use cases – Entity relation model & Table design

Part I

The configuration database

• Storage of all controllable devices with

– their properties – the links between them – their hierarchy

• The control system can be bootstrapped from the

configuration database.

THOR_00 (TFC) 16*16 TTCtx_X

transmitter(16*14)

TTCocX_Y

• Opt. couplers(1*32)

TTCrxX_Y_W receiver (1*32) SubDet_L0FEX_Y_Z (?*1) SubDet_L1FEX_Y_Z (?*5)

Munin0_X 32*2 DAQ (readout net) ODIN_X Readout s. MuninL0_00 16*16 MuninL1_00 16*16 Throttle set of links TFC set of links DAQ set of links TFC set of links sometimes possible

X ≤16

used 1

X≤16 Y≤14 W≤32

X≤16

TTCrxX_Y receiver (1*32) SubDet can be (VELO, RICH, L0MUON,...) Z<16

TFC DATAFLOW

TFC system : use cases

• List of possible scenarios (2 examples)

– Find all the connection paths between 2 devices – configure the connectivity of the TFC switch

Path concept

Example: I want to know all the possible paths between VELO_L0FE00_00_00 and TFC switch (THOR)

Path :

[(VELO_L0FE00_00_00,0), (TTCrx00_00_00, 0), TFC] → 1st link [(TTCrx00_00_00,0) , (TTCoc00_00,0),TFC] → 2nd link [(TTCoc00_00,0),(TTCtx_00,0),TFC] →3rd link [(TTCtx_00,0),(THOR_00,0)] →4th link

VELO_L0FE00_00_00

TTCrx00_00_00 TTCrx00_00_11 TTCoc00_00 TTCtx_00 T HOR_00

TFC link

Configuring the connectivity of the TFC switch

0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

connection busy

VELO RICH1 ECAL ODIN_05 VELO RICH1 ECAL

Queries to the TFC_PATH table

Queries to the DEVICE table THOR switch

Entity relation model

Device

+Device Name +Device type +Active

Device Type

Device Type Name Nb of input Nb of output 1 N

Table design

Device

+Device Name (pk) +Device type (fk) ref DeviceType(Device_type_ name) + active

Device Type

Device Type Name (pk) Nb of input Nb of output 1 N

• Configuration database & PVSS

– Structure of the Configuration database – Presentation of the DEMO

• Conclusion

Part II

Structure of the Conf.DB

PVSS System PVSS Libraires & Tools

fw_recipes fw_recipes _properties fw_device device tfc_path fw_device_ properties fw_com ponents

PL/SQL scripts

• Conf. DB

DIM SERVER

PART OF THE FRAMEWORK LHCb specific tables

Readout Supervisor 0 Readout Supervisor 2 Readout Supervisor 3

. . .

TFC Switch Readout Supervisor 1 VELO FE ST FE OT FE RICH FE ECAL FE Readout Supervisor 1 VELO FE ST FE OT FE TFC Switch

WILL BE EMULATED BY A TEST BOARD (freja)

Presentation of the demo (1/2)

• Get the connectivity between selected subsystems and TFC switch
• Get a free readout supervisor and update its status

Presentation of the demo (2/2)

• Creation of the different devices (TFC switch,

Readout supervisor...) in PVSS

• Storage in the fw_tables via PVSS framework
• Storage of the connectivity between devices in

LHCb tables

• Links to other existing panels to set up the

configuration

• Connection to the hardware (from the TFC system)

via PVSS and DIM

Conclusion

– Design of TFC and Read Out Network system tables completed – First prototype built to show possible queries to the Configuration database via PVSS

• Future work:

– Design of other subsystem tables (connectivity) – Optimization of performance – Design of a generic API

Thank you for your attention QUESTIONS ?

Extract of the fw_device_properties

How the datapoint called TFC:Odin/ODIN_00 is stored in the Conf.DB ?

One attribute and its value per line are stored