{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,9,11]],"date-time":"2025-09-11T17:44:08Z","timestamp":1757612648180,"version":"3.44.0"},"reference-count":52,"publisher":"Association for Computing Machinery (ACM)","issue":"10","content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2025,6]]},"abstract":"<jats:p>\n            Many GaussDB customers, particularly small and medium-sized enterprises (SMEs), require high transaction throughput with occasional analytical queries. HTAP systems that deploy both OLTP and OLAP engines on a single server to manage hybrid workloads have become increasingly popular among customers for achieving high cost-efficiency and data freshness. However, co-locating these systems can lead to resource contention, particularly for memory, potentially degrading overall system performance and causing Service-Level Agreements (SLA) violations. To address this issue, we propose\n            <jats:italic toggle=\"yes\">T<\/jats:italic>\n            <jats:sup>2<\/jats:sup>\n            (Twisted Twin), an adaptive memory management approach that dynamically allocates memory between OLTP and OLAP components. This approach ensures OLTP meets SLA while optimizing the efficiency of OLAP query processing. However, this is non-trivial, as memory allocation triggers a cascade of effects, including in-memory column selection and data synchronization, both critical in HTAP systems. To overcome these challenges, we introduce a Bayesian optimization framework tailored for fluctuating workloads that adjusts memory allocation responsively. Experiments conducted on the real-world HTAP system, GaussDB-HTAP, demonstrate the effectiveness and efficiency of\n            <jats:italic toggle=\"yes\">T<\/jats:italic>\n            <jats:sup>2<\/jats:sup>\n            .\n          <\/jats:p>","DOI":"10.14778\/3748191.3748197","type":"journal-article","created":{"date-parts":[[2025,9,4]],"date-time":"2025-09-04T13:50:16Z","timestamp":1756993816000},"page":"3312-3325","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":0,"title":["Twisted Twin: A Collaborative and Competitive Memory Management Approach in HTAP Systems"],"prefix":"10.14778","volume":"18","author":[{"given":"Jiani","family":"Yang","sequence":"first","affiliation":[{"name":"Zhejiang University &amp; Zhejiang Key Laboratory of Big Data Intelligent Computing"}]},{"given":"Sai","family":"Wu","sequence":"additional","affiliation":[{"name":"Zhejiang University &amp; Zhejiang Key Laboratory of Big Data Intelligent Computing"}]},{"given":"Yong","family":"Wang","sequence":"additional","affiliation":[{"name":"Huawei"}]},{"given":"Dongxiang","family":"Zhang","sequence":"additional","affiliation":[{"name":"Zhejiang University"}]},{"given":"Yifei","family":"Liu","sequence":"additional","affiliation":[{"name":"Zhejiang University"}]},{"given":"Xiu","family":"Tang","sequence":"additional","affiliation":[{"name":"Zhejiang University"}]},{"given":"Gang","family":"Chen","sequence":"additional","affiliation":[{"name":"Zhejiang University"}]}],"member":"320","published-online":{"date-parts":[[2025,9,4]]},"reference":[{"key":"e_1_2_1_1_1","doi-asserted-by":"publisher","DOI":"10.14778\/3415478.3415533"},{"key":"e_1_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.1145\/3035918.3064029"},{"key":"e_1_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2018.00028"},{"key":"e_1_2_1_4_1","doi-asserted-by":"publisher","DOI":"10.1023\/A:1010933404324"},{"key":"e_1_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.14778\/3587136.3587137"},{"key":"e_1_2_1_6_1","doi-asserted-by":"publisher","DOI":"10.1145\/3514221.3517882"},{"key":"e_1_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.1109\/69.476501"},{"key":"e_1_2_1_8_1","volume-title":"Narasayya","author":"Chaudhuri Surajit","year":"1997","unstructured":"Surajit Chaudhuri and Vivek R. Narasayya. 1997. An Efficient Cost-Driven Index Selection Tool for Microsoft SQL Server. In VLDB'97, Proceedings of 23rd International Conference on Very Large Data Bases, August 25\u201329, 1997, Athens, Greece, Matthias Jarke, Michael J. Carey, Klaus R. Dittrich, Frederick H. Lochovsky, Pericles Loucopoulos, and Manfred A. Jeusfeld (Eds.). Morgan Kaufmann, 146\u2013155. http:\/\/www.vldb.org\/conf\/1997\/P146.PDF"},{"key":"e_1_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.14778\/3554821.3554832"},{"key":"e_1_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.14778\/3007263.3007277"},{"key":"e_1_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.1145\/1988842.1988850"},{"key":"e_1_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.14778\/1978665.1978668"},{"key":"e_1_2_1_13_1","volume-title":"Advances in Neural Information Processing Systems 9, NIPS","author":"Drucker Harris","year":"1996","unstructured":"Harris Drucker, Christopher J. C. Burges, Linda Kaufman, Alexander J. Smola, and Vladimir Vapnik. 1996. Support Vector Regression Machines. In Advances in Neural Information Processing Systems 9, NIPS, Denver, CO, USA, December 2\u20135, 1996, Michael Mozer, Michael I. Jordan, and Thomas Petsche (Eds.). MIT Press, 155\u2013161. http:\/\/papers.nips.cc\/paper\/1238-support-vector-regression-machines"},{"key":"e_1_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.1287\/OPRE.29.3.612"},{"key":"e_1_2_1_15_1","doi-asserted-by":"publisher","unstructured":"J. Forrest and the CBC team. [n. d.]. CBC (COIN-OR Branch-and-Cut). 10.5281\/zenodo.1334726","DOI":"10.5281\/zenodo.1334726"},{"key":"e_1_2_1_16_1","volume-title":"A Tutorial on Bayesian Optimization. CoRR abs\/1807.02811","author":"Frazier Peter I.","year":"2018","unstructured":"Peter I. Frazier. 2018. A Tutorial on Bayesian Optimization. CoRR abs\/1807.02811 (2018). arXiv:1807.02811 http:\/\/arxiv.org\/abs\/1807.02811"},{"key":"e_1_2_1_17_1","doi-asserted-by":"publisher","DOI":"10.1214\/aos\/1013203451"},{"key":"e_1_2_1_18_1","doi-asserted-by":"publisher","DOI":"10.1016\/0167-6377(96)00025-9"},{"key":"e_1_2_1_19_1","doi-asserted-by":"publisher","DOI":"10.1287\/OPRE.22.1.180"},{"key":"e_1_2_1_20_1","doi-asserted-by":"publisher","DOI":"10.1109\/TKDE.2022.3163195"},{"key":"e_1_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.14778\/3415478.3415535"},{"volume-title":"GaussDB: Next-Generation Distributed Database. https:\/\/www.huaweicloud.com\/intl\/en-us\/product\/gaussdb.html Accessed","year":"2024","key":"e_1_2_1_22_1","unstructured":"Huawei. 2024. GaussDB: Next-Generation Distributed Database. https:\/\/www.huaweicloud.com\/intl\/en-us\/product\/gaussdb.html Accessed: June 16, 2024."},{"key":"e_1_2_1_23_1","doi-asserted-by":"publisher","DOI":"10.1023\/A:1008306431147"},{"key":"e_1_2_1_24_1","doi-asserted-by":"publisher","DOI":"10.14778\/3407790.3407832"},{"key":"e_1_2_1_25_1","doi-asserted-by":"publisher","DOI":"10.48786\/EDBT.2022.06"},{"key":"e_1_2_1_26_1","doi-asserted-by":"publisher","DOI":"10.1109\/CEC.2001.934453"},{"key":"e_1_2_1_27_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2015.7113373"},{"key":"e_1_2_1_28_1","doi-asserted-by":"publisher","DOI":"10.1145\/3340531.3412106"},{"key":"e_1_2_1_29_1","doi-asserted-by":"publisher","DOI":"10.14778\/2824032.2824071"},{"key":"e_1_2_1_30_1","doi-asserted-by":"publisher","DOI":"10.1145\/3514221.3526148"},{"key":"e_1_2_1_31_1","doi-asserted-by":"publisher","DOI":"10.1007\/S00366-020-01240-3"},{"key":"e_1_2_1_32_1","volume-title":"The Eleventh International Conference on Learning Representations, ICLR 2023","author":"Nie Yuqi","year":"2023","unstructured":"Yuqi Nie, Nam H. Nguyen, Phanwadee Sinthong, and Jayant Kalagnanam. 2023. A Time Series is Worth 64 Words: Long-term Forecasting with Transformers. In The Eleventh International Conference on Learning Representations, ICLR 2023, Kigali, Rwanda, May 1\u20135, 2023. OpenReview.net. https:\/\/openreview.net\/forum?id=Jbdc0vTOcol"},{"key":"e_1_2_1_33_1","unstructured":"Oracle. 2021. Oracle. Database In-Memory Guide. Public Documentation 21c. https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/21\/dbimr\/index.html 71\u201388."},{"key":"e_1_2_1_34_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE51399.2021.00058"},{"key":"e_1_2_1_35_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICSMC.2005.1571121"},{"key":"e_1_2_1_36_1","doi-asserted-by":"publisher","DOI":"10.14778\/2536222.2536233"},{"key":"e_1_2_1_37_1","doi-asserted-by":"publisher","DOI":"10.1038\/323533a0"},{"key":"e_1_2_1_38_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2019.00113"},{"key":"e_1_2_1_39_1","volume-title":"15th USENIX Symposium on Operating Systems Design and Implementation, OSDI 2021","author":"Shen Sijie","year":"2021","unstructured":"Sijie Shen, Rong Chen, Haibo Chen, and Binyu Zang. 2021. Retrofitting High Availability Mechanism to Tame Hybrid Transaction\/Analytical Processing. In 15th USENIX Symposium on Operating Systems Design and Implementation, OSDI 2021, July 14\u201316, 2021, Angela Demke Brown and Jay R. Lorch (Eds.). USENIX Association, 219\u2013238. https:\/\/www.usenix.org\/conference\/osdi21\/presentation\/shen"},{"key":"e_1_2_1_40_1","doi-asserted-by":"publisher","DOI":"10.1145\/2213836.2213946"},{"key":"e_1_2_1_41_1","doi-asserted-by":"publisher","DOI":"10.1007\/S00778-024-00858-9"},{"key":"e_1_2_1_42_1","doi-asserted-by":"publisher","DOI":"10.5555\/1182635.1164220"},{"key":"e_1_2_1_43_1","doi-asserted-by":"publisher","DOI":"10.1109\/3PGCIC.2012.54"},{"key":"e_1_2_1_44_1","doi-asserted-by":"publisher","DOI":"10.5555\/961322.961367"},{"key":"e_1_2_1_45_1","doi-asserted-by":"publisher","DOI":"10.1145\/3514221.3517843"},{"key":"e_1_2_1_46_1","doi-asserted-by":"publisher","DOI":"10.1145\/253260.253279"},{"key":"e_1_2_1_47_1","doi-asserted-by":"publisher","DOI":"10.1007\/S11222-007-9033-Z"},{"key":"e_1_2_1_48_1","doi-asserted-by":"publisher","DOI":"10.1145\/3589785"},{"key":"e_1_2_1_49_1","volume-title":"A survey of effective heuristics and their application to a variety of knapsack problems. IMA journal of management Mathematics 19, 3","author":"Wilbaut Christophe","year":"2008","unstructured":"Christophe Wilbaut, Said Hanafi, and Said Salhi. 2008. A survey of effective heuristics and their application to a variety of knapsack problems. IMA journal of management Mathematics 19, 3 (2008), 227\u2013244."},{"key":"e_1_2_1_50_1","doi-asserted-by":"publisher","DOI":"10.1145\/3514221.3526128"},{"key":"e_1_2_1_51_1","doi-asserted-by":"publisher","DOI":"10.14778\/3641204.3641206"},{"key":"e_1_2_1_52_1","doi-asserted-by":"publisher","DOI":"10.1145\/3299869.3300085"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/3748191.3748197","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,9,4]],"date-time":"2025-09-04T13:52:36Z","timestamp":1756993956000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/3748191.3748197"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2025,6]]},"references-count":52,"journal-issue":{"issue":"10","published-print":{"date-parts":[[2025,6]]}},"alternative-id":["10.14778\/3748191.3748197"],"URL":"https:\/\/doi.org\/10.14778\/3748191.3748197","relation":{},"ISSN":["2150-8097"],"issn-type":[{"type":"print","value":"2150-8097"}],"subject":[],"published":{"date-parts":[[2025,6]]},"assertion":[{"value":"2025-09-04","order":3,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}