{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,4,13]],"date-time":"2026-04-13T19:56:53Z","timestamp":1776110213569,"version":"3.50.1"},"reference-count":118,"publisher":"Springer Science and Business Media LLC","issue":"2","license":[{"start":{"date-parts":[[2023,1,11]],"date-time":"2023-01-11T00:00:00Z","timestamp":1673395200000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.springernature.com\/gp\/researchers\/text-and-data-mining"},{"start":{"date-parts":[[2023,1,11]],"date-time":"2023-01-11T00:00:00Z","timestamp":1673395200000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.springernature.com\/gp\/researchers\/text-and-data-mining"}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":["Sci. China Inf. Sci."],"published-print":{"date-parts":[[2023,2]]},"DOI":"10.1007\/s11432-021-3578-6","type":"journal-article","created":{"date-parts":[[2023,1,14]],"date-time":"2023-01-14T16:02:47Z","timestamp":1673712167000},"update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":20,"title":["Survey on performance optimization for database systems"],"prefix":"10.1007","volume":"66","author":[{"given":"Shiyue","family":"Huang","sequence":"first","affiliation":[]},{"given":"Yanzhao","family":"Qin","sequence":"additional","affiliation":[]},{"given":"Xinyi","family":"Zhang","sequence":"additional","affiliation":[]},{"given":"Yaofeng","family":"Tu","sequence":"additional","affiliation":[]},{"given":"Zhongliang","family":"Li","sequence":"additional","affiliation":[]},{"given":"Bin","family":"Cui","sequence":"additional","affiliation":[]}],"member":"297","published-online":{"date-parts":[[2023,1,11]]},"reference":[{"key":"3578_CR1","doi-asserted-by":"publisher","first-page":"121","DOI":"10.1007\/s11390-020-9802-0","volume":"35","author":"R B Ross","year":"2020","unstructured":"Ross R B, Amvrosiadis G, Carns P, et al. Mochi: composing data services for high-performance computing environments. J Comput Sci Technol, 2020, 35: 121\u2013144","journal-title":"J Comput Sci Technol"},{"key":"3578_CR2","doi-asserted-by":"publisher","first-page":"86","DOI":"10.1007\/s41019-020-00149-7","volume":"6","author":"H Lan","year":"2021","unstructured":"Lan H, Bao Z, Peng Y. A survey on advancing the DBMS query optimizer: cardinality estimation, cost model, and plan enumeration. Data Sci Eng, 2021, 6: 86\u2013101","journal-title":"Data Sci Eng"},{"key":"3578_CR3","doi-asserted-by":"publisher","first-page":"382","DOI":"10.1007\/s11390-020-9700-5","volume":"35","author":"Z Y Dong","year":"2020","unstructured":"Dong Z Y, Tang C Z, Wang J C, et al. Optimistic transaction processing in deterministic database. J Comput Sci Technol, 2020, 35: 382\u2013394","journal-title":"J Comput Sci Technol"},{"key":"3578_CR4","doi-asserted-by":"publisher","first-page":"1096","DOI":"10.1109\/TKDE.2020.2994641","volume":"34","author":"X Zhou","year":"2022","unstructured":"Zhou X, Chai C, Li G, et al. Database meets artificial intelligence: a survey. IEEE Trans Knowl Data Eng, 2022, 34: 1096\u20131116","journal-title":"IEEE Trans Knowl Data Eng"},{"key":"3578_CR5","doi-asserted-by":"crossref","unstructured":"Cooper B F, Silberstein A, Tam E, et al. Benchmarking cloud serving systems with YCSB. In: Proceedings of ACM Symposium on Cloud Computing, 2010. 143\u2013154","DOI":"10.1145\/1807128.1807152"},{"key":"3578_CR6","doi-asserted-by":"crossref","unstructured":"Alomari M, Cahill M J, Fekete A D, et al. The cost of serializability on platforms that use snapshot isolation. In: Proceedings of IEEE International Conference on Data Engineering, 2008. 576\u2013585","DOI":"10.1109\/ICDE.2008.4497466"},{"key":"3578_CR7","doi-asserted-by":"crossref","unstructured":"Leis V, Gubichev A, Mirchev A, et al. How good are query optimizers, really? In: Proceedings of the VLDB Endowment, 2015. 204\u2013215","DOI":"10.14778\/2850583.2850594"},{"key":"3578_CR8","doi-asserted-by":"crossref","unstructured":"Ma M, Yin Z, Zhang S, et al. Diagnosing root causes of intermittent slow queries in large-scale cloud databases. In: Proceedings of the VLDB Endowment, 2020. 1176\u20131189","DOI":"10.14778\/3389133.3389136"},{"key":"3578_CR9","doi-asserted-by":"crossref","unstructured":"Mozafari B, Curino C, Jindal A, et al. Performance and resource modeling in highly-concurrent OLTP workloads. In: Proceedings of ACM SIGMOD International Conference on Management of Data, 2013. 301\u2013312","DOI":"10.1145\/2463676.2467800"},{"key":"3578_CR10","unstructured":"Pavlo A, Angulo G, Arulraj J, et al. Self-driving database management systems. In: Proceedings of Conference on Innovative Data Systems Research, 2017"},{"key":"3578_CR11","doi-asserted-by":"crossref","unstructured":"Ma L, Zhang W, Jiao J, et al. MB2: decomposed behavior modeling for self-driving database management systems. In: Proceedings of ACM SIGMOD International Conference on Management of Data, 2021. 1248\u20131261","DOI":"10.1145\/3448016.3457276"},{"key":"3578_CR12","doi-asserted-by":"crossref","unstructured":"Ganapathi A, Kuno H A, Dayal U, et al. Predicting multiple metrics for queries: better decisions enabled by machine learning. In: Proceedings of IEEE International Conference on Data Engineering, 2009. 592\u2013603","DOI":"10.1109\/ICDE.2009.130"},{"key":"3578_CR13","doi-asserted-by":"crossref","unstructured":"Akdere M, \u00c7etintemel U, Riondato M, et al. Learning-based query performance modeling and prediction. In: Proceedings of IEEE International Conference on Data Engineering, 2012. 390\u2013401","DOI":"10.1109\/ICDE.2012.64"},{"key":"3578_CR14","unstructured":"Wu W, Chi Y, Zhu S, et al. Predicting query execution time: are optimizer cost models really unusable? In: Proceedings of IEEE International Conference on Data Engineering, 2013. 1081\u20131092"},{"key":"3578_CR15","doi-asserted-by":"crossref","unstructured":"Marcus R C, Papaemmanouil O. Plan-structured deep neural network models for query performance prediction. In: Proceedings of the VLDB Endowment, 2019. 1733\u20131746","DOI":"10.14778\/3342263.3342646"},{"key":"3578_CR16","doi-asserted-by":"crossref","unstructured":"Zhou X, Sun J, Li G, et al. Query performance prediction for concurrent queries using graph embedding. In: Proceedings of the VLDB Endowment, 2020. 1416\u20131428","DOI":"10.14778\/3397230.3397238"},{"key":"3578_CR17","first-page":"1","volume":"3","author":"F R Bach","year":"2002","unstructured":"Bach F R, Jordan M I. Kernel independent component analysis. J Mach Learn Res, 2002, 3: 1\u201348","journal-title":"J Mach Learn Res"},{"key":"3578_CR18","doi-asserted-by":"publisher","DOI":"10.1017\/CBO9780511809682","volume-title":"Kernel Methods for Pattern Analysis","author":"J Shawe-Taylor","year":"2004","unstructured":"Shawe-Taylor J, Cristianini N. Kernel Methods for Pattern Analysis. Cambridge: Cambridge University Press, 2004"},{"key":"3578_CR19","doi-asserted-by":"crossref","unstructured":"Sun J, Li G. An end-to-end learning-based cost estimator. In: Proceedings of the VLDB Endowment, 2019. 307\u2013319","DOI":"10.14778\/3368289.3368296"},{"key":"3578_CR20","unstructured":"Mozafari B, Curino C, Madden S. DBSeer: resource and performance prediction for building a next generation database cloud. In: Proceedings of Conference on Innovative Data Systems Research, 2013"},{"key":"3578_CR21","doi-asserted-by":"crossref","unstructured":"Yoon D Y, Mozafari B, Brown D P. DBSeer: pain-free database administration through workload intelligence. In: Proceedings of the VLDB Endowment, 2015. 2036\u20132039","DOI":"10.14778\/2824032.2824130"},{"key":"3578_CR22","unstructured":"Ester M, Kriegel H, Sander J, et al. A density-based algorithm for discovering clusters in large spatial databases with noise. In: Proceedings of International Conference on Knowledge Discovery and Data Mining, 1996. 226\u2013231"},{"key":"3578_CR23","doi-asserted-by":"crossref","unstructured":"Thomasian A. On a more realistic lock contention model and its analysis. In: Proceedings of IEEE International Conference on Data Engineering, 1994. 2\u20139","DOI":"10.1109\/ICDE.1994.283009"},{"key":"3578_CR24","doi-asserted-by":"publisher","first-page":"61","DOI":"10.1109\/TNN.2008.2005605","volume":"20","author":"F Scarselli","year":"2009","unstructured":"Scarselli F, Gori M, Tsoi A C, et al. The graph neural network model. IEEE Trans Neural Netw, 2009, 20: 61\u201380","journal-title":"IEEE Trans Neural Netw"},{"key":"3578_CR25","doi-asserted-by":"crossref","unstructured":"Yoon D Y, Niu N, Mozafari B. DBSherlock: a performance diagnostic tool for transactional databases. In: Proceedings of ACM SIGMOD International Conference on Management of Data, 2016. 1599\u20131614","DOI":"10.1145\/2882903.2915218"},{"key":"3578_CR26","doi-asserted-by":"crossref","unstructured":"Liu P, Zhang S, Sun Y, et al. FluxInfer: automatic diagnosis of performance anomaly for online database system. In: Proceedings of IEEE International Performance Computing and Communications Conference, 2020. 1\u20138","DOI":"10.1109\/IPCCC50635.2020.9391550"},{"key":"3578_CR27","doi-asserted-by":"publisher","first-page":"120","DOI":"10.1007\/s41019-022-00185-5","volume":"7","author":"D Samariya","year":"2022","unstructured":"Samariya D, Ma J. A new dimensionality-unbiased score for efficient and effective outlying aspect mining. Data Sci Eng, 2022, 7: 120\u2013135","journal-title":"Data Sci Eng"},{"key":"3578_CR28","doi-asserted-by":"publisher","first-page":"1604","DOI":"10.1109\/TCC.2020.3007016","volume":"10","author":"D Dundjerski","year":"2022","unstructured":"Dundjerski D, Tomasevic M. Automatic database troubleshooting of azure SQL databases. IEEE Trans Cloud Comput, 2022, 10: 1604\u20131619","journal-title":"IEEE Trans Cloud Comput"},{"key":"3578_CR29","unstructured":"Nagaraj K, Killian C E, Neville J. Structured comparative analysis of systems logs to diagnose performance problems. In: Proceedings of USENIX Symposium on Networked Systems Design and Implementation, 2012. 353\u2013366"},{"key":"3578_CR30","doi-asserted-by":"crossref","unstructured":"Glasbergen B, Abebe M, Daudjee K, et al. Sentinel: universal analysis and insight for data systems. In: Proceedings of the VLDB Endowment, 2020. 2720\u20132733","DOI":"10.14778\/3407790.3407856"},{"key":"3578_CR31","unstructured":"Dias K, Ramacher M, Shaft U, et al. Automatic performance diagnosis and tuning in oracle. In: Proceedings of Conference on Innovative Data Systems Research, 2005. 84\u201394"},{"key":"3578_CR32","unstructured":"Kalmegh P, Babu S, Roy S. Analyzing query performance and attributing blame for contentions in a cluster computing framework. 2017. ArXiv:1708.08435"},{"key":"3578_CR33","doi-asserted-by":"crossref","unstructured":"Mogul J C, Wilkes J. Nines are not enough: meaningful metrics for clouds. In: Proceedings of ACM Workshop on Hot Topics in Operating Systems, 2019. 136\u2013141","DOI":"10.1145\/3317550.3321432"},{"key":"3578_CR34","doi-asserted-by":"crossref","unstructured":"Cao W, Gao Y, Lin B, et al. TcpRT: instrument and diagnostic analysis system for service quality of cloud databases at massive scale in real-time. In: Proceedings of ACM SIGMOD International Conference on Management of Data, 2018. 615\u2013627","DOI":"10.1145\/3183713.3190659"},{"key":"3578_CR35","doi-asserted-by":"publisher","first-page":"126","DOI":"10.2307\/2346729","volume":"28","author":"A N Pettitt","year":"1979","unstructured":"Pettitt A N. A non-parametric approach to the change-point problem. Appl Stat, 1979, 28: 126\u2013135","journal-title":"Appl Stat"},{"key":"3578_CR36","doi-asserted-by":"crossref","unstructured":"Agrawal R, Imielinski T, Swami A N. Mining association rules between sets of items in large databases. In: Proceedings of ACM SIGMOD International Conference on Management of Data, 1993. 207\u2013216","DOI":"10.1145\/170036.170072"},{"key":"3578_CR37","doi-asserted-by":"crossref","unstructured":"Kim M, Sumbaly R, Shah S. Root cause detection in a service-oriented architecture. In: Proceedings of ACM SIGMETRICS Performance Evaluation Review, 2013. 93\u2013104","DOI":"10.1145\/2494232.2465753"},{"key":"3578_CR38","doi-asserted-by":"publisher","first-page":"509","DOI":"10.1145\/361002.361007","volume":"18","author":"J L Bentley","year":"1975","unstructured":"Bentley J L. Multidimensional binary search trees used for associative searching. Commun ACM, 1975, 18: 509\u2013517","journal-title":"Commun ACM"},{"key":"3578_CR39","unstructured":"Kim B, Rudin C, Shah J A. The Bayesian case model: a generative approach for case-based reasoning and prototype classification. In: Proceedings of Conference and Workshop on Neural Information Processing Systems, 2014. 1952\u20131960"},{"key":"3578_CR40","doi-asserted-by":"crossref","unstructured":"Xing W, Ghorbani A A. Weighted PageRank algorithm. In: Proceedings of IEEE Conference on Communication Networks and Services Research, 2004. 305\u2013314","DOI":"10.1109\/DNSR.2004.1344743"},{"key":"3578_CR41","volume-title":"Learning Bayesian Networks","author":"R E Neapolitan","year":"2004","unstructured":"Neapolitan R E, et al. Learning Bayesian Networks. Upper Saddle River: Pearson Prentice Hall, 2004"},{"key":"3578_CR42","doi-asserted-by":"crossref","unstructured":"Bernstein P A, Cseri I, Dani N, et al. Adapting Microsoft SQL server for cloud computing. In: Proceedings of IEEE International Conference on Data Engineering, 2011. 1255\u20131263","DOI":"10.1109\/ICDE.2011.5767935"},{"key":"3578_CR43","first-page":"88","volume":"19","author":"J Han","year":"2021","unstructured":"Han J, Jia T, Wu Y, et al. Feedback-aware anomaly detection through logs aware anomaly detection through logs for large for large-scale software systems scale software systems. ZTE commun, 2021, 19: 88\u201394","journal-title":"ZTE commun"},{"key":"3578_CR44","first-page":"49","volume":"1","author":"D Heckerman","year":"2000","unstructured":"Heckerman D, Chickering D M, Meek C, et al. Dependency networks for inference, collaborative filtering, and data visualization. J Mach Learn Res, 2000, 1: 49\u201375","journal-title":"J Mach Learn Res"},{"key":"3578_CR45","doi-asserted-by":"crossref","unstructured":"Pele O, Werman M. Fast and robust earth mover\u2019s distances. In: Proceedings of IEEE International Conference on Computer Vision, 2009. 460\u2013467","DOI":"10.1109\/ICCV.2009.5459199"},{"key":"3578_CR46","doi-asserted-by":"crossref","unstructured":"Kalmegh P, Babu S, Roy S. iQCAR: inter-query contention analyzer for data analytics frameworks. In: Proceedings of ACM SIGMOD International Conference on Management of Data, 2019. 918\u2013935","DOI":"10.1145\/3299869.3319904"},{"key":"3578_CR47","unstructured":"Storm A J, Garcia-Arellano C, Lightstone S, et al. Adaptive self-tuning memory in DB2. In: Proceedings of the VLDB Endowment, 2006. 1081\u20131092"},{"key":"3578_CR48","doi-asserted-by":"crossref","unstructured":"Zhu Y, Liu J, Guo M, et al. BestConfig: tapping the performance potential of systems via automatic configuration tuning. In: Proceedings of ACM Symposium on Cloud Computing, 2017. 338\u2013350","DOI":"10.1145\/3127479.3128605"},{"key":"3578_CR49","doi-asserted-by":"crossref","unstructured":"Duan S, Thummala V, Babu S. Tuning database configuration parameters with iTunes. In: Proceedings of the VLDB Endowment, 2009. 1246\u20131257","DOI":"10.14778\/1687627.1687767"},{"key":"3578_CR50","unstructured":"Aken D V, Pavlo A, Gordon G J, et al. Automatic database management system tuning through large-scale machine learning. In: Proceedings of ACM SIGMOD International Conference on Management of Data, 2017. 1009\u20131024"},{"key":"3578_CR51","doi-asserted-by":"crossref","unstructured":"Fekry A, Carata L, Pasquier T F J, et al. To tune or not to tune? In search of optimal configurations for data analytics. In: Proceedings of ACM KDD Conference on Knowledge Discovery & Data Mining, 2020. 2494\u20132504","DOI":"10.1145\/3394486.3403299"},{"key":"3578_CR52","doi-asserted-by":"crossref","unstructured":"Kunjir M, Babu S. Black or white? How to develop an autotuner for memory-based analytics. In: Proceedings of ACM SIGMOD International Conference on Management of Data, 2020. 1667\u20131683","DOI":"10.1145\/3318464.3380591"},{"key":"3578_CR53","doi-asserted-by":"crossref","unstructured":"Zhang X, Wu H, Chang Z, et al. ResTune: resource oriented tuning boosted by meta-learning for cloud databases. In: Proceedings of ACM SIGMOD International Conference on Management of Data, 2021. 2102\u20132114","DOI":"10.1145\/3448016.3457291"},{"key":"3578_CR54","doi-asserted-by":"crossref","unstructured":"Zhang J, Liu Y, Zhou K, et al. An end-to-end automatic cloud database tuning system using deep reinforcement learning. In: Proceedings of ACM SIGMOD International Conference on Management of Data, 2019. 415\u2013432","DOI":"10.1145\/3299869.3300085"},{"key":"3578_CR55","doi-asserted-by":"crossref","unstructured":"Li G, Zhou X, Li S, et al. Qtune: a query-aware database tuning system with deep reinforcement learning. In: Proceedings of the VLDB Endowment, 2019. 2118\u20132130","DOI":"10.14778\/3352063.3352129"},{"key":"3578_CR56","doi-asserted-by":"crossref","unstructured":"Whang K. Index selection in relational databases. In: Proceedings of Foundations of Data Organization, 1985. 487\u2013500","DOI":"10.1007\/978-1-4613-1881-1_41"},{"key":"3578_CR57","unstructured":"Chaudhuri S, Narasayya V R. An efficient cost-driven index selection tool for Microsoft SQL server. In: Proceedings of the VLDB Endowment, 1997. 146\u2013155"},{"key":"3578_CR58","unstructured":"Chaudhuri S, Narasayya V. Anytime algorithm of database tuning advisor for Microsoft SQL server. 2020. https:\/\/www.microsoft.com\/en-us\/research\/publication\/anytime-algorithm-of-database-tuning-advisor-for-microsoft-sql-server\/"},{"key":"3578_CR59","unstructured":"Valentin G, Zuliani M, Zilio D C, et al. DB2 advisor: an optimizer smart enough to recommend its own indexes. In: Proceedings of IEEE International Conference on Data Engineering, 2000. 101\u2013110"},{"key":"3578_CR60","doi-asserted-by":"crossref","unstructured":"Bruno N, Chaudhuri S. Automatic physical database tuning: a relaxation-based approach. In: Proceedings of ACM SIGMOD International Conference on Management of Data, 2005. 227\u2013238","DOI":"10.1145\/1066157.1066184"},{"key":"3578_CR61","doi-asserted-by":"crossref","unstructured":"Dash D, Polyzotis N, Ailamaki A. CoPhy: a scalable, portable, and interactive index advisor for large workloads. In: Proceedings of the VLDB Endowment, 2011. 362\u2013372","DOI":"10.14778\/1978665.1978668"},{"key":"3578_CR62","doi-asserted-by":"crossref","unstructured":"Schlosser R, Kossmann J, Boissier M. Efficient scalable multi-attribute index selection using recursive strategies. In: Proceedings of IEEE International Conference on Data Engineering, 2019. 1238\u20131249","DOI":"10.1109\/ICDE.2019.00113"},{"key":"3578_CR63","doi-asserted-by":"crossref","unstructured":"Basu D, Lin Q, Chen W, et al. Regularized cost-model oblivious database tuning with reinforcement learning. In: Transactions on Large-Scale Data- and Knowledge-Centered Systems XXVIII, 2016. 28: 96\u2013132","DOI":"10.1007\/978-3-662-53455-7_5"},{"key":"3578_CR64","doi-asserted-by":"crossref","unstructured":"Sadri Z, Gruenwald L, Leal E. DRLindex: deep reinforcement learning index advisor for a cluster database. In: Proceedings of ACM Symposium on International Database Engineering & Applications, 2020. 1\u20138","DOI":"10.1145\/3410566.3410603"},{"key":"3578_CR65","doi-asserted-by":"crossref","unstructured":"Sadri Z, Gruenwald L, Leal E. Online index selection using deep reinforcement learning for a cluster database. In: Proceedings of IEEE International Conference on Data Engineering Workshops, 2020. 158\u2013161","DOI":"10.1109\/ICDEW49219.2020.00035"},{"key":"3578_CR66","unstructured":"Sharma A, Schuhknecht F M, Dittrich J. The case for automatic database administration using deep reinforcement learning. 2018. ArXiv:1801.05643"},{"key":"3578_CR67","doi-asserted-by":"crossref","unstructured":"Lan H, Bao Z, Peng Y. An index advisor using deep reinforcement learning. In: Proceedings of International Conference on Information and Knowledge Management, 2020. 2105\u20132108","DOI":"10.1145\/3340531.3412106"},{"key":"3578_CR68","doi-asserted-by":"crossref","unstructured":"Ding B, Das S, Marcus R, et al. AI meets AI: leveraging query executions to improve index recommendations. In: Proceedings of ACM SIGMOD International Conference on Management of Data, 2019. 1241\u20131258","DOI":"10.1145\/3299869.3324957"},{"key":"3578_CR69","doi-asserted-by":"publisher","first-page":"72","DOI":"10.1016\/j.asoc.2015.01.026","volume":"30","author":"T D\u00f6keroglu","year":"2015","unstructured":"D\u00f6keroglu T, Bayir M A, Cosar A. Robust heuristic algorithms for exploiting the common tasks of relational cloud database queries. Appl Soft Computing, 2015, 30: 72\u201382","journal-title":"Appl Soft Computing"},{"key":"3578_CR70","unstructured":"Zilio D C, Zuzarte C, Lightstone S, et al. Recommending materialized views and indexes with the IBM DB2 design advisor. In: Proceedings of International Conference on Autonomic Computing, 2004. 180\u2013187"},{"key":"3578_CR71","doi-asserted-by":"crossref","unstructured":"Jindal A, Karanasos K, Rao S, et al. Selecting subexpressions to materialize at datacenter scale. In: Proceedings of the VLDB Endowment, 2018. 800\u2013812","DOI":"10.14778\/3192965.3192971"},{"key":"3578_CR72","doi-asserted-by":"crossref","unstructured":"Jindal A, Qiao S, Patel H, et al. Computation reuse in analytics job service at Microsoft. In: Proceedings of ACM SIGMOD International Conference on Management of Data, 2018. 191\u2013203","DOI":"10.1145\/3183713.3190656"},{"key":"3578_CR73","doi-asserted-by":"crossref","unstructured":"Yuan H, Li G, Feng L, et al. Automatic view generation with deep learning and reinforcement learning. In: Proceedings of IEEE International Conference on Data Engineering, 2020. 1501\u20131512","DOI":"10.1109\/ICDE48307.2020.00133"},{"key":"3578_CR74","unstructured":"Liang X, Elmore A J, Krishnan S. Opportunistic view materialization with deep reinforcement learning. 2019. ArXiv:1903.01363"},{"key":"3578_CR75","doi-asserted-by":"crossref","unstructured":"Serafini M, Mansour E, Aboulnaga A, et al. Accordion: elastic scalability for database systems supporting distributed transactions. In: Proceedings of the VLDB Endowment, 2014. 1035\u20131046","DOI":"10.14778\/2732977.2732979"},{"key":"3578_CR76","doi-asserted-by":"crossref","unstructured":"Taft R, Mansour E, Serafini M, et al. E-Store: fine-grained elastic partitioning for distributed transaction processing systems. In: Proceedings of the VLDB Endowment, 2014. 245\u2013256","DOI":"10.14778\/2735508.2735514"},{"key":"3578_CR77","doi-asserted-by":"crossref","unstructured":"Serafini M, Taft R, Elmore A J, et al. Clay: fine-grained adaptive partitioning for general database schemas. In: Proceedings of the VLDB Endowment, 2016. 445\u2013456","DOI":"10.14778\/3025111.3025125"},{"key":"3578_CR78","doi-asserted-by":"crossref","unstructured":"Marcus R, Papaemmanouil O, Semenova S, et al. NashDB: an end-to-end economic method for elastic database fragmentation, replication, and provisioning. In: Proceedings of ACM SIGMOD International Conference on Management of Data, 2018. 1253\u20131267","DOI":"10.1145\/3183713.3196935"},{"key":"3578_CR79","doi-asserted-by":"crossref","unstructured":"Taft R, El-Sayed N, Serafini M, et al. P-Store: an elastic database system with predictive provisioning. In: Proceedings of ACM SIGMOD International Conference on Management of Data, 2018. 205\u2013219","DOI":"10.1145\/3183713.3190650"},{"key":"3578_CR80","doi-asserted-by":"crossref","unstructured":"Das S, Nishimura S, Agrawal D, et al. Albatross: lightweight elasticity in shared storage databases for the cloud using live data migration. In: Proceedings of the VLDB Endowment, 2011. 494\u2013505","DOI":"10.14778\/2002974.2002977"},{"key":"3578_CR81","doi-asserted-by":"crossref","unstructured":"Elmore A J, Das S, Agrawal D, et al. Zephyr: live migration in shared nothing databases for elastic cloud platforms. In: Proceedings of ACM SIGMOD International Conference on Management of Data, 2011. 301\u2013312","DOI":"10.1145\/1989323.1989356"},{"key":"3578_CR82","doi-asserted-by":"crossref","unstructured":"Elmore A J, Arora V, Taft R, et al. Squall: fine-grained live reconfiguration for partitioned main memory databases. In: Proceedings of ACM SIGMOD International Conference on Management of Data, 2015. 299\u2013313","DOI":"10.1145\/2723372.2723726"},{"key":"3578_CR83","doi-asserted-by":"crossref","unstructured":"Lin Y, Pi S, Liao M, et al. MgCrab: transaction crabbing for live migration in deterministic database systems. In: Proceedings of the VLDB Endowment, 2019. 597\u2013610","DOI":"10.14778\/3303753.3303764"},{"key":"3578_CR84","doi-asserted-by":"crossref","unstructured":"Ding X, Chen L, Gao Y, et al. UlTraMan: a unified platform for big trajectory data management and analytics. In: Proceedings of the VLDB Endowment, 2018. 787\u2013799","DOI":"10.14778\/3192965.3192970"},{"key":"3578_CR85","doi-asserted-by":"publisher","first-page":"287","DOI":"10.1007\/s00778-021-00652-x","volume":"30","author":"Z Fang","year":"2021","unstructured":"Fang Z, Chen L, Gao Y, et al. Dragoon: a hybrid and efficient big trajectory management system for offline and online analytics. VLDB J, 2021, 30: 287\u2013310","journal-title":"VLDB J"},{"key":"3578_CR86","doi-asserted-by":"crossref","unstructured":"Shao S, Qiu Z, Yu X, et al. Database-access performance antipatterns in database-backed web applications. In: Proceedings of IEEE International Conference on Software Maintenance and Evolution (ICSME), 2020. 58\u201369","DOI":"10.1109\/ICSME46990.2020.00016"},{"key":"3578_CR87","doi-asserted-by":"crossref","unstructured":"Khumnin P, Senivongse T. SQL antipatterns detection and database refactoring process. In: Proceedings of IEEE\/ACIS International Conference on Software Engineering, Artificial Intelligence, Networking and Parallel\/Distributed Computing (SNPD), 2017. 199\u2013205","DOI":"10.1109\/SNPD.2017.8022723"},{"key":"3578_CR88","doi-asserted-by":"crossref","unstructured":"Dintyala P, Narechania A, Arulraj J. SQLCheck: automated detection and diagnosis of SQL anti-patterns. In: Proceedings of ACM SIGMOD International Conference on Management of Data, 2020. 2331\u20132345","DOI":"10.1145\/3318464.3389754"},{"key":"3578_CR89","doi-asserted-by":"publisher","first-page":"741","DOI":"10.1007\/s11390-021-1350-8","volume":"36","author":"J K Ge","year":"2021","unstructured":"Ge J K, Chai Y F, Chai Y P. WATuning: a workload-aware tuning system with attention-based deep reinforcement learning. J Comput Sci Technol, 2021, 36: 741\u2013761","journal-title":"J Comput Sci Technol"},{"key":"3578_CR90","doi-asserted-by":"crossref","unstructured":"Sullivan D G, Seltzer M I, Pfeffer A. Using probabilistic reasoning to automate software tuning. In: Proceedings of the Joint International Conference on Measurement and Modeling of Computer Systems, 2004. 404\u2013405","DOI":"10.1145\/1012888.1005739"},{"key":"3578_CR91","doi-asserted-by":"crossref","unstructured":"Zhang X, Chang Z, Li Y, et al. Facilitating database tuning with hyper-parameter optimization: a comprehensive experimental evaluation. In: Proceedings of the VLDB Endowment, 2022. 1808\u20131821","DOI":"10.14778\/3538598.3538604"},{"key":"3578_CR92","unstructured":"Tian W, Martin P, Powley W. Techniques for automatically sizing multiple buffer pools in DB2. In: Proceedings of Conference of the Centre for Advanced Studies on Collaborative Research, 2003. 294\u2013302"},{"key":"3578_CR93","doi-asserted-by":"crossref","unstructured":"Narayanan D, Thereska E, Ailamaki A. Continuous resource monitoring for self-predicting DBMS. In: Proceedings of IEEE International Symposium on Modeling, Analysis, and Simulation of Computer and Telecommunication Systems, 2005. 239\u2013248","DOI":"10.1109\/MASCOTS.2005.21"},{"key":"3578_CR94","doi-asserted-by":"crossref","unstructured":"Hutter F, Hoos H H, Leyton-Brown K. Sequential model-based optimization for general algorithm configuration. In: Proceedings of International Conference on Learning and Intelligent Optimization, 2011. 507\u2013523","DOI":"10.1007\/978-3-642-25566-3_40"},{"key":"3578_CR95","doi-asserted-by":"crossref","unstructured":"McKay M D. Latin hypercube sampling as a tool in uncertainty analysis of computer models. In: Proceedings of Conference on Winter Simulation, 1992. 557\u2013564","DOI":"10.1145\/167293.167637"},{"key":"3578_CR96","unstructured":"Zaharia M, Chowdhury M, Das T, et al. Resilient distributed datasets: a fault-tolerant abstraction for in-memory cluster computing. In: Proceedings of USENIX Symposium on Networked Systems Design and Implementation, 2012. 15\u201328"},{"key":"3578_CR97","doi-asserted-by":"crossref","unstructured":"Li Y, Shen Y, Zhang W, et al. OpenBox: a generalized black-box optimization service. In: Proceedings of ACM SIGKDD Conference on Knowledge Discovery & Data Mining, 2021. 3209\u20133219","DOI":"10.1145\/3447548.3467061"},{"key":"3578_CR98","doi-asserted-by":"crossref","unstructured":"Zhang X, Wu H, Li Y, et al. Towards dynamic and safe configuration tuning for cloud databases. In: Proceedings of International Conference on Management of Data, 2022","DOI":"10.1145\/3514221.3526176"},{"key":"3578_CR99","unstructured":"Lillicrap T P, Hunt J J, Pritzel A, et al. Continuous control with deep reinforcement learning. In: Proceedings of the International Conference on Learning Representations, 2016"},{"key":"3578_CR100","first-page":"679","volume":"6","author":"R E Bellman","year":"1957","unstructured":"Bellman R E. A Markov decision process. J Math Fluid Mech, 1957, 6: 679\u2013684","journal-title":"J Math Fluid Mech"},{"key":"3578_CR101","doi-asserted-by":"crossref","unstructured":"Schnaitter K, Polyzotis N, Getoor L. Index interactions in physical design tuning: modeling, analysis, and applications. In: Proceedings of the VLDB Endowment, 2009. 1234\u20131245","DOI":"10.14778\/1687627.1687766"},{"key":"3578_CR102","doi-asserted-by":"crossref","unstructured":"Kossmann J, Halfpap S, Jankrift M, et al. Magic mirror in my hand, which is the best in the land? An experimental evaluation of index selection algorithms. In: Proceedings of the VLDB Endowment, 2020. 2382\u20132395","DOI":"10.14778\/3407790.3407832"},{"key":"3578_CR103","doi-asserted-by":"publisher","DOI":"10.1002\/9780470316887","volume-title":"Markov Decision Processes: Discrete Stochastic Dynamic Programming","author":"M L Puterman","year":"1994","unstructured":"Puterman M L. Markov Decision Processes: Discrete Stochastic Dynamic Programming. New York: John Wiley & Sons, Inc., 1994"},{"key":"3578_CR104","first-page":"1107","volume":"4","author":"M G Lagoudakis","year":"2003","unstructured":"Lagoudakis M G, Parr R. Least-squares policy iteration. J Mach Learn Res, 2003, 4: 1107\u20131149","journal-title":"J Mach Learn Res"},{"key":"3578_CR105","unstructured":"Mnih V, Kavukcuoglu K, Silver D, et al. Playing atari with deep reinforcement learning. 2013. ArXiv:1312.5602"},{"key":"3578_CR106","doi-asserted-by":"publisher","first-page":"529","DOI":"10.1038\/nature14236","volume":"518","author":"V Mnih","year":"2015","unstructured":"Mnih V, Kavukcuoglu K, Silver D, et al. Human-level control through deep reinforcement learning. Nature, 2015, 518: 529\u2013533","journal-title":"Nature"},{"key":"3578_CR107","doi-asserted-by":"crossref","unstructured":"Cosar A, Lim E, Srivastava J. Multiple query optimization with depth-first branch-and-bound and dynamic query ordering. In: Proceedings of International Conference on Information and Knowledge Management, 1993. 433\u2013438","DOI":"10.1145\/170088.170181"},{"key":"3578_CR108","unstructured":"Mitchell M, Holland J H, Forrest S. When will a genetic algorithm outperform hill climbing. In: Proceedings of Conference and Workshop on Neural Information Processing Systems, 1993. 51\u201358"},{"key":"3578_CR109","doi-asserted-by":"publisher","first-page":"273","DOI":"10.1162\/1063656041774983","volume":"12","author":"M Lozano","year":"2004","unstructured":"Lozano M, Herrera F, Krasnogor N, et al. Real-coded memetic algorithms with crossover hill-climbing. Evolary Computation, 2004, 12: 273\u2013302","journal-title":"Evolary Computation"},{"key":"3578_CR110","doi-asserted-by":"publisher","first-page":"264","DOI":"10.1016\/j.asoc.2014.01.036","volume":"19","author":"F Tao","year":"2014","unstructured":"Tao F, Feng Y, Zhang L, et al. CLPS-GA: a case library and Pareto solution-based hybrid genetic algorithm for energy-aware cloud service scheduling. Appl Soft Computing, 2014, 19: 264\u2013279","journal-title":"Appl Soft Computing"},{"key":"3578_CR111","doi-asserted-by":"crossref","unstructured":"Martella C, Logothetis D, Loukas A, et al. Spinner: scalable graph partitioning in the cloud. In: Proceedings of IEEE International Conference on Data Engineering, 2017. 1083\u20131094","DOI":"10.1109\/ICDE.2017.153"},{"key":"3578_CR112","doi-asserted-by":"crossref","unstructured":"Chaiken R, Jenkins B, Larson P, et al. SCOPE: easy and efficient parallel processing of massive data sets. In: Proceedings of the VLDB Endowment, 2008. 1265\u20131276","DOI":"10.14778\/1454159.1454166"},{"key":"3578_CR113","doi-asserted-by":"publisher","first-page":"611","DOI":"10.1007\/s00778-012-0280-z","volume":"21","author":"J Zhou","year":"2012","unstructured":"Zhou J, Bruno N, Wu M C, et al. SCOPE: parallel databases meet MapReduce. VLDB J, 2012, 21: 611\u2013636","journal-title":"VLDB J"},{"key":"3578_CR114","doi-asserted-by":"publisher","first-page":"65","DOI":"10.1007\/s41019-019-00114-z","volume":"5","author":"Y Ji","year":"2020","unstructured":"Ji Y, Chai Y, Zhou X, et al. Smart intra-query fault tolerance for massive parallel processing databases. Data Sci Eng, 2020, 5: 65\u201379","journal-title":"Data Sci Eng"},{"key":"3578_CR115","doi-asserted-by":"publisher","first-page":"53","DOI":"10.1007\/s007780050033","volume":"6","author":"M Mehta","year":"1997","unstructured":"Mehta M, DeWitt D J. Data placement in shared-nothing parallel database systems. VLDB J, 1997, 6: 53\u201372","journal-title":"VLDB J"},{"key":"3578_CR116","unstructured":"Chen G, He W, Liu J, et al. Energy-aware server provisioning and load dispatching for connection-intensive internet services. In: Proceedings of USENIX Symposium on Networked Systems Design and Implementation, 2012. 337\u2013350"},{"key":"3578_CR117","doi-asserted-by":"crossref","unstructured":"Kallman R, Kimura H, Natkins J, et al. H-store: a high-performance, distributed main memory transaction processing system. In: Proceedings of the VLDB Endowment, 2008. 1496\u20131499","DOI":"10.14778\/1454159.1454211"},{"key":"3578_CR118","first-page":"45","volume":"8","author":"D Hao","year":"2020","unstructured":"Hao D, Luo S M, Zhang H S. A distributed in-memory database solution for mass data applications. ZTE Commun, 2020, 8: 45\u201348","journal-title":"ZTE Commun"}],"container-title":["Science China Information Sciences"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/s11432-021-3578-6.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/link.springer.com\/article\/10.1007\/s11432-021-3578-6\/fulltext.html","content-type":"text\/html","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/s11432-021-3578-6.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2024,10,12]],"date-time":"2024-10-12T07:18:48Z","timestamp":1728717528000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/s11432-021-3578-6"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2023,1,11]]},"references-count":118,"journal-issue":{"issue":"2","published-print":{"date-parts":[[2023,2]]}},"alternative-id":["3578"],"URL":"https:\/\/doi.org\/10.1007\/s11432-021-3578-6","relation":{},"ISSN":["1674-733X","1869-1919"],"issn-type":[{"value":"1674-733X","type":"print"},{"value":"1869-1919","type":"electronic"}],"subject":[],"published":{"date-parts":[[2023,1,11]]},"assertion":[{"value":"20 December 2021","order":1,"name":"received","label":"Received","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"8 March 2022","order":2,"name":"revised","label":"Revised","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"11 July 2022","order":3,"name":"accepted","label":"Accepted","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"11 January 2023","order":4,"name":"first_online","label":"First Online","group":{"name":"ArticleHistory","label":"Article History"}}],"article-number":"121102"}}