{"id":"https://openalex.org/W7089550488","doi":"https://doi.org/10.35134/komtekinfo.v12i3.658","title":"Large Language Model Method as a Translator Indonesian Into SQL Language","display_name":"Large Language Model Method as a Translator Indonesian Into SQL Language","publication_year":2025,"publication_date":"2025-09-30","ids":{"openalex":"https://openalex.org/W7089550488","doi":"https://doi.org/10.35134/komtekinfo.v12i3.658"},"language":"en","primary_location":{"id":"doi:10.35134/komtekinfo.v12i3.658","doi":"https://doi.org/10.35134/komtekinfo.v12i3.658","is_oa":true,"landing_page_url":"https://doi.org/10.35134/komtekinfo.v12i3.658","pdf_url":"https://jkomtekinfo.org/ojs/index.php/komtekinfo/article/download/658/261","source":{"id":"https://openalex.org/S4210220810","display_name":"Jurnal KomtekInfo","issn_l":"2356-0010","issn":["2356-0010","2502-8758"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I3020390545","host_organization_name":"Universitas Putra Indonesia \"YPTK\"","host_organization_lineage":["https://openalex.org/I3020390545"],"host_organization_lineage_names":[],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Jurnal KomtekInfo","raw_type":"journal-article"},"volume":null,"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"diamond","oa_url":"https://jkomtekinfo.org/ojs/index.php/komtekinfo/article/download/658/261","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":null,"display_name":"Candra Putra","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I4402554199","display_name":"Universitas Islam Negeri Syekh Ali Hasan Ahmad Addary Padangsidimpuan","ror":"https://ror.org/05a4kwh70","country_code":null,"type":"education","lineage":["https://openalex.org/I4402554199"]}],"countries":[],"is_corresponding":false,"raw_author_name":"Candra Putra","raw_affiliation_strings":["Universitas Islam Negeri Syekh Ali Hasan Ahmad Addary"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Universitas Islam Negeri Syekh Ali Hasan Ahmad Addary","institution_ids":["https://openalex.org/I4402554199"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5069643175","display_name":"Syafri Arlis","orcid":"https://orcid.org/0000-0003-3279-4637","observed_orcids":["https://orcid.org/0000-0003-3279-4637"]},"institutions":[{"id":"https://openalex.org/I3020390545","display_name":"Universitas Putra Indonesia \"YPTK\"","ror":"https://ror.org/04pqmjc38","country_code":"ID","type":"education","lineage":["https://openalex.org/I3020390545"]}],"countries":["ID"],"is_corresponding":false,"raw_author_name":"Syafri Arlis","raw_affiliation_strings":["LPPM Universitas Putra Indonesia YPTK Padang Jl. Raya Lubuk Begalung , Padang , West Sumatera , Indonesia,","Universitas Putra Indonesia YPTK , Padang , 25221 , Indonesia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"LPPM Universitas Putra Indonesia YPTK Padang Jl. Raya Lubuk Begalung , Padang , West Sumatera , Indonesia,","institution_ids":["https://openalex.org/I3020390545"]},{"raw_affiliation_string":"Universitas Putra Indonesia YPTK , Padang , 25221 , Indonesia","institution_ids":["https://openalex.org/I3020390545"]}]},{"author_position":"last","author":{"id":null,"display_name":"Gunadi Widi Nurcahyo","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I3020390545","display_name":"Universitas Putra Indonesia \"YPTK\"","ror":"https://ror.org/04pqmjc38","country_code":"ID","type":"education","lineage":["https://openalex.org/I3020390545"]}],"countries":["ID"],"is_corresponding":false,"raw_author_name":"Gunadi Widi Nurcahyo","raw_affiliation_strings":["Universitas Putra Indonesia YPTK"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Universitas Putra Indonesia YPTK","institution_ids":["https://openalex.org/I3020390545"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":true,"cited_by_count":0,"citation_normalized_percentile":{"value":0.38307415,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"124","last_page":"130"},"is_retracted":false,"is_paratext":false,"is_xpac":true,"primary_topic":{"id":"https://openalex.org/T10181","display_name":"Natural Language Processing Techniques","score":0.7465999722480774,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10181","display_name":"Natural Language Processing Techniques","score":0.7465999722480774,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10028","display_name":"Topic Modeling","score":0.12080000340938568,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.035599999129772186,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/natural-language-to-sql","display_name":"natural language to SQL translation","score":0.8209999799728394},{"id":"https://openalex.org/keywords/large-language-models","display_name":"large language models","score":0.9599999785423279},{"id":"https://openalex.org/keywords/academic-information-system","display_name":"academic information system","score":0.8080000281333923},{"id":"https://openalex.org/keywords/database-query-generation","display_name":"database query generation","score":0.6759999990463257},{"id":"https://openalex.org/keywords/non-technical-users","display_name":"non-technical users","score":0.8980000019073486}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8616999983787537},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.767799973487854},{"id":"https://openalex.org/C195324797","wikidata":"https://www.wikidata.org/wiki/Q33742","display_name":"Natural language","level":2,"score":0.5135999917984009},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.48080000281333923},{"id":"https://openalex.org/C67463725","wikidata":"https://www.wikidata.org/wiki/Q17081452","display_name":"Natural language programming","level":5,"score":0.47530001401901245},{"id":"https://openalex.org/C2779207338","wikidata":"https://www.wikidata.org/wiki/Q9240","display_name":"Indonesian","level":2,"score":0.460999995470047},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.4440999925136566},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.42899999022483826},{"id":"https://openalex.org/C2776650193","wikidata":"https://www.wikidata.org/wiki/Q264661","display_name":"Obstacle","level":2,"score":0.42320001125335693},{"id":"https://openalex.org/C179531526","wikidata":"https://www.wikidata.org/wiki/Q595637","display_name":"Language Integrated Query","level":5,"score":0.42260000109672546},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.41449999809265137},{"id":"https://openalex.org/C2776760102","wikidata":"https://www.wikidata.org/wiki/Q5139990","display_name":"Code (set theory)","level":3,"score":0.4041999876499176},{"id":"https://openalex.org/C129792486","wikidata":"https://www.wikidata.org/wiki/Q1050419","display_name":"Language identification","level":3,"score":0.3928999900817871},{"id":"https://openalex.org/C180198813","wikidata":"https://www.wikidata.org/wiki/Q121182","display_name":"Information system","level":2,"score":0.3727000057697296},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.3695000112056732},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.3538999855518341},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.34299999475479126},{"id":"https://openalex.org/C32977378","wikidata":"https://www.wikidata.org/wiki/Q604737","display_name":"Data control language","level":5,"score":0.32910001277923584},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.3273000121116638},{"id":"https://openalex.org/C195807954","wikidata":"https://www.wikidata.org/wiki/Q1662562","display_name":"Information extraction","level":2,"score":0.3246999979019165},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.32409998774528503},{"id":"https://openalex.org/C100463513","wikidata":"https://www.wikidata.org/wiki/Q5227322","display_name":"Data model (GIS)","level":2,"score":0.3102000057697296},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.29589998722076416},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.2921999990940094},{"id":"https://openalex.org/C2776543384","wikidata":"https://www.wikidata.org/wiki/Q593289","display_name":"Information access","level":2,"score":0.28929999470710754},{"id":"https://openalex.org/C47487241","wikidata":"https://www.wikidata.org/wiki/Q5227230","display_name":"Data access","level":2,"score":0.2874000072479248},{"id":"https://openalex.org/C121017731","wikidata":"https://www.wikidata.org/wiki/Q11661","display_name":"Information technology","level":2,"score":0.28690001368522644},{"id":"https://openalex.org/C192209626","wikidata":"https://www.wikidata.org/wiki/Q190909","display_name":"Focus (optics)","level":2,"score":0.28139999508857727},{"id":"https://openalex.org/C83479923","wikidata":"https://www.wikidata.org/wiki/Q2063748","display_name":"Universal Networking Language","level":4,"score":0.2809000015258789},{"id":"https://openalex.org/C174252522","wikidata":"https://www.wikidata.org/wiki/Q3816772","display_name":"Natural language user interface","level":3,"score":0.26759999990463257}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.35134/komtekinfo.v12i3.658","doi":"https://doi.org/10.35134/komtekinfo.v12i3.658","is_oa":true,"landing_page_url":"https://doi.org/10.35134/komtekinfo.v12i3.658","pdf_url":"https://jkomtekinfo.org/ojs/index.php/komtekinfo/article/download/658/261","source":{"id":"https://openalex.org/S4210220810","display_name":"Jurnal KomtekInfo","issn_l":"2356-0010","issn":["2356-0010","2502-8758"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I3020390545","host_organization_name":"Universitas Putra Indonesia \"YPTK\"","host_organization_lineage":["https://openalex.org/I3020390545"],"host_organization_lineage_names":[],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Jurnal KomtekInfo","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.35134/komtekinfo.v12i3.658","doi":"https://doi.org/10.35134/komtekinfo.v12i3.658","is_oa":true,"landing_page_url":"https://doi.org/10.35134/komtekinfo.v12i3.658","pdf_url":"https://jkomtekinfo.org/ojs/index.php/komtekinfo/article/download/658/261","source":{"id":"https://openalex.org/S4210220810","display_name":"Jurnal KomtekInfo","issn_l":"2356-0010","issn":["2356-0010","2502-8758"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I3020390545","host_organization_name":"Universitas Putra Indonesia \"YPTK\"","host_organization_lineage":["https://openalex.org/I3020390545"],"host_organization_lineage_names":[],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Jurnal KomtekInfo","raw_type":"journal-article"},"sustainable_development_goals":[],"sustainable_development_goals_aurora":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W7089550488.pdf","grobid_xml":"https://content.openalex.org/works/W7089550488.grobid-xml"},"referenced_works_count":0,"referenced_works":[],"related_works":[],"abstract_inverted_index":{"The":[0,140,160,194],"development":[1],"of":[2,10,26,150,156,162,169,220],"information":[3,11,41,78,225],"technology":[4,113,222],"has":[5,227],"encouraged":[6],"the":[7,21,27,35,95,115,146,163,167,183,191,218],"massive":[8],"implementation":[9],"systems":[12,226],"and":[13,110,236,241],"web-based":[14],"applications":[15],"in":[16,20,37,105,137,175,223,230],"various":[17],"sectors,":[18],"including":[19],"academic":[22,77,224],"environment.":[23],"However,":[24],"one":[25],"challenges":[28],"that":[29,127,197,217],"are":[30],"still":[31],"often":[32],"faced":[33],"is":[34,84,122,165,179],"difficulty":[36],"extracting":[38],"or":[39,52,69],"mining":[40],"from":[42,76,211],"databases":[43,133],"flexibly":[44],"without":[45,94],"having":[46],"to":[47,86,97,130,189,202,213],"create":[48],"additional":[49,99],"report":[50],"modules":[51],"write":[53],"SQL":[54,91,187],"code":[55],"manually.":[56],"This":[57,215],"problem":[58],"becomes":[59],"an":[60],"obstacle":[61],"for":[62,245],"non-technical":[63],"users,":[64],"such":[65],"as":[66],"administrative":[67],"staff":[68],"lecturers,":[70],"who":[71,247],"need":[72,96],"certain":[73],"data":[74,232],"quickly":[75],"systems.":[79],"In":[80],"this":[81,198],"paper,":[82],"it":[83],"intended":[85],"convert":[87],"Indonesian":[88,176],"commands":[89,136],"into":[90,185],"queries":[92],"automatically,":[93],"add":[98],"programming":[100],"code.":[101],"Along":[102],"with":[103,114,132,205],"advances":[104],"Natural":[106],"Language":[107,117,172],"Processing":[108],"(NLP)":[109],"Machine":[111],"Learning":[112],"Large":[116],"Model":[118],"(LLM)":[119],"method,":[120],"there":[121],"now":[123],"a":[124,154,186,206,251],"new":[125],"approach":[126,199],"allows":[128],"users":[129,246],"interact":[131],"only":[134],"through":[135],"natural":[138],"language.":[139],"case":[141],"study":[142],"was":[143,200],"conducted":[144],"on":[145,166],"Academic":[147],"Information":[148],"System":[149],"UIN":[151],"Padangsidimpuan":[152],"using":[153],"dataset":[155],"1,500":[157],"student":[158],"data.":[159,193],"focus":[161],"research":[164],"type":[168],"Data":[170],"Query":[171],"(DQL)":[173],"query":[174],"form,":[177],"which":[178],"then":[180],"translated":[181],"by":[182],"model":[184],"command":[188],"obtain":[190],"desired":[192],"results":[195,204],"showed":[196],"able":[201],"achieve":[203],"Rouge1":[207],"conversion":[208],"precision":[209],"rate":[210],"0.03":[212],"0.89.":[214],"shows":[216],"integration":[219],"LLM":[221],"great":[228],"potential":[229],"improving":[231],"accessibility,":[233],"operational":[234],"efficiency,":[235],"supporting":[237],"data-driven":[238],"decision-making":[239],"faster":[240],"more":[242],"intuitively,":[243],"especially":[244],"do":[248],"not":[249],"have":[250],"technical":[252],"background.":[253]},"counts_by_year":[],"updated_date":"2026-10-12T09:40:04.860316","created_date":"2025-10-13T00:00:00"}