{"id":"https://openalex.org/W1977072432","doi":"https://doi.org/10.1145/1363189.1363193","title":"A general framework for improving query processing performance on multi-level memory hierarchies","display_name":"A general framework for improving query processing performance on multi-level memory hierarchies","publication_year":2007,"publication_date":"2007-06-15","ids":{"openalex":"https://openalex.org/W1977072432","doi":"https://doi.org/10.1145/1363189.1363193","mag":"1977072432"},"language":"en","primary_location":{"id":"doi:10.1145/1363189.1363193","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1363189.1363193","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 3rd international workshop on Data management on new hardware","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/A5039946576","display_name":"Bingsheng He","orcid":"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":true,"raw_author_name":"Bingsheng He","raw_affiliation_strings":["Hong Kong Univ. of Science and Technology","Hong Kong University of Science & Technology"],"affiliations":[{"raw_affiliation_string":"Hong Kong Univ. 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":"middle","author":{"id":"https://openalex.org/A5100599394","display_name":"Yinan Li","orcid":"https://orcid.org/0000-0001-7137-7823"},"institutions":[{"id":"https://openalex.org/I20231570","display_name":"Peking University","ror":"https://ror.org/02v51f717","country_code":"CN","type":"education","lineage":["https://openalex.org/I20231570"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yinan Li","raw_affiliation_strings":["Peking University"],"affiliations":[{"raw_affiliation_string":"Peking University","institution_ids":["https://openalex.org/I20231570"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5034823616","display_name":"Qiong Luo","orcid":"https://orcid.org/0000-0002-2861-9492"},"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 Univ. of Science and Technology","Hong Kong University of Science & Technology"],"affiliations":[{"raw_affiliation_string":"Hong Kong Univ. 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/A5106446263","display_name":"Dongqing Yang","orcid":null},"institutions":[{"id":"https://openalex.org/I20231570","display_name":"Peking University","ror":"https://ror.org/02v51f717","country_code":"CN","type":"education","lineage":["https://openalex.org/I20231570"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Dongqing Yang","raw_affiliation_strings":["Peking University"],"affiliations":[{"raw_affiliation_string":"Peking University","institution_ids":["https://openalex.org/I20231570"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5039946576"],"corresponding_institution_ids":["https://openalex.org/I200769079"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.10216235,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"9"},"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.9993000030517578,"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.9993000030517578,"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.9990000128746033,"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.9984999895095825,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8714268207550049},{"id":"https://openalex.org/keywords/joins","display_name":"Joins","score":0.747132420539856},{"id":"https://openalex.org/keywords/hash-function","display_name":"Hash function","score":0.5932404398918152},{"id":"https://openalex.org/keywords/memory-hierarchy","display_name":"Memory hierarchy","score":0.5555567145347595},{"id":"https://openalex.org/keywords/hierarchy","display_name":"Hierarchy","score":0.5073511004447937},{"id":"https://openalex.org/keywords/performance-improvement","display_name":"Performance improvement","score":0.4870336651802063},{"id":"https://openalex.org/keywords/memory-management","display_name":"Memory management","score":0.42628592252731323},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.35885319113731384},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.22011792659759521},{"id":"https://openalex.org/keywords/overlay","display_name":"Overlay","score":0.18333742022514343},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.10455310344696045}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8714268207550049},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.747132420539856},{"id":"https://openalex.org/C99138194","wikidata":"https://www.wikidata.org/wiki/Q183427","display_name":"Hash function","level":2,"score":0.5932404398918152},{"id":"https://openalex.org/C2778100165","wikidata":"https://www.wikidata.org/wiki/Q1589327","display_name":"Memory hierarchy","level":3,"score":0.5555567145347595},{"id":"https://openalex.org/C31170391","wikidata":"https://www.wikidata.org/wiki/Q188619","display_name":"Hierarchy","level":2,"score":0.5073511004447937},{"id":"https://openalex.org/C2778915421","wikidata":"https://www.wikidata.org/wiki/Q3643177","display_name":"Performance improvement","level":2,"score":0.4870336651802063},{"id":"https://openalex.org/C176649486","wikidata":"https://www.wikidata.org/wiki/Q2308807","display_name":"Memory management","level":3,"score":0.42628592252731323},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.35885319113731384},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.22011792659759521},{"id":"https://openalex.org/C136085584","wikidata":"https://www.wikidata.org/wiki/Q910289","display_name":"Overlay","level":2,"score":0.18333742022514343},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.10455310344696045},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"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/C21547014","wikidata":"https://www.wikidata.org/wiki/Q1423657","display_name":"Operations management","level":1,"score":0.0},{"id":"https://openalex.org/C115537543","wikidata":"https://www.wikidata.org/wiki/Q165596","display_name":"Cache","level":2,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1145/1363189.1363193","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1363189.1363193","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 3rd international workshop on Data management on new hardware","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.108.8325","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.108.8325","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cse.ust.hk/catalac/papers/framework_tr.pdf","raw_type":"text"},{"id":"pmh:oai:repository.hkust.edu.hk:1783.1-48151","is_oa":false,"landing_page_url":"http://repository.hkust.edu.hk/ir/Record/1783.1-48151","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,"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":[],"awards":[{"id":"https://openalex.org/G4613725787","display_name":null,"funder_award_id":"DAG05/06.EG11HKUST6263/04E617206","funder_id":"https://openalex.org/F4320321592","funder_display_name":"Research Grants Council, University Grants Committee"}],"funders":[{"id":"https://openalex.org/F4320321592","display_name":"Research Grants Council, University Grants Committee","ror":"https://ror.org/00djwmt25"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":35,"referenced_works":["https://openalex.org/W1568945110","https://openalex.org/W1570477871","https://openalex.org/W1645807896","https://openalex.org/W1989622633","https://openalex.org/W1991774299","https://openalex.org/W1994085050","https://openalex.org/W2014515453","https://openalex.org/W2015463411","https://openalex.org/W2054052779","https://openalex.org/W2059385032","https://openalex.org/W2095875205","https://openalex.org/W2097125969","https://openalex.org/W2098130516","https://openalex.org/W2100099053","https://openalex.org/W2105156747","https://openalex.org/W2105220449","https://openalex.org/W2116730320","https://openalex.org/W2122048769","https://openalex.org/W2123268668","https://openalex.org/W2127902590","https://openalex.org/W2130642985","https://openalex.org/W2135552269","https://openalex.org/W2137077706","https://openalex.org/W2141138026","https://openalex.org/W2142072070","https://openalex.org/W2150054597","https://openalex.org/W2155651153","https://openalex.org/W2160404300","https://openalex.org/W2171543585","https://openalex.org/W2179415026","https://openalex.org/W2914512445","https://openalex.org/W3213397929","https://openalex.org/W4205806386","https://openalex.org/W4247806688","https://openalex.org/W6686057848"],"related_works":["https://openalex.org/W4389476357","https://openalex.org/W2465781960","https://openalex.org/W2580538010","https://openalex.org/W3012526378","https://openalex.org/W2116516372","https://openalex.org/W1500809736","https://openalex.org/W2346051120","https://openalex.org/W2115160022","https://openalex.org/W4253099060","https://openalex.org/W2108925206"],"abstract_inverted_index":{"We":[0],"propose":[1],"a":[2,73],"general":[3],"framework":[4,79],"for":[5,28],"improving":[6],"the":[7,20,33,48,56,82,98,101],"query":[8,29],"processing":[9],"performance":[10,26,65,70,84],"on":[11],"multi-level":[12],"memory":[13,21,34,64],"hierarchies.":[14],"Our":[15,94],"motivation":[16],"is":[17,23],"that":[18],"(1)":[19],"hierarchy":[22,35],"an":[24],"important":[25],"factor":[27],"processing,":[30],"(2)":[31],"both":[32],"and":[36,43,45,67,91],"database":[37],"systems":[38],"are":[39],"becoming":[40],"increasingly":[41],"complex":[42],"diverse,":[44],"(3)":[46],"increasing":[47],"amount":[49],"of":[50,63,85,100],"tuning":[51,66],"does":[52],"not":[53],"always":[54],"improve":[55,81],"performance.":[57],"Therefore,":[58],"we":[59,76],"categorize":[60],"multiple":[61],"levels":[62],"quantify":[68],"their":[69],"impacts.":[71],"As":[72],"case":[74],"study,":[75],"use":[77],"this":[78],"to":[80],"in-memory":[83],"storage":[86],"models,":[87],"B+-trees,":[88],"nested-loop":[89],"joins":[90],"hash":[92],"joins.":[93],"empirical":[95],"evaluation":[96],"verifies":[97],"usefulness":[99],"proposed":[102],"framework.":[103]},"counts_by_year":[],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}