1 / 22

Barrel Module Database - Status

Barrel Module Database - Status. Dave Robinson SCT Week December 2003. Status of upload utilities Review of uploading SCTDAQ info Flagging Hybrid re-work Module Quality uploads Module Signoff Uploads Comparison Utility for MacroAssembly Sites. Database Actions by each Cluster.

yvon
Download Presentation

Barrel Module Database - Status

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. Barrel Module Database - Status Dave Robinson SCT Week December 2003 • Status of upload utilities • Review of uploading SCTDAQ info • Flagging Hybrid re-work • Module Quality uploads • Module Signoff Uploads • Comparison Utility for MacroAssembly Sites

  2. Database Actions byeach Cluster Uploads Shipments Receive Sensors Sensor Data Sensor QC Datasheet Send Sensors Baseboard QC Send bmBB ASIC QC Receive Sensors Receive bmBB Datasheet Sensor-Baseboard Assembly Hybrid QC Assembly Send bmSB Receive Hybrid Receive ASICs Datasheet Hybrid Assembly Assembly SCTDAQ Send bmHASIC Datasheet Receive bmHASIC Receive bmSB Assembly SCTDAQ Module Assembly XY Metrology Send bmMODULE Z Metrology Quality Receive bmMODULE SCTDAQ QA Institute Quality Send bmMODULE Receive bmMODULE SCTDAQ Macro Assembly Assembly

  3. Summary of Upload Utilities SCTDAQ Uploader:http://www.hep.phy.cam.ac.uk/~silicon/jSCTDAQ.html All other uploads:http://www.hep.phy.cam.ac.uk/~silicon/jBarrels.html

  4. Uploading SCTDAQ data • Four methods, ordered by increasing convenience: • Directly using java applicationjava DBUpload/uploadSCTDAQ “D:\\sctvar\\results\\” “D:\\sctvar\\uploads\\” “X:\\archivedData\\” “202201702000.*” • From within SCTDAQ (Rint).x DBUpload.cpp(“202201702000.*”); • Via a perl script (wrapper to java application)perl uploadSCTDAQ.pl “202201702000.*” • Add new script to Dave C’s suite of perl scripts:perl StoreTestResults.pl 20220170200022 Module_Reception <runno> <scanno>perl uploadSCTDB.pl 20220170200022 Module_Reception • Special Options: • Serial numbers as regular expressions“202201702000.*” implies 20220170200001 to 20220170200099 • ‘-noupload’ option (upload files processed/created – then your responsibility to upload) • ‘-nogui’ option (generates upload files without being promped by the spreadsheet gui.

  5. How to flag rework in the SCT database • Eg chip replacement: • dis-assembly / re-assemble of hybrid/chip using Geneva web interface • Put replaced chip in third column of datasheet • Re-upload datasheet (if original uploaded)

  6. perl StoreTestResults.pl 20220330200287 Module_Reception <runno> perl MakeWebIndex.pl 20220330200287 Module_Reception perl uploadSCTDB.pl 20220330200287 Module_Reception

  7. New Barrel Database Interface http://www.hep.phy.cam.ac.uk/~silicon/jBarrels.html • New tabs ‘Quality Summary’ and ‘Module Signoff’ • Invoke by ‘java Barrels/gui’

  8. Module Signoff Uploads Uploaded when all QC work is completed, and when the module is ready for assembly on to a barrel. Uploaded once by a senior physicist, after reviewing all data (sctdaq, metrology, etc ) and any other sources of information.

  9. Module Quality Uploads Comments and flags uploaded by the QC institute afterall SCTDAQ tests have been performed by that institute. Module quality information is essential for the physicist who signs off the module (who may not have been involved with the SCTDAQ testing), because SCTDAQ data alone is not enough to be able to make a judgement on the module’s electrical quality. One set of quality data uploaded per QC insitute (but an institute can upload/edit previously uploaded information).

  10. UK-B Module Quality and Signoff • Universities performing QC (QMUL, Cambridge, Birmingham) upload their quality information to the RAL database via web interface on RAL server • All module data, including quality information, available on a module summary webpage • Signoff info entered into RAL database via web interface on RAL server. Script then generates SCT database upload files for signoff and all quality information (from all universities) and uploads them. Non UK-B clusters • Quality information uploaded directly to SCT database viabarrels java application • For module signoff, physicist reviews java module summaryreport (via barrels application) • Signoff info then uploaded directly to SCT database

  11. UK-B Quality and Signoff Handled by web interfaces to RAL local database.

  12. UK-B module Summary page

  13. Uploading/editing Module Quality Info

  14. Uploading Signoff Information

  15. Top of module summary report • Report behaves like a web browser: • clickable links • forward/back buttons

  16. Example of Sensor Test Report

  17. Module Summary Report .. continued

  18. Example of SCTDAQ Characterisation Report

  19. Comparisons Utility for MacroAssembly Sites http://www.hep.phy.cam.ac.uk/~silicon/software/jComparisons.html • Compares reception tests at macroAssembly site withpreviously uploaded data • Easy to use interface for non-experts • Compares: - Noise (enc) from Response Curve Tests - Gain from Response Curve Tests - Noise (enc) from Noise Tests - Occupancy from Noise Tests - Currents at 150V, 350V and 500V - Defect count • Significant deviations highlighted in RED • Agreement highlighted in GREEN

  20. Eg Cambridge as ‘macroAssembly Site’

  21. Old pre-series Electrical module at Oxford

More Related