Article Per Year (5 Year)
p-Index From 2021 - 2026
0.23
P-Index
This Author published in this journals
All Journal Jurnal Komputer Teknologi Informasi Sistem Komputer (JUKTISI)
Basallamah, Muhammad Alam
Unknown Affiliation
Computer Science & IT Control & Systems Engineering Decision Sciences, Operations Research & Management Education Engineering

Published : 1 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 1 Documents
Search

 1 
A Pengembangan Chatbot Informasi Kesehatan Ibu dan Anak Jawa Barat Berbasis Hybrid RAG dan TextToSQL Basallamah, Muhammad Alam; Riza, Lala Septem; Anisyah, Ani
Jurnal Komputer Teknologi Informasi Sistem Informasi (JUKTISI) Vol. 4 No. 3 (2026): Februari 2026
Publisher : LKP KARYA PRIMA KURSUS

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.62712/juktisi.v4i3.783

Abstract

The high Maternal Mortality Rate and stunting prevalence in West Java hinder the achievement of SDGs. Information accessibility remains a key constraint as data is scattered in narrative formats within Health Profiles and MCH Books. This study develops a hybrid chatbot based on Retrieval-Augmented Generation (RAG) and Text-to-SQL using the Google Gemini Large Language Model. The system integrates hierarchical chunking, intelligent routing, conversational memory, and automatic data visualization to present factual and statistical information precisely. System evaluation demonstrates high performance: Text-to-SQL reached 93.33% execution accuracy and 85% Router accuracy. In the RAG module, testing on 60 questions yielded scores of 0.990 Faithfulness, 0.883 Context Recall, and 0.950 Answer Relevancy. The system achieved a perfect score of 1.000 for out-of-context handling, proving safety from hallucinations. User Acceptance Testing (UAT) recorded a 80% success rate, where the chart feature was rated significant in aiding data understanding. The study concludes that the hybrid approach effectively enhances health insight accessibility for the public and stakeholders, although complex table extraction requires further optimization.
Co-Authors Anisyah, Ani Lala Septem Riza