Leveraging Large Language Models for Text-to-SQL with Attention to Data Security
摘要
In today’s data-driven world, efficient access to databases is paramount for various applications across industries. A significant change has been observed in human-computer interaction in the contemporary era of artificial intelligence. The nexus between database administration and natural language processing is where this shift is most noticeable. Existing methods of working with SQL databases require a high degree of technical proficiency, which limits the accessibility of these tools to non-technical users. Key objectives of this study included investigating the utilization of Large Language Models (LLM) to enhance data retrieval from SQL databases, focusing on user-friendly access and robust data security. Leveraging large language models, particularly pre-trained models, this research aimed to develop an end-to-end solution for database access, enabling users to interact with databases through natural language queries. The accuracy level was determined to be 82.6%. This paper focuses on data security in database access, highlighting the protection of sensitive information during retrieval. Experiments with real-world datasets showed improved user experience, query accuracy, and data security, validating the effectiveness of the AI-powered approach. The research findings have implications for various domains, including data management, information retrieval, and cybersecurity, paving the way for more efficient and secure database interaction in the era of big data and LLM.