Transcript No Slide Title

CMS Database Issues
Derek Barge
DOE review, January 20, 2004
CMS Database Issues-Derek Barge
Slide 1
Sensors:
factories
Frames:
Brussels
Pitch adapter: Hybrid:
Brussels
CF carrier
Hybrids:
Strasbourg
CERN
Sensor QAC
Pisa
Module
FNAL UCSB
assembly
Bonding
FNAL UCSB
& testing
Perugia
Wien
Bari
TIB-TID INTEGRATION
Lyon
Wien
Pisa
Louvain
Brussels
PETALS INTEGRATIONAachen
TECassembly
Aachen
TK ASSEMBLY
CERN
Louvain
Strasbourg
Zurich StrasbourgKarlsruheAachen
Brussels Lyon
Pisa
TOB assembly TIB-IDassembly
CERN
Karlsruhe
Wien
Padova Pisa Torino Bari Firenze
Integration ROD INTEGRATION
into
FNAL
UCSB
mechanics
Sub-assemblies
Perugia
Strasbourg Karlsruhe
TECassembly
Karlsruhe
. --> Lyon
Production
Hybrids
Sensors
Overview
• Quick Overview of Production Process:

Hybrids (~2755 TOB – 5 types, 500-2613 TEC – 3 types)
1. Receiving / Visual Inspection / Hybrid Assembly
2. Testing – Bonding – Thermal Testing – Module Assembly

Sensors (5510 TOB – 2 types, 1000-5226 TEC – 4 types)
1. Receiving / Probing (Special)
2. Module Assembly

Modules (~2755 TOB – 6 types, 500-2613 TEC – 3 types)
1. Assembly (using hybrids & sensors)
2. Wire-bonding
3. Testing

Rods ( ~460 - ~24 types)
1. Assembly / Testing / ? / Shipping
DOE review, January 20, 2004
CMS Database
-Derek
Barge Issues-Derek Barge
Slide 3
KeepingHybrids
Sensors
Track of Things
• What Do we need to keep track of?

For Hybrids, Sensors, Modules & Rods, we need to know:
- Where is it? (What Test Center? UCSB, CERN, etc.)
- What Type is it? (Module or Hybrid? TEC or TOB? Single or
Stereo?)
- How is it related to other objects?
- Does it contain any other parts? What are their serial numbers?
- Is it a part in another container? What is the container’s serial number?
- Has it been Wire-bonded? (hybrids & modules only)
- What channels were NOT bonded successfully?
- Has it been tested?
- What channels were faulty and why? Did it Pass or Fail?
- Is it ready for the next production stage?
- History & Shipping (When was it: Made? Bonded? Tested?
Shipped?)
DOE review, January 20, 2004
CMS Database
-Derek
Barge Issues-Derek Barge
Slide 4
Data Hybrids
Sensors
Management
• Need tools to track parts & record information at
different stages of production and centers

System must handle:
~ 13,480+ Total Objects of ~ 46+ types

Requirements
- Must be Reliable
- Must be Adaptable, needs to quickly accommodate changes
- Should be centralized
- Should be Internet based for accessibility
- Must be secure
- Should be easy to use
- Should be as fast as possible

What is the CMS collaboration’s solution?
DOE review, January 20, 2004
CMS Database
-Derek
Barge Issues-Derek Barge
Slide 5
TrackerDB
Hybrids
Sensors
• Oracle (SQL) database for tracking CMS production

Relational Database format, data stored in tables:
- Center
- Bonding Data
- Object Assembly

- Sensor Data (ST, QTC)
- Gantry Assembly Measurements
- History & Shipping
Data is uploaded and stored for later reference
- Uploading of Module Assembly & Wire-bonding data almost fully
automated, Hybrid data will be automated this month

Queries can be written to get data for
- A Specific Part (Example: time history for a particular hybrid)
- All parts meeting certain criteria (Example: all modules at UCSB
that have been assembled and not wire-bonded)
DOE review, January 20, 2004
CMS Database
-Derek
Barge Issues-Derek Barge
Slide 6
DBHybrids
Sensors
Problems
• Although the TrackerDB itself is reliable, and has
the potential to meet our needs,

All the interface tools we need either don’t exist or work
- BigBrowser is slow & can’t track parts through their containers
- Other interfaces track modules only or sensors only
- Interface servers go down (PISA server summer ’03)

Data Problems (being resolved)
- Sensors with incorrect or missing data
- Hybrids received with missing bonding data

Testing Tables not developed
- Hybrid Testing Tables not ready until DEC 2003
- Module testing data structures not sufficient for UCSB
DOE review, January 20, 2004
CMS Database
-Derek
Barge Issues-Derek Barge
Slide 7
Sensors
Solution
Hybrids
Sensors2
• Combine TrackerDB & local UCSB DB

Maximize mileage from Tracker DB, rely on it for:
- Sensor Data (unavoidable)
- Bonding Data (also kept locally)
- Gantry Data (also kept locally)
- Relating Object serial numbers (also kept locally)
- Object Histories & Shipping (unavoidable)

Local UCSB DB System handles TrackerDB shortfalls:
- Hybrid Testing Data (migrating to DB JAN 2004)
- Module Testing Data

UCSB web interface designed to:
- Query TrackerDB & display results
- Interface to local testing data
DOE review, January 20, 2004
CMS Database
-Derek
Barge Issues-Derek Barge
Slide 8
UCSB
UCSB
DB
Interface
Interface
Hybrids
Sensors
Problems
Working
Works
• Currently Relying on UCSB Interface for:

Inventory for Hybrids, Sensors & Modules, can sort by:
- #, Center, Type, Bonding Status, Production Stage (container?)

Sensor Data:
- Position of Faulty Strips (CAC, IDIEL, ISTRIP, RPOLY)
- Depletion Voltage (used to pair sensors for module production)
- Current(Voltage) curve (compared to module I(V) in module testing)



All Hybrid & Module Electrical Testing Data
Tracking incoming & outgoing shipments
Frame inventory (otherwise untracked)
DOE review, January 20, 2004
CMS Database
-Derek
Barge Issues-Derek Barge
Slide 9
UCSB Interface - Main
DOE review, January 20, 2004
CMS Database Issues-Derek Barge
Slide 10
UCSB Sensor Inventory
DOE review, January 20, 2004
CMS Database Issues-Derek Barge
Slide 11
Sensor 30210314308203
DOE review, January 20, 2004
CMS Database Issues-Derek Barge
Slide 12
Processed
Hybrid
Hybrids
Sensors
Results
Hybrids
• What have we done so far?

Hybrids (199 processed so far)
- 160 at UCSB (All wire-bonded)
- 126 TOB_P_4U (52 in modules)
- 7 TOB_P_4D (3 in modules)
- 7 TOB_P_6U (6 in modules)
- 6 TOB_S_4U (0 in modules)
- 8 TOB_S_4D (3 in modules)
- 6 TEC (4 in modules)
- 11 sent to Fermilab for module production
- 16 in module at FERMILAB
- 10 in modules at CERN
- 1 in module at STRASBOURG
- 1 in module in TORINO
DOE review, January 20, 2004
CMS Database
-Derek
Barge Issues-Derek Barge
Slide 13
Automation
Hybrids
Sensors
• Tasks previously done by technicians now done
automatically:

Example: Module Checklist
- Paper Checklist (9 min + / module)
- find what hybrid, near sensor, and far sensor are in the module
- lookup channel faults and I(V) curves for both sensors (PIZA interface)
- manually add sensor I(V) curves
- Automated Checklist ( ~ 2 min )
- Enter Module serial number and wait
• Efficiency improvement of at least 7 min / module,
1.75 hours / day @ 15 modules / day

Accuracy improved, no data entry errors
DOE review, January 20, 2004
CMS Database
-Derek
Barge Issues-Derek Barge
Slide 14
Works
What’s
Hybrids
Sensors
in Progress
Left?
• Still need systems to manage:


Module Thermal Testing Data
Rod Assembly & Testing Data
• Also Distributed to Fermilab


Already using UCSB tools for Module checklist & Sensor
Data
Still need inventory tools
DOE review, January 20, 2004
CMS Database
-Derek
Barge Issues-Derek Barge
Slide 15