Transcript Status of Barrel Database

Barrel Module Database
Presented at the SCT Barrel PAR
15th May 2003
Dave Robinson, Cambridge
• Introduction
- Database access
- Barrel module data
• User Interfaces
- Examples:
- Uploading ASIC-hybrid assembly data
- Retrieving electrical characterisations
• Upload Status by Barrel Clusters
- Database Actions
- Schedule
• Summary
SCT Database
Overview of Access Channels
http: read/write/update/delete
Web Interface
Java Applications
JDBC: insert
Oracle 9i DB
Sun Ultra SPARC
Master DB
JDBC: read
Geneva University
Barrel Community
Data Uploads
(GUI)
Data Retrieval
And Display
(GUI)
Geneva University:
System maintenance, administration, table development,
web interface, read/write channels.
Barrel Community:
User Interfaces for data upload and retrieval/display.
Links to Database and User Interfaces
• http://wacap.unige.ch:3146/phyprdwww/sctprd/welcome.html
- Main Geneva database website.
Read/write web interface and general database
documentation
The data upload and retrieval/display utilities are
all standalone java applications (graphical user
interfaces) that must be downloaded from the
links below.
They run on Windows, Linux and MacOSX.
• http://www.hep.phy.cam.ac.uk/~silicon/jBarrels.html
- Barrel specific upload utilities – download, installation
instructions and user guide.
(item registration, assemblies, metrology, datasheets,
shipments, profiles)
• http://www.hep.phy.cam.ac.uk/~silicon/jSCTDAQ.html
- SCTDAQ electrical characterisation uploads, used also
for endcap module/hybrid uploads.
Download, installation instructions and user guide.
• http://www.hep.phy.cam.ac.uk/~silicn/jSCTDB.html
- General data retrieval and display GUI for all SCT
components.
Download, installation instructions and user guide.
Barrel Data
ORACLE tables are implemented for the following
data for barrel modules and their components:
• Item status
eg current location, assembly status etc
• Shipments between institutes
eg sender, receiver, date, items etc
• Assembly Information
eg components, positions, assembly dates
• Dis-Assembly Information
eg chip replacements etc
• XY and Z metrology
• Datasheets
- baseboards
- sensor-baseboards
- passive hybrids
- populated hybrids
- modules
• Test Data
- module/hybrid electrical data (SCTDAQ
full electrical characterisations)
- sensor data, eg IVs, defects, depletion etc
- ASIC and ASIC wafer data, eg cap corr
factors etc
Given the module serial number, return its location,
assembly details, shipment history, test history, test
data for the module and any of its components.
Data Upload/Retrieval Utilities
• Standalone GUI applications written in java
• Run on Windows, Linux and MacOSX
• Flexible – upload one item of data or upload
an entire backlog in one go
• Extensive interactions with database before
upload (verification, authorisation etc). Tries to
prevent you making a mistake.
• Upload utilities available for:
-
Item Registration
Shipments (sending and receiving)
Assembly Information
Metrology Data
Datasheets
Electrical (SCTDAQ) test data
Profiles (soon...)
• Data Retrieval/Display available for all the
above plus all module subcomponents
•The utilities do not have direct write access to
the database. Instead they generate one or
many ‘upload files’ and then invoke a Genevasupplied java upload utility to upload them all.
Example 1: Upload ASIC-hybrid assembly
Example 2: Retrieve/Display module SCTDAQ data
Barrel Module Assembly Tree
Module
Sensor-Baseboard
Baseboard
ASIC Hybrid
Passive Hybrid
Sensor
Sensor
Sensor
Sensor
ASIC
ASIC
ASIC
ASIC
ASIC
ASIC
Note: to assemble a device in the
database from its various components,
the serial number of the device and all
the components must be registered
and shipped to the same location.
Eg before an institute can assemble a
hybrid, it must receive a shipment (or
shipments) containing all 12 ASICs and
the unpopulated hybrid.
ASIC
ASIC
ASIC
ASIC
ASIC
ASIC
The institute that assembles ASICs to hybrids maintains an
excel spreadsheet containing all data relevant to the assembly
of that hybrid. Within this spreadsheet is information on which
ASIC is attached at which position.
ASIC labelled by:
“TestSite”-”Lot Number”-”Wafer Number”-”Chip site on wafer”
Eg RAL-Z39992-W05-X8-Y0 or RAL-Z3992-W05-2
The upload application interprets this string and
looks up the appropriate 14-digit serial number
from the database.
User Interface Example:
ASIC to Hybrid Assembly
1. Select the ‘Assemblies’ tab
2. Select which device you wish to
assemble from ‘Sensor-Baseboards’,
‘Hybrids’ or ‘Modules’
3. Confirm institute and cluster (already
set by default according to your
preferences)
4. Click on ‘New...’
5. Enter range of serial numbers
corresponding to the assembled hybrids
All valid assemblies within the serial number
range are listed as a tree.
Valid assemblies are defined as:
• All components registered in database
• All components located at your institute
• Components have not been assembled before
• Excel datasheet(s) present on your file system
Example 2: Retrieving SCTDAQ Data
Data retrieval/display GUI presents data as
spreadsheets, web reports, images, raw data views etc.
Eg Direct comparison in spreadsheet of any test
parameter measured within and between different
institutes
‘Full Data’ button creates a web report
containing all data from that test
‘All Tests’ button creates a web report of all
tests on a module. Will soon be expanded to
include links to non-SCTDAQ data (eg module
metrology, sensor characteristics etc)
Upload Status by Barrel SCT Clusters
Barrel module production started before the
production database became available:
Timetable for database development work
• November 02: ORACLE tables implemented
for SCTDAQ
• December 02: Proposal by barrel community
for serial number conventions
• Feb 03: ORACLE tables implemented for
barrel XY and Z metrology
• Mar 03: Serial number conventions approved
in barrel meeting during SCT week
• May 03: ORACLE tables implemented for
datasheet uploads
• May 03: All necessary tables and upload
utilities now available
Barrel clusters therefore implemented their own
bookkeeping and web reporting utilities during
the first phase of production.
Upload of data backlog and routine database
interactions commence from May 03.
Database Actions by
each Cluster
Uploads
Shipments
Receive Sensors
Sensor QC
Send Sensors
Receive
Hybrid
Datasheet
Baseboard QC
Send bmBB
ASIC QC
Receive
Sensors
Receive
bmBB
Sensor-Baseboard
Assembly
Hybrid QC
Sensor Data
Datasheet
Assembly
Send bmSB
Receive
ASICs
Datasheet
Assembly
SCTDAQ
Hybrid Assembly
Send bmHASIC
Receive
bmHASIC
Receive
bmSB
Module Assembly
Send bmMODULE
Datasheet
Assembly
SCTDAQ
XY Metrology
Z Metrology
Receive bmMODULE
QA Institute
SCTDAQ
Send bmMODULE
Receive bmMODULE
Macro Assembly
SCTDAQ
Assembly
Starting to use the Database:
Steps for each Cluster
• Register all serial numbers
• Upload backlog of all test data so far
(once serial numbers are registered, test data can
be uploaded at any time from any location)
• Establish shipment route to ensure module
assembly information is registered in full
(to assemble a device, the device and all its
components must be located at the same institute,
and this requirement imposes a strict ‘shipment route’
of components around the cluster)
• Establish fixed routine of shipments/uploads
for every institute in cluster
These actions are already underway by the
UK-B cluster.
The database and user interfaces have now been
extensively debugged/exercised using UK-B data.
Summary
• Schedule of database development has meant
that some clusters have a significant backlog of
data. This has not been a problem so far,
because their local bookkeeping/database
systems are web-accessible
• ORACLE tables for SCT barrel module production
are now fully established
• Interfaces to the database are available now
to simplify and automate the upload and retrieval
of data, including the upload of any backlogs.
• UK-B cluster now using the database routinely
with uploads of some data backlogs ~100%
• All other clusters are scheduled to start using the
database routinely from May 03 onwards.
• We are in good shape to start exploiting the
SCT production database