{"id":"https://openalex.org/W3147966060","doi":"https://doi.org/10.1109/ideas.2007.4318084","title":"Adaptive Execution of Stream Window Joins in a Limited Memory Environment","display_name":"Adaptive Execution of Stream Window Joins in a Limited Memory Environment","publication_year":2007,"publication_date":"2007-09-01","ids":{"openalex":"https://openalex.org/W3147966060","doi":"https://doi.org/10.1109/ideas.2007.4318084","mag":"3147966060"},"language":"en","primary_location":{"id":"doi:10.1109/ideas.2007.4318084","is_oa":false,"landing_page_url":"https://doi.org/10.1109/ideas.2007.4318084","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"11th International Database Engineering and Applications Symposium (IDEAS 2007)","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5090609543","display_name":"Fatima Farag","orcid":null},"institutions":[{"id":"https://openalex.org/I168635309","display_name":"University of Calgary","ror":"https://ror.org/03yjb2x39","country_code":"CA","type":"education","lineage":["https://openalex.org/I168635309"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Fatima Farag","raw_affiliation_strings":["Department of Computer Science, University of Calgary, Calgary, AB, Canada"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Science, University of Calgary, Calgary, AB, Canada","institution_ids":["https://openalex.org/I168635309"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5109911563","display_name":"Moustafa A. Hammad","orcid":null},"institutions":[{"id":"https://openalex.org/I168635309","display_name":"University of Calgary","ror":"https://ror.org/03yjb2x39","country_code":"CA","type":"education","lineage":["https://openalex.org/I168635309"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Moustafa A. Hammad","raw_affiliation_strings":["Department of Computer Science, University of Calgary, Calgary, AB, Canada"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Science, University of Calgary, Calgary, AB, Canada","institution_ids":["https://openalex.org/I168635309"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.3369,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.71895192,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":94},"biblio":{"volume":null,"issue":null,"first_page":"12","last_page":"20"},"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.9998999834060669,"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.9998999834060669,"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.9994000196456909,"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.9991000294685364,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8791589736938477},{"id":"https://openalex.org/keywords/joins","display_name":"Joins","score":0.8687798380851746},{"id":"https://openalex.org/keywords/data-stream-mining","display_name":"Data stream mining","score":0.778661847114563},{"id":"https://openalex.org/keywords/sliding-window-protocol","display_name":"Sliding window protocol","score":0.6919278502464294},{"id":"https://openalex.org/keywords/data-stream","display_name":"Data stream","score":0.6373963356018066},{"id":"https://openalex.org/keywords/window","display_name":"Window (computing)","score":0.5093706846237183},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.44794631004333496},{"id":"https://openalex.org/keywords/distributed-computing","display_name":"Distributed computing","score":0.43663284182548523},{"id":"https://openalex.org/keywords/volume","display_name":"Volume (thermodynamics)","score":0.41881483793258667},{"id":"https://openalex.org/keywords/real-time-computing","display_name":"Real-time computing","score":0.3484184443950653},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.33676546812057495},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.2622498869895935},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.12295189499855042}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8791589736938477},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.8687798380851746},{"id":"https://openalex.org/C89198739","wikidata":"https://www.wikidata.org/wiki/Q3079880","display_name":"Data stream mining","level":2,"score":0.778661847114563},{"id":"https://openalex.org/C102392041","wikidata":"https://www.wikidata.org/wiki/Q592860","display_name":"Sliding window protocol","level":3,"score":0.6919278502464294},{"id":"https://openalex.org/C2778484313","wikidata":"https://www.wikidata.org/wiki/Q1172540","display_name":"Data stream","level":2,"score":0.6373963356018066},{"id":"https://openalex.org/C2778751112","wikidata":"https://www.wikidata.org/wiki/Q835016","display_name":"Window (computing)","level":2,"score":0.5093706846237183},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.44794631004333496},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.43663284182548523},{"id":"https://openalex.org/C20556612","wikidata":"https://www.wikidata.org/wiki/Q4469374","display_name":"Volume (thermodynamics)","level":2,"score":0.41881483793258667},{"id":"https://openalex.org/C79403827","wikidata":"https://www.wikidata.org/wiki/Q3988","display_name":"Real-time computing","level":1,"score":0.3484184443950653},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.33676546812057495},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.2622498869895935},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.12295189499855042},{"id":"https://openalex.org/C62520636","wikidata":"https://www.wikidata.org/wiki/Q944","display_name":"Quantum mechanics","level":1,"score":0.0},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0},{"id":"https://openalex.org/C76155785","wikidata":"https://www.wikidata.org/wiki/Q418","display_name":"Telecommunications","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/ideas.2007.4318084","is_oa":false,"landing_page_url":"https://doi.org/10.1109/ideas.2007.4318084","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"11th International Database Engineering and Applications Symposium (IDEAS 2007)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":17,"referenced_works":["https://openalex.org/W1510252230","https://openalex.org/W1512675310","https://openalex.org/W1512840853","https://openalex.org/W1594122454","https://openalex.org/W1782020131","https://openalex.org/W1831560769","https://openalex.org/W1848127982","https://openalex.org/W2106990403","https://openalex.org/W2115503987","https://openalex.org/W2126982545","https://openalex.org/W2132461362","https://openalex.org/W2132510297","https://openalex.org/W6638394102","https://openalex.org/W6638614332","https://openalex.org/W6638621328","https://openalex.org/W6677231548","https://openalex.org/W7027717352"],"related_works":["https://openalex.org/W127192698","https://openalex.org/W2360131081","https://openalex.org/W1572762191","https://openalex.org/W3207785250","https://openalex.org/W2985941356","https://openalex.org/W1994631397","https://openalex.org/W2991818765","https://openalex.org/W2106570241","https://openalex.org/W4360995307","https://openalex.org/W2388307643"],"abstract_inverted_index":{"A":[0,150],"sliding":[1],"window":[2],"join":[3,73],"(SWJoin)":[4],"is":[5],"becoming":[6],"an":[7,35,70],"integral":[8],"operation":[9],"in":[10,93],"every":[11],"stream":[12,106],"data":[13,25,63,88,103,110,125,130],"management":[14],"system.":[15],"In":[16,65],"some":[17],"streaming":[18],"applications":[19],"the":[20,29,40,49,101,108,112,119,122,128,132,140,143,147,160,163],"increasing":[21],"volume":[22],"of":[23,31,46,61,81,104,111,121,146,162],"streamed":[24],"as":[26,28],"well":[27],"multiplicity":[30],"concurrent":[32],"queries":[33],"requires":[34],"adaptive":[36],"SWJoin":[37,47],"algorithm":[38,74,91],"for":[39],"limited":[41],"memory":[42,50],"resources.":[43],"Previous":[44],"algorithms":[45,158],"address":[48],"limitation":[51],"by":[52,126],"exploiting":[53],"external-memory":[54,71],"resources":[55],"while":[56],"imposing":[57],"timely":[58],"ordered":[59],"arrival":[60,79],"input":[62,82,148],"streams.":[64,114,134],"this":[66],"paper":[67],"we":[68],"propose":[69],"sliding-window":[72],"(EM-SWJoin)":[75],"that":[76],"addresses":[77],"general":[78],"patterns":[80],"streams":[83],"and":[84,155],"exploits":[85],"disk-":[86],"based":[87],"structures.":[89],"The":[90,96,115],"runs":[92],"two":[94],"phases.":[95],"first":[97],"phase":[98,117,138],"partially":[99,123],"joins":[100],"arriving":[102],"one":[105,137],"with":[107],"memory-resident":[109],"other":[113,141,156],"second":[116],"completes":[118],"processing":[120],"joined":[124],"considering":[127],"disk-resident":[129],"from":[131,136],"corresponding":[133],"Swapping":[135],"to":[139],"improves":[142],"response":[144],"time":[145],"data.":[149],"comparative":[151],"study":[152],"between":[153],"EM-SWJoin":[154],"related":[157],"illustrates":[159],"superiority":[161],"proposed":[164],"algorithm.":[165]},"counts_by_year":[{"year":2015,"cited_by_count":1}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}
