Browse > Article
http://dx.doi.org/10.17703/JCCT.2020.6.4.693

Methods for improving Database Performance through SQL Analysis in the Course Registration System  

Kim, Hee Wan (Div. of Computer Science and Engineering, Sahmyook University)
Publication Information
The Journal of the Convergence on Culture Technology / v.6, no.4, 2020 , pp. 693-701 More about this Journal
Abstract
In this paper, SQL statements are analyzed to improve database performance in the current course registration system. The performance of the current database was measured through the execution plan of the SQL statements used in the transactions related to the course registration. Through the SQL analysis, the complemented SQL statements confirmed the improved performance. Overall, the performance of the course registration database system was improved through the analysis of the execution plan, and some improvement methods of the course registration SQL were shown as test results. The improved method is to reorganize the tables and index tables related to the course registration through database tuning, and utilize the SQL function to implement an optimized system that has evolved into a course database system with improved performance. The enrollment system re-adjusted by the proposed method showed excellent results in terms of performance compared to the previous enrollment system, and the integrated performance test result reduced the response time by 1.8 to 18 times.
Keywords
course registration; database performance; SQL analysis; execution plan; index table;
Citations & Related Records
Times Cited By KSCI : 2  (Citation Analysis)
연도 인용수 순위
1 Peng Y., Liu N., Li Y., and Shao Z., "Design and implementation of the online course registration system at Tsinghua University," IEEE International Conference on Systems and Informatics (ICSI), pp. 1179-1182, 2012. https://doi.org/10.1109/icsai.2012.6223244   DOI
2 Ala'a M., "Online registration system," International Journal of Computer Science and Security (IJCSS), Vo. 4, No 3, pp. 331-340, 2010.
3 Tang Y.F., and Zhang Y.S., "Design and implementation of college student information management system based on web Services," IEEE International Symposium on IT in Medicine and Education (ITIME'09), pp. 1044-1048, 2009. https://doi.org/10.1109/itime.2009.5236230   DOI
4 T. G. Lee, "Data Pattern Modeling for Bio-information Processing based on OpenBCI Platform," The Journal of the Convergence on Culture Technology (JCCT) Vol. 5, No. 4, pp.451-456, 2019. http://dx.doi.org/10.17703/JCCT.2019.5.4.451   DOI
5 K. M. Park, "Partial Range Scan For Increased Relational Database System Performance," Korea Information Science Society Summer Conference, Vol. 37, No. 1C, pp.1737-1739, Jun. 2010.
6 U. S. Han, The Guide for Data Architecture Professional, Korea Database Agency, 2010.
7 W. C. Lee, S. N. Kim, and S. M. Lee, "Performance Improvement Method of Course Registration System," 2014 Korea Information Science Society Winter Conference, pp. 162-164, Dec. 2014.
8 D. H. Kim, H. G. Mun, and H. G. Shin, "Implementation of Web Service Overload Protection Using NetFUNNEL - Focused on the Course Registration Guide System for University ," Korea Information Science Society Summer Conference, pp.1980-1982, Jun. 2014.
9 Laghari M.S., "Automated course advising system," International Journal of Machine Learning and Computing, Vol. 4, No. 1, pp. 47-55, 2014. https://doi.org/10.7763/ijmlc.2014.v4.384   DOI
10 H. J. Choi,J. W. Ock, J. Y. Jeong, M. C. Kim, and E. J. Lee, "Analysis and improvement of class registration system," Korea Information Science Society Summer Conference, pp.1737-1739, Jun. 2019.
11 Liu Y., Gao F., and Liu Y., "Design and implementation of student registration system for universities," IEEE 2nd International Conference on Consumer Electronics, Communications, and Networks (CECNet), pp. 1760-1763, 2012. https://doi.org/10.1109/cecnet.2012.6202263   DOI
12 J. Y. Shin, and S. W. Lee, "A Simulation for improvement course registration," Korea Information Science Society Summer Conference, pp.1736-1738, Jun. 2016.
13 Y. J. Lim, and E. M. Choi, "Performance Comparison of HW and SW L4 Switches in Various Workload," Journal of Korean Information Science Society, Vol.30, No.2, pp475-477, 2003.
14 J. J. Kim, and H. Y. Nho, "Design and Implementation of University Registration System Using MMDBMS," Basic Science Research, Vol. 21, pp.41-54, Kangwon University, 2010.