View in EDS

AI-orchestrated SQL optimization engines for high-volume financial reconciliation workflows.

Saved in:
Bibliographic Details
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
FullText Text:
  Availability: 0
Header DbId: egs
DbLabel: Engineering Source
An: 194222344
AccessLevel: 6
PubType: Academic Journal
PubTypeId: academicJournal
PreciseRelevancyScore: 0
IllustrationInfo
Items – Name: Title
  Label: Title
  Group: Ti
  Data: AI-orchestrated SQL optimization engines for high-volume financial reconciliation workflows.
– Name: Author
  Label: Authors
  Group: Au
  Data: <searchLink fieldCode="AR" term="%22Keshireddy%2C+Srikanth+Reddy%22">Keshireddy, Srikanth Reddy</searchLink><relatesTo>1</relatesTo> (AUTHOR)<i> sreek.278@gmail.com</i><br /><searchLink fieldCode="AR" term="%22Jamithireddy%2C+Nagendra+Harish%22">Jamithireddy, Nagendra Harish</searchLink><relatesTo>2</relatesTo> (AUTHOR)<br /><searchLink fieldCode="AR" term="%22Jamithireddy%2C+Naren+Swamy%22">Jamithireddy, Naren Swamy</searchLink><relatesTo>2</relatesTo> (AUTHOR)<br /><searchLink fieldCode="AR" term="%22Sappa%2C+Ankita%22">Sappa, Ankita</searchLink><relatesTo>3</relatesTo> (AUTHOR)
– Name: TitleSource
  Label: Source
  Group: Src
  Data: <searchLink fieldCode="JN" term="%22African+Journal+of+Science%2C+Technology%2C+Innovation+%26+Development%22">African Journal of Science, Technology, Innovation & Development</searchLink>. Jun2026, Vol. 18 Issue 3, p362-380. 19p.
– Name: Subject
  Label: Subjects
  Group: Su
  Data: <searchLink fieldCode="DE" term="%22Machine+learning%22">Machine learning</searchLink><br /><searchLink fieldCode="DE" term="%22Transaction+systems+%28Computer+systems%29%22">Transaction systems (Computer systems)</searchLink><br /><searchLink fieldCode="DE" term="%22Real-time+computing%22">Real-time computing</searchLink><br /><searchLink fieldCode="DE" term="%22Computer+performance%22">Computer performance</searchLink><br /><searchLink fieldCode="DE" term="%22Load+balancing+%28Computer+networks%29%22">Load balancing (Computer networks)</searchLink><br /><searchLink fieldCode="DE" term="%22Workflow+management%22">Workflow management</searchLink>
– Name: Abstract
  Label: Abstract
  Group: Ab
  Data: 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]
– Name: AbstractSuppliedCopyright
  Label:
  Group: Ab
  Data: <i>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.</i> (Copyright applies to all Abstracts.)
PLink https://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=egs&AN=194222344
RecordInfo BibRecord:
  BibEntity:
    Identifiers:
      – Type: doi
        Value: 10.1080/20421338.2026.2659624
    Languages:
      – Code: eng
        Text: English
    PhysicalDescription:
      Pagination:
        PageCount: 19
        StartPage: 362
    Subjects:
      – SubjectFull: Machine learning
        Type: general
      – SubjectFull: Transaction systems (Computer systems)
        Type: general
      – SubjectFull: Real-time computing
        Type: general
      – SubjectFull: Computer performance
        Type: general
      – SubjectFull: Load balancing (Computer networks)
        Type: general
      – SubjectFull: Workflow management
        Type: general
    Titles:
      – TitleFull: AI-orchestrated SQL optimization engines for high-volume financial reconciliation workflows.
        Type: main
  BibRelationships:
    HasContributorRelationships:
      – PersonEntity:
          Name:
            NameFull: Keshireddy, Srikanth Reddy
      – PersonEntity:
          Name:
            NameFull: Jamithireddy, Nagendra Harish
      – PersonEntity:
          Name:
            NameFull: Jamithireddy, Naren Swamy
      – PersonEntity:
          Name:
            NameFull: Sappa, Ankita
    IsPartOfRelationships:
      – BibEntity:
          Dates:
            – D: 01
              M: 06
              Text: Jun2026
              Type: published
              Y: 2026
          Identifiers:
            – Type: issn-print
              Value: 20421338
          Numbering:
            – Type: volume
              Value: 18
            – Type: issue
              Value: 3
          Titles:
            – TitleFull: African Journal of Science, Technology, Innovation & Development
              Type: main
ResultId 1