Barrel Module Database Status

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 Uploaderhttp//www.hep.phy.cam.ac.uk/sil
icon/jSCTDAQ.html All other uploadshttp//www.he
p.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(2022017
  02000.)
• Via a perl script (wrapper to java
  application)perl uploadSCTDAQ.pl
  202201702000.
• Add new script to Dave Cs suite of perl
  scriptsperl StoreTestResults.pl 20220170200022
  Module_Reception ltrunnogt ltscannogtperl
  uploadSCTDB.pl 20220170200022 Module_Reception

• Special Options
• Serial numbers as regular expressions2022017020
  00. 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 ltrunnogt 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.htm
l

• 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
modules 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
(No Transcript)
20
Comparisons Utility for MacroAssembly Sites
http//www.hep.phy.cam.ac.uk/silicon/software/jCo
mparisons.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

21
Eg Cambridge as macroAssembly Site
22
Old pre-series Electrical module at Oxford