Research on SQL Performance Optimization of CRM Stored Procedure

Abstract:

In this paper, we research the stored procedure combined with the bank CRM system. Mainly introduces how to improve the efficiency of the stored procedure in ORACLEs PL/SQL in the banks CRM system.

• Periodical: Applied Mechanics and Materials (Volumes 519-520)
• Pages: 28-31
• DOI: https://doi.org/10.4028/www.scientific.net/AMM.519-520.28
• Online since: February 2014
• Authors: Rui Wang*, Na Wang
• Keywords: Oracle, PL/SQL, SQL Performance Optimization

References

[1] Hongji ZHANG, Xuping LI, Yong LUO, Lianze TENG, Aiqun DAI. Design and Building of the New Countryside Construction Database Based on ArcSDE and SQL Server[J]. Asian Agricultural Research. 2013(08).

[2] GUO Min. ORACLE database SQL optimization principle[J]. Computer Systems & Applications. (2010).

[3] Dileepa Jayathilake, Charith Sooriaarachchi, Thilok Gunawardena, Buddhika Kulasuriya, Thusitha Dayaratne. A Study Into the Capabilities of NoSQL Databases in Handling a Highly Heterogeneous Tree[A]. Proceedings of 2012 IEEE 6th International Conference on Information and Automation for Sustainability（ICIAFS2012）[C]. (2012).

DOI: 10.1109/iciafs.2012.6419890

[4] Jujiang Cao, Longgang Li and Xiuyu Meng Department of Mechanical and Electrical Engineering Shaanxi University of Science & Technology Xi'an, Shaanxi Province, China. Application of Kingview SQL Database Technology in Traditional Chinese Medicine Dropping Pill Packing Control System[A]. Proceedings of 2010 International Conference on Broadcast Technology and Multimedia Communication(Volume 3)[C]. (2010).

DOI: 10.1007/978-3-642-03718-4_16

[5] Sangita Roy, Avinash Kumar Singh, Ashok Singh Sairam. Analyzing SQL Meta Characters and Preventing SQL Injection Attacks Using Meta Filter[A]. Proceedings of International Conference on Information and Electronics Engineering（ICIEE 2011）[C]. (2011).

[6] A New Algorithm for Quantitative Association Rule Mining Based on SQL Language[A]. Proceedings of 2010 4th International Conference on Intelligent Information Technology Application(Volume 1)[C]. (2010).

[7] Atefeh Tajpou, Maslin Masrom, Mohammad Zaman Heydari, Suhaimi Ibrahim. SQL Injection Detection and Prevention Tools Assessment[A]. Proceedings of 2010 3rd IEEE International Conference on Computer Science and Information Technology VOL. 9[C]. (2010).

DOI: 10.1109/iccsit.2010.5563777

[8] WU Jie-ming, ZHOU Jin. Research on query optimization rules of Oracle database based on SQL[J]. Journal of Shaanxi University of Technology(Natural Science Edition). (2013).

[9] Zhang Yun Fan. Analysis of performance optimization of database based on SQL[J]. China Management Informationization. (2013).

[10] GUO Xia. Analysis of SQL statement optimization based on ORACLE database[J]. Computer Knowledge and Technology. (2013).