{"id":"https://openalex.org/W4367602297","doi":"https://doi.org/10.46880/jmika.vol7no1.pp25-33","title":"PERBANDINGAN EFISIENSI WAKTU PROSES PENGAKSESAN DATA ANTARA QUERY BERBENTUK JOIN DENGAN SUBSELECT","display_name":"PERBANDINGAN EFISIENSI WAKTU PROSES PENGAKSESAN DATA ANTARA QUERY BERBENTUK JOIN DENGAN SUBSELECT","publication_year":2023,"publication_date":"2023-04-30","ids":{"openalex":"https://openalex.org/W4367602297","doi":"https://doi.org/10.46880/jmika.vol7no1.pp25-33"},"language":"en","primary_location":{"id":"doi:10.46880/jmika.vol7no1.pp25-33","doi":"https://doi.org/10.46880/jmika.vol7no1.pp25-33","is_oa":true,"landing_page_url":"http://dx.doi.org/10.46880/jmika.vol7no1.pp25-33","pdf_url":"https://ejurnal.methodist.ac.id/index.php/methomika/article/download/1550/1272","source":{"id":"https://openalex.org/S4210226398","display_name":"METHOMIKA Jurnal Manajemen Informatika dan Komputerisasi Akuntansi","issn_l":"2598-8565","issn":["2598-8565","2620-4339"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I3132896252","host_organization_name":"Universitas Methodist Indonesia","host_organization_lineage":["https://openalex.org/I3132896252"],"host_organization_lineage_names":[],"type":"journal"},"license":"cc-by-nc","license_id":"https://openalex.org/licenses/cc-by-nc","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"METHOMIKA Jurnal Manajemen Informatika dan Komputerisasi Akuntansi","raw_type":"journal-article"},"volume":null,"type":"article","is_traditional":true,"indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"diamond","oa_url":"https://ejurnal.methodist.ac.id/index.php/methomika/article/download/1550/1272","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":null,"display_name":"Universitas Harapan Bangsa","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I4405257931","display_name":"Universitas Harapan Bangsa","ror":"https://ror.org/05v0eqq44","country_code":"ID","type":"education","lineage":["https://openalex.org/I4405257931"]}],"countries":["ID"],"is_corresponding":false,"raw_author_name":"Universitas Harapan Bangsa","raw_affiliation_strings":["Universitas Harapan Bangsa"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Universitas Harapan Bangsa","institution_ids":["https://openalex.org/I4405257931"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5030556135","display_name":"Raden Bagus Bambang Sumantri","orcid":"https://orcid.org/0000-0001-5522-9329","observed_orcids":["https://orcid.org/0000-0001-5522-9329"]},"institutions":[{"id":"https://openalex.org/I2608206482","display_name":"Universitas Ahmad Dahlan","ror":"https://ror.org/03hn13397","country_code":"ID","type":"education","lineage":["https://openalex.org/I2608206482"]},{"id":"https://openalex.org/I4405257931","display_name":"Universitas Harapan Bangsa","ror":"https://ror.org/05v0eqq44","country_code":"ID","type":"education","lineage":["https://openalex.org/I4405257931"]}],"countries":["ID"],"is_corresponding":false,"raw_author_name":"Raden Bagus Bambang Sumantri","raw_affiliation_strings":["Universitas Harapan Bangsa","Universitas Ahmad Dahlan"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Universitas Harapan Bangsa","institution_ids":["https://openalex.org/I4405257931"]},{"raw_affiliation_string":"Universitas Ahmad Dahlan","institution_ids":["https://openalex.org/I2608206482"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5008217421","display_name":"Guntur Subari","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I2608206482","display_name":"Universitas Ahmad Dahlan","ror":"https://ror.org/03hn13397","country_code":"ID","type":"education","lineage":["https://openalex.org/I2608206482"]}],"countries":["ID"],"is_corresponding":false,"raw_author_name":"Guntur Subari","raw_affiliation_strings":["Universitas Ahmad Dahlan","Institut Teknologi Sains NU Pekalongan"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Universitas Ahmad Dahlan","institution_ids":["https://openalex.org/I2608206482"]},{"raw_affiliation_string":"Institut Teknologi Sains NU Pekalongan","institution_ids":[]}]},{"author_position":"middle","author":{"id":null,"display_name":"Universitas Ahmad Dahlan","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I4405257931","display_name":"Universitas Harapan Bangsa","ror":"https://ror.org/05v0eqq44","country_code":"ID","type":"education","lineage":["https://openalex.org/I4405257931"]}],"countries":["ID"],"is_corresponding":false,"raw_author_name":"Universitas Ahmad Dahlan","raw_affiliation_strings":["Universitas Harapan Bangsa"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Universitas Harapan Bangsa","institution_ids":["https://openalex.org/I4405257931"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5014561614","display_name":"Fajar Mahardika","orcid":"https://orcid.org/0000-0003-2775-7794","observed_orcids":["https://orcid.org/0000-0003-2775-7794"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Fajar Mahardika","raw_affiliation_strings":["Institut Teknologi Sains NU Pekalongan"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Institut Teknologi Sains NU Pekalongan","institution_ids":[]}]},{"author_position":"middle","author":{"id":null,"display_name":"Institut Teknologi Sains NU Pekalongan","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Institut Teknologi Sains NU Pekalongan","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5088915549","display_name":"Hadi Jayusman","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I4405257931","display_name":"Universitas Harapan Bangsa","ror":"https://ror.org/05v0eqq44","country_code":"ID","type":"education","lineage":["https://openalex.org/I4405257931"]}],"countries":["ID"],"is_corresponding":false,"raw_author_name":"Hadi Jayusman","raw_affiliation_strings":["Universitas Harapan Bangsa"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Universitas Harapan Bangsa","institution_ids":["https://openalex.org/I4405257931"]}]},{"author_position":"last","author":{"id":null,"display_name":"Universitas Harapan Bangsa","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Universitas Harapan Bangsa","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.8385,"has_fulltext":true,"cited_by_count":10,"citation_normalized_percentile":{"value":0.86073059,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":93,"max":98},"biblio":{"volume":"7","issue":"1","first_page":"25","last_page":"33"},"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.9911999702453613,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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.9911999702453613,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T13681","display_name":"Engineering and Information Technology","score":0.005799999926239252,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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/T11734","display_name":"Decision Support System Applications","score":0.0006000000284984708,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/sql-query-performance","display_name":"SQL query performance","score":0.6169999837875366},{"id":"https://openalex.org/keywords/join-queries","display_name":"join queries","score":0.7940000295639038},{"id":"https://openalex.org/keywords/data-access-time","display_name":"data access time","score":0.7870000004768372},{"id":"https://openalex.org/keywords/query-optimization","display_name":"query optimization","score":0.6029999852180481}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8129494190216064},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.7920064926147461},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.749297022819519},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.6714661121368408},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.6484774351119995},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.6097867488861084},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.5892561674118042},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5659739971160889},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.5491445660591125},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.49276378750801086},{"id":"https://openalex.org/C118689300","wikidata":"https://www.wikidata.org/wiki/Q7978614","display_name":"Web query classification","level":4,"score":0.4916682839393616},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.4536813795566559},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.4252142906188965},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.42301106452941895},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.42155972123146057},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.13474449515342712},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.12673500180244446},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.107144296169281},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.1020520031452179},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.46880/jmika.vol7no1.pp25-33","doi":"https://doi.org/10.46880/jmika.vol7no1.pp25-33","is_oa":true,"landing_page_url":"http://dx.doi.org/10.46880/jmika.vol7no1.pp25-33","pdf_url":"https://ejurnal.methodist.ac.id/index.php/methomika/article/download/1550/1272","source":{"id":"https://openalex.org/S4210226398","display_name":"METHOMIKA Jurnal Manajemen Informatika dan Komputerisasi Akuntansi","issn_l":"2598-8565","issn":["2598-8565","2620-4339"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I3132896252","host_organization_name":"Universitas Methodist Indonesia","host_organization_lineage":["https://openalex.org/I3132896252"],"host_organization_lineage_names":[],"type":"journal"},"license":"cc-by-nc","license_id":"https://openalex.org/licenses/cc-by-nc","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"METHOMIKA Jurnal Manajemen Informatika dan Komputerisasi Akuntansi","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.46880/jmika.vol7no1.pp25-33","doi":"https://doi.org/10.46880/jmika.vol7no1.pp25-33","is_oa":true,"landing_page_url":"http://dx.doi.org/10.46880/jmika.vol7no1.pp25-33","pdf_url":"https://ejurnal.methodist.ac.id/index.php/methomika/article/download/1550/1272","source":{"id":"https://openalex.org/S4210226398","display_name":"METHOMIKA Jurnal Manajemen Informatika dan Komputerisasi Akuntansi","issn_l":"2598-8565","issn":["2598-8565","2620-4339"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I3132896252","host_organization_name":"Universitas Methodist Indonesia","host_organization_lineage":["https://openalex.org/I3132896252"],"host_organization_lineage_names":[],"type":"journal"},"license":"cc-by-nc","license_id":"https://openalex.org/licenses/cc-by-nc","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"METHOMIKA Jurnal Manajemen Informatika dan Komputerisasi Akuntansi","raw_type":"journal-article"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4367602297.pdf","grobid_xml":"https://content.openalex.org/works/W4367602297.grobid-xml"},"referenced_works_count":6,"referenced_works":["https://openalex.org/W2312654041","https://openalex.org/W2647244924","https://openalex.org/W2790609983","https://openalex.org/W2797352280","https://openalex.org/W2931277606","https://openalex.org/W4225394206"],"related_works":["https://openalex.org/W3024035691","https://openalex.org/W7211971022","https://openalex.org/W2620734149","https://openalex.org/W2896878667","https://openalex.org/W3207955562","https://openalex.org/W4406977047","https://openalex.org/W4409635530","https://openalex.org/W3118261778","https://openalex.org/W2180919406","https://openalex.org/W280367515"],"abstract_inverted_index":{"Queries":[0],"in":[1,47,109,122],"a":[2,7,67,92,136,164,181],"database":[3,35],"application":[4,14,183],"system,":[5],"have":[6],"great":[8],"influence":[9],"on":[10],"the":[11,25,31,34,53,56,62,70,77,87,110,148,151,159,188],"success":[12],"of":[13,33,45,52,55,65,81,89,103,112,132,139,150,187],"development.":[15],"Frequently":[16],"used":[17,60,121],"query":[18,27,57,72,152,162,173],"forms":[19,186],"include":[20],"subselect":[21,145],"and":[22,114,127,144],"join.":[23],"Choosing":[24],"right":[26],"form":[28,54,88,111,161,167],"will":[29,73,119],"affect":[30,74],"performance":[32],"application.":[36],"Database":[37],"applications":[38],"are":[39,125],"sometimes":[40],"slow":[41],"to":[42,58,85,169],"respond":[43],"because":[44,69],"slowness":[46],"their":[48],"databases.":[49],"The":[50,79,101,116,130],"selection":[51],"be":[59,120,156],"is":[61,84,106,135,163,174],"first":[63],"step":[64],"forming":[66],"query,":[68],"resulting":[71],"access":[75,95,140],"from":[76,176],"database.":[78],"purpose":[80],"this":[82,104,123,133],"study":[83,105,124,134],"determine":[86],"SQL":[90,166],"with":[91],"faster":[93,165,172],"data":[94],"time,":[96],"whether":[97],"join":[98,143,160],"or":[99],"subselect.":[100,170],"subject":[102],"queries":[107],"made":[108],"joins":[113],"subselects.":[115],"methods":[117],"that":[118,158],"literature":[126],"experimental":[128],"methods.":[129],"result":[131],"comparison":[137],"table":[138],"time":[141],"between":[142],"queries.":[146],"From":[147],"results":[149],"comparison,":[153],"it":[154],"can":[155],"concluded":[157],"compared":[168],"A":[171],"determined":[175],"testing":[177],"done":[178],"by":[179],"creating":[180],"simple":[182],"using":[184],"both":[185],"query.":[189]},"counts_by_year":[{"year":2026,"cited_by_count":4},{"year":2025,"cited_by_count":4},{"year":2023,"cited_by_count":2}],"updated_date":"2026-11-04T10:54:05.112534","created_date":"2023-05-02T00:00:00"}