{"id":"https://openalex.org/W2124346586","doi":"https://doi.org/10.1109/icde.2001.914872","title":"Integrating semi-join-reducers into state-of-the-art query processors","display_name":"Integrating semi-join-reducers into state-of-the-art query processors","publication_year":2002,"publication_date":"2002-11-13","ids":{"openalex":"https://openalex.org/W2124346586","doi":"https://doi.org/10.1109/icde.2001.914872","mag":"2124346586"},"language":"en","primary_location":{"id":"doi:10.1109/icde.2001.914872","doi":"https://doi.org/10.1109/icde.2001.914872","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2001.914872","pdf_url":null,"source":{"id":"https://openalex.org/S4210210321","display_name":"IEEE International Conference on Data Engineering (ICDE)","issn_l":"1084-4627","issn":["1084-4627","2375-0286"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","norway-2"],"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":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings 17th International Conference on Data Engineering","raw_type":"proceedings-article"},"volume":null,"type":"conference-paper","is_traditional":true,"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/A5111482601","display_name":"Konrad Stocker","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I186354981","display_name":"University of Passau","ror":"https://ror.org/05ydjnb78","country_code":"DE","type":"education","lineage":["https://openalex.org/I186354981"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"K. Stocker","raw_affiliation_strings":["Universit\u00e4t Passau, Passau, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Universit\u00e4t Passau, Passau, Germany","institution_ids":["https://openalex.org/I186354981"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5111504785","display_name":"Donald Kossmann","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I62916508","display_name":"Technical University of Munich","ror":"https://ror.org/02kkvpp62","country_code":"DE","type":"education","lineage":["https://openalex.org/I62916508"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"D. Kossmann","raw_affiliation_strings":["Technische Universit\u00e4t M\u00fcnchen, M\u00fcnchen, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Technische Universit\u00e4t M\u00fcnchen, M\u00fcnchen, Germany","institution_ids":["https://openalex.org/I62916508"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5075069681","display_name":"R. Braumandi","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"R. Braumandi","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5105815320","display_name":"A. Kemper","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I186354981","display_name":"University of Passau","ror":"https://ror.org/05ydjnb78","country_code":"DE","type":"education","lineage":["https://openalex.org/I186354981"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"A. Kemper","raw_affiliation_strings":["Universit\u00e4t Passau, Passau, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Universit\u00e4t Passau, Passau, Germany","institution_ids":["https://openalex.org/I186354981"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.621,"has_fulltext":false,"cited_by_count":50,"citation_normalized_percentile":{"value":0.65920685,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":87,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"575","last_page":"584"},"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.9976000189781189,"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.9976000189781189,"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/T11106","display_name":"Data Management and Algorithms","score":0.0003000000142492354,"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/T10054","display_name":"Parallel Computing and Optimization Techniques","score":0.00019999999494757503,"subfield":{"id":"https://openalex.org/subfields/1708","display_name":"Hardware and Architecture"},"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/query-optimization","display_name":"query optimization","score":0.8349999785423279},{"id":"https://openalex.org/keywords/client-server-architecture","display_name":"client-server architecture","score":0.6499999761581421},{"id":"https://openalex.org/keywords/middleware","display_name":"middleware","score":0.8510000109672546},{"id":"https://openalex.org/keywords/communication-overhead-reduction","display_name":"communication cost reduction","score":0.9309999942779541},{"id":"https://openalex.org/keywords/query-plan-generation","display_name":"query plan generation","score":0.6809999942779541},{"id":"https://openalex.org/keywords/distributed-databases","display_name":"distributed databases","score":0.6940000057220459}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7879214286804199},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.7530096769332886},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.6223111748695374},{"id":"https://openalex.org/C48103436","wikidata":"https://www.wikidata.org/wiki/Q599031","display_name":"State (computer science)","level":2,"score":0.5474796891212463},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.31961166858673096},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.3115260601043701},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.05935060977935791},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1109/icde.2001.914872","doi":"https://doi.org/10.1109/icde.2001.914872","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2001.914872","pdf_url":null,"source":{"id":"https://openalex.org/S4210210321","display_name":"IEEE International Conference on Data Engineering (ICDE)","issn_l":"1084-4627","issn":["1084-4627","2375-0286"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","norway-2"],"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":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings 17th International Conference on Data Engineering","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.21.1803","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.21.1803","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.db.fmi.uni-passau.de/~stocker/PAPERS/semijoin.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":33,"referenced_works":["https://openalex.org/W25483517","https://openalex.org/W106164280","https://openalex.org/W1480809079","https://openalex.org/W1481711124","https://openalex.org/W1484813121","https://openalex.org/W1581902732","https://openalex.org/W1804205637","https://openalex.org/W1968541019","https://openalex.org/W1969914452","https://openalex.org/W1977570286","https://openalex.org/W1997551838","https://openalex.org/W2009020789","https://openalex.org/W2017383881","https://openalex.org/W2023195086","https://openalex.org/W2026896584","https://openalex.org/W2044202775","https://openalex.org/W2046649829","https://openalex.org/W2054338562","https://openalex.org/W2059844260","https://openalex.org/W2079329679","https://openalex.org/W2090731375","https://openalex.org/W2103277464","https://openalex.org/W2122949840","https://openalex.org/W2133900260","https://openalex.org/W2140487524","https://openalex.org/W2153329411","https://openalex.org/W2153485419","https://openalex.org/W2154888102","https://openalex.org/W2155166680","https://openalex.org/W2167679350","https://openalex.org/W3003067944","https://openalex.org/W4243358384","https://openalex.org/W6604260118"],"related_works":["https://openalex.org/W4243358384","https://openalex.org/W2137120813","https://openalex.org/W2111050884","https://openalex.org/W4231417542","https://openalex.org/W2110816960","https://openalex.org/W2148562629","https://openalex.org/W2118829832","https://openalex.org/W1918131718","https://openalex.org/W1553428165","https://openalex.org/W2119005434"],"abstract_inverted_index":{"Semi-join":[0],"reducers":[1,29,45],"were":[2],"introduced":[3],"in":[4,22,50,86,108],"the":[5,13,23,34,67,115,118,124],"late":[6],"1970s":[7],"as":[8],"a":[9,70,134],"means":[10],"to":[11,58,63,79,88],"reduce":[12,59],"communication":[14,60],"costs":[15,61],"of":[16,37,69,117,126],"distributed":[17,35],"database":[18],"systems.":[19],"Subsequent":[20],"work":[21],"1980s":[24],"showed,":[25],"however,":[26],"that":[27,38,43,129],"semi-join":[28,44,94],"are":[30],"rarely":[31],"beneficial":[32,49],"for":[33],"systems":[36,55],"time.":[39],"This":[40],"paper":[41],"shows":[42],"can":[46],"indeed":[47],"be":[48],"modern":[51],"client-server":[52],"or":[53,62],"middleware":[54],"-":[56],"either":[57],"better":[64],"exploit":[65],"all":[66],"resources":[68],"system.":[71],"Furthermore,":[72],"we":[73],"present":[74,97,123],"and":[75,103,114],"evaluate":[76],"alternative":[77],"ways":[78],"extend":[80],"state-of-the-art":[81],"(dynamic":[82],"programming)":[83],"query":[84,91,136],"optimizers":[85],"order":[87],"generate":[89],"good":[90],"plans":[92,119],"with":[93,133],"reducers.":[95],"We":[96,122],"two":[98],"variants,":[99],"called":[100],"Access":[101],"Root":[102],"Join":[104],"Root,":[105],"which":[106],"differ":[107],"their":[109],"implementation":[110],"complexity,":[111],"running":[112],"times":[113],"quality":[116],"they":[120],"produce.":[121],"results":[125],"performance":[127],"experiments":[128],"compare":[130],"both":[131],"variants":[132],"traditional":[135],"optimizer.":[137]},"counts_by_year":[{"year":2025,"cited_by_count":4},{"year":2024,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2018,"cited_by_count":4},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":2},{"year":2015,"cited_by_count":3},{"year":2014,"cited_by_count":2},{"year":2013,"cited_by_count":2},{"year":2012,"cited_by_count":4}],"updated_date":"2026-11-10T11:39:43.021295","created_date":"2016-06-24T00:00:00"}