Year: 2025
Type: article
Abstract: This paper presents an automated ETL (Extract, Transform, Load) framework using SQL, PL/SQL, and Bash scripting to process structured data files and insert them into an Oracle database. The system is enhanced with a critical notification mechanism via SMS alerts using public SMS APIs. The primary focus is on database automation, error logging, and alert integration, providing a lightweight yet scalable solution for ETL operations in academic and real-world settings.
Author: Malarkodi M
Language: English
Subfield: Software
Field: Computer Science
Domain: Physical Sciences
Open Access status: hybrid
OpenAlex ID: W4412667079
