Barrel Module Database - Status
Sponsored Links
This presentation is the property of its rightful owner.
1 / 22

Barrel Module Database - Status PowerPoint PPT Presentation


  • 103 Views
  • Uploaded on
  • Presentation posted in: General

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.

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


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 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


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


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.


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)


perl StoreTestResults.pl 20220330200287 Module_Reception <runno>

perl MakeWebIndex.pl 20220330200287 Module_Reception

perl uploadSCTDB.pl 20220330200287 Module_Reception


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’


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.


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).


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


UK-B Quality and Signoff

Handled by web interfaces to RAL local database.


UK-B module Summary page


Uploading/editing Module Quality Info


Uploading Signoff Information


Top of module summary report

  • Report behaves like a web browser:

  • clickable links

  • forward/back buttons


Example of Sensor Test Report


Module Summary Report .. continued


Example of SCTDAQ Characterisation Report


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


Eg Cambridge as ‘macroAssembly Site’


Old pre-series Electrical module at Oxford


  • Login