Transformer-Based Auto-Tuner for PL/SQL and Shell Scripts
Keywords:
transformer models, auto-tuning, PL/SQL optimization, shell scripting, runtime trace analysis, neural code transformationAbstract
The objective of this research is to introduces a transformer-based auto-tuning architecture to improve PL/SQL and shell script performance in legacy business workloads. Inefficient constructions like nested loops and join operations are identified using runtime execution traces and rewritten utilising neural sequence-to-sequence transformations in the proposed system. To ensure consistency and determine the optimal program run, we compare each alteration to performance baselines.
Downloads
References
A. Vaswani et al., "Attention is All You Need," Advances in Neural Information Processing Systems, vol. 30, pp. 5998–6008, 2017.
M. Allamanis, E. T. Barr, P. Devanbu, and C. Sutton, "A Survey of Machine Learning for Big Code and Naturalness," ACM Computing Surveys, vol. 51, no. 4, pp. 81:1–81:37, 2018.
H. Zhang, Z. Chen, and J. Yang, "Automatic Optimization of SQL Queries Based on Deep Reinforcement Learning," Proceedings of the VLDB Endowment, vol. 12, no. 11, pp. 1857–1869, 2019.
A. Budhkar, R. Gupta, and V. Jain, "Learning to Synthesize Programs for Data Transformation Tasks," International Conference on Machine Learning, pp. 795–804, 2019.
M. T. Ribeiro, S. Singh, and C. Guestrin, "Why Should I Trust You?: Explaining the Predictions of Any Classifier," Proceedings of the 22nd ACM SIGKDD International Conference on Knowledge Discovery and Data Mining, pp. 1135–1144, 2016.
S. Ahmad, M. Chakraborty, and M. Ray, "A Survey on Automated Program Repair Techniques," Journal of Systems and Software, vol. 151, pp. 137–154, 2019.
J. Guo, S. Wang, and H. Wang, "Neural Program Repair by Jointly Learning to Localize and Repair," Proceedings of the 58th Annual Meeting of the Association for Computational Linguistics, pp. 4564–4575, 2020.
Y. Shin, S. Park, and E. Lee, "CodeBERT: A Pre-Trained Model for Programming and Natural Languages," arXiv preprint arXiv:2002.08155, 2020.
S. Liu, J. Zhang, and T. Chen, "Learning to Optimize Join Queries With Deep Reinforcement Learning," International Conference on Data Engineering (ICDE), pp. 151–162, 2020.
A. Vaswani, N. Shazeer, and J. Uszkoreit, "Tensor2Tensor for Neural Machine Translation," arXiv preprint arXiv:1803.07416, 2018.
P. T. Eugster, P. Felber, R. Guerraoui, and A.-M. Kermarrec, "The Many Faces of Publish/Subscribe," ACM Computing Surveys, vol. 35, no. 2, pp. 114–131, 2003.
D. Wang, R. J. Mooney, and C. Sutton, "Deep Learning for Programming Language Tasks: A Survey," IEEE Transactions on Neural Networks and Learning Systems, vol. 31, no. 10, pp. 3675–3693, 2020.
S. Gulwani, "Program Synthesis," Foundations and Trends in Programming Languages, vol. 4, no. 1-2, pp. 1–119, 2017.
D. Allamanis and M. Brockschmidt, "Learning to Represent Programs with Graphs," International Conference on Learning Representations (ICLR), 2018.
J. Devlin, M.-W. Chang, K. Lee, and K. Toutanova, "BERT: Pre-training of Deep Bidirectional Transformers for Language Understanding," Proceedings of NAACL-HLT, pp. 4171–4186, 2019.
S. Narayanan, M. A. Islam, and S. Khurshid, "Automated Detection of Performance Anti-Patterns in Database Applications," IEEE Transactions on Software Engineering, vol. 45, no. 4, pp. 320–338, 2019.
Y. Kim, S. Lee, and H. Kim, "Neural Code Completion," Proceedings of the 57th Annual Meeting of the Association for Computational Linguistics, pp. 1022–1031, 2019.
X. Huang, J. Yang, and H. Zhang, "Deep Learning-Based Optimization for Complex SQL Queries," Proceedings of the 2019 ACM SIGMOD International Conference on Management of Data, pp. 111–126, 2019.
T. Chen and C. Guestrin, "XGBoost: A Scalable Tree Boosting System," Proceedings of the 22nd ACM SIGKDD International Conference on Knowledge Discovery and Data Mining, pp. 785–794, 2016.
Y. Tian, M. He, and B. Li, "Performance Profiling and Analysis of Shell Scripts for System Automation," International Journal of Software Engineering and Knowledge Engineering, vol. 29, no. 3, pp. 405–426, 2019.
Downloads
Published
Issue
Section
License
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
