Prosiding Seminar Nasional Official Statistics
Vol 2024 No 1 (2024): Seminar Nasional Official Statistics 2024

Pengembangan Aplikasi Chatbot dengan Large Language Model untuk Text-to-SQL Generation

Nugraha, Gede Putra (Unknown)
Suadaa, Lya Hulliyyatus (Unknown)
Wilantika, Nori (Unknown)
Maghfiroh, Lutfi Rahmatuti (Unknown)



Article Info

Publish Date
08 Nov 2024

Abstract

The agricultural census query builder system has two modes: a query builder mode with an interface that facilitates the selection of tables, columns, and query criteria, and an SQL programming mode for executing SQL queries. The system provides a list of queries for basic anomaly checking nationwide, but advanced and unique anomaly checking for each work unit requires writing SQL queries from scratch, which is inefficient. This research developed a chatbot application that translates user queries into SQL queries for data anomaly checking. This chatbot uses the Large Language Model (LLM) GPT-4o. The chatbot application development uses the Rapid Application Development (RAD) model for rapid system development. Black Box Test and System Usability Test with System Usability Scale (SUS) show the results as expected by the user, with an average SUS score of 84.17 which indicates the chatbot application is acceptable.

Copyrights © 2024






Journal Info

Abbrev

semnasoffstat

Publisher

Subject

Humanities Computer Science & IT Economics, Econometrics & Finance Social Sciences

Description

prosiding seminar ini bertujuan untuk menghasilkan berbagai pemikiran solutif, inovatif, dan adaptif terkait isu, strategi, dan metode yang memanfaatkan official ...