LLM and Agent-Driven Data Analysis: A Systematic Approach for Enterprise Applications and System-level Deployment
Preprint
Abstract
The rapid progress in Generative AI and Agent technologies is profoundly transforming enterprise data management and analytics. Traditional database applications and system deployment are fundamentally impacted by AI-driven tools, such as Retrieval-Augmented Generation (RAG) and vector database technologies, which provide new pathways for semantic querying over enterprise knowledge bases. In the meantime, data security and compliance are top priorities for organizations adopting AI technologies. For enterprise data analysis, SQL generations powered by large language models (LLMs) and AI agents, has emerged as a key bridge connecting natural language with structured data, effectively lowering the barrier to enterprise data access and improving analytical efficiency. This paper focuses on enterprise data analysis applications and system deployment, covering a range of innovative frameworks, enabling complex query understanding, multi-agent collaboration, security verification, and computational efficiency. Through representative use cases, key challenges related to distributed deployment, data security, and inherent difficulties in SQL generation tasks are discussed.Keywords
All Related Versions
This publication has 18 references indexed in Scilit:
- XiYan-SQL: A Novel Multi-Generator Framework for Text-to-SQLIEEE Transactions on Knowledge and Data Engineering, 2026
- PET-SQL: A Prompt-Enhanced Two-Round Refinement of Text-to-SQL with Cross-Consistency2026
- PaVeRL-SQL: Text–to–SQL via Partial–Match Rewards and Verbal Reinforcement Learning2025
- Talking to Data: Designing Smart Assistants for Humanities Databases2025
- A Survey on Employing Large Language Models for Text-to-SQL TasksACM Computing Surveys, 2025
- Beyond Quacking: Deep Integration of Language Models and RAG into DuckDBProceedings of the VLDB Endowment, 2025
- TableRAG: A Retrieval Augmented Generation Framework for Heterogeneous Document Reasoning2025
- Synthesizing Text-to-SQL Data from Weak and Strong LLMs2024
- Text-to-SQL Empowered by Large Language Models: A Benchmark EvaluationProceedings of the VLDB Endowment, 2024
- RAT-SQL: Relation-Aware Schema Encoding and Linking for Text-to-SQL Parsers2020