Call for Paper - January 2022 Edition
IJCA solicits original research papers for the January 2022 Edition. Last date of manuscript submission is December 20, 2021. Read More

Experiment of Query Optimization Techniques to get the Efficient Query

Print
PDF
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Year of Publication: 2017
Authors:
Luqman Hakim, Suryanto Nugroho, Sigit Hadi Waluyo
10.5120/ijca2017914888

Luqman Hakim, Suryanto Nugroho and Sigit Hadi Waluyo. Experiment of Query Optimization Techniques to get the Efficient Query. International Journal of Computer Applications 170(10):6-10, July 2017. BibTeX

@article{10.5120/ijca2017914888,
	author = {Luqman Hakim and Suryanto Nugroho and Sigit Hadi Waluyo},
	title = {Experiment of Query Optimization Techniques to get the Efficient Query},
	journal = {International Journal of Computer Applications},
	issue_date = {July 2017},
	volume = {170},
	number = {10},
	month = {Jul},
	year = {2017},
	issn = {0975-8887},
	pages = {6-10},
	numpages = {5},
	url = {http://www.ijcaonline.org/archives/volume170/number10/28104-2017914888},
	doi = {10.5120/ijca2017914888},
	publisher = {Foundation of Computer Science (FCS), NY, USA},
	address = {New York, USA}
}

Abstract

Optimization of a database query becomes one of the critical phases in data processing handling. Database optimization is needed to make a structured query language more concise and efficient. This study aims to conduct experiments with structured query language modifications compared to structured query language examples commonly used in the manufacture of software. This study uses a database with a record large enough to try to implement its SQL. The results of the experiments of all modified query writing are more efficient than the queries used by the information system in the database regarding data processing time.

References

  1. Wenjiao, B, Jiming, L, Jichao, T & LI, S. Query Optimization of Distributed Database Based on Parallel Genetic Algorithm and Max-Min Ant System. 2015 8th International Symposium on Computational Intelligence and Design, 2015.
  2. Habimana, J. 2015. Query Optimization Techniques - Tips For Writing Efficient And Faster SQL Queries. International Journal Of Scientific & Technology Research, 4, 22-26.
  3. Gordon C. Everest. 2005 Fundamentals of Database System Benyamin Tokyo.
  4. ARIPIN 2010. Meningkatkan Efektifitas Pengelolaan Database Dengan Optimasi SQL. Techno.Com, 9.
  5. Haas, S., Arnold, O., Scholzey, S., H¨Oppnery, S., Ellguthy, G., Andreas Dixiusy, Ungeth¨Umz, A., Mierz, E., N¨Othen, B., Mat´Uˇs, E., Schiefery, S., Cederstroemy, L., Pilzx, F., Mayry, C., Sch¨Uffnyy, R. E., Lehnerz, W. & Fettweis , G. P. 2016. A Database Accelerator For Energy-Efficient Query Processing And Optimization.
  6. Lakshmi, S. V. & Vatsavayi, V. K. Query Optimization Using Clustering And Genetic Algorithm For Distributed Databases. 2016 International Conference On Computer Communication And Informatics (Iccci -2016), 2016 Coimbatore, India.

Keywords

Database Relation, Structured Query Language, Database Optimization, Database Management System.