{"id":"https://openalex.org/W3144778742","doi":"https://doi.org/10.1007/s00778-021-00663-8","title":"Micro-architectural analysis of in-memory OLTP: Revisited","display_name":"Micro-architectural analysis of in-memory OLTP: Revisited","publication_year":2021,"publication_date":"2021-03-31","ids":{"openalex":"https://openalex.org/W3144778742","doi":"https://doi.org/10.1007/s00778-021-00663-8","mag":"3144778742"},"language":"en","primary_location":{"id":"doi:10.1007/s00778-021-00663-8","is_oa":true,"landing_page_url":"https://doi.org/10.1007/s00778-021-00663-8","pdf_url":"https://link.springer.com/content/pdf/10.1007/s00778-021-00663-8.pdf","source":{"id":"https://openalex.org/S78926909","display_name":"The VLDB Journal","issn_l":"0949-877X","issn":["0949-877X","1066-8888"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"The VLDB Journal","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://link.springer.com/content/pdf/10.1007/s00778-021-00663-8.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5046034599","display_name":"Utku \u015eirin","orcid":"https://orcid.org/0000-0002-7386-768X"},"institutions":[{"id":"https://openalex.org/I5124864","display_name":"\u00c9cole Polytechnique F\u00e9d\u00e9rale de Lausanne","ror":"https://ror.org/02s376052","country_code":"CH","type":"education","lineage":["https://openalex.org/I2799323385","https://openalex.org/I5124864"]}],"countries":["CH"],"is_corresponding":true,"raw_author_name":"Utku Sirin","raw_affiliation_strings":["EPFL, Lausanne, Switzerland"],"raw_orcid":"https://orcid.org/0000-0002-7386-768X","affiliations":[{"raw_affiliation_string":"EPFL, Lausanne, Switzerland","institution_ids":["https://openalex.org/I5124864"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5061990490","display_name":"P\u0131nar T\u00f6z\u00fcn","orcid":"https://orcid.org/0000-0001-6838-4854"},"institutions":[{"id":"https://openalex.org/I83467386","display_name":"IT University of Copenhagen","ror":"https://ror.org/02309jg23","country_code":"DK","type":"education","lineage":["https://openalex.org/I83467386"]}],"countries":["DK"],"is_corresponding":false,"raw_author_name":"P\u0131nar T\u00f6z\u00fcn","raw_affiliation_strings":["IT University of Copenhagen, Copenhagen, Denmark"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IT University of Copenhagen, Copenhagen, Denmark","institution_ids":["https://openalex.org/I83467386"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5034234312","display_name":"Danica Porobic","orcid":"https://orcid.org/0009-0003-4943-1530"},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Danica Porobic","raw_affiliation_strings":["Oracle, Redwood City, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Oracle, Redwood City, USA","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5003350392","display_name":"Ahmad Yasin","orcid":"https://orcid.org/0000-0002-8891-0513"},"institutions":[{"id":"https://openalex.org/I1343180700","display_name":"Intel (United States)","ror":"https://ror.org/01ek73717","country_code":"US","type":"company","lineage":["https://openalex.org/I1343180700"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Ahmad Yasin","raw_affiliation_strings":["Intel Corporation, Mountain View, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Intel Corporation, Mountain View, USA","institution_ids":["https://openalex.org/I1343180700"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5070907021","display_name":"Anastasia Ailamaki","orcid":null},"institutions":[{"id":"https://openalex.org/I5124864","display_name":"\u00c9cole Polytechnique F\u00e9d\u00e9rale de Lausanne","ror":"https://ror.org/02s376052","country_code":"CH","type":"education","lineage":["https://openalex.org/I2799323385","https://openalex.org/I5124864"]}],"countries":["CH"],"is_corresponding":false,"raw_author_name":"Anastasia Ailamaki","raw_affiliation_strings":["EPFL, Lausanne, Switzerland"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"EPFL, Lausanne, Switzerland","institution_ids":["https://openalex.org/I5124864"]}]}],"institutions":[],"countries_distinct_count":3,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5046034599"],"corresponding_institution_ids":["https://openalex.org/I5124864"],"apc_list":{"value":2290,"currency":"EUR","value_usd":2890},"apc_paid":{"value":2290,"currency":"EUR","value_usd":2890},"fwci":0.8006,"has_fulltext":true,"cited_by_count":5,"citation_normalized_percentile":{"value":0.73470602,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":"30","issue":"4","first_page":"641","last_page":"665"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","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/T11181","display_name":"Advanced Data Storage Technologies","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/T10054","display_name":"Parallel Computing and Optimization Techniques","score":0.9994000196456909,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9973999857902527,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/online-transaction-processing","display_name":"Online transaction processing","score":0.8100336194038391},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.41815829277038574},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.19966983795166016},{"id":"https://openalex.org/keywords/database-transaction","display_name":"Database transaction","score":0.1385742425918579},{"id":"https://openalex.org/keywords/transaction-processing","display_name":"Transaction processing","score":0.11558490991592407}],"concepts":[{"id":"https://openalex.org/C191087605","wikidata":"https://www.wikidata.org/wiki/Q1501395","display_name":"Online transaction processing","level":4,"score":0.8100336194038391},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.41815829277038574},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.19966983795166016},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.1385742425918579},{"id":"https://openalex.org/C72108876","wikidata":"https://www.wikidata.org/wiki/Q844565","display_name":"Transaction processing","level":3,"score":0.11558490991592407}],"mesh":[],"locations_count":4,"locations":[{"id":"doi:10.1007/s00778-021-00663-8","is_oa":true,"landing_page_url":"https://doi.org/10.1007/s00778-021-00663-8","pdf_url":"https://link.springer.com/content/pdf/10.1007/s00778-021-00663-8.pdf","source":{"id":"https://openalex.org/S78926909","display_name":"The VLDB Journal","issn_l":"0949-877X","issn":["0949-877X","1066-8888"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"The VLDB Journal","raw_type":"journal-article"},{"id":"pmh:oai:pure.atira.dk:openaire/7e80637d-d0a2-408a-9039-5af17fc21145","is_oa":true,"landing_page_url":"https://pure.itu.dk/portal/da/publications/7e80637d-d0a2-408a-9039-5af17fc21145","pdf_url":null,"source":{"id":"https://openalex.org/S4377196680","display_name":"IT University Of Copenhagen (IT University of Copenhagen)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I83467386","host_organization_name":"IT University of Copenhagen","host_organization_lineage":["https://openalex.org/I83467386"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Sirin, U, T\u00f6z\u00fcn, P, Porobic, D, Yasin, A & Ailamaki, A 2021, 'Micro-architectural analysis of in-memory OLTP: Revisited', The VLDB Journal, vol. 30, no. 4, pp. 641-665. https://doi.org/10.1007/s00778-021-00663-8","raw_type":"info:eu-repo/semantics/publishedVersion"},{"id":"pmh:oai:infoscience.epfl.ch:284817","is_oa":true,"landing_page_url":"http://infoscience.epfl.ch/record/284817","pdf_url":null,"source":{"id":"https://openalex.org/S4306400487","display_name":"Infoscience (Ecole Polytechnique F\u00e9d\u00e9rale de Lausanne)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"research article"},{"id":"pmh:oai:pure.atira.dk:publications/7e80637d-d0a2-408a-9039-5af17fc21145","is_oa":true,"landing_page_url":"https://link.springer.com/article/10.1007/s00778-021-00663-8","pdf_url":null,"source":{"id":"https://openalex.org/S4377196680","display_name":"IT University Of Copenhagen (IT University of Copenhagen)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I83467386","host_organization_name":"IT University of Copenhagen","host_organization_lineage":["https://openalex.org/I83467386"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Sirin, U, T\u00f6z\u00fcn, P, Porobic, D, Yasin, A & Ailamaki, A 2021, 'Micro-architectural analysis of in-memory OLTP: Revisited', The VLDB Journal, vol. 30, no. 4, pp. 641-665. https://doi.org/10.1007/s00778-021-00663-8","raw_type":"info:eu-repo/semantics/publishedVersion"}],"best_oa_location":{"id":"doi:10.1007/s00778-021-00663-8","is_oa":true,"landing_page_url":"https://doi.org/10.1007/s00778-021-00663-8","pdf_url":"https://link.springer.com/content/pdf/10.1007/s00778-021-00663-8.pdf","source":{"id":"https://openalex.org/S78926909","display_name":"The VLDB Journal","issn_l":"0949-877X","issn":["0949-877X","1066-8888"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"The VLDB Journal","raw_type":"journal-article"},"sustainable_development_goals":[{"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9","score":0.47999998927116394}],"awards":[{"id":"https://openalex.org/G393940262","display_name":"Transforming Raw Data into Information through Virtualization","funder_award_id":"617508","funder_id":"https://openalex.org/F4320320300","funder_display_name":"European Commission"},{"id":"https://openalex.org/G7435325732","display_name":"Workload- and hardware-aware transaction processing","funder_award_id":"146407","funder_id":"https://openalex.org/F4320320924","funder_display_name":"Schweizerischer Nationalfonds zur F\u00f6rderung der Wissenschaftlichen Forschung"},{"id":"https://openalex.org/G993971353","display_name":null,"funder_award_id":"200021","funder_id":"https://openalex.org/F4320320924","funder_display_name":"Schweizerischer Nationalfonds zur F\u00f6rderung der Wissenschaftlichen Forschung"}],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"},{"id":"https://openalex.org/F4320320300","display_name":"European Commission","ror":"https://ror.org/00k4n6c32"},{"id":"https://openalex.org/F4320320915","display_name":"\u00c9cole Polytechnique F\u00e9d\u00e9rale de Lausanne","ror":"https://ror.org/02s376052"},{"id":"https://openalex.org/F4320320924","display_name":"Schweizerischer Nationalfonds zur F\u00f6rderung der Wissenschaftlichen Forschung","ror":"https://ror.org/00yjd3n13"}],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W3144778742.pdf","grobid_xml":"https://content.openalex.org/works/W3144778742.grobid-xml"},"referenced_works_count":58,"referenced_works":["https://openalex.org/W1955594754","https://openalex.org/W1963674762","https://openalex.org/W1982752205","https://openalex.org/W2008441771","https://openalex.org/W2013062050","https://openalex.org/W2014977566","https://openalex.org/W2020129682","https://openalex.org/W2036895660","https://openalex.org/W2038057969","https://openalex.org/W2050078636","https://openalex.org/W2054075931","https://openalex.org/W2067354926","https://openalex.org/W2101995353","https://openalex.org/W2106771621","https://openalex.org/W2126603366","https://openalex.org/W2135232880","https://openalex.org/W2141181087","https://openalex.org/W2141710443","https://openalex.org/W2143522680","https://openalex.org/W2155350341","https://openalex.org/W2165663045","https://openalex.org/W2170952599","https://openalex.org/W2172190421","https://openalex.org/W2272535669","https://openalex.org/W2290349115","https://openalex.org/W2394555589","https://openalex.org/W2397097813","https://openalex.org/W2397360326","https://openalex.org/W2398519237","https://openalex.org/W2406543354","https://openalex.org/W2435606122","https://openalex.org/W2495124393","https://openalex.org/W2561036834","https://openalex.org/W2566979091","https://openalex.org/W2610776462","https://openalex.org/W2612080955","https://openalex.org/W2612473142","https://openalex.org/W2763683179","https://openalex.org/W2889144945","https://openalex.org/W2903881938","https://openalex.org/W2907714110","https://openalex.org/W2908321983","https://openalex.org/W2926642061","https://openalex.org/W2945486614","https://openalex.org/W2949157610","https://openalex.org/W2951202371","https://openalex.org/W2962771342","https://openalex.org/W2996353500","https://openalex.org/W2997451313","https://openalex.org/W3011145936","https://openalex.org/W3013171512","https://openalex.org/W3013798096","https://openalex.org/W3103567827","https://openalex.org/W3138135046","https://openalex.org/W4230886184","https://openalex.org/W4238420657","https://openalex.org/W4239323686","https://openalex.org/W4256143806"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2899084033","https://openalex.org/W2748952813","https://openalex.org/W4249709097","https://openalex.org/W2084383859","https://openalex.org/W54400829","https://openalex.org/W2185554786","https://openalex.org/W2612731889","https://openalex.org/W2385555572","https://openalex.org/W2285495824"],"abstract_inverted_index":{"Abstract":[0],"Micro-architectural":[1],"behavior":[2,82,126,138,161],"of":[3,19,127,139,168,219,228,239],"traditional":[4,24,249],"disk-based":[5,95,117,140,163,250],"online":[6],"transaction":[7],"processing":[8,91],"(OLTP)":[9],"systems":[10,26,104,130,141,204],"has":[11],"been":[12],"investigated":[13],"extensively":[14],"over":[15],"the":[16,29,37,42,50,124,137,152,169,181,186,191,195,207,211,217,229,240],"past":[17],"couple":[18],"decades.":[20],"Results":[21],"show":[22,148],"that":[23,102],"OLTP":[25,34,85,144,156],"mostly":[27],"under-utilize":[28],"available":[30],"micro-architectural":[31,81,106,125,160],"resources.":[32],"In-memory":[33],"systems,":[35],"on":[36,86,123],"other":[38],"hand,":[39],"process":[40],"all":[41,151],"data":[43,63,112,183,221],"in":[44,80,194,213],"main-memory":[45],"and,":[46],"therefore,":[47],"can":[48,205],"omit":[49],"buffer":[51],"pool.":[52],"Furthermore,":[53],"they":[54,69],"usually":[55,71],"adopt":[56],"more":[57,165],"lightweight":[58],"concurrency":[59],"control":[60],"mechanisms,":[61],"cache-conscious":[62],"structures,":[64],"and":[65,111,133,237,251],"cleaner":[66],"codebases":[67],"since":[68],"are":[70,190,232,243],"designed":[72,202],"from":[73,185],"scratch.":[74],"Hence,":[75],"we":[76,100],"expect":[77,101],"significant":[78],"differences":[79],"when":[83,142],"running":[84,143],"platforms":[87],"optimized":[88],"for":[89,247],"in-memory":[90,103,128,155,203,254],"as":[92,109],"opposed":[93],"to":[94,136,162,173,234,245],"database":[96,129],"systems.":[97,118],"In":[98],"particular,":[99],"exploit":[105],"features":[107],"such":[108],"instruction":[110,177,208,214],"caches":[113],"significantly":[114],"better":[115],"than":[116,166],"This":[119],"paper":[120],"sheds":[121],"light":[122],"by":[131],"analyzing":[132],"contrasting":[134],"it":[135],"workloads.":[145],"The":[146],"results":[147],"that,":[149],"despite":[150],"design":[153],"changes,":[154],"exhibits":[157],"very":[158],"similar":[159],"OLTP:":[164],"half":[167],"execution":[170,197],"time":[171],"goes":[172],"memory":[174],"stalls":[175,215,246],"where":[176],"cache":[178,188,209],"misses":[179,184],"or":[180],"long-latency":[182],"last-level":[187],"(LLC)":[189],"dominant":[192],"factors":[193],"overall":[196],"time.":[198],"Even":[199],"though":[200],"ground-up":[201],"eliminate":[206],"misses,":[210],"reduction":[212],"amplifies":[216],"impact":[218],"LLC":[220],"misses.":[222],"As":[223],"a":[224],"result,":[225],"only":[226],"30%":[227],"CPU":[230,241],"cycles":[231,242],"used":[233],"retire":[235],"instructions,":[236],"70%":[238],"wasted":[244],"both":[248],"new":[252],"generation":[253],"OLTP.":[255]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":1}],"updated_date":"2026-03-27T05:58:40.876381","created_date":"2025-10-10T00:00:00"}