{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,7,9]],"date-time":"2026-07-09T06:04:00Z","timestamp":1783577040425,"version":"3.55.0"},"reference-count":75,"publisher":"Association for Computing Machinery (ACM)","issue":"11","content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2025,7]]},"abstract":"<jats:p>Memory channel bandwidth imposes an upper bound on the performance of online transaction processing (OLTP) on in-memory database management systems (DBMS). Emerging processing-in-memory (PIM) hardware has the potential to overcome this barrier by using small cores in DRAM chips that can read and process data in situ, thereby avoiding moving these data across memory channels. However, na\u00efvely offloading all database components to PIM does not solve the problem due to the characteristics of software components and the limitations of PIM hardware.<\/jats:p>\n          <jats:p>In this paper, we present OLTPim, the first end-to-end OLTP DBMS designed for PIM systems. We build a formalized model for the affinity of each database operation towards PIM and use it to decide the partitioning of components on different types of memory. We also design a lightweight batching algorithm to overcome the large PIM control latency while minimizing the batching overhead. We implement and evaluate OLTPim on the latest PIM system from UPMEM with 64 worker threads and 2048 PIM modules. Our results show that OLTPim achieves up to 1.71\u00d7 throughput and up to 6.14\u00d7 less per-transaction memory channel traffic over MosaicDB, a state-of-the-art in-memory system.<\/jats:p>","DOI":"10.14778\/3749646.3749690","type":"journal-article","created":{"date-parts":[[2025,9,4]],"date-time":"2025-09-04T17:55:06Z","timestamp":1757008506000},"page":"4241-4254","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":3,"title":["No Cap, This Memory Slaps: Breaking through the Memory Wall of Transactional Database Systems with Processing-in-Memory"],"prefix":"10.14778","volume":"18","author":[{"given":"Hyoungjoo","family":"Kim","sequence":"first","affiliation":[{"name":"Carnegie Mellon University"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Yiwei","family":"Zhao","sequence":"additional","affiliation":[{"name":"Carnegie Mellon University"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Andrew","family":"Pavlo","sequence":"additional","affiliation":[{"name":"Carnegie Mellon University"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Phillip B.","family":"Gibbons","sequence":"additional","affiliation":[{"name":"Carnegie Mellon University"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"320","published-online":{"date-parts":[[2025,9,4]]},"reference":[{"key":"e_1_2_1_1_1","doi-asserted-by":"publisher","DOI":"10.1145\/2749469.2750386"},{"key":"e_1_2_1_2_1","volume-title":"Adaptive Query Compilation with Processing-in-Memory. In 2023 IEEE 39th International Conference on Data Engineering Workshops (ICDEW). 191\u2013197","author":"Baumstark Alexander","year":"2023","unstructured":"Alexander Baumstark, Muhammad Attahir Jibril, and Kai-Uwe Sattler. 2023. Adaptive Query Compilation with Processing-in-Memory. In 2023 IEEE 39th International Conference on Data Engineering Workshops (ICDEW). 191\u2013197."},{"key":"e_1_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.1145\/3592980.3595312"},{"key":"e_1_2_1_4_1","doi-asserted-by":"publisher","DOI":"10.1145\/3514221.3517876"},{"key":"e_1_2_1_5_1","volume-title":"Processing Multi-Layer Perceptrons In-Memory. In 2024 IEEE Workshop on Signal Processing Systems (SiPS). 7\u201312","author":"Carrinho Pedro","year":"2024","unstructured":"Pedro Carrinho, Oscar Ferraz, Jo\u00e3o Dinis Ferreira, Yann Falevoz, Vitor Silva, and Gabriel Falcao. 2024. Processing Multi-Layer Perceptrons In-Memory. In 2024 IEEE Workshop on Signal Processing Systems (SiPS). 7\u201312."},{"key":"e_1_2_1_6_1","doi-asserted-by":"publisher","DOI":"10.1109\/HPCA61900.2025.00047"},{"key":"e_1_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.1109\/DAC56929.2023.10247915"},{"key":"e_1_2_1_8_1","doi-asserted-by":"publisher","DOI":"10.1145\/3649329.3658266"},{"key":"e_1_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.1145\/3490148.3538591"},{"key":"e_1_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.1145\/3323165.3323191"},{"key":"e_1_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.1109\/IISWC.2015.32"},{"key":"e_1_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.1145\/1807128.1807152"},{"key":"e_1_2_1_13_1","unstructured":"Transaction Processing Performance Council. 2010. TPC Benchmark C. https:\/\/www.tpc.org\/TPC_Documents_Current_Versions\/pdf\/tpc-c_v5.11.0.pdf. Accessed on 2025.07.13."},{"key":"e_1_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.1109\/TCAD.2018.2821565"},{"key":"e_1_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.1145\/3470496.3527431"},{"key":"e_1_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.1145\/2463676.2463710"},{"key":"e_1_2_1_17_1","doi-asserted-by":"publisher","DOI":"10.1145\/2463676.2465295"},{"key":"e_1_2_1_18_1","doi-asserted-by":"publisher","DOI":"10.1561\/9781680833256"},{"key":"e_1_2_1_19_1","doi-asserted-by":"crossref","unstructured":"Dina Fakhry Mohamed Abdelsalam M Watheq El-Kharashi and Mona Safar. 2023. An HBM3 Processing-In-Memory Architecture for Security and Data Integrity: Case Study. In Green Sustainability: Towards Innovative Digital Transformation Dalia Magdi Ahmed Abou El-Fetouh Mohamed Mamdouh and Amit Joshi (Eds.). 281\u2013293.","DOI":"10.1007\/978-981-99-4764-5_18"},{"key":"e_1_2_1_20_1","volume-title":"In-Memory Bit Flipping LDPC Decoding. In 2024 32nd European Signal Processing Conference (EUSIPCO). 706\u2013710","author":"Ferraz Oscar","year":"2024","unstructured":"Oscar Ferraz, Gabriel Falcao, and Vitor Silva. 2024. In-Memory Bit Flipping LDPC Decoding. In 2024 32nd European Signal Processing Conference (EUSIPCO). 706\u2013710."},{"key":"e_1_2_1_21_1","volume-title":"Unlocking the Potential of LDPC Decoders with PiM Acceleration. In 2023 57th Asilomar Conference on Signals, Systems, and Computers. 1579\u20131583","author":"Ferraz Oscar","year":"2023","unstructured":"Oscar Ferraz, Yann Falevoz, Vitor Silva, and Gabriel Falcao. 2023. Unlocking the Potential of LDPC Decoders with PiM Acceleration. In 2023 57th Asilomar Conference on Signals, Systems, and Computers. 1579\u20131583."},{"key":"e_1_2_1_22_1","volume-title":"JDBC API tutorial and reference","author":"Fisher Maydene","unstructured":"Maydene Fisher, Jonathan Ellis, Jon Ellis, and Jonathan Bruce. 2003. JDBC API tutorial and reference. Addison-Wesley Professional."},{"key":"e_1_2_1_23_1","unstructured":"Sahar Ghoflsaz Ghinani Jingyao Zhang and Elaheh Sadredini. 2025. Enabling Low-Cost Secure Computing on Untrusted In-Memory Architectures. arXiv:2501.17292 [cs.CR] https:\/\/arxiv.org\/abs\/2501.17292"},{"key":"e_1_2_1_24_1","doi-asserted-by":"publisher","DOI":"10.1145\/3508041"},{"key":"e_1_2_1_25_1","doi-asserted-by":"publisher","DOI":"10.1109\/ACCESS.2022.3174101"},{"key":"e_1_2_1_26_1","doi-asserted-by":"publisher","DOI":"10.1109\/IISWC59245.2023.00030"},{"key":"e_1_2_1_27_1","doi-asserted-by":"publisher","DOI":"10.14778\/1952376.1952381"},{"key":"e_1_2_1_28_1","doi-asserted-by":"publisher","DOI":"10.14778\/3551793.3551833"},{"key":"e_1_2_1_29_1","doi-asserted-by":"publisher","DOI":"10.14778\/3430915.3430932"},{"key":"e_1_2_1_30_1","unstructured":"heavy.ai. 2025. HeavyDB (formerly OmniSciDB). https:\/\/github.com\/heavyai\/heavydb. Accessed on 2025.07.13."},{"key":"e_1_2_1_31_1","doi-asserted-by":"publisher","DOI":"10.1145\/1810479.1810540"},{"key":"e_1_2_1_32_1","unstructured":"heterodb. 2025. PG-Strom Manual. https:\/\/heterodb.github.io\/pg-strom\/. Accessed on 2025.07.13."},{"key":"e_1_2_1_33_1","doi-asserted-by":"publisher","DOI":"10.1145\/3007787.3001159"},{"key":"e_1_2_1_34_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICCD.2016.7753257"},{"key":"e_1_2_1_35_1","doi-asserted-by":"publisher","DOI":"10.14778\/3632093.3632117"},{"key":"e_1_2_1_36_1","doi-asserted-by":"publisher","DOI":"10.1109\/HPCA57654.2024.00029"},{"key":"e_1_2_1_37_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE60146.2024.00300"},{"key":"e_1_2_1_38_1","doi-asserted-by":"publisher","DOI":"10.14778\/2994509.2994512"},{"key":"e_1_2_1_39_1","doi-asserted-by":"publisher","DOI":"10.14778\/1920841.1920928"},{"key":"e_1_2_1_40_1","doi-asserted-by":"publisher","DOI":"10.14778\/3236187.3236216"},{"key":"e_1_2_1_41_1","doi-asserted-by":"publisher","DOI":"10.1145\/3409964.3461816"},{"key":"e_1_2_1_42_1","doi-asserted-by":"publisher","DOI":"10.14778\/3574245.3574275"},{"key":"e_1_2_1_43_1","doi-asserted-by":"publisher","DOI":"10.1145\/3558481.3591070"},{"key":"e_1_2_1_44_1","unstructured":"Hongbo Kang Yiwei Zhao and Hyoungjoo Kim. 2024. upmem-sdk-light. https:\/\/github.com\/Loremkang\/upmem-sdk-light. Accessed on 2025.07.13."},{"key":"e_1_2_1_45_1","doi-asserted-by":"publisher","DOI":"10.1145\/2463676.2465326"},{"key":"e_1_2_1_46_1","doi-asserted-by":"publisher","DOI":"10.14778\/3368289.3368298"},{"key":"e_1_2_1_47_1","doi-asserted-by":"publisher","DOI":"10.1109\/MM.2022.3164651"},{"key":"e_1_2_1_48_1","doi-asserted-by":"publisher","DOI":"10.1145\/2882903.2882905"},{"key":"e_1_2_1_49_1","volume-title":"Proceedings of the 12th Conference on Innovative Data Systems Research (CIDR). 14","author":"Korolija Dario","year":"2022","unstructured":"Dario Korolija, Dimitrios Koutsoukos, Kimberly Keeton, Konstantin Taranov, Dejan S Milojicic, and Gustavo Alonso. 2022. Farview: Disaggregated Memory with Operator Off-loading for Database Engines. In Proceedings of the 12th Conference on Innovative Data Systems Research (CIDR). 14."},{"key":"e_1_2_1_50_1","doi-asserted-by":"publisher","DOI":"10.1109\/BIBM.2016.7822732"},{"key":"e_1_2_1_51_1","doi-asserted-by":"publisher","DOI":"10.1109\/MICRO61859.2024.00053"},{"key":"e_1_2_1_52_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2013.6544812"},{"key":"e_1_2_1_53_1","doi-asserted-by":"publisher","DOI":"10.1145\/3620665.3640376"},{"key":"e_1_2_1_54_1","doi-asserted-by":"publisher","DOI":"10.1145\/3589258"},{"key":"e_1_2_1_55_1","doi-asserted-by":"publisher","DOI":"10.1145\/3087556.3087582"},{"key":"e_1_2_1_56_1","doi-asserted-by":"publisher","DOI":"10.1145\/2168836.2168855"},{"key":"e_1_2_1_57_1","doi-asserted-by":"publisher","DOI":"10.1145\/3673038.3673094"},{"key":"e_1_2_1_58_1","volume-title":"Emerging computing: from devices to systems: looking beyond Moore and Von Neumann","author":"Mutlu Onur","unstructured":"Onur Mutlu, Saugata Ghose, Juan G\u00f3mez-Luna, and Rachata Ausavarungnirun. 2022. A modern primer on processing in memory. In Emerging computing: from devices to systems: looking beyond Moore and Von Neumann. Springer, 171\u2013243."},{"key":"e_1_2_1_59_1","doi-asserted-by":"publisher","DOI":"10.14778\/3461535.3461538"},{"key":"e_1_2_1_60_1","doi-asserted-by":"publisher","DOI":"10.14778\/2350229.2350260"},{"key":"e_1_2_1_61_1","doi-asserted-by":"publisher","DOI":"10.1145\/3656019.3676947"},{"key":"e_1_2_1_62_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICCD63220.2024.00018"},{"key":"e_1_2_1_63_1","volume-title":"Proceedings of the 33rd International Conference on Very Large Data Bases (VLDB). 1150\u20131160","author":"Stonebraker Michael","year":"2007","unstructured":"Michael Stonebraker, Samuel Madden, Daniel J Abadi, Stavros Harizopoulos, Nabil Hachem, and Pat Helland. 2007. The End of an Architectural Era: (It's Time for a Complete Rewrite). In Proceedings of the 33rd International Conference on Very Large Data Bases (VLDB). 1150\u20131160."},{"key":"e_1_2_1_64_1","doi-asserted-by":"publisher","DOI":"10.1145\/3652892.3700782"},{"key":"e_1_2_1_65_1","doi-asserted-by":"publisher","DOI":"10.1145\/2517349.2522713"},{"key":"e_1_2_1_66_1","unstructured":"UPMEM. 2025. UPMEM Software Development Kit (SDK). https:\/\/sdk.upmem.com\/. Accessed on 2025.07.13."},{"key":"e_1_2_1_67_1","doi-asserted-by":"publisher","DOI":"10.14778\/3547305.3547307"},{"key":"e_1_2_1_68_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE60146.2024.00296"},{"key":"e_1_2_1_69_1","doi-asserted-by":"publisher","DOI":"10.14778\/3067421.3067427"},{"key":"e_1_2_1_70_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2017.54"},{"key":"e_1_2_1_71_1","doi-asserted-by":"publisher","DOI":"10.1145\/2600212.2600213"},{"key":"e_1_2_1_72_1","doi-asserted-by":"publisher","DOI":"10.1145\/3658617.3697627"},{"key":"e_1_2_1_73_1","doi-asserted-by":"publisher","DOI":"10.1145\/3694906.3743318"},{"key":"e_1_2_1_74_1","volume-title":"Syed Shakib Sarwar, Kleber Hugo Stangherlin, Yi-Lun Lu, Jorge Tomas Gomez, Jae-Sun Seo, Phillip B Gibbons, Barbara De Salvo, and Chiao Liu.","author":"Zhao Yiwei","year":"2024","unstructured":"Yiwei Zhao, Ziyun Li, Win-San Khwa, Xiaoyu Sun, Sai Qian Zhang, Syed Shakib Sarwar, Kleber Hugo Stangherlin, Yi-Lun Lu, Jorge Tomas Gomez, Jae-Sun Seo, Phillip B Gibbons, Barbara De Salvo, and Chiao Liu. 2024. Neural Architecture Search of Hybrid Models for NPU-CIM Heterogeneous AR\/VR Devices. arXiv preprint arXiv:2410.08326 (2024)."},{"key":"e_1_2_1_75_1","doi-asserted-by":"publisher","DOI":"10.1109\/HPCA56546.2023.10071005"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/3749646.3749690","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,9,5]],"date-time":"2025-09-05T03:30:24Z","timestamp":1757043024000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/3749646.3749690"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2025,7]]},"references-count":75,"journal-issue":{"issue":"11","published-print":{"date-parts":[[2025,7]]}},"alternative-id":["10.14778\/3749646.3749690"],"URL":"https:\/\/doi.org\/10.14778\/3749646.3749690","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2025,7]]},"assertion":[{"value":"2025-09-04","order":3,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}