Interactive Analysis Case – 04: Understanding Relational Databases and Queries
Enhancing Understanding of SQL Syntax and Relational Databases through ThanoSQL
Introducing ThanoSQL's interactive analysis service.
The interactive analysis service allows AI to take user queries in natural language and provide answers using a database.
In this video, we will look at an example of asking questions about SQL syntax for relational databases using natural language.
The content explained in the video follows the sequence below:
1) As seen in the previous video (Interactive Analysis Case – 01 Customer Service Interaction Analysis, organizing and extracting the necessary information from a recorded customer service interaction database can be done using natural language.
2) But what if you ask a general question about using a database (DB) or SQL queries rather than a question about data analysis? Choose a table and ask about 'JOIN' function of the DB.
3) Once the user enters a question, the LLM will respond based on its knowledge of relational databases learned through training. Interestingly, it explains using the table selected as an example.
As shown in the illustration, it explains the basic SQL syntax, detailed descriptions, and usage based on the table the user chose.
4) ThanoSQL's interactive analysis service can also be used as a learning tool to improve understanding of SQL syntax and relational databases.