Interactive Analysis Case – 04: Understanding Relational Databases and Queries

smartmind

2024년 8월 29일

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.

▲ 한국어 내레이션

▲ English Narration

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.


ThanoSQL Implementation Inquiry

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.

▲ 한국어 내레이션

▲ English Narration

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.


ThanoSQL Implementation Inquiry

Contact

전화 070 - 7151-9357

서비스 이용약관

개인정보 처리방침

(주)스마트마인드

사업자 등록번호 : 552-81-01061

호스팅 서비스 : 주식회사 스마트마인드 | 정보통신업

06165 서울특별시 강남구 삼성로 104길 17, 3층(삼성동, 대모빌딩)

Contact

전화 070 - 7151-9357

서비스 이용약관

개인정보 처리방침

(주)스마트마인드

사업자 등록번호 : 552-81-01061

호스팅 서비스 : 주식회사 스마트마인드 | 정보통신업

06165 서울특별시 강남구 삼성로 104길 17, 3층(삼성동, 대모빌딩)

Contact

전화 070 - 7151-9357

서비스 이용약관

개인정보 처리방침

(주)스마트마인드

사업자 등록번호 : 552-81-01061

호스팅 서비스 : 주식회사 스마트마인드 | 정보통신업

06165 서울특별시 강남구 삼성로 104길 17, 3층(삼성동, 대모빌딩)