{"id":"https://openalex.org/W4361854164","doi":"https://doi.org/10.1109/tpds.2023.3262782","title":"Exploring Fine-Grained In-Memory Database Performance for Modern CPUs","display_name":"Exploring Fine-Grained In-Memory Database Performance for Modern CPUs","publication_year":2023,"publication_date":"2023-01-01","ids":{"openalex":"https://openalex.org/W4361854164","doi":"https://doi.org/10.1109/tpds.2023.3262782"},"language":"en","primary_location":{"id":"doi:10.1109/tpds.2023.3262782","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tpds.2023.3262782","pdf_url":null,"source":{"id":"https://openalex.org/S97130795","display_name":"IEEE Transactions on Parallel and Distributed Systems","issn_l":"1045-9219","issn":["1045-9219","1558-2183","2161-9883"],"is_oa":false,"is_in_doaj":false,"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":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Parallel and Distributed Systems","raw_type":"journal-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/A5070995801","display_name":"Zhuan Liu","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Zhuan Liu","raw_affiliation_strings":["Intel Corp, China"],"raw_orcid":"https://orcid.org/0000-0001-7269-0280","affiliations":[{"raw_affiliation_string":"Intel Corp, China","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5084801199","display_name":"Ruichen Han","orcid":"https://orcid.org/0009-0008-8561-3979"},"institutions":[{"id":"https://openalex.org/I78988378","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92","country_code":"CN","type":"education","lineage":["https://openalex.org/I78988378"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Ruichen Han","raw_affiliation_strings":["School of Information, Renmin University of China, Beijing, China"],"raw_orcid":"https://orcid.org/0009-0008-8561-3979","affiliations":[{"raw_affiliation_string":"School of Information, Renmin University of China, Beijing, China","institution_ids":["https://openalex.org/I78988378"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100644855","display_name":"Yansong Zhang","orcid":"https://orcid.org/0000-0003-2198-0987"},"institutions":[{"id":"https://openalex.org/I141301092","display_name":"China Meteorological Administration","ror":"https://ror.org/00bx3rb98","country_code":"CN","type":"government","lineage":["https://openalex.org/I141301092"]},{"id":"https://openalex.org/I78988378","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92","country_code":"CN","type":"education","lineage":["https://openalex.org/I78988378"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yansong Zhang","raw_affiliation_strings":["National Satellite Meteorological Center of China, Beijing, China","School of Information, Renmin University of China, Beijing, China"],"raw_orcid":"https://orcid.org/0000-0003-2198-0987","affiliations":[{"raw_affiliation_string":"National Satellite Meteorological Center of China, Beijing, China","institution_ids":["https://openalex.org/I141301092"]},{"raw_affiliation_string":"School of Information, Renmin University of China, Beijing, China","institution_ids":["https://openalex.org/I78988378"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100433777","display_name":"Yu Zhang","orcid":"https://orcid.org/0009-0005-8048-9612"},"institutions":[{"id":"https://openalex.org/I141301092","display_name":"China Meteorological Administration","ror":"https://ror.org/00bx3rb98","country_code":"CN","type":"government","lineage":["https://openalex.org/I141301092"]},{"id":"https://openalex.org/I78988378","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92","country_code":"CN","type":"education","lineage":["https://openalex.org/I78988378"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yu Zhang","raw_affiliation_strings":["National Satellite Meteorological Center of China, Beijing, China","School of Information, Renmin University of China, Beijing, China"],"raw_orcid":"https://orcid.org/0009-0005-8048-9612","affiliations":[{"raw_affiliation_string":"National Satellite Meteorological Center of China, Beijing, China","institution_ids":["https://openalex.org/I141301092"]},{"raw_affiliation_string":"School of Information, Renmin University of China, Beijing, China","institution_ids":["https://openalex.org/I78988378"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5102896373","display_name":"Xi Tang","orcid":"https://orcid.org/0009-0006-7235-5099"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Xi Tang","raw_affiliation_strings":["Intel Corp, China"],"raw_orcid":"https://orcid.org/0009-0006-7235-5099","affiliations":[{"raw_affiliation_string":"Intel Corp, China","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5027634839","display_name":"Gang Deng","orcid":"https://orcid.org/0009-0004-4655-505X"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Gang Deng","raw_affiliation_strings":["Intel Corp, China"],"raw_orcid":"https://orcid.org/0009-0004-4655-505X","affiliations":[{"raw_affiliation_string":"Intel Corp, China","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5009853331","display_name":"Tao Zhong","orcid":"https://orcid.org/0009-0008-8327-8345"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Tao Zhong","raw_affiliation_strings":["Intel Corp, China"],"raw_orcid":"https://orcid.org/0009-0008-8327-8345","affiliations":[{"raw_affiliation_string":"Intel Corp, China","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5046346225","display_name":"Roman Dementiev","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Roman Dementiev","raw_affiliation_strings":["Intel Corp, China"],"raw_orcid":"https://orcid.org/0009-0009-9183-2673","affiliations":[{"raw_affiliation_string":"Intel Corp, China","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100640072","display_name":"Yunfei Lu","orcid":"https://orcid.org/0009-0004-5324-7493"},"institutions":[{"id":"https://openalex.org/I2250955327","display_name":"Huawei Technologies (China)","ror":"https://ror.org/00cmhce21","country_code":"CN","type":"company","lineage":["https://openalex.org/I2250955327"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yunfei Lu","raw_affiliation_strings":["Huawei Technologies Co., Ltd, Hangzhou, China"],"raw_orcid":"https://orcid.org/0009-0004-5324-7493","affiliations":[{"raw_affiliation_string":"Huawei Technologies Co., Ltd, Hangzhou, China","institution_ids":["https://openalex.org/I2250955327"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5076215964","display_name":"Mingjian Que","orcid":"https://orcid.org/0009-0009-8351-515X"},"institutions":[{"id":"https://openalex.org/I2250955327","display_name":"Huawei Technologies (China)","ror":"https://ror.org/00cmhce21","country_code":"CN","type":"company","lineage":["https://openalex.org/I2250955327"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Mingjian Que","raw_affiliation_strings":["Huawei Technologies Co., Ltd, Hangzhou, China"],"raw_orcid":"https://orcid.org/0009-0009-8351-515X","affiliations":[{"raw_affiliation_string":"Huawei Technologies Co., Ltd, Hangzhou, China","institution_ids":["https://openalex.org/I2250955327"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.6441,"has_fulltext":false,"cited_by_count":4,"citation_normalized_percentile":{"value":0.86439095,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"16"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9993000030517578,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9993000030517578,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9919999837875366,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9918000102043152,"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.8552499413490295},{"id":"https://openalex.org/keywords/cache","display_name":"Cache","score":0.7630001902580261},{"id":"https://openalex.org/keywords/x86","display_name":"x86","score":0.7028988003730774},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.6491803526878357},{"id":"https://openalex.org/keywords/cache-pollution","display_name":"Cache pollution","score":0.6316277980804443},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.602415919303894},{"id":"https://openalex.org/keywords/cache-coloring","display_name":"Cache coloring","score":0.6013869047164917},{"id":"https://openalex.org/keywords/cache-algorithms","display_name":"Cache algorithms","score":0.570186197757721},{"id":"https://openalex.org/keywords/smart-cache","display_name":"Smart Cache","score":0.5618924498558044},{"id":"https://openalex.org/keywords/cpu-cache","display_name":"CPU cache","score":0.5529298782348633},{"id":"https://openalex.org/keywords/page-cache","display_name":"Page cache","score":0.48967817425727844},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.4248397946357727},{"id":"https://openalex.org/keywords/pipeline-burst-cache","display_name":"Pipeline burst cache","score":0.4233935475349426},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.06428703665733337}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8552499413490295},{"id":"https://openalex.org/C115537543","wikidata":"https://www.wikidata.org/wiki/Q165596","display_name":"Cache","level":2,"score":0.7630001902580261},{"id":"https://openalex.org/C170723468","wikidata":"https://www.wikidata.org/wiki/Q182933","display_name":"x86","level":3,"score":0.7028988003730774},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.6491803526878357},{"id":"https://openalex.org/C113166858","wikidata":"https://www.wikidata.org/wiki/Q5015981","display_name":"Cache pollution","level":5,"score":0.6316277980804443},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.602415919303894},{"id":"https://openalex.org/C201148951","wikidata":"https://www.wikidata.org/wiki/Q5015976","display_name":"Cache coloring","level":4,"score":0.6013869047164917},{"id":"https://openalex.org/C38556500","wikidata":"https://www.wikidata.org/wiki/Q13404475","display_name":"Cache algorithms","level":4,"score":0.570186197757721},{"id":"https://openalex.org/C167713795","wikidata":"https://www.wikidata.org/wiki/Q352090","display_name":"Smart Cache","level":5,"score":0.5618924498558044},{"id":"https://openalex.org/C189783530","wikidata":"https://www.wikidata.org/wiki/Q352090","display_name":"CPU cache","level":3,"score":0.5529298782348633},{"id":"https://openalex.org/C36340418","wikidata":"https://www.wikidata.org/wiki/Q7124288","display_name":"Page cache","level":5,"score":0.48967817425727844},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.4248397946357727},{"id":"https://openalex.org/C157547923","wikidata":"https://www.wikidata.org/wiki/Q7197276","display_name":"Pipeline burst cache","level":5,"score":0.4233935475349426},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.06428703665733337},{"id":"https://openalex.org/C13280743","wikidata":"https://www.wikidata.org/wiki/Q131089","display_name":"Geodesy","level":1,"score":0.0},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/tpds.2023.3262782","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tpds.2023.3262782","pdf_url":null,"source":{"id":"https://openalex.org/S97130795","display_name":"IEEE Transactions on Parallel and Distributed Systems","issn_l":"1045-9219","issn":["1045-9219","1558-2183","2161-9883"],"is_oa":false,"is_in_doaj":false,"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":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Parallel and Distributed Systems","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":24,"referenced_works":["https://openalex.org/W1194153933","https://openalex.org/W1987238352","https://openalex.org/W2005684205","https://openalex.org/W2066860750","https://openalex.org/W2072541977","https://openalex.org/W2080723374","https://openalex.org/W2086977914","https://openalex.org/W2097880677","https://openalex.org/W2106911865","https://openalex.org/W2295615355","https://openalex.org/W2296150852","https://openalex.org/W2440477515","https://openalex.org/W2612080955","https://openalex.org/W2765206444","https://openalex.org/W2803861595","https://openalex.org/W2889286927","https://openalex.org/W2898401919","https://openalex.org/W2907714110","https://openalex.org/W3032789239","https://openalex.org/W3046551054","https://openalex.org/W3176391989","https://openalex.org/W4281718197","https://openalex.org/W4282585030","https://openalex.org/W6697530613"],"related_works":["https://openalex.org/W2141363922","https://openalex.org/W2399041033","https://openalex.org/W2072955902","https://openalex.org/W2162744059","https://openalex.org/W2088347047","https://openalex.org/W3140186264","https://openalex.org/W12620440","https://openalex.org/W2000122388","https://openalex.org/W1576527819","https://openalex.org/W2397009038"],"abstract_inverted_index":{"Modern":[0],"CPUs":[1,26,95,162,200,210,236,241,252],"keep":[2],"integrating":[3],"more":[4,110],"cores":[5,111,263],"and":[6,21,30,37,46,54,74,112,136,170,174,189,208,224,242,276],"large":[7,34,38,51,148],"size":[8,40,48,57,115,146],"cache,":[9],"which":[10],"is":[11,68,163],"beneficial":[12],"for":[13,64,70,271],"in-memory":[14,60,71,83,272],"databases":[15,61],"to":[16,86,96,133,166,238,249],"improve":[17],"parallel":[18],"processing":[19,229],"power":[20],"cache":[22,39,47,56,114,126,137,143,172,266],"locality.":[23],"While":[24],"state-of-the-art":[25],"have":[27],"diverse":[28,167],"architectures":[29,67,101,127,169],"roadmaps":[31,260],"such":[32],"as":[33],"core":[35,44,52,134],"count":[36,45,53,135],"(AMD":[41],"x86),":[42,50],"moderate":[43,55,145],"(intel":[49],"(ARM),":[58],"exploring":[59],"performance":[62,89,159,191],"characteristics":[63],"different":[65,94,161,175],"CPU":[66,99,168,195,259],"important":[69,130],"database":[72,84,273],"designs":[73],"optimizations.":[75],"In":[76],"this":[77],"paper,":[78],"we":[79,120],"develop":[80],"a":[81],"fine-grained":[82],"benchmark":[85,217],"evaluate":[87],"the":[88,124,139,215,243],"of":[90,177,219,261],"each":[91,178],"operator":[92,158,179],"on":[93,160,233],"explore":[97],"how":[98],"hardware":[100,196],"influence":[102],"performance.":[103],"Different":[104],"from":[105],"well":[106,232],"known":[107],"conclusions":[108],"that":[109,123,156,222],"larger":[113],"can":[116],"achieve":[117],"higher":[118],"performance,":[119],"find":[121],"out":[122],"micro":[125,171],"play":[128],"an":[129],"role":[131],"opposite":[132],"size,":[138],"shared":[140],"monolithic":[141],"L3":[142,150],"with":[144,186,227],"beats":[147],"disaggregated":[149],"cache.":[151],"The":[152,258],"experiments":[153,218],"also":[154],"show":[155],"predicting":[157],"difficult":[164],"according":[165],"architectures,":[173],"implementations":[176],"are":[180],"not":[181],"always":[182],"high":[183],"or":[184,264],"low":[185],"interleaved":[187],"strong":[188],"weak":[190],"regions":[192],"influenced":[193],"by":[194],"architectures.":[197],"Intel":[198],"x86":[199,207,235,240,251,256],"represent":[201,211],"cache-centric":[202],"processor":[203,213],"design,":[204,214],"while":[205],"AMD":[206,239,250],"ARM":[209],"computing-centric":[212],"OLAP":[216,225],"SSB":[220],"discover":[221],"OmniSciDB":[223],"Accelerator":[226],"vector-wise":[228],"model":[230],"performs":[231],"intel":[234,255],"compared":[237],"JIT":[244],"compliant":[245],"based":[246],"Hyper":[247],"prefers":[248],"rather":[253],"than":[254],"CPUs.":[257],"increasing":[262],"improving":[265],"locality":[267],"should":[268],"be":[269],"considered":[270],"algorithm":[274],"design":[275],"platform":[277],"selection.":[278]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":1}],"updated_date":"2026-03-27T05:58:40.876381","created_date":"2025-10-10T00:00:00"}