STAVE Production Database Status Report Jiayi Chen Brandeis

STAVE Production Database Status Report Jiayi Chen Brandeis University In collaboration with: Andrew Blue, Jens Dopke , Zach Schillaci, Hannah Herde November 9, 2018 STAVE PD Status Report 1

Outline • STAVE defined in production database (PD) • Assembly stage • Preliminary script developed to automatically assemble MODULEs with STAVE • Test type proposed to record module placement accuracy All-cap (STAVE) for database object; lower case (stave) for real world component Jiayi Chen jennyz@brandeis. edu STAVE PD Status Report 2

Define STAVE in PD STAVE type (during production) Child-components Short Strip or Long Strip Stave core Track STAVE status throughout production Jiayi Chen jennyz@brandeis. edu ITk Production Database - STAVE Status Report 3

Jiayi Chen jennyz@brandeis. edu STAVE PD Status Report 4

Assembly stage Workflow (real-world assembly; interfacing database): 1. 2. 3. 4. Save stave core ID and properties (LS/SS, A/C) locally Register a new STAVE using stave core properties; assemble CORE Assemble modules Remove the bridge and read RFIDs of the modules (we can have a prescription of the order to read them, ex. from position 1 14) and save RFIDs 5. Assemble MODULEs (using its RFID) and upload calibration and survey files 6. Assemble more modules; assemble more MODULEs Assumptions (are they right or wrong? ): • There is no need to register new STAVE during reception stage register STAVE at the assembly stage • There will be no plan for which module to go on which stave at what position or even if there is, there can be human mistake more efficient to assemble MODULEs after real world module assembly Jiayi Chen jennyz@brandeis. edu STAVE PD Status Report 5

Loaded. Stave. py 1. Initiate: ‘python 2. 7 Loaded. Stave. py initiate --directory. /Calibrations/ --positions 8, 9, 10’ (i) register a new STAVE (prompt up will ask for a local name) (ii) (optional) assemble some MODULEs at position 8, 9 and 10 Automatically fill in child-parent properties (iii) set STAVE stage to assembly as the first module is assembled 2. Update: ‘python 2. 7 Loaded. Stave. py update --directory. /Calibrations/ --positions 11, 12, 13’ (i) find the STAVE using local name (ii) assemble more MODULEs at position 11, 12 and 13 Find this STAVE at: https: //uuappg 01. plus 4 u. net/cern-itkpd-test/98234766872260181 dcb 3 f 6 d 1 f 130482581 ba 1 e 7 bbe 34413 c/component. View? code=356 a 296 d 48 b 1 1278 ac 4 d 618564880 c 1 c Jiayi Chen jennyz@brandeis. edu STAVE PD Status Report 6

Loaded. Stave. py Jiayi Chen jennyz@brandeis. edu STAVE PD Status Report 7

Module Survey Summary Test (proposal) Test type for STAVE: Module Survey Summary • a test that summarizes the module placement accuracy for one side of a stave; • passing this test will be the requirement to set STAVE stage to post-assembly Run number indicates the stave side, as this test is associated with one stave side Jiayi Chen jennyz@brandeis. edu STAVE PD Status Report 8

Module Survey Summary Test (proposal 1) Result Name Entry: (array) positions of the modules that are within the 25 -micron tolerance Entries: (string) position#: corner name (how many microns away from ideal position) Find this test at: https: //uuappg 01. plus 4 u. net/cern-itkpd-test/98234766872260181 dcb 3 f 6 d 1 f 130482581 ba 1 e 7 bbe 34413 c/test. Run. View? id=5 bdc 9 e 2 ee 3 bfc 00009 b 99 dc 1 Jiayi Chen jennyz@brandeis. edu STAVE PD Status Report 9

Module Survey Summary Test (proposal 2) • Each MODULE only has one result (not repeated) • Easy to read for viewers, but also easy to retrieve • (Discussion with Gabriella) use all STAVEs’ make histogram on the PD to check/track assembly performance (need to ask database engineer) Find this test at: https: //uuappg 01. plus 4 u. net/cern-itkpd-test/98234766872260181 dcb 3 f 6 d 1 f 130482581 ba 1 e 7 bbe 34413 c/test. Run. View? id=5 be 4 d 2 bde 3 bfc 00009 b 9 a 964 Jiayi Chen jennyz@brandeis. edu ITk Production Database - STAVE Status Report 10

Module Survey Summary Test (proposal) Upload the calibration log Additional comments Jiayi Chen jennyz@brandeis. edu ITk Production Database - STAVE Status Report 11

Summary • defined STAVE in the PD • considered a plausible workflow plan for MODULEs assembly • Preliminary script for assembling MODULEs with STAVE ready • Script might need further optimization, even changes if I made some wrong assumption? • created test type associated with assembly • I can start to work on scripts to upload tests automatically Jiayi Chen jennyz@brandeis. edu STAVE PD Status Report 12

Backup Slides ITk Production Database - STAVE Status Report 13

Loaded. Stave. py 2. Update: ‘python 2. 7 Loaded. Stave. py update --directory. /Calibrations/ --positions 11, 12, 13’ (i) find the STAVE using local name (ii) assemble more MODULEs at position 11, 12 and 13 Jiayi Chen jennyz@brandeis. edu STAVE PD Status Report 14