Impact of SQL-Driven Financial Data Pipelines on Audit-Readiness and Reporting Cycles in State Government Accounting
International Journal of Scientific Interdisciplinary Research · 01.06.2024 · 05 (02) · 720-745
DOI: 10.63125/cdaatq74 ↗Kurz gefasst
Fachartikel in der Zeitschrift International Journal of Scientific Interdisciplinary Research, online erschienen am 01.06.2024. Verfasst von S M Arif Al Sany.
Abstract (Originalsprache)
This study investigated the impact of SQL-driven financial data pipelines on audit-readiness and reporting-cycle performance in state government accounting through a comprehensive quantitative meta-analysis of 74 empirical studies comprising a cumulative sample of approximately 19,820 organizational observations. The research was grounded in information processing theory, internal control frameworks, and data governance perspectives, aiming to quantify the relationship between structured query language (SQL) based data integration and key public-sector accountability indicators, including audit-readiness, reporting timeliness, reconciliation efficiency, and financial data accuracy. The findings revealed a strong and statistically significant positive relationship, with a pooled effect size of r = 0.59 (p < 0.001), indicating that SQL-driven pipelines substantially enhanced audit-readiness and reporting performance across government accounting environments. Specifically, audit-readiness improved by an average of 22.6%, while reporting-cycle time was reduced by 27.9%, demonstrating notable gains in administrative efficiency. Automated reconciliation processes contributed further by reducing reconciliation time by 31.2%, supporting faster financial close cycles. Subgroup analyses indicated that the strength of this relationship varied across contexts, with higher effect sizes observed in state treasury and finance functions (r = 0.66) and tax and revenue agencies (r = 0.63), as well as in large agencies (r = 0.64) compared to smaller entities. Differences in information technology maturity showed stronger effects in high-maturity agencies (r = 0.65) relative to low-maturity agencies (r = 0.53), reflecting differences in digital infrastructure readiness. Moderating factors such as data quality (r = 0.63), schema standardization (r = 0.65), and extract-transform-load (ETL) automation (r = 0.62) were found to significantly enhance audit-readiness outcomes. Heterogeneity analysis indicated moderate variability (I² = 41.3%), while publication bias tests confirmed the robustness of the results. Overall, the study demonstrated that SQL-driven financial data pipelines are critical enablers of accurate, timely, and auditable financial reporting in state government accounting, providing strong empirical support for their adoption across diverse public-sector contexts.
Zitieren
APA
Sany, S. M. A. A. (2024). Impact of SQL-Driven Financial Data Pipelines on Audit-Readiness and Reporting Cycles in State Government Accounting. International Journal of Scientific Interdisciplinary Research, 05(02), 720-745. https://doi.org/10.63125/cdaatq74
Vancouver
Sany SMAA. Impact of SQL-Driven Financial Data Pipelines on Audit-Readiness and Reporting Cycles in State Government Accounting. International Journal of Scientific Interdisciplinary Research. 2024;05(02):720-745. doi:10.63125/cdaatq74
BibTeX
@article{Sany2024,
author = {Sany, S M Arif Al},
title = {Impact of SQL-Driven Financial Data Pipelines on Audit-Readiness and Reporting Cycles in State Government Accounting},
journal = {International Journal of Scientific Interdisciplinary Research},
year = {2024},
volume = {05},
number = {02},
pages = {720--745},
doi = {10.63125/cdaatq74}
}
EUVIMED