Barrel Module Database - Status
Download
1 / 22

Barrel Module Database - Status - PowerPoint PPT Presentation


  • 126 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Barrel Module Database - Status' - yvon


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

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

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

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

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

Handled by web interfaces to RAL local database.





Top of module summary report <runno>

  • Report behaves like a web browser:

  • clickable links

  • forward/back buttons





Comparisons Utility for MacroAssembly Sites <runno>

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




ad