{"id":"https://openalex.org/W4409635530","doi":"https://doi.org/10.31602/tji.v16i2.18624","title":"EFEKTIVITAS INDEKS DALAM MENINGKATKAN PERFORMA QUERY JOIN DI SISTEM BASIS DATA RELASIONAL","display_name":"EFEKTIVITAS INDEKS DALAM MENINGKATKAN PERFORMA QUERY JOIN DI SISTEM BASIS DATA RELASIONAL","publication_year":2025,"publication_date":"2025-04-15","ids":{"openalex":"https://openalex.org/W4409635530","doi":"https://doi.org/10.31602/tji.v16i2.18624"},"language":"id","primary_location":{"id":"doi:10.31602/tji.v16i2.18624","doi":"https://doi.org/10.31602/tji.v16i2.18624","is_oa":true,"landing_page_url":"https://doi.org/10.31602/tji.v16i2.18624","pdf_url":"https://ojs.uniska-bjm.ac.id/index.php/JIT/article/download/18624/7417","source":{"id":"https://openalex.org/S4210183553","display_name":"Technologia Jurnal Ilmiah","issn_l":"2086-6917","issn":["2086-6917","2656-8047"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I4210144356","host_organization_name":"Universitas Islam Kalimantan Muhammad Arsyad Al Banjary","host_organization_lineage":["https://openalex.org/I4210144356"],"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":"Technologia : Jurnal Ilmiah","raw_type":"journal-article"},"volume":null,"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://ojs.uniska-bjm.ac.id/index.php/JIT/article/download/18624/7417","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5036286279","display_name":"Muhammad Rais Wathani","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I4210144356","display_name":"Universitas Islam Kalimantan Muhammad Arsyad Al Banjary","ror":"https://ror.org/04r30sv87","country_code":"ID","type":"education","lineage":["https://openalex.org/I4210144356"]}],"countries":["ID"],"is_corresponding":false,"raw_author_name":"Muhammad Rais Wathani","raw_affiliation_strings":["Universitas Islam Kalimantan Muhammad Arsyad Al Banjari (UNISKA MAB)"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Universitas Islam Kalimantan Muhammad Arsyad Al Banjari (UNISKA MAB)","institution_ids":["https://openalex.org/I4210144356"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5109405546","display_name":"Eka Setya Wijaya","orcid":"https://orcid.org/0000-0002-6895-7154","observed_orcids":["https://orcid.org/0000-0002-6895-7154"]},"institutions":[{"id":"https://openalex.org/I42264441","display_name":"Lambung Mangkurat University","ror":"https://ror.org/01khn0w07","country_code":"ID","type":"education","lineage":["https://openalex.org/I42264441"]}],"countries":["ID"],"is_corresponding":false,"raw_author_name":"Eka Setya Wijaya","raw_affiliation_strings":["Universitas Lambung Mangkurat"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Universitas Lambung Mangkurat","institution_ids":["https://openalex.org/I42264441"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5036707756","display_name":"Zaenuddin Zaenuddin","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I4210144356","display_name":"Universitas Islam Kalimantan Muhammad Arsyad Al Banjary","ror":"https://ror.org/04r30sv87","country_code":"ID","type":"education","lineage":["https://openalex.org/I4210144356"]}],"countries":["ID"],"is_corresponding":false,"raw_author_name":"Zaenuddin Zaenuddin","raw_affiliation_strings":["Universitas Islam Kalimantan Muhammad Arsyad Al Banjari (UNISKA MAB)"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Universitas Islam Kalimantan Muhammad Arsyad Al Banjari (UNISKA MAB)","institution_ids":["https://openalex.org/I4210144356"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5021632869","display_name":"Muhammad Zainal Abidin","orcid":"https://orcid.org/0009-0006-9765-7755","observed_orcids":["https://orcid.org/0009-0006-9765-7755"]},"institutions":[{"id":"https://openalex.org/I42264441","display_name":"Lambung Mangkurat University","ror":"https://ror.org/01khn0w07","country_code":"ID","type":"education","lineage":["https://openalex.org/I42264441"]}],"countries":["ID"],"is_corresponding":false,"raw_author_name":"Muhammad Zainal Abidin","raw_affiliation_strings":["Universitas Lambung Mangkurat"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Universitas Lambung Mangkurat","institution_ids":["https://openalex.org/I42264441"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.4148,"has_fulltext":true,"cited_by_count":1,"citation_normalized_percentile":{"value":0.60746385,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":93,"max":96},"biblio":{"volume":"16","issue":"2","first_page":"361","last_page":"361"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9984999895095825,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9984999895095825,"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"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.000699999975040555,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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/T11269","display_name":"Algorithms and Data Compression","score":0.0003000000142492354,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/relational-database-management-systems","display_name":"relational database management systems","score":0.8769999742507935},{"id":"https://openalex.org/keywords/query-optimization","display_name":"query optimization","score":0.8420000076293945},{"id":"https://openalex.org/keywords/mysql","display_name":"MySQL","score":0.4429999887943268},{"id":"https://openalex.org/keywords/query-execution-time","display_name":"query execution time","score":0.6620000004768372}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.5719596743583679},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.5574213862419128},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.53046715259552},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.15781137347221375},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.03438621759414673}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.31602/tji.v16i2.18624","doi":"https://doi.org/10.31602/tji.v16i2.18624","is_oa":true,"landing_page_url":"https://doi.org/10.31602/tji.v16i2.18624","pdf_url":"https://ojs.uniska-bjm.ac.id/index.php/JIT/article/download/18624/7417","source":{"id":"https://openalex.org/S4210183553","display_name":"Technologia Jurnal Ilmiah","issn_l":"2086-6917","issn":["2086-6917","2656-8047"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I4210144356","host_organization_name":"Universitas Islam Kalimantan Muhammad Arsyad Al Banjary","host_organization_lineage":["https://openalex.org/I4210144356"],"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":"Technologia : Jurnal Ilmiah","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.31602/tji.v16i2.18624","doi":"https://doi.org/10.31602/tji.v16i2.18624","is_oa":true,"landing_page_url":"https://doi.org/10.31602/tji.v16i2.18624","pdf_url":"https://ojs.uniska-bjm.ac.id/index.php/JIT/article/download/18624/7417","source":{"id":"https://openalex.org/S4210183553","display_name":"Technologia Jurnal Ilmiah","issn_l":"2086-6917","issn":["2086-6917","2656-8047"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I4210144356","host_organization_name":"Universitas Islam Kalimantan Muhammad Arsyad Al Banjary","host_organization_lineage":["https://openalex.org/I4210144356"],"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":"Technologia : Jurnal Ilmiah","raw_type":"journal-article"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4409635530.pdf","grobid_xml":"https://content.openalex.org/works/W4409635530.grobid-xml"},"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W4406977047","https://openalex.org/W2647244924","https://openalex.org/W3024035691","https://openalex.org/W3118261778","https://openalex.org/W4321479718","https://openalex.org/W4409522413","https://openalex.org/W7223448532","https://openalex.org/W7219531375","https://openalex.org/W4412586180","https://openalex.org/W4412774366"],"abstract_inverted_index":{"Optimasi":[0],"kinerja":[1,148],"query":[2,28,143],"join":[3,29],"dalam":[4,17,25,119,139],"sistem":[5,56,136],"basis":[6,137],"data":[7,16,138],"relasional":[8],"(RDBMS)":[9],"sangat":[10,117],"penting":[11],"untuk":[12,146],"meningkatkan":[13,147],"efisiensi":[14],"pengolahan":[15],"skala":[18],"besar.":[19],"Penelitian":[20],"ini":[21,113,131],"mengevaluasi":[22],"efektivitas":[23],"indeks":[24,73,116,145],"mempercepat":[26,74],"eksekusi":[27,75,122],"menggunakan":[30],"dataset":[31],"Employee":[32],"Database":[33],"SQL":[34],"pada":[35,55,125],"MySQL.":[36],"Tiga":[37],"skenario":[38,126],"pengujian":[39],"dilakukan:":[40],"Single":[41,76],"Join,":[42,44],"Triple":[43,46,87,99],"dan":[45,65,98],"Join":[47,77,88,100],"dengan":[48,57,101,127],"kondisi":[49,102],"filter,":[50],"masing-masing":[51],"dieksekusi":[52],"10":[53],"kali":[54],"spesifikasi":[58],"CPU":[59],"Intel":[60],"Core":[61],"i5-2467M":[62],"(1.6":[63],"GHz)":[64],"RAM":[66],"12":[67],"GB.":[68],"Hasil":[69,112],"eksperimen":[70],"menunjukkan":[71,114],"bahwa":[72,115],"dari":[78,89,103],"250":[79],"ms":[80,83,91,94,105,108],"menjadi":[81,92,106],"150":[82],"(40%":[84],"lebih":[85,96,110],"cepat),":[86,97],"950":[90],"750":[93],"(21%":[95],"1800":[104],"900":[107],"(50%":[109],"cepat).":[111],"efektif":[118],"mengurangi":[120],"waktu":[121],"query,":[123],"terutama":[124],"filter":[128],"spesifik.":[129],"Temuan":[130],"memberikan":[132],"wawasan":[133],"bagi":[134],"pengembang":[135],"merancang":[140],"strategi":[141],"optimasi":[142],"berbasis":[144,150],"aplikasi":[149],"data.":[151]},"counts_by_year":[{"year":2026,"cited_by_count":1}],"updated_date":"2026-11-02T09:45:03.842371","created_date":"2025-04-22T00:00:00"}