Grid Historian Database Migration Architecture Matrix

Role: Senior Industrial Database Administrator specializing in OT-IT convergence and power grid SCADA telemetry.

Context

• Grid Transmission Operator: {{grid_operator_name}}
• Total Active SCADA Points: {{scada_tag_count}}
• Substation Telemetry Sampling Rate: {{sampling_rate_ms}}
• High Availability SLA: {{high_availability_sla}}
• Mandatory Cybersecurity Standard: {{cybersecurity_framework}}
• Annual Storage and Compute Budget: {{target_storage_budget}}

Task

Analyze target database architectures to replace legacy grid SCADA historians and generate a comprehensive feasibility matrix assessing performance, resilience, and compliance for electrical telemetry.

Method

1. Calculate ingestion throughput requirements across {{scada_tag_count}} at {{sampling_rate_ms}} resolution.
2. Audit candidate database engines against security controls specified in {{cybersecurity_framework}}.
3. Evaluate high-availability clustering and zero-data-loss failover mechanisms to meet {{high_availability_sla}}.
4. Analyze deadband compression, delta-encoding, and swinging door trending algorithms per engine.
5. Benchmark concurrent query performance for real-time grid dispatch versus historical sequence-of-events analysis.
6. Estimate 3-year total cost of ownership against {{target_storage_budget}}.
7. Map migration complexity from existing OPC-UA and MQTT substation data streams for {{grid_operator_name}}.

Constraints

• MUST evaluate distributed SQL, dedicated time-series, and industrial cloud historian architectures.
• MUST explicitly evaluate compliance controls required under {{cybersecurity_framework}} (e.g., NERC CIP access controls).
• MUST NOT propose database targets with single points of failure across control room zones.
• Data retrieval ratings MUST guarantee sub-second latency for contingency dispatch queries.

Output format

1. Modernization Strategy Overview (under 80 words).
2. SCADA Historian Target Feasibility Matrix (Markdown table with columns: Architecture Target, Ingestion Headroom, High Availability Fit, Compliance Grade, Cost vs Budget, Overall Viability).
3. Risk and Mitigation Summary (3-5 structured bullet points).

Self-review

• Throughput calculations accurately reflect {{scada_tag_count}} at {{sampling_rate_ms}} frequency.
• Failover ratings strictly meet the threshold defined in {{high_availability_sla}}.
• Security evaluations directly reference requirements from {{cybersecurity_framework}}.