{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,3,31]],"date-time":"2026-03-31T23:34:17Z","timestamp":1775000057076,"version":"3.50.1"},"reference-count":56,"publisher":"Association for Computing Machinery (ACM)","issue":"6","content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2023,2]]},"abstract":"<jats:p>Hybrid transactional\/analytical processing (HTAP) would overload database systems. To alleviate performance interference between transactions and analytics, recent research pursues the potential of in-storage processing (ISP) using commodity computational storage devices (CSDs). However, in-storage query processing faces technical challenges in HTAP environments. Continuously updated data versions pose two hurdles: (1) data items keep changing, and (2) finding visible data versions incurs excessive data access in CSDs. Such access patterns dominate the cost of query processing, which may hinder the active deployment of CSDs.<\/jats:p>\n          <jats:p>\n            This paper addresses the core issues by proposing an\n            <jats:italic>\n              <jats:bold>a<\/jats:bold>\n              nalyt\n              <jats:bold>i<\/jats:bold>\n              c offloa\n              <jats:bold>d e<\/jats:bold>\n              ngine\n            <\/jats:italic>\n            (AIDE) that transforms engine-specific query execution logic into vendor-neutral computation through a canonical interface. At the core of AIDE are the\n            <jats:italic>canonical representation<\/jats:italic>\n            of vendor-specific data and the separate management of data locators. It enables any CSD to execute vendor-neutral operations on canonical tuples with separate indexes, regardless of host databases. To eliminate excessive data access, we\n            <jats:italic>prescreen<\/jats:italic>\n            the indexes before offloading; thus, host-side prescreening can obviate the need for running costly version searching in CSDs and boost analytics. We implemented our prototype for PostgreSQL and MyRocks, demonstrating that AIDE supports efficient ISP for two databases using the same FPGA logic. Evaluation results show that AIDE improves query latency up to 42\u00d7 on PostgreSQL and 34\u00d7 on MyRocks.\n          <\/jats:p>","DOI":"10.14778\/3583140.3583161","type":"journal-article","created":{"date-parts":[[2023,4,20]],"date-time":"2023-04-20T16:45:59Z","timestamp":1682009159000},"page":"1480-1493","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":13,"title":["Deploying Computational Storage for HTAP DBMSs Takes More Than Just Computation Offloading"],"prefix":"10.14778","volume":"16","author":[{"given":"Kitaek","family":"Lee","sequence":"first","affiliation":[{"name":"Hanyang University"}]},{"given":"Insoon","family":"Jo","sequence":"additional","affiliation":[{"name":"Hanyang University"}]},{"given":"Jaechan","family":"Ahn","sequence":"additional","affiliation":[{"name":"Hanyang University"}]},{"given":"Hyuk","family":"Lee","sequence":"additional","affiliation":[{"name":"Samsung Electronics"}]},{"given":"Hwang","family":"Lee","sequence":"additional","affiliation":[{"name":"Samsung Electronics"}]},{"given":"Woong","family":"Sul","sequence":"additional","affiliation":[{"name":"Hanyang University"}]},{"given":"Hyungsoo","family":"Jung","sequence":"additional","affiliation":[{"name":"Hanyang University"}]}],"member":"320","published-online":{"date-parts":[[2023,4,20]]},"reference":[{"key":"e_1_2_1_1_1","unstructured":"2020. sysbench-1.0.20. Available at https:\/\/github.com\/akopytov\/sysbench.  2020. sysbench-1.0.20. Available at https:\/\/github.com\/akopytov\/sysbench."},{"key":"e_1_2_1_2_1","unstructured":"2022. HammerDB Version 4.4. Available at https:\/\/github.com\/TPC-Council\/HammerDB\/releases\/tag\/v4.4.  2022. HammerDB Version 4.4. Available at https:\/\/github.com\/TPC-Council\/HammerDB\/releases\/tag\/v4.4."},{"key":"e_1_2_1_3_1","unstructured":"2022. NTT OSS Center DBMS Development and Support Team: pg_hint_plan-1.4. Available at https:\/\/github.com\/ossc-db\/pg_hint_plan.  2022. NTT OSS Center DBMS Development and Support Team: pg_hint_plan-1.4. Available at https:\/\/github.com\/ossc-db\/pg_hint_plan."},{"key":"e_1_2_1_4_1","unstructured":"2022. Vitis Unified Software Platform Documentation: Application Acceleration Development (UG1393): Vitis Analyzer. Available at https:\/\/docs.xilinx.com\/r\/en-US\/ug1393-vitis-application-acceleration\/Using-the-Vitis-Analyzer.  2022. Vitis Unified Software Platform Documentation: Application Acceleration Development (UG1393): Vitis Analyzer. Available at https:\/\/docs.xilinx.com\/r\/en-US\/ug1393-vitis-application-acceleration\/Using-the-Vitis-Analyzer."},{"key":"e_1_2_1_5_1","unstructured":"Amazon Web Services Inc. 2022. What Is AWS Glue? https:\/\/docs.aws.amazon.com\/glue\/latest\/dg\/what-is-glue.html.  Amazon Web Services Inc. 2022. What Is AWS Glue? https:\/\/docs.aws.amazon.com\/glue\/latest\/dg\/what-is-glue.html."},{"key":"e_1_2_1_6_1","unstructured":"Oracle Corporation and\/or its affiliates. 2022. MySQL 8.0 Reference Manual: 15.3 InnoDB Multi-Versioning. https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/innodb-multi-versioning.html  Oracle Corporation and\/or its affiliates. 2022. MySQL 8.0 Reference Manual: 15.3 InnoDB Multi-Versioning. https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/innodb-multi-versioning.html"},{"key":"e_1_2_1_7_1","unstructured":"Oracle Corporation and\/or its affiliates. 2022. Oracle Database Concept: 9 Data Concurrency and Consistency. https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/cncpt\/data-concurrency-and-consistency.html  Oracle Corporation and\/or its affiliates. 2022. Oracle Database Concept: 9 Data Concurrency and Consistency. https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/cncpt\/data-concurrency-and-consistency.html"},{"key":"e_1_2_1_8_1","doi-asserted-by":"publisher","DOI":"10.1145\/800220.806699"},{"key":"e_1_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.1145\/319996.319998"},{"key":"e_1_2_1_10_1","volume-title":"POLARDB Meets Computational Storage: Efficiently Support Analytical Workloads in Cloud-Native Relational Database. In 18th USENIX Conference on File and Storage Technologies (FAST 20)","author":"Cao Wei","year":"2020","unstructured":"Wei Cao , Yang Liu , Zhushi Cheng , Ning Zheng , Wei Li , Wenjie Wu , Linqiang Ouyang , Peng Wang , Yijing Wang , Ray Kuan , 2020 . POLARDB Meets Computational Storage: Efficiently Support Analytical Workloads in Cloud-Native Relational Database. In 18th USENIX Conference on File and Storage Technologies (FAST 20) . 29--41. Wei Cao, Yang Liu, Zhushi Cheng, Ning Zheng, Wei Li, Wenjie Wu, Linqiang Ouyang, Peng Wang, Yijing Wang, Ray Kuan, et al. 2020. POLARDB Meets Computational Storage: Efficiently Support Analytical Workloads in Cloud-Native Relational Database. In 18th USENIX Conference on File and Storage Technologies (FAST 20). 29--41."},{"key":"e_1_2_1_11_1","volume-title":"Citusdata: Tools for running CH-benCHmark with HammerDB. https:\/\/github.com\/citusdata\/ch-benchmark.","author":"Data Citus","year":"2020","unstructured":"Citus Data . 2020 . Citusdata: Tools for running CH-benCHmark with HammerDB. https:\/\/github.com\/citusdata\/ch-benchmark. Citus Data. 2020. Citusdata: Tools for running CH-benCHmark with HammerDB. https:\/\/github.com\/citusdata\/ch-benchmark."},{"key":"e_1_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.1145\/1988842.1988850"},{"key":"e_1_2_1_13_1","doi-asserted-by":"publisher","DOI":"10.1145\/3448016.3457551"},{"key":"e_1_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.1145\/2463676.2463710"},{"key":"e_1_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.1145\/2463676.2465295"},{"key":"e_1_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.1145\/2094114.2094126"},{"key":"e_1_2_1_17_1","doi-asserted-by":"publisher","DOI":"10.1145\/1142473.1142511"},{"key":"e_1_2_1_18_1","volume-title":"Peloton: The Self-driving Database Management System. https:\/\/pelotondb.io\/","author":"Carnegie Mellon University Database Group.","year":"2020","unstructured":"Carnegie Mellon University Database Group. 2020 . Peloton: The Self-driving Database Management System. https:\/\/pelotondb.io\/ Carnegie Mellon University Database Group. 2020. Peloton: The Self-driving Database Management System. https:\/\/pelotondb.io\/"},{"key":"e_1_2_1_19_1","volume-title":"Terrier: The Self-driving Database Management System. https:\/\/github.com\/cmu-db\/terrier","author":"Carnegie Mellon University Database Group.","year":"2020","unstructured":"Carnegie Mellon University Database Group. 2020 . Terrier: The Self-driving Database Management System. https:\/\/github.com\/cmu-db\/terrier Carnegie Mellon University Database Group. 2020. Terrier: The Self-driving Database Management System. https:\/\/github.com\/cmu-db\/terrier"},{"key":"e_1_2_1_20_1","doi-asserted-by":"publisher","DOI":"10.1145\/1376616.1376670"},{"key":"e_1_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.14778\/3415478.3415535"},{"key":"e_1_2_1_22_1","volume-title":"PinK: High-Speed in-Storage Key-Value Store with Bounded Tails","author":"Im Junsu","unstructured":"Junsu Im , Jinwook Bae , Chanwoo Chung , Arvind Arvind , and Sungjin Lee . 2020. PinK: High-Speed in-Storage Key-Value Store with Bounded Tails . USENIX Association , USA. Junsu Im, Jinwook Bae, Chanwoo Chung, Arvind Arvind, and Sungjin Lee. 2020. PinK: High-Speed in-Storage Key-Value Store with Bounded Tails. USENIX Association, USA."},{"key":"e_1_2_1_23_1","unstructured":"MemSQL Inc. 2022. MemSQL. https:\/\/www.memsql.com\/  MemSQL Inc. 2022. MemSQL. https:\/\/www.memsql.com\/"},{"key":"e_1_2_1_24_1","doi-asserted-by":"publisher","DOI":"10.14778\/2994509.2994512"},{"key":"e_1_2_1_25_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2011.5767867"},{"key":"e_1_2_1_26_1","doi-asserted-by":"publisher","DOI":"10.1145\/3448016.3452783"},{"key":"e_1_2_1_27_1","doi-asserted-by":"publisher","DOI":"10.1145\/3514221.3526135"},{"key":"e_1_2_1_28_1","doi-asserted-by":"publisher","DOI":"10.14778\/2824032.2824071"},{"key":"e_1_2_1_29_1","doi-asserted-by":"publisher","DOI":"10.1145\/3132747.3132756"},{"key":"e_1_2_1_30_1","doi-asserted-by":"publisher","DOI":"10.14778\/3436905.3436913"},{"key":"e_1_2_1_31_1","doi-asserted-by":"publisher","DOI":"10.1109\/FPL.2019.00035"},{"key":"e_1_2_1_32_1","doi-asserted-by":"publisher","DOI":"10.1145\/3448016.3457562"},{"key":"e_1_2_1_33_1","unstructured":"Microsoft. 2022. Microsoft SQL Server. https:\/\/www.microsoft.com\/en-us\/sql-server\/  Microsoft. 2022. Microsoft SQL Server. https:\/\/www.microsoft.com\/en-us\/sql-server\/"},{"key":"e_1_2_1_34_1","unstructured":"NuoDB. 2022. NuoDB. https:\/\/nuodb.com\/  NuoDB. 2022. NuoDB. https:\/\/nuodb.com\/"},{"key":"e_1_2_1_35_1","doi-asserted-by":"publisher","DOI":"10.1145\/588111.588125"},{"key":"e_1_2_1_36_1","doi-asserted-by":"publisher","DOI":"10.1145\/3503222.3507711"},{"key":"e_1_2_1_39_1","doi-asserted-by":"publisher","DOI":"10.14778\/3476311.3476378"},{"key":"e_1_2_1_40_1","doi-asserted-by":"publisher","DOI":"10.1145\/3477132.3483555"},{"key":"e_1_2_1_41_1","doi-asserted-by":"publisher","DOI":"10.1145\/2213836.2213946"},{"key":"e_1_2_1_42_1","doi-asserted-by":"publisher","DOI":"10.5555\/2093889.2093965"},{"key":"e_1_2_1_43_1","volume-title":"PostgreSQL: Documentation for PostgreSQL 12","author":"The PostgreSQL Global Development Group","unstructured":"The PostgreSQL Global Development Group . 2022. PostgreSQL: Documentation for PostgreSQL 12 : Chapter 15. Parallel Query . https:\/\/www.postgresql.org\/docs\/12\/parallel-query.html. The PostgreSQL Global Development Group. 2022. PostgreSQL: Documentation for PostgreSQL 12: Chapter 15. Parallel Query. https:\/\/www.postgresql.org\/docs\/12\/parallel-query.html."},{"key":"e_1_2_1_44_1","volume-title":"PostgreSQL: Documentation for PostgreSQL 12","author":"The PostgreSQL Global Development Group","unstructured":"The PostgreSQL Global Development Group . 2022. PostgreSQL: Documentation for PostgreSQL 12 : Chapter 29.3. Asynchronous Commit . https:\/\/www.postgresql.org\/docs\/12\/wal-async-commit.html. The PostgreSQL Global Development Group. 2022. PostgreSQL: Documentation for PostgreSQL 12: Chapter 29.3. Asynchronous Commit. https:\/\/www.postgresql.org\/docs\/12\/wal-async-commit.html."},{"key":"e_1_2_1_45_1","volume-title":"Proceedings of the 11th USENIX Conference on File and Storage Technologies","author":"Tiwari Devesh","year":"2013","unstructured":"Devesh Tiwari , Simona Boboila , Sudharshan S. Vazhkudai , Youngjae Kim , Xiaosong Ma , Peter J. Desnoyers , and Yan Solihin . 2013 . Active Flash: Towards Energy-Efficient, in-Situ Data Analytics on Extreme-Scale Machines . In Proceedings of the 11th USENIX Conference on File and Storage Technologies ( San Jose, CA) (FAST'13). USENIX Association, USA, 119--132. Devesh Tiwari, Simona Boboila, Sudharshan S. Vazhkudai, Youngjae Kim, Xiaosong Ma, Peter J. Desnoyers, and Yan Solihin. 2013. Active Flash: Towards Energy-Efficient, in-Situ Data Analytics on Extreme-Scale Machines. In Proceedings of the 11th USENIX Conference on File and Storage Technologies (San Jose, CA) (FAST'13). USENIX Association, USA, 119--132."},{"key":"e_1_2_1_46_1","doi-asserted-by":"publisher","DOI":"10.1145\/3399666.3399934"},{"key":"e_1_2_1_47_1","doi-asserted-by":"publisher","DOI":"10.14778\/3547305.3547307"},{"key":"e_1_2_1_48_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE51399.2021.00161"},{"key":"e_1_2_1_49_1","doi-asserted-by":"publisher","DOI":"10.1145\/2933349.2933353"},{"key":"e_1_2_1_50_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2019.00067"},{"key":"e_1_2_1_51_1","volume-title":"A technical overview of the oracle exadata database machine and exadata storage server. Oracle White Paper","author":"Weiss Ronald","year":"2012","unstructured":"Ronald Weiss . 2012. A technical overview of the oracle exadata database machine and exadata storage server. Oracle White Paper . Oracle Corporation , Redwood Shores ( 2012 ). Ronald Weiss. 2012. A technical overview of the oracle exadata database machine and exadata storage server. Oracle White Paper. Oracle Corporation, Redwood Shores (2012)."},{"key":"e_1_2_1_52_1","doi-asserted-by":"publisher","DOI":"10.14778\/2732967.2732972"},{"key":"e_1_2_1_53_1","unstructured":"Xilinx. 2021. SmartSSD Computational Storage Drive. https:\/\/www.xilinx.com\/applications\/data-center\/computational-storage\/smartssd.html  Xilinx. 2021. SmartSSD Computational Storage Drive. https:\/\/www.xilinx.com\/applications\/data-center\/computational-storage\/smartssd.html"},{"key":"e_1_2_1_54_1","doi-asserted-by":"publisher","DOI":"10.1109\/MICRO50266.2020.00041"},{"key":"e_1_2_1_55_1","volume-title":"AQUOMAN: An Analytic-Query Offloading Machine. In 2020 53rd Annual IEEE\/ACM International Symposium on Microarchitecture (MICRO). IEEE, 386--399","author":"Xu Shuotao","year":"2020","unstructured":"Shuotao Xu , Thomas Bourgeat , Tianhao Huang , Hojun Kim , Sungjin Lee , and Arvind Arvind . 2020 . AQUOMAN: An Analytic-Query Offloading Machine. In 2020 53rd Annual IEEE\/ACM International Symposium on Microarchitecture (MICRO). IEEE, 386--399 . Shuotao Xu, Thomas Bourgeat, Tianhao Huang, Hojun Kim, Sungjin Lee, and Arvind Arvind. 2020. AQUOMAN: An Analytic-Query Offloading Machine. In 2020 53rd Annual IEEE\/ACM International Symposium on Microarchitecture (MICRO). IEEE, 386--399."},{"key":"e_1_2_1_56_1","doi-asserted-by":"publisher","DOI":"10.14778\/3025111.3025113"},{"key":"e_1_2_1_57_1","doi-asserted-by":"publisher","DOI":"10.23919\/DATE51398.2021.9474088"},{"key":"e_1_2_1_58_1","doi-asserted-by":"publisher","DOI":"10.14778\/3415478.3415553"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/3583140.3583161","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2023,4,20]],"date-time":"2023-04-20T16:53:55Z","timestamp":1682009635000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/3583140.3583161"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2023,2]]},"references-count":56,"journal-issue":{"issue":"6","published-print":{"date-parts":[[2023,2]]}},"alternative-id":["10.14778\/3583140.3583161"],"URL":"https:\/\/doi.org\/10.14778\/3583140.3583161","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2023,2]]},"assertion":[{"value":"2023-04-20","order":2,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}