Graph Maintenance Operations

Merge Operation

When two DTX_IDs represent the same person:

1. Merge detection (probabilistic matcher flags)
2. Human review (if confidence < threshold)
3. Approval workflow
4. Execute: move identifiers, apply merge policies, update segments, record history
5. Mark merged DTX_ID as MERGED (never delete for audit)

Split Operation

When incorrect merge detected (admin-initiated):

1. Select identifiers to split off
2. Generate new DTX_ID
3. Move identifiers, recompute traits, update segments
4. Record in audit log

MSISDN Recycling

Telcos recycle MSISDNs after churn. Detection: no activity for X days + different behavioral patterns + different IMEI.

Resolution: Mark old link INACTIVE, create new DTX_ID, link MSISDN. Old events stay with original DTX_ID.

Confidence Decay

-- Daily job: 1% decay per day after 30 days inactive
UPDATE identity_edges
SET confidence = confidence * POWER(0.99, days_since_last_seen)
WHERE link_type = 'PROBABILISTIC'
  AND days_since_last_seen > 30;

-- Remove below 30% threshold
DELETE FROM identity_edges WHERE confidence < 0.3;