A Dual-Mode AI Chatbot (RAG and SQL Agent) for a Microservice-based Supermarket System

Các tác giả

  • Duy Lê Hữu
  • Khôi Nguyễn Hoàng
  • Trung Trần Thế Industrial University of HCMC

Từ khóa:

Microservices, Spring Boot, Spring Cloud, ReactJS, React Native, Smart Retail, AI Chatbot, SQL Agent, RAG

Tóm tắt

In the current context of digital transformation and the modern retail industry, applying information technology to business management has become essential. This paper proposes a multi-platform smart supermarket sales system using a Microservices architecture. Each business domain is encapsulated in a separate service, communicating via HTTP REST, routed through an API Gateway, and using Eureka for service discovery. The system is built on Spring Boot 3.x, Spring Cloud 202x, and Spring Data JPA with MariaDB. It integrates Spring Security with JWT for authentication, OpenFeign for REST client communication, and AWS S3 for file storage. The system also features an intelligent AI chatbot assistant, developed with Python (FastAPI) and LangChain, which plays a key role. It communicates via WebSocket, leverages a dual-mode architecture (RAG and SQL Agent) to access real-time business data, and provides a highly personalized experience.

Đã Xuất bản

09-12-2025

Số

Chuyên mục

Kỹ thuật phần mềm (Software Engineering)