AI-orchestrated SQL optimization engines for high-volume financial reconciliation workflows.
Saved in:
| Title: | AI-orchestrated SQL optimization engines for high-volume financial reconciliation workflows. |
|---|---|
| Authors: | Keshireddy, Srikanth Reddy1 (AUTHOR) sreek.278@gmail.com, Jamithireddy, Nagendra Harish2 (AUTHOR), Jamithireddy, Naren Swamy2 (AUTHOR), Sappa, Ankita3 (AUTHOR) |
| Source: | African Journal of Science, Technology, Innovation & Development. Jun2026, Vol. 18 Issue 3, p362-380. 19p. |
| Subjects: | Machine learning, Transaction systems (Computer systems), Real-time computing, Computer performance, Load balancing (Computer networks), Workflow management |
| Abstract: | In high-throughput financial reconciliation contexts, traditional SQL engines often face significant challenges performing intricate workload-related transactions due to complex multi-dimensional processing. This study proposes a new SQL optimization strategy which is orchestrated by AI systems with an embedded self-learning algorithm that intelligently restructures the execution paths for specific queries in real time, optimizes the workload partitioning, and increases overall reconciliation throughput. This architecture combines machine learning components with a rule-based profiler to discover inefficiencies in the system and re-query based on the given context and surrounding patterns. Extensive experiments on synthetic and real-world financial datasets showed that the system achieved over a 65% reduction in query response latency. Similar improvements in the CPU, memory consumption, the execution resources used, and efficiency absorbing the active transactional load with precision and accuracy while preserving operational integrity of the process were noted. Other benchmarks using PostgreSQL, Oracle, or SAP HANA all confirmed that the adaptability and flexibility of the system were preserved. These findings show that AI-based orchestration drives automated SQL execution systems for modern architecture of financial infrastructure providing dynamic optimization methods for sophisticated revaluation processes. [ABSTRACT FROM AUTHOR] |
| Copyright of African Journal of Science, Technology, Innovation & Development is the property of Taylor & Francis Ltd and its content may not be copied or emailed to multiple sites without the copyright holder's express written permission. Additionally, content may not be used with any artificial intelligence tools or machine learning technologies. However, users may print, download, or email articles for individual use. This abstract may be abridged. No warranty is given about the accuracy of the copy. Users should refer to the original published version of the material for the full abstract. (Copyright applies to all Abstracts.) | |
| Database: | Engineering Source |
Be the first to leave a comment!
