With over 30 years of experience supporting utility and energy companies across North America, VertexOne has cemented its position as a leader in cloud-based SaaS software. Their suite of tools focuses on billing, customer service, customer engagement, and streamlining business processes, empowering clients to achieve digital transformation and operational efficiency.
.jpg)
The utilities sector is unlike any other. Companies in this space—responsible for delivering essential services such as electricity, natural gas, water, and sewage—must process and manage massive volumes of data. Accessing this information quickly and accurately is crucial for both day-to-day operations and customer satisfaction.While VertexOne has consistently helped its clients reduce operational costs and enhance self-service options, one critical challenge persisted: navigating and querying complex datasets efficiently. Their Customer Information System (CIS)—a centralized platform designed to simplify customer management—contained over thousands of interconnected tables, creating a formidable barrier for users seeking specific insights.For non-technical users, this challenge was even more daunting. Extracting meaningful data required advanced SQL knowledge, a skillset most business users lacked. This reliance on technical teams led to bottlenecks, slowing decision-making and reducing overall efficiency.
Complex Database
The scale and intricacy of client databases made it nearly impossible for users to intuitively locate and analyze data. With over 1,500 tables, navigating the schema required deep expertise in SQL and database structures.
Non-Technical User Base
Many of VertexOne’s users lacked the technical background to write SQL queries, making them reliant on database administrators or IT teams for every request.
Size and Complexity
The database's size compounded the problem, making it difficult to design a system that could accurately interpret natural language queries and translate them into SQL reliably.Recognizing the need for a scalable, user-friendly solution, VertexOne partnered with us to change how their users access and analyze data.
We developed a Text-to-SQL system powered by Large Language Models (LLMs) to address these challenges. This solution allowed users to interact with their data using plain English, eliminating the need for SQL knowledge.
1. Natural Language Query Input
Users input questions or commands in plain English. For instance, “What were the top 10 customer complaints in the last quarter?”
2. Schema Understanding
The system processes the database schema, including table names, column descriptions, and relationships, ensuring the LLM has full context.
3. Query Translation
Using a fine-tuned LLM, the system translates the natural language input into an accurate SQL query.
4. Query Validation
To ensure accuracy and security, the generated SQL is validated before execution.he validated SQL query is executed, and results are presented in user-friendly formats, such as tables or visualizations.
5.Execution and Visualization
The validated SQL query is executed, and results are presented in user-friendly formats, such as tables or visualizations.
Scalability:
The LLM adapts to growing datasets and schema complexity, ensuring consistent performance as the database expands.
Accuracy:
Fine-tuning the LLM on domain-specific data ensures it understands user intent and delivers precise results.
Ease of Use:
By removing the technical barrier, the system empowers all users, regardless of SQL expertise.
The implementation of the Text-to-SQL system has been transformative for VertexOne:
Improved Accessibility
Users can now interact with the database directly, reducing reliance on technical teams. This has resulted in 70% faster response times for data-related requests.
Faster Insights
Real-time SQL generation has improved decision-making speed by an impressive 87%.
Scalability
The solution seamlessly handles large schemas, adapting to data growth without compromising performance.
High Accuracy
The system boasts over 90% accuracy in SQL generation, ensuring reliable data retrieval for informed decision-making.
At Aidetic, we've been at the forefront of AI solutions since 2018—pioneering advancements five years ahead in terms of team expertise and solution excellence.
