CFP last date
22 April 2024
Call for Paper
May Edition
IJCA solicits high quality original research papers for the upcoming May edition of the journal. The last date of research paper submission is 22 April 2024

Submit your paper
Know more
The week's pick
Responsive image
Enhancing Privacy Preservation: Multi-Attribute Protection with P-Sensitive K-Anonymity

Twinkle Patel Kiran Amin
Random Articles
Reseach Article

Experiment of Query Optimization Techniques to get the Efficient Query

by Luqman Hakim, Suryanto Nugroho, Sigit Hadi Waluyo
journal cover thumbnail

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

Luqman Hakim, Suryanto Nugroho, Sigit Hadi Waluyo . Experiment of Query Optimization Techniques to get the Efficient Query. International Journal of Computer Applications. 170, 10 ( Jul 2017), 6-10. DOI=10.5120/ijca2017914888

@article{ 10.5120/ijca2017914888,
author = { Luqman Hakim, Suryanto Nugroho, Sigit Hadi Waluyo },
title = { Experiment of Query Optimization Techniques to get the Efficient Query },
journal = { International Journal of Computer Applications },
issue_date = { Jul 2017 },
volume = { 170 },
number = { 10 },
month = { Jul },
year = { 2017 },
issn = { 0975-8887 },
pages = { 6-10 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume170/number10/28104-2017914888/ },
doi = { 10.5120/ijca2017914888 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-07T00:18:06.147720+05:30
%A Luqman Hakim
%A Suryanto Nugroho
%A Sigit Hadi Waluyo
%T Experiment of Query Optimization Techniques to get the Efficient Query
%J International Journal of Computer Applications
%@ 0975-8887
%V 170
%N 10
%P 6-10
%D 2017
%I Foundation of Computer Science (FCS), NY, 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.
Index Terms

Computer Science
Information Sciences

Keywords

Database Relation Structured Query Language Database Optimization Database Management System.

Powered by PhDFocusTM