| # | Requirement | Description | |---|-------------|-------------| | F1 | raw 4K files from both on‑premises SMB shares and Azure Blob storage. | | F2 | Extract technical metadata (resolution, frame‑rate, audio channels, etc.) using FFmpeg. | | F3 | Validate files against a business rule set (e.g., max bitrate ≤ 80 Mbps, HDR flag present). | | F4 | Load enriched metadata into a star schema (Fact_Video, Dim_Genre, Dim_Production, Dim_Date). | | F5 | Track lineage and processing status for each asset. | | N1 | Performance – process ≥ 10 GB/hr per VM instance. | | N2 | Scalability – pipeline can be horizontally scaled across multiple SSIS agents. | | N3 | Reliability – automatic retry on transient storage errors, with idempotent loads. | | N4 | Observability – dashboards showing throughput, error rates, and storage usage. |
In a media production environment, there might be a need to integrate data from various sources, such as video files, associated metadata (like resolution, frame rate, etc.), and other related data (like production notes, timestamps, etc.). SSIS could be used to automate the process of integrating this data. ssis448 4k work
or academic performance monitoring often used in educational and clinical settings. | | F4 | Load enriched metadata into
4K work generates massive files.