Talk to your data: Enhancing Business Intelligence and Inventory Management with LLM-Driven Semantic Parsing and Text-to-SQL for Database Querying

This paper delves into the potential of Large Language Models (LLMs) in revolutionizing business intelligence and inventory management through semantic parsing and text-to-SQL methodologies. It assesses various LLM models, such as DIN-SQL, DSP, NSQL, GPT, CoPilot, and LLaMa, elucidating their capabilities and contributions. Two critical analyses are presented here. The first compares cutting-edge LLM models using cosine similarity and cost efficiency metrics. The second analysis enhances GPT’s precision through prompt engineerings, like few-shot techniques, and explores frameworks like DIN-SQL, NSQL, and DSP. DIN-SQL substantially boosts accuracy, and NSQL demonstrates potential in specific scenarios. This research underscores the transformative potential of LLM-driven models in business intelligence and inventory management. DIN-SQL, in particular, emerges as a game-changer with the potential to reshape inventory management practices. GPT showcases its versatility through fine-tuning for tasks beyond conventional programming, while CoPilot offers a cost-effective alternative. This study emphasizes the importance of cost-effectiveness in real-world applications, with LLaMa and CoPilot being practical choices. NSQL, with its budget-friendly and semi-accurate solution, holds promise for semantic parsing in growing companies. These insights are a foundation for further innovation, promising unmatched efficiency and competitiveness across industries in the evolving Artificial intelligence landscape.