LLM-Driven Decision Automation: Integrating SQL and Java APIs through Multi-Step Reasoning Pipelines

Sriram Ghanta

International Journal of Scientific Research in Computer Science, Engineering and Information Technology, 2024, vol. 10, issue 6, 2688-2702

Abstract: The rapid evolution of Large Language Models (LLMs) has enabled new paradigms in intelligent decision automation by transforming how systems interpret, reason over, and act upon both structured and unstructured data. By integrating LLM chains with structured data systems such as SQL databases and enterprise-grade Java APIs, organizations can automate complex decision-making workflows that traditionally required human intervention, domain expertise, and manual rule configuration. These integrations allow LLMs to not only generate context-aware queries but also execute business logic through API orchestration, effectively bridging the gap between natural language understanding and operational systems. This paper proposes a unified architecture that combines prompt chaining, retrieval-augmented generation (RAG), and programmatic API orchestration to enable scalable and reliable decision automation across heterogeneous enterprise environments. By leveraging iterative reasoning, contextual grounding, and feedback-driven refinement, the approach enhances accuracy, reduces hallucination, and improves explainability in automated decisions. The study synthesizes recent advancements in text-to-SQL systems, LLM orchestration frameworks, and API-driven enterprise systems, demonstrating how multi-step reasoning pipelines can be operationalized in real-world environments to support use cases such as dynamic reporting, intelligent workflow execution, anomaly detection, and real-time decision support while maintaining robustness, scalability, and enterprise compliance requirements.

Keywords: Large Language Models; Decision Automation; LLM Chains; Text-to-SQL; Retrieval-Augmented Generation (RAG); API Integration; Java APIs; Workflow Automation; Intelligent Systems; Enterprise AI (search for similar items in EconPapers)
Date: 2024
Note: Article URL: https://ijsrcseit.com/home/article/view/CSEIT2410789
References: Add references at CitEc
Citations:

Downloads: (external link)
https://ijsrcseit.com/home/article/view/CSEIT2410789 Article URL (text/html)
https://ijsrcseit.com/home/article/download/CSEIT2410789/CSEIT2410789 Full text (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:jbh:ijsrcs:v10:y2024:i6:id:1925

DOI: 10.32628/CSEIT2410789

Access Statistics for this article

More articles in International Journal of Scientific Research in Computer Science, Engineering and Information Technology from International Journal of Scientific Research in Computer Science, Engineering and Information Technology
Bibliographic data for series maintained by Pankaj Sharma (USA) ().