Map
Identify read-only integration points into IBM DB2 without touching MES schema
Our client operates three silicon fabrication sites in Japan, producing high-precision wafer substrates for advanced electronics under strict quality mandates. Their manufacturing execution system — a mature IBM DB2 MES built up over more than a decade — tracked every lot, sublot, and wafer through every production stage, and could not afford to be touched.
There had been earlier discussions about automation, but the standard answer from the MES team was always the same: any change to the inspection workflow risked disrupting live production. The challenge wasn't a lack of will — it was finding an approach that never touched the MES at all.
The challenge was to give three fab sites a consistent, auditable AI-assisted inspection workflow — without restructuring, or even touching, a mature MES that the whole operation depended on staying stable.
The defining constraint shaped every decision: extend the existing MES, don't replace it. The AI pipeline, staging database, and operator UI needed to sit beside the MES, not inside it, while production kept running.
Identify read-only integration points into IBM DB2 without touching MES schema
Stand up a 5-stage AI pipeline — ETL, SONAR, inference, QC, disposition — beside the MES
Give operators validation rules that make untraceable overrides impossible
Deploy the same codebase safely across three fab sites with isolated data
The MES is read from via existing DB2 views — DOPEHIS, DLOT, DSUBLOT, DWAFER. The AI pipeline, staging database, and operator UI all live alongside it. Production kept running throughout the entire build and deployment.
This wasn't a cost decision — it was a data sovereignty decision. Wafer images and MES lot data are treated as proprietary manufacturing intelligence, and sending them to a cloud inference API was never an option the client would consider.
Role-based access — Operator, QC, Supervisor — means each person only sees the screens relevant to their job. The wafer grid shows 25 slots at a glance with AI results pre-populated: OK, HOLD, or NG.
These guardrails weren't designed to slow operators down — they eliminate the class of errors that produce untraceable quality issues.
Imari2, Kubara1, and Kubara2 all run the same AI model and business rules, with per-site configuration files and enforced data isolation in Oracle — a record from Kubara1 is never visible in the Imari2 queue.
A five-stage pipeline that reads from the existing MES and writes back to it — without ever touching its schema.
A .NET 8 worker polls IBM DB2 on delta checkpoints and stages new lot and wafer records.
.NET 8 worker · DB2 delta pollInspection images are resolved from YDC SONAR XML templates and linked to staged records.
YDC SONAR XML / CSVA YOLOv8 ONNX model runs on an on-prem NVIDIA H100, applying business rules after inference.
YOLOv8 ONNX · CUDA on H100Only lots the AI marks HOLD or NG are surfaced for human review in a role-based UI.
WinForms · Japanese localeEvery decision is logged with user, timestamp, and fab site, exportable per site or date range.
Oracle state machine · Excel export“Operators don’t touch AI or databases — they see lots, wafers, and pictures, and press Approve.” That was the design brief from the start. The complexity lives entirely in the back end.
Atomic Loops project brief
73%
Faster manual review
~45 min per lot to ~12 min per lot
~70%
Lots cleared by AI alone
No operator intervention required
100%
Decisions traceable
User, timestamp, and fab site on every record
0
MES disruption
Production ran uninterrupted through build and rollout
It means building new capability — an AI pipeline, a staging database, an operator UI — that reads from an existing manufacturing execution system through existing views, without changing its schema or workflow, so the MES itself is never at risk.
Wafer images and MES lot data are proprietary manufacturing intelligence under strict information security requirements. On-prem inference keeps that data on the fab network and removes dependency on a third-party uptime guarantee for a production-critical step.
YOLOv8 is an object detection model. Exported to ONNX and run on-prem, it scans wafer images for defect patterns like carrier scratches and flags them for review, pre-screening the majority of lots before any human sees them.
Every decision — AI result, operator override, defect code, timestamp, user ID, and fab site — is logged centrally, giving quality teams a full audit trail regardless of which site a lot came from.
The main risk is disrupting a system the whole operation depends on. Designing the automation as a non-invasive layer that only reads from the MES, rather than modifying it, removes that risk.
The AI clears the majority of lots automatically and surfaces only the ones it flags as HOLD or NG for human review, so operator time is spent on judgment calls rather than routine screening.
ONNX Runtime executes a trained model in a portable format with hardware acceleration — in this case CUDA on an NVIDIA H100 — allowing fast, on-prem inference without a cloud dependency.
By treating the existing MES as a fixed constraint and designing every new component to sit alongside it — validated in a pilot before multi-site rollout, with production running throughout.
© 2026 London School of DIGITAL BUSINESS.
All Rights Reserved