Published 2021 | Version v1
Journal article Open

Hybrid Control Strategies for Efficient Scheduling and Flow Management in ETL Pipelines

Authors/Creators

Description

Efficient coordination of extract, transform and load operations remains a central challenge in modern data environments where heterogeneous workloads, fluctuating input volumes and interdependent processing paths must be executed reliably within constrained operational windows. Traditional scheduling approaches, which rely primarily on static calendars or isolated event triggers, often struggle to accommodate sudden workload shifts, variable resource availability or the dynamic behavior of upstream systems. This study introduces a hybrid control strategy designed to integrate rule-driven scheduling with adaptive flow management mechanisms capable of adjusting execution plans in response to real-time operational conditions. The proposed approach combines deterministic dependency modeling, workload-aware prioritization, constraint-sensitive routing and continuous feedback loops to create a more stable and resilient orchestration layer for large-scale ETL ecosystems. Using a conceptual and analytically grounded evaluation across representative pipeline scenarios, the study demonstrates how hybrid control methods can reduce congestion, mitigate cascading delays, improve resource utilization and enhance operational predictability. The findings contribute a structured framework that unifies classical scheduling principles with adaptive control logic, offering enterprises a scalable method for coordinating complex ETL pipelines while maintaining reliability, throughput and adherence to business-driven processing commitments.

Files

IJSRET_V7_issue3_501.pdf

Files (798.1 kB)

Name Size Download all
md5:d49d472a94428c94db698a1ca2a53677
798.1 kB Preview Download

Additional details