{"id":"https://openalex.org/W1991774299","doi":"https://doi.org/10.1145/1183614.1183717","title":"Cache-oblivious nested-loop joins","display_name":"Cache-oblivious nested-loop joins","alternate_titles":[],"publication_year":2006,"publication_date":"2006-01-01","ids":{"openalex":"https://openalex.org/W1991774299","doi":"https://doi.org/10.1145/1183614.1183717","mag":"1991774299"},"language":"en","primary_location":{"id":"doi:10.1145/1183614.1183717","doi":"https://doi.org/10.1145/1183614.1183717","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1183614.1183717","pdf_url":null,"source":{"id":"https://openalex.org/S4393918199","display_name":"ACM International Conference on Information and Knowledge Management (CIKM)","issn_l":"2155-0751","issn":["2155-0751"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 15th ACM international conference on Information and knowledge management - CIKM '06","raw_type":"proceedings-article"},"parent_works":[],"lineage":["https://openalex.org/W1991774299"],"child_works_count":0,"type":"conference-abstract","is_traditional":false,"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/A5039946576","display_name":"Bingsheng He","orcid":"https://orcid.org/0000-0001-8618-4581","observed_orcids":["https://orcid.org/0000-0001-8618-4581"]},"institutions":[{"id":"https://openalex.org/I200769079","display_name":"Hong Kong University of Science and Technology","ror":"https://ror.org/00q4vv597","country_code":"HK","type":"education","lineage":["https://openalex.org/I200769079"]}],"countries":["HK"],"is_corresponding":false,"raw_author_name":"Bingsheng He","raw_affiliation_strings":["Hong Kong University of Science and Technology","Hong Kong University of Science & Technology"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Hong Kong University of Science and Technology","institution_ids":["https://openalex.org/I200769079"]},{"raw_affiliation_string":"Hong Kong University of Science & Technology","institution_ids":["https://openalex.org/I200769079"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5034823616","display_name":"Qiong Luo","orcid":"https://orcid.org/0000-0002-2861-9492","observed_orcids":["https://orcid.org/0000-0002-2861-9492","https://orcid.org/0000-0002-4275-1756"]},"institutions":[{"id":"https://openalex.org/I200769079","display_name":"Hong Kong University of Science and Technology","ror":"https://ror.org/00q4vv597","country_code":"HK","type":"education","lineage":["https://openalex.org/I200769079"]}],"countries":["HK"],"is_corresponding":false,"raw_author_name":"Qiong Luo","raw_affiliation_strings":["Hong Kong University of Science and Technology","Hong Kong University of Science & Technology"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Hong Kong University of Science and Technology","institution_ids":["https://openalex.org/I200769079"]},{"raw_affiliation_string":"Hong Kong University of Science & Technology","institution_ids":["https://openalex.org/I200769079"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I200769079"],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":13,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"718","last_page":"718"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9922000169754028,"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.9922000169754028,"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.0035000001080334187,"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"}},{"id":"https://openalex.org/T11269","display_name":"Algorithms and Data Compression","score":0.002300000051036477,"subfield":{"id":"https://openalex.org/subfields/2614","display_name":"Theoretical Computer Science"},"field":{"id":"https://openalex.org/fields/26","display_name":"Mathematics"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/cache-oblivious-algorithms","display_name":"cache-oblivious algorithms","score":0.9980000257492065},{"id":"https://openalex.org/keywords/nested-loop-join","display_name":"nested loop join","score":0.8519999980926514},{"id":"https://openalex.org/keywords/relational-query-processing","display_name":"relational query processing","score":0.984000027179718},{"id":"https://openalex.org/keywords/multi-level-memory-hierarchy","display_name":"multi-level memory hierarchy","score":0.8519999980926514},{"id":"https://openalex.org/keywords/recursive-partitioning","display_name":"recursive partitioning","score":0.9620000123977661},{"id":"https://openalex.org/keywords/recursive-clustering","display_name":"recursive clustering","score":0.9520000219345093},{"id":"https://openalex.org/keywords/buffering","display_name":"buffering","score":0.8270000219345093}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8679671883583069},{"id":"https://openalex.org/C115537543","wikidata":"https://www.wikidata.org/wiki/Q165596","display_name":"Cache","level":2,"score":0.7851837873458862},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.7104688286781311},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.6856105327606201},{"id":"https://openalex.org/C38556500","wikidata":"https://www.wikidata.org/wiki/Q13404475","display_name":"Cache algorithms","level":4,"score":0.650254487991333},{"id":"https://openalex.org/C59687516","wikidata":"https://www.wikidata.org/wiki/Q5015938","display_name":"Cache-oblivious algorithm","level":5,"score":0.6330928802490234},{"id":"https://openalex.org/C25536678","wikidata":"https://www.wikidata.org/wiki/Q5015977","display_name":"Cache invalidation","level":5,"score":0.6207938194274902},{"id":"https://openalex.org/C113166858","wikidata":"https://www.wikidata.org/wiki/Q5015981","display_name":"Cache pollution","level":5,"score":0.5369967818260193},{"id":"https://openalex.org/C189783530","wikidata":"https://www.wikidata.org/wiki/Q352090","display_name":"CPU cache","level":3,"score":0.5286277532577515},{"id":"https://openalex.org/C1306188","wikidata":"https://www.wikidata.org/wiki/Q4060687","display_name":"Nested loop join","level":2,"score":0.5175265669822693},{"id":"https://openalex.org/C2777210771","wikidata":"https://www.wikidata.org/wiki/Q4927124","display_name":"Block (permutation group theory)","level":2,"score":0.45410215854644775},{"id":"https://openalex.org/C31170391","wikidata":"https://www.wikidata.org/wiki/Q188619","display_name":"Hierarchy","level":2,"score":0.4536844491958618},{"id":"https://openalex.org/C201148951","wikidata":"https://www.wikidata.org/wiki/Q5015976","display_name":"Cache coloring","level":4,"score":0.43096688389778137},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3534010052680969},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.1037023663520813},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0850151777267456},{"id":"https://openalex.org/C34447519","wikidata":"https://www.wikidata.org/wiki/Q179522","display_name":"Market economy","level":1,"score":0.0},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/1183614.1183717","doi":"https://doi.org/10.1145/1183614.1183717","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1183614.1183717","pdf_url":null,"source":{"id":"https://openalex.org/S4393918199","display_name":"ACM International Conference on Information and Knowledge Management (CIKM)","issn_l":"2155-0751","issn":["2155-0751"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 15th ACM international conference on Information and knowledge management - CIKM '06","raw_type":"proceedings-article"},{"id":"pmh:oai:repository.hkust.edu.hk:1783.1-37501","doi":null,"is_oa":false,"landing_page_url":"http://repository.hkust.edu.hk/ir/Record/1783.1-37501","pdf_url":null,"source":{"id":"https://openalex.org/S4306401796","display_name":"Rare & Special e-Zone (The Hong Kong University of Science and Technology)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I200769079","host_organization_name":"Hong Kong University of Science and Technology","host_organization_lineage":["https://openalex.org/I200769079"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Conference paper"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":26,"referenced_works":["https://openalex.org/W1497812785","https://openalex.org/W1538592187","https://openalex.org/W1555915743","https://openalex.org/W1568945110","https://openalex.org/W1570477871","https://openalex.org/W1645807896","https://openalex.org/W1980313943","https://openalex.org/W1989622633","https://openalex.org/W1990713878","https://openalex.org/W1994085050","https://openalex.org/W2006706309","https://openalex.org/W2083576929","https://openalex.org/W2090747326","https://openalex.org/W2095875205","https://openalex.org/W2097125969","https://openalex.org/W2098130516","https://openalex.org/W2105156747","https://openalex.org/W2105879586","https://openalex.org/W2112184526","https://openalex.org/W2116730320","https://openalex.org/W2127902590","https://openalex.org/W2155651153","https://openalex.org/W2161694911","https://openalex.org/W2179415026","https://openalex.org/W2753710282","https://openalex.org/W2788962374"],"related_works":["https://openalex.org/W7096097932","https://openalex.org/W2383350887","https://openalex.org/W7098446028","https://openalex.org/W7098542396","https://openalex.org/W2123268668","https://openalex.org/W1996466054","https://openalex.org/W2039346857","https://openalex.org/W2948969539","https://openalex.org/W2291572755","https://openalex.org/W2039787998"],"abstract_inverted_index":{"We":[0],"propose":[1,65],"to":[2,9,16,23,68,81],"adapt":[3],"the":[4,49,58,103],"newly":[5],"emerged":[6],"cache-oblivious":[7,37,70,83,100],"model":[8],"relational":[10],"query":[11],"processing.":[12],"Our":[13,87],"goal":[14],"is":[15,35],"automatically":[17],"achieve":[18],"an":[19],"overall":[20],"performance":[21,104],"comparable":[22],"that":[24,98],"of":[25,54,57,105],"fine-tuned":[26],"algorithms":[27,38],"on":[28,93],"a":[29,61],"multi-level":[30],"memory":[31],"hierarchy.":[32,59],"This":[33],"automaticity":[34],"because":[36],"assume":[39],"no":[40],"knowledge":[41],"about":[42],"any":[43],"specific":[44],"parameter":[45],"values,":[46],"such":[47],"as":[48],"capacity":[50],"and":[51,76,79,90],"block":[52],"size":[53],"each":[55],"level":[56],"As":[60],"first":[62],"step,":[63],"we":[64],"recursive":[66,77],"partitioning":[67],"implement":[69,82],"nested-loop":[71],"joins":[72],"(NLJs)":[73],"without":[74],"indexes,":[75],"clustering":[78],"buffering":[80],"NLJs":[84,101],"with":[85],"indexes.":[86],"theoretical":[88],"results":[89],"empirical":[91],"evaluation":[92],"three":[94],"different":[95],"architectures":[96],"show":[97],"our":[99],"match":[102],"their":[106],"manually":[107],"optimized,":[108],"cache-conscious":[109],"counterparts.":[110]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W1991774299","counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":1}],"updated_date":"2026-11-16T12:05:36.265796","created_date":"2016-06-24T00:00:00"}
