Page 1: Regional Airline Operations Information System – Logical & Physical Architecture

Edge Layer (Airports, OCC, Aircraft EFBs): Dispatch, crew scheduling, maintenance hangars, gate check-in systems, and flight data sources (ACARS, ADS-B, FOQA).

Secure Connectivity: SD-WAN and VPN links unify all airport and flight ops systems through zero-trust authentication and Single Sign-On (SSO).

Cloud Layer (Multi-AZ VPC):

API Gateway & Microservices: Handles scheduling, crew legality, maintenance logs, safety reports, and ticketing modules.

Event Streaming Bus: (Kafka/Kinesis) captures real-time flight, maintenance, and crew status updates.

Operational Data Store (ODS): Caches recent data for instant access by OCC dashboards.

ETL/ELT Pipeline: (Airflow/dbt) transforms data into structured layers for analytics.

Data Lake: Holds raw and curated datasets (telemetry, maintenance logs, weather).

Data Warehouse: (Snowflake/BigQuery) delivers historical KPIs and regulatory reports.

MDM &amp; Governance: Ensures standardized naming, lineage tracking, and audit compliance.

Consumers: Dashboards for on-time performance, safety, and maintenance; predictive analytics; AI-based disruption management; partner data portals.

Security & Resilience: IAM with least-privilege, encryption at rest/in transit, backups and versioning, multi-AZ replication, and disaster recovery region failover.

Diagram