{"id":"https://openalex.org/W3135376611","doi":"https://doi.org/10.1109/access.2021.3064202","title":"An Efficient Data Access Approach With Queue and Stack in Optimized Hybrid Join","display_name":"An Efficient Data Access Approach With Queue and Stack in Optimized Hybrid Join","publication_year":2021,"publication_date":"2021-01-01","ids":{"openalex":"https://openalex.org/W3135376611","doi":"https://doi.org/10.1109/access.2021.3064202","mag":"3135376611"},"language":"en","primary_location":{"id":"doi:10.1109/access.2021.3064202","is_oa":true,"landing_page_url":"https://doi.org/10.1109/access.2021.3064202","pdf_url":null,"source":{"id":"https://openalex.org/S2485537415","display_name":"IEEE Access","issn_l":"2169-3536","issn":["2169-3536"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Access","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://doi.org/10.1109/access.2021.3064202","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5061815437","display_name":"Omer Aziz","orcid":"https://orcid.org/0000-0002-9869-5212"},"institutions":[{"id":"https://openalex.org/I87482320","display_name":"University of Management and Technology","ror":"https://ror.org/0095xcq10","country_code":"PK","type":"education","lineage":["https://openalex.org/I87482320"]}],"countries":["PK"],"is_corresponding":false,"raw_author_name":"Omer Aziz","raw_affiliation_strings":["School of Systems and Technology, University of Management and Technology, Lahore, Pakistan"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Systems and Technology, University of Management and Technology, Lahore, Pakistan","institution_ids":["https://openalex.org/I87482320"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5024941166","display_name":"Tayyaba Anees","orcid":"https://orcid.org/0000-0003-2266-9322"},"institutions":[{"id":"https://openalex.org/I87482320","display_name":"University of Management and Technology","ror":"https://ror.org/0095xcq10","country_code":"PK","type":"education","lineage":["https://openalex.org/I87482320"]}],"countries":["PK"],"is_corresponding":false,"raw_author_name":"Tayyaba Anees","raw_affiliation_strings":["School of Systems and Technology, University of Management and Technology, Lahore, Pakistan"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Systems and Technology, University of Management and Technology, Lahore, Pakistan","institution_ids":["https://openalex.org/I87482320"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5090225150","display_name":"Erum Mehmood","orcid":"https://orcid.org/0000-0001-9424-8274"},"institutions":[{"id":"https://openalex.org/I87482320","display_name":"University of Management and Technology","ror":"https://ror.org/0095xcq10","country_code":"PK","type":"education","lineage":["https://openalex.org/I87482320"]}],"countries":["PK"],"is_corresponding":false,"raw_author_name":"Erum Mehmood","raw_affiliation_strings":["School of Systems and Technology, University of Management and Technology, Lahore, Pakistan"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Systems and Technology, University of Management and Technology, Lahore, Pakistan","institution_ids":["https://openalex.org/I87482320"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I87482320"],"apc_list":{"value":1850,"currency":"USD","value_usd":1850},"apc_paid":{"value":1850,"currency":"USD","value_usd":1850},"fwci":1.2154,"has_fulltext":false,"cited_by_count":9,"citation_normalized_percentile":{"value":0.79499362,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":"9","issue":null,"first_page":"41261","last_page":"41274"},"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.9994999766349792,"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.9994999766349792,"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.9987000226974487,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9934999942779541,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8537254333496094},{"id":"https://openalex.org/keywords/partition","display_name":"Partition (number theory)","score":0.6336356401443481},{"id":"https://openalex.org/keywords/join","display_name":"Join (topology)","score":0.5861032605171204},{"id":"https://openalex.org/keywords/key","display_name":"Key (lock)","score":0.5714293718338013},{"id":"https://openalex.org/keywords/queue","display_name":"Queue","score":0.5694628953933716},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.4723338186740875},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.4449653625488281},{"id":"https://openalex.org/keywords/distributed-computing","display_name":"Distributed computing","score":0.3780950903892517},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.36087456345558167},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.35797181725502014},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.16478943824768066},{"id":"https://openalex.org/keywords/computer-network","display_name":"Computer network","score":0.16175901889801025}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8537254333496094},{"id":"https://openalex.org/C42812","wikidata":"https://www.wikidata.org/wiki/Q1082910","display_name":"Partition (number theory)","level":2,"score":0.6336356401443481},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.5861032605171204},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.5714293718338013},{"id":"https://openalex.org/C160403385","wikidata":"https://www.wikidata.org/wiki/Q220543","display_name":"Queue","level":2,"score":0.5694628953933716},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.4723338186740875},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.4449653625488281},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.3780950903892517},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.36087456345558167},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.35797181725502014},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.16478943824768066},{"id":"https://openalex.org/C31258907","wikidata":"https://www.wikidata.org/wiki/Q1301371","display_name":"Computer network","level":1,"score":0.16175901889801025},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1109/access.2021.3064202","is_oa":true,"landing_page_url":"https://doi.org/10.1109/access.2021.3064202","pdf_url":null,"source":{"id":"https://openalex.org/S2485537415","display_name":"IEEE Access","issn_l":"2169-3536","issn":["2169-3536"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Access","raw_type":"journal-article"},{"id":"pmh:oai:doaj.org/article:35190735755f4eec98215745e5e208e7","is_oa":true,"landing_page_url":"https://doaj.org/article/35190735755f4eec98215745e5e208e7","pdf_url":null,"source":{"id":"https://openalex.org/S4306401280","display_name":"DOAJ (DOAJ: Directory of Open Access Journals)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-sa","license_id":"https://openalex.org/licenses/cc-by-sa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"IEEE Access, Vol 9, Pp 41261-41274 (2021)","raw_type":"article"}],"best_oa_location":{"id":"doi:10.1109/access.2021.3064202","is_oa":true,"landing_page_url":"https://doi.org/10.1109/access.2021.3064202","pdf_url":null,"source":{"id":"https://openalex.org/S2485537415","display_name":"IEEE Access","issn_l":"2169-3536","issn":["2169-3536"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Access","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":111,"referenced_works":["https://openalex.org/W21469624","https://openalex.org/W135511438","https://openalex.org/W150801922","https://openalex.org/W176053229","https://openalex.org/W197630086","https://openalex.org/W253264081","https://openalex.org/W1484813121","https://openalex.org/W1493149182","https://openalex.org/W1499784129","https://openalex.org/W1500547548","https://openalex.org/W1515038756","https://openalex.org/W1570448133","https://openalex.org/W1580576187","https://openalex.org/W1584573194","https://openalex.org/W1594122454","https://openalex.org/W1635892993","https://openalex.org/W1660831082","https://openalex.org/W1831560769","https://openalex.org/W1831808549","https://openalex.org/W1836314187","https://openalex.org/W1848127982","https://openalex.org/W1905990867","https://openalex.org/W1917129590","https://openalex.org/W1943411325","https://openalex.org/W1994694191","https://openalex.org/W2006761638","https://openalex.org/W2014868275","https://openalex.org/W2020754916","https://openalex.org/W2021282951","https://openalex.org/W2028859573","https://openalex.org/W2051695193","https://openalex.org/W2064384103","https://openalex.org/W2072480178","https://openalex.org/W2082004608","https://openalex.org/W2103106131","https://openalex.org/W2104288714","https://openalex.org/W2105175890","https://openalex.org/W2109149785","https://openalex.org/W2112215401","https://openalex.org/W2120828587","https://openalex.org/W2122822096","https://openalex.org/W2123328263","https://openalex.org/W2131165411","https://openalex.org/W2132520571","https://openalex.org/W2146658606","https://openalex.org/W2146884585","https://openalex.org/W2152198818","https://openalex.org/W2161578281","https://openalex.org/W2162654304","https://openalex.org/W2164149526","https://openalex.org/W2164364358","https://openalex.org/W2166604013","https://openalex.org/W2167276970","https://openalex.org/W2169486917","https://openalex.org/W2169593628","https://openalex.org/W2170699196","https://openalex.org/W2187771821","https://openalex.org/W2201552871","https://openalex.org/W2297132530","https://openalex.org/W2315672253","https://openalex.org/W2348265989","https://openalex.org/W2365233879","https://openalex.org/W2395205829","https://openalex.org/W2412937480","https://openalex.org/W2432128781","https://openalex.org/W2505774719","https://openalex.org/W2508578281","https://openalex.org/W2513947825","https://openalex.org/W2518609810","https://openalex.org/W2519985672","https://openalex.org/W2522845637","https://openalex.org/W2538888527","https://openalex.org/W2548167726","https://openalex.org/W2549408802","https://openalex.org/W2559976359","https://openalex.org/W2560887315","https://openalex.org/W2563411137","https://openalex.org/W2563792322","https://openalex.org/W2568574061","https://openalex.org/W2572325517","https://openalex.org/W2579896634","https://openalex.org/W2582157995","https://openalex.org/W2584339594","https://openalex.org/W2584519632","https://openalex.org/W2590311336","https://openalex.org/W2598227572","https://openalex.org/W2604824709","https://openalex.org/W2606568264","https://openalex.org/W2609009517","https://openalex.org/W2914354916","https://openalex.org/W2971286980","https://openalex.org/W3005224441","https://openalex.org/W3015061971","https://openalex.org/W3126729787","https://openalex.org/W4213366719","https://openalex.org/W4244059595","https://openalex.org/W4253103473","https://openalex.org/W4253656115","https://openalex.org/W4255814300","https://openalex.org/W4293743697","https://openalex.org/W4299853504","https://openalex.org/W6600893865","https://openalex.org/W6629102967","https://openalex.org/W6629829915","https://openalex.org/W6629856530","https://openalex.org/W6630842491","https://openalex.org/W6638475507","https://openalex.org/W6638621328","https://openalex.org/W6640690195","https://openalex.org/W6679785179","https://openalex.org/W6683793818"],"related_works":["https://openalex.org/W4205996836","https://openalex.org/W2151692181","https://openalex.org/W4392498349","https://openalex.org/W2093960938","https://openalex.org/W3214148052","https://openalex.org/W2807741550","https://openalex.org/W794462722","https://openalex.org/W2029625042","https://openalex.org/W4256664196","https://openalex.org/W4248476017"],"abstract_inverted_index":{"As":[0,147],"rapid":[1],"decision":[2],"making":[3],"in":[4,8,56,105,143,209,265],"business":[5],"organizations":[6],"gain":[7],"popularity,":[9],"the":[10,57,60,70,106,124,129,135,140,144,148,158,168,178,185,192,214,288],"complexity":[11],"and":[12,17,127,190,205,228,233,269,281],"adaptability":[13],"of":[14,21,33,59,81,150,161,170,194,216,254,259,267,271],"extract,":[15],"transform,":[16],"load":[18,123],"(ETL)":[19],"process":[20,208],"near":[22,34],"real-time":[23,35],"data":[24,36,42,45,53,61,189,294],"warehousing":[25],"has":[26,102,131],"dramatically":[27],"increased.":[28],"The":[29],"most":[30],"important":[31],"part":[32,80],"warehouse":[37,62],"is":[38,54,78,88,115,157,245],"to":[39,66,90,122,132,239,251,276],"feed":[40],"new":[41,52,222],"from":[43],"different":[44],"sources":[46],"on":[47],"near-real-time":[48],"basis.":[49],"However,":[50,108,198],"this":[51,92,95,113,166],"not":[55],"format":[58,72],"therefore,":[63,128],"it":[64,117],"needs":[65],"be":[67,201],"transformed":[68],"into":[69,154],"required":[71,89],"by":[73,218],"using":[74,291],"transformation":[75],"algorithms":[76,223,237,261,286],"which":[77],"essential":[79],"ETL":[82],"process.":[83],"A":[84],"semi-stream":[85],"join":[86,181,196],"algorithm":[87,101,114,130,163,171],"implement":[91],"transformation,":[93],"for":[94,183,284],"purpose":[96],"a":[97,119],"HYBRIDJOIN":[98,217],"(hybrid":[99],"join)":[100],"been":[103],"presented":[104],"literature.":[107],"major":[109,159,241],"design":[110],"issue":[111],"with":[112,187,231],"that":[116,244],"uses":[118],"single":[120],"buffer":[121,156],"disk":[125,137,145,152,155,246],"partitions":[126],"wait":[133],"until":[134],"next":[136],"partition":[138,142,153],"overwrites":[139],"exiting":[141],"buffer.":[146],"cost":[149,160,243,282],"loading":[151],"overall":[162],"processing":[164,242],"cost,":[165],"leaves":[167],"performance":[169,199,290],"sub-optimal.":[172],"Moreover,":[173],"existing":[174,277],"approaches":[175],"only":[176],"considering":[177],"oldest":[179,206],"key":[180,195],"attributes":[182,207],"finding":[184],"matches":[186],"master":[188],"maintaining":[191],"Queue":[193,232],"attribute.":[197],"can":[200],"improved":[202],"if":[203],"recent":[204],"parallel.":[210],"This":[211],"article":[212],"addresses":[213],"limitation":[215],"presenting":[219],"two":[220],"optimized":[221],"named:":[224],"Parallel-Hybrid":[225],"Join":[226,230],"(P-HYBRIDJOIN)":[227],"Hybrid":[229],"Stack":[234],"(QaS-HYBRIDJOIN).":[235],"Proposed":[236],"aim":[238],"reduce":[240],"I/O":[247],"as":[248,250,274],"well":[249],"increase":[252],"number":[253,270],"matching":[255,272],"stream":[256,293],"tuples.":[257],"Both":[258],"these":[260],"perform":[262],"significantly":[263],"better":[264],"terms":[266],"throughput":[268],"tuples":[273],"compared":[275],"approaches.":[278],"Performance":[279],"analysis":[280],"model":[283],"proposed":[285],"show":[287],"best":[289],"intermittent":[292],"under":[295],"limited":[296],"resources.":[297]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":4},{"year":2021,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}