LHCb Cables System Author Lucas Vieira lucas vgcern

LHCb Cables System Author: Lucas Vieira <lucas. vg@cern. ch> CERN Supervisor: Gloria Corti <Gloria. Corti@cern. ch> Brazil Supervisor: Carmen Maidantchik <carmen. maidantchik@cern. ch> Requisites: Laurent Roy <laurent. roy@cern. ch> 1

Introduction The problems Handling processes of cables and cable requests Bulk action Data consistency Procedural way to communicate with subdetectors cabling responsible for the upgrade (1) Main users Cable manager 2 Responsible for sub-detectors cabling

Introduction Provided features Cable request workflow (Create, Submit, Accept…) Cable workflow (Installed, To be Removed, Removed…) Advanced search Bulk data edition and label printing Access control with egroups Interaction with Traceability Item id generation for new equipments Also supports the management: Cable Tray (2) Rack and “sub-detector” Provider, cable type and cable function Systems and subsystems 3

Introduction - Technologies (3) New database model Initial data extracted from LHCb Integration database (Traceabillity) 4

Technologies (3) Configurable Search Interfaces Forms Report Configuration 5

Web Interface Overview Main Menu Cable Request and Workflow Cable Tray Cable and Workflow Advanced Search and Bulk Actions System, Provider, Cable Type, Cable Function. . . 6

Web Interface - Cable Request Creation 7

Web Interface - Cable Request Creation Edition Summary History 8

Web Interface - Cable Request & Workflow 9

Cable Request Workflow - Permissions and Notifications Action Can perform the action Who is notified 1 Anyone 2 Anyone => ? ( Creator | Responsible ) 3 Anyone => ? ( Creator | Responsible ) Cable Manager, Responsible 4 Cable Manager, Responsible Creator 5 Cable Manager, Responsible Creator 6 Creator Responsible - sub-detectors responsible have permission for cables that concern only their own subdetector. When a cable request is accepted, corresponding cables are created, at the “To Be Installed” state. 10

Web Interface - Cable & Workflow 11

Cable Workflow - Permissions & Notifications Action Can perform the action Who is notified 1 Cable Manager, Responsible 2 Cable Manager, Responsible 3 Cable Manager, Responsible 4 Cable Manager, Responsible, Creator (? ) Cable Manager, Responsible 5 Cable Manager, Responsible 6 Cable Manager, Responsible, Creator (? ) Cable Manager, Responsible 7 Cable Manager, Responsible, Traceability Responsible 8 Cable Manager, Responsible 9 Cable Manager, Responsible, Traceability Responsible - permission for cables that concern only their own subdetector. 12

Cable Request & Cable Request On request approval, cables are created Cables 13

Web Interface - Cable Properties Permission: Cable Manager, Responsible 14

Web Interface - Cables - Searching, Analysing and Exporting Results 15

Web Interface - Bulk Printing 16

Web Interface - Bulk Edition 17

Users and Permissions Main users Cable manager Responsible for sub-detectors cabling Any LHCb interested person Cable Manager Sub-detector Resp. LHCb User Cable R/W R Cable Request R/W R R Features Search (in general) Cable Tray, System, Provider, Cable Type, Cable Function W - permission for cables/requests that concern only their own subdetector. 18

Conclusions Web Interface Next steps Validation period Cable Request and Workflow Cable Search and Bulk Actions All feedbacks are welcome. From now until November 11 th. Cable Tray System Provider, Cable Type, Cable Function. . . https: //glance. cern. ch/beta/lhcb/cables/ Testing Additional changes To receive Cables System Updates. From November 12 th until 30 th. lhcb-cables-admins@cern. ch Moving to production, December 1 st. 19

References Images ● ● 1, 2 : LHCb Upgrade Electronics, Cabling issues, Laurent Roy. https: //indico. cern. ch/event/538957/contributions/2188597/attachments/1288161/1917098/Electronics_meeting_09 June 2016_Cabling. pdf 3: Atlas Workshop, FENCE, Bruno Lange. https: //glance-stage. cern. ch/stage-newdev/lucas/fencetutorial/documment/brunolange_workshop_atlas_1. pdf Workflow ● ● https: //stweet. wordpress. com/2011/04/09/designing-sequential-workflow-database-for-business-applications/ https: //stweet. wordpress. com/2014/05/23/designing-database-for-complex-workflow-applications/ Hierarchical Database ● ● ● http: //www. agiledata. org/essays/mapping. Objects. html#Map. Hierarchy. To. Table http: //www. sqlteam. com/article/implementing-table-inheritance-in-sql-server https: //blogs. oracle. com/sql/entry/implementing_a_mutually_exclusive_relationship 20