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

Barrel Module Database - Status PowerPoint PPT Presentation


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

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


Barrel module database status

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


Barrel module database status

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


Barrel module database status

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.


Barrel module database status

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)


Barrel module database status

perl StoreTestResults.pl 20220330200287 Module_Reception <runno>

perl MakeWebIndex.pl 20220330200287 Module_Reception

perl uploadSCTDB.pl 20220330200287 Module_Reception


Barrel module database status

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’


Barrel module database status

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.


Barrel module database status

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


Barrel module database status

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


Barrel module database status

UK-B Quality and Signoff

Handled by web interfaces to RAL local database.


Barrel module database status

UK-B module Summary page


Barrel module database status

Uploading/editing Module Quality Info


Barrel module database status

Uploading Signoff Information


Barrel module database status

Top of module summary report

  • Report behaves like a web browser:

  • clickable links

  • forward/back buttons


Barrel module database status

Example of Sensor Test Report


Barrel module database status

Module Summary Report .. continued


Barrel module database status

Example of SCTDAQ Characterisation Report


Barrel module database status

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


Barrel module database status

Eg Cambridge as ‘macroAssembly Site’


Barrel module database status

Old pre-series Electrical module at Oxford


  • Login