AtScale, a pioneering leader in data management and analytics, announces a significant breakthrough in Natural Language Processing (NLP). By integrating AtScale’s Semantic Layer and Query Engine with large language models (LLMs), AtScale has set a new standard in Text-to-SQL accuracy, achieving an impressive 92.5% across all combinations of question and schema complexities.
As enterprises generate and store increasing volumes of data, the demand for quick, accurate data analysis has never been higher, outpacing traditional methods reliant on human analysts. AtScale’s integration of Generative AI transforms natural language queries into precise SQL commands, dramatically improving efficiency and decision-making speed. While LLMs excel at generating human-like text, they often struggle with complex database schemas and business logic. AtScale’s Semantic Layer bridges this gap by providing LLMs with comprehensive business-side metadata, eliminating the need to create metrics from scratch or generate complex joins, and significantly enhancing result consistency and accuracy.
“Our integration of AtScale’s Semantic Layer and Query Engine with LLMs marks a significant milestone in NLP and data analytics,” said David Mariani, CTO and Co-Founder of AtScale. “By feeding the LLM with relevant business context, we can achieve a level of accuracy previously unattainable, making Text-to-SQL solutions trusted in everyday business use.”
In rigorous testing, AtScale’s integrated solution outperformed traditional methods by a wide margin. Across a diverse set of 40 business-related questions, the solution achieved a 92.5% accuracy rate, compared to just 20% for systems without the Semantic Layer. These results underscore the system’s capability to handle a wide range of query complexities with superior precision.
Key Benefits of AtScale’s Solution:
- Enhanced Accuracy: Achieves 92.5% accuracy in translating natural language questions into SQL queries.
- Simplified Query Generation: Removes the need for LLMs to generate joins or complex business logic, reducing errors and improving efficiency.
- Business Context Integration: Provides LLMs with essential business metadata, ensuring consistent and accurate results.
AtScale is committed to continuously advancing its AI-driven solutions. The company plans to enhance the integration further by optimizing prompt engineering and expanding training datasets, aiming to tackle even more complex queries with greater precision and efficiency. By doing so, AtScale seeks to empower businesses with increasingly robust and reliable data analysis tools.
You can download the full report here, which includes detailed statistics, charts, and a deeper dive into the analysis.
About AtScale
AtScale enables smarter data-driven decisions by bridging the gap between data and analytics, simplifying and extending BI and data science capabilities. With its Universal Semantic Layer, AtScale empowers enterprises to create business-friendly data models that ensure consistency and accuracy across various BI tools. With over a decade of innovation, AtScale continues to lead the industry, transforming how enterprises utilize and analyze their data. For more information, please visit www.atscale.com and follow us on LinkedIn.
View source version on businesswire.com: https://www.businesswire.com/news/home/20240808651958/en/