Automating Exadata Performance Optimization Using AI and Predictive Analytics
Abstract
The automated performance optimization of Oracle Exadata with the help of artificial intelligence and predictive analytics represent evolutionary approach to database management, significantly enhancing efficiency, resource utilization, and system reliability. The objective of this research paper is to dive deep into advanced AI-driven methodologies for workload analysis, anomaly detection, and real-time performance tuning, which utilizes machine learning models to train on historical workload data to predict system bottlenecks and optimize query execution plans dynamically.
Downloads
References
S. Chaudhuri, "An Overview of Query Optimization in Relational Systems," Proceedings of the 17th ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems, Seattle, WA, USA, 1998, pp. 34-43.
M. J. Franklin, "Concurrency Control and Recovery," The VLDB Journal, vol. 5, no. 1, pp. 85-100, Mar. 1996.
A. Pavlo et al., "Self-Driving Database Management Systems," CIDR, Asilomar, CA, USA, 2017, pp. 1-12.
J. Dean and L. A. Barroso, "The Tail at Scale," Communications of the ACM, vol. 56, no. 2, pp. 74-80, 2013.
S. Krishnan, J. Franklin, and J. D. Ullman, "AI in Databases: New Directions and Emerging Trends," ACM Computing Surveys, vol. 53, no. 3, pp. 1-40, Jun. 2021.
G. Hinton, L. Deng, and D. Yu, "Deep Learning for AI," Proceedings of the IEEE, vol. 105, no. 4, pp. 229-234, 2017.
R. Marcus and O. Papaemmanouil, "Deep Reinforcement Learning for Join Query Optimization," ACM SIGMOD International Conference on Management of Data, Houston, TX, USA, 2018, pp. 3-16.
A. Kipf et al., "Learned Cardinalities: Estimating Correlated Joins with Deep Learning," CIDR, Amsterdam, Netherlands, 2019.
T. Kraska, A. Beutel, E. H. Chi, J. Dean, and N. Polyzotis, "The Case for Learned Index Structures," ACM SIGMOD International Conference on Management of Data, Houston, TX, USA, 2018, pp. 489-504.
S. Dutt, P. B. Gibbons, and A. Meliou, "AI-Driven Query Optimization: A Survey of Recent Advancements," ACM Computing Surveys, vol. 56, no. 1, pp. 1-32, 2023.
H. Samet, "Foundations of Multidimensional and Metric Data Structures," Morgan Kaufmann, 2006.
K. Chen, L. Li, and X. Zhang, "Adaptive Caching Techniques for High-Performance Databases: An AI Perspective," IEEE Transactions on Knowledge and Data Engineering, vol. 35, no. 7, pp. 1289-1304, 2023.
T. Mitchell, "Machine Learning," McGraw-Hill Science/Engineering/Math, 1997.
R. S. Sutton and A. G. Barto, "Reinforcement Learning: An Introduction," MIT Press, 2018.
P. Bailis, A. Davidson, and S. Narayanan, "Fast Query Execution via Machine Learning," Proceedings of the VLDB Endowment, vol. 12, no. 3, pp. 123-134, 2022.
S. Aken, A. Pavlo, G. Gordon, and B. Zhang, "Automatic Database Management System Tuning Through Large-Scale Machine Learning," ACM SIGMOD International Conference on Management of Data, Chicago, IL, USA, 2017, pp. 1009-1024.
C. Curino et al., "Workload-Aware Database Partitioning," Proceedings of the ACM SIGMOD International Conference on Management of Data, Providence, RI, USA, 2010, pp. 21-32.
J. Wang and S. Wu, "AI-Driven Anomaly Detection in High-Performance Computing Systems," IEEE Transactions on Parallel and Distributed Systems, vol. 33, no. 6, pp. 2345-2359, 2022.
A. J. Smola and S. V. N. Vishwanathan, "Introduction to Machine Learning," Cambridge University Press, 2008.
H. Garcia-Molina, J. D. Ullman, and J. Widom, "Database Systems: The Complete Book," Pearson, 2019.
