arXiv:2410.07144cs.DBcs.AI2024-10被引 2

用生成式AI把自然语言转成SQL,让普通人也能直接查数据库。

Natural Language Query Engine for Relational Databases using Generative AI

  • 用大模型自动将自然语言转化为语法语义都正确的SQL。
  • 不仅能生成准确查询,还能把结果转成易懂的自然语言回复。
  • 适合没学过SQL的业务人员快速获取数据洞察。

数据驱动决策日益重要,但传统关系型数据库需掌握SQL才能访问,对非技术人员构成障碍。本文提出一种基于生成式AI的新方案,实现自然语言到SQL的自动转换,确保生成的SQL在语法和语义上均正确,并能将查询结果转化为清晰自然的语言回答。该方法简化了用户与数据库的交互流程,使无技术背景的使用者可直接高效地获取数据洞察,推动数据民主化,提升整体工作效率。

原文摘要 · Abstract (English)

The growing reliance on data-driven decision-making highlights the need for more intuitive ways to access and analyze information stored in relational databases. However, the requirement of SQL knowledge has long been a significant barrier for non-technical users. This article introduces an innovative solution that leverages Generative AI to bridge this gap, enabling users to query databases using natural language. Our approach automatically translates natural language queries into SQL, ensuring both syntactic and semantic correctness, while also generating clear, natural language responses from the retrieved data. By streamlining the interaction between users and databases, this method empowers individuals without technical expertise to engage with data directly and efficiently, democratizing access to valuable insights and enhancing productivity.

自然语言查询生成式AI数据库SQL生成

Thank you to arXiv for use of its open access interoperability. PaperDance 不是 arXiv 官方产品;中文卡片由大模型生成,请以原文为准。