{"id":856,"date":"2026-03-08T01:05:13","date_gmt":"2026-03-07T17:05:13","guid":{"rendered":"https:\/\/iweb20wp-b205b.url.tku.edu.tw\/jase\/?post_type=tkuisotope&p=856"},"modified":"2026-03-22T13:22:11","modified_gmt":"2026-03-22T05:22:11","slug":"dbdw-a-dual-branch-database-workload-prediction-model-2","status":"publish","type":"tkuisotope","link":"\/jase\/?tkuisotope=dbdw-a-dual-branch-database-workload-prediction-model-2","title":{"rendered":"DBDW: A Dual-Branch Database Workload Prediction Model"},"content":{"rendered":"\n
\n
\n

<\/i> 2026<\/a><\/p>\n<\/div>\n\n\n\n

\n

<\/i> Volume 30<\/a><\/p>\n<\/div>\n\n\n\n

\n
\n
\n
\n

Chao Yang, Tiantian Liu, Fang Peng, and Tianyou Zhu<\/i><\/a><\/p>\n\n\n\n

Big Data Center, State Grid Corporation of China, Beijing 100052, P.R.China<\/p>\n<\/div>\n\n\n\n

\n

Received:\u00a0July 31, 2025
Accepted:\u00a0September 1, 2025
Publication Date:\u00a0March 8, 2025<\/p>\n<\/div>\n<\/div>\n\n\n\n

\"\u4e0a\u50b3\u5716\u7247\"\n\n\n

Architectural details of the Sparse TCMixer<\/p>\n<\/div>\n<\/div>\n\n\n\n

<\/i> Copyright <\/strong>The Author(s). This is an open access article distributed under the terms of the Creative Commons Attribution License (CC BY 4.0)<\/a>, which permits unrestricted use, distribution, and reproduction in any medium, provided the original author and source are cited.<\/p>\n\n\n\n

Download Citation:\u00a0 RIS<\/a> | BibTeX <\/a>| http:\/\/dx.doi.org\/10.6180\/jase.202607_30.026<\/a>\u00a0\u00a0<\/p>\n\n\n\n

Download PDF<\/a><\/p>\n\n\n\n

<\/div>\n\n\n\n

Scalable cloud databases allow users to dynamically adjust computational resources based on business needs. However, most current elastic scaling techniques face challenges in making sound decisions due to complex workload variations. Achieving efficient resource allocation requires accurate workload modeling and timely prediction of future workload changes. Therefore, we propose DBDW, an accurate and lightweight model for database workload prediction. DBDW consists of Local Branch and Global branch. The Global branch uses a Mixer architecture to model long-term cloud database workloads at a holistic level. The Local Branch employs multiple components to selectively emphasize local features via a gating strategy. It also uses a channel sparse clustering method to collaboratively represent multichannel information with low computational overhead. Experimental results show DBDW effectively models workload sequences using historical data. Its lowest prediction MAE\/MSE for future workloads are 0.5953\/0.5971. Furthermore, DBDW demonstrates significantly reduced computational costs: GPU memory usage during training is 304.14 MB , training speed reaches 0.3238 s\/epoch , parameter count is 0.34 million, and FLOPs are 4.19 million. This confirms DBDW ensures accurate predictions while greatly reducing overhead, allowing deployment without affecting database operations.<\/p>\n\n\n\n

Keywords:\u00a0Database Workload; Time Series; Mixer; MLP<\/em><\/p>\n\n\n\n

<\/div>\n\n\n\n
\n
    \n
  1. [1] H. Xu, H. Liu, X. Chen, L. Wang, K. Jin, S. Hou, and Z. Li, (2025) \u201cElastic Scaling Method for Multi-tenant Databases Based on Hybrid Workload Prediction Model” International Journal of Software and Informatics 15(01): 69\u201386. DOI: 10.21655\/ijsi.1673-7288.00346.<\/li>\n
  2. [2] A. Verbitski, A. Gupta, D. Saha, M. Brahmadesam, K. Gupta, R. Mittal, S. Krishnamurthy, S. Maurice, T. Kharatishvili, and X. Bao. \u201cAmazon aurora: Design considerations for high throughput cloud-native relational databases\u201d. In: Proceedings of the 2017 ACM International Conference on Management of Data. 2017, 1041\u20131052. DOI: 10.1145\/3035918.3056101.<\/li>\n
  3. [3] W. Cao, Y. Zhang, X. Yang, F. Li, S. Wang, Q. Hu, X. Cheng, Z. Chen, Z. Liu, J. Fang, et al. \u201cPolardb serverless: A cloud native database for disaggregated data centers\u201d. In: Proceedings of the 2021 International Conference on Management of Data. 2021, 2477\u20132489. DOI: 10.1145\/3448016.3457560.<\/li>\n
  4. [4] J. C. Corbett, J. Dean, M. Epstein, A. Fikes, C. Frost, J. J. Furman, S. Ghemawat, A. Gubarev, C. Heiser, P. Hochschild, et al., (2013) \u201cSpanner: Google\u2019s globally distributed database” ACM Transactions on Computer Systems (TOCS) 31(3): 1\u201322. DOI: 10.1145\/2491245.<\/li>\n
  5. [5] P. Antonopoulos, A. Budovski, C. Diaconu, A. Hernandez Saenz, J. Hu, H. Kodavalla, D. Kossmann, S. Lingam, U. F. Minhas, N. Prakash, et al. \u201cSocrates: The new sql server in the cloud\u201d. In: Proceedings of the 2019 International Conference on Management of Data. 2019, 1743\u20131756. DOI: 10.1145\/3299869.3314047.<\/li>\n
  6. [6] S. Salza and M. Terranova. \u201cWorkload modeling for relational database systems\u201d. In: Database Machines: Fourth International Workshop Grand Bahama Island, March 1985. Springer. 1985, 233\u2013255. DOI: 10.1007\/978-1-4612-5144-6_12.<\/li>\n
  7. [7] T.-T. Nguyen, Y.-J. Yeom, T. Kim, D.-H. Park, and S. Kim, (2020) \u201cHorizontal pod autoscaling in kubernetes for elastic container orchestration” Sensors 20(16): 4621. DOI: 10.3390\/s20164621.<\/li>\n
  8. [8] Y. Zhu, J. Liu, M. Guo, Y. Bao, W. Ma, Z. Liu, K. Song, and Y. Yang. \u201cBestconfig: tapping the performance potential of systems via automatic configuration tuning\u201d. In: Proceedings of the 2017 symposium on cloud computing. 2017, 338\u2013350. DOI: 10.1145\/3127479.3128605.<\/li>\n
  9. [9] L. Ma, D. Van Aken, A. Hefny, G. Mezerhane, A. Pavlo, and G. J. Gordon. \u201cQuery-based workload forecasting for self-driving database management systems\u201d. In: Proceedings of the 2018 International Conference on Management of Data. 2018, 631\u2013645. DOI: 10.1145\/3183713.3196908.<\/li>\n
  10. [10] A. Zafeiropoulos, E. Fotopoulou, N. Filinis, and S. Papavassiliou, (2022) \u201cReinforcement learning-assisted autoscaling mechanisms for serverless computing platforms” Simulation Modelling Practice and Theory 116: 102461. DOI: 10.1016\/j.simpat.2021.102461.<\/li>\n
  11. [11] J. Zhang, K. Zhou, G. Li, Y. Liu, M. Xie, B. Cheng, and J. Xing, (2021) \u201cCDBTune+: An efficient deep reinforcement learning-based automatic cloud database tuning system” The VLDB Journal 30(6): 959\u2013987. DOI: 10.1007\/s00778-021-00670-9.<\/li>\n
  12. [12] B. Mozafari, C. Curino, A. Jindal, and S. Madden. \u201cPerformance and resource modeling in highlyconcurrent OLTP workloads\u201d. In: Proceedings of the 2013 acm sigmod international conference on management of data. 2013, 301\u2013312. DOI: 10.1145\/2463676.2467800y.<\/li>\n
  13. [13] A. Mahgoub, P. Wood, A. Medoff, S. Mitra, F. Meyer, S. Chaterji, and S. Bagchi. \u201c{SOPHIA}: Online reconfiguration of clustered {NoSQL} databases for {Time-Varying} workloads\u201d. In: 2019 USENIX Annual Technical Conference (USENIX ATC 19). 2019, 223\u2013240. DOI: 10.5555\/3358807.3358827.<\/li>\n
  14. [14] J. Wang, T. Li, A. Wang, X. Liu, L. Chen, J. Chen, J. Liu, J. Wu, F. Li, and Y. Gao, (2023) \u201cReal-time workload pattern analysis for large-scale cloud databases” arXiv preprint arXiv:2307.02626: DOI: 10.48550\/arXiv.2307.02626.<\/li>\n
  15. [15] Z. Chen, J. Hu, G. Min, A. Y. Zomaya, and T. ElGhazawi, (2019) \u201cTowards accurate prediction for highdimensional and highly-variable cloud workloads with deep learning” IEEE Transactions on Parallel and Distributed Systems 31(4): 923\u2013934. DOI: 10.1109\/TPDS.2019.2953745.<\/li>\n
  16. [16] J. Bi, H. Yuan, and M. Zhou, (2019) \u201cTemporal prediction of multiapplication consolidated workloads in distributed clouds” IEEE Transactions on Automation Science and Engineering 16(4): 1763\u20131773. DOI: 10.1109\/TASE.2019.2895801.<\/li>\n
  17. [17] O. Poppe, Q. Guo, W. Lang, P. Arora, M. Oslake, S. Xu, and A. Kalhan, (2022) \u201cMoneyball: proactive auto-scaling in Microsoft Azure SQL database serverless” Proceedings of the VLDB Endowment 15(6): 1279\u20131287. DOI: 10.14778\/3514061.3514073.<\/li>\n
  18. [18] P. Padala, K.-Y. Hou, K. G. Shin, X. Zhu, M. Uysal, Z. Wang, S. Singhal, and A. Merchant. \u201cAutomated control of multiple virtualized resources\u201d. In: Proceedings of the 4th ACM European conference on Computer systems. 2009, 13\u201326. DOI: 10.1145\/1519065.1519068.<\/li>\n
  19. [19] H. Zhou, S. Zhang, J. Peng, S. Zhang, J. Li, H. Xiong, and W. Zhang. \u201cInformer: Beyond efficient transformer for long sequence time-series forecasting\u201d. In: Proceedings of the AAAI conference on artificial intelligence. 35. 12. 2021, 11106 11115. DOI: 10.1609\/aaai.v35i12.17325.<\/li>\n
  20. [20] H. Wu, J. Xu, J. Wang, and M. Long, (2021) \u201cAutoformer: Decomposition transformers with auto-correlation for long-term series forecasting” Advances in neural information processing systems 34: 22419\u201322430. DOI: 10.48550\/arXiv.2106.13008.<\/li>\n
  21. [21] T. Zhou, Z. Ma, Q. Wen, X. Wang, L. Sun, and R. Jin. \u201cFedformer: Frequency enhanced decomposed transformer for long-term series forecasting\u201d. In: International conference on machine learning. PMLR. 2022, 27268\u201327286. DOI: 10.48550\/arXiv.2201.12740.<\/li>\n
  22. [22] Y. Liu, T. Hu, H. Zhang, H. Wu, S. Wang, L. Ma, and M. Long, (2023) \u201citransformer: Inverted transformers are effective for time series forecasting” arXiv preprint arXiv:2310.06625: DOI: 10.48550\/arXiv.2310.06625.<\/li>\n
  23. [23] A. Zeng, M. Chen, L. Zhang, and Q. Xu. \u201cAre transformers effective for time series forecasting?\u201d In: Proceedings of the AAAI conference on artificial intelligence. 37. 9. 2023, 11121\u201311128. DOI: 10.1609\/aaai.v37i9.26317.<\/li>\n
  24. [24] S.-A. Chen, C.-L. Li, N. Yoder, S. O. Arik, and T. Pfister, (2023) \u201cTsmixer: An all-mlp architecture for time series forecasting” arXiv preprint arXiv:2303.06053: DOI: 10.48550\/arXiv.2303.06053.<\/li>\n
  25. [25] C. Challu, K. G. Olivares, B. N. Oreshkin, F. G. Ramirez, M. M. Canseco, and A. Dubrawski. \u201cNhits: Neural hierarchical interpolation for time series forecasting\u201d. In: Proceedings of the AAAI conference on artificial intelligence. 37. 6. 2023, 6989\u20136997. DOI: 10.1609\/aaai.v37i6.25854.<\/li>\n
  26. [26] D. Campos, M. Zhang, B. Yang, T. Kieu, C. Guo, and C. S. Jensen, (2023) \u201cLightTS: Lightweight time series classification with adaptive ensemble distillation” Proceedings of the ACM on Management of Data 1(2): 1\u201327. DOI: 10.1145\/3589316.<\/li>\n
  27. [27] K. Yi, Q. Zhang, W. Fan, S. Wang, P. Wang, H. He, N. An, D. Lian, L. Cao, and Z. Niu, (2023) \u201cFrequencydomain mlps are more effective learners in time series forecasting” Advances in Neural Information Processing Systems 36: 76656\u201376679. DOI: 10.48550\/arXiv.2311.06184.<\/li>\n
  28. [28] Q. Huang, L. Shen, R. Zhang, J. Cheng, S. Ding, Z. Zhou, and Y. Wang, (2024) \u201cHdmixer: Hierarchical dependency with extendable patch for multivariate time series forecasting” 38(11): 12608\u201312616. DOI: 10.1609\/aaai.v38i11.29155.<\/li>\n
  29. [29] Y. Zhao, Z. Ma, T. Zhou, M. Ye, L. Sun, and Y. Qian, (2023) \u201cGcformer: an efficient solution for accurate and scalable long-term multivariate time series forecasting”: 3464\u20133473. DOI: 10.1145\/3583780.3615136.<\/li>\n
  30. [30] Y. Nie, N. H. Nguyen, P. Sinthong, and J. Kalagnanam, (2022) \u201cA time series is worth 64 words: Long-term forecasting with transformers” arXiv preprint arXiv:2211.14730: DOI: 10.48550\/arXiv.2211.14730.<\/li>\n<\/ol>\n<\/div>\n\n\n\n

    <\/p>\n","protected":false},"author":3,"template":"wp-custom-template-detail-4-aricles","meta":{"_uag_custom_page_level_css":""},"categories":[12,16,6],"tags":[43],"acf":[],"uagb_featured_image_src":[],"uagb_author_info":{"display_name":"\u6797\u923a\u6db5","author_link":"\/jase\/?author=3"},"uagb_comment_info":0,"uagb_excerpt":" Copyright The Author(s). This is an open access article distributed under the terms of the Creative Commons Attribution License (CC BY 4.0), which permits unrestricted use, distribution, and reproduction in any medium, provided the original author and source are cited. Download Citation:\u00a0 RIS | BibTeX | http:\/\/dx.doi.org\/10.6180\/jase.202607_30.026\u00a0\u00a0 Download PDF Scalable cloud databases allow users to dynamically adjust computational…","_links":{"self":[{"href":"\/jase\/index.php?rest_route=\/wp\/v2\/tkuisotope\/856"}],"collection":[{"href":"\/jase\/index.php?rest_route=\/wp\/v2\/tkuisotope"}],"about":[{"href":"\/jase\/index.php?rest_route=\/wp\/v2\/types\/tkuisotope"}],"author":[{"embeddable":true,"href":"\/jase\/index.php?rest_route=\/wp\/v2\/users\/3"}],"wp:attachment":[{"href":"\/jase\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=856"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"\/jase\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=856"},{"taxonomy":"post_tag","embeddable":true,"href":"\/jase\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=856"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}