The week's pick
Random Articles
Reseach Article
A Survey of Various Query Optimization Techniques
| International Journal of Computer Applications |
| Foundation of Computer Science (FCS), NY, USA |
| Volume 173 - Number 5 |
| Year of Publication: 2017 |
| Authors: Rini John, Nikita Palaskar |
10.5120/ijca2017915286
|
Rini John, Nikita Palaskar . A Survey of Various Query Optimization Techniques. International Journal of Computer Applications. 173, 5 ( Sep 2017), 36-38. DOI=10.5120/ijca2017915286
Abstract
Data storage and retrieving the data on a specific time frame is critical for any application today. So an efficiently designed query lets the user get the results in the desired time and creates the credibility for the corresponding application. Here in this paper various techniques which are currently used or proposed in recent years and to get a better perspective in this field of query optimization are explored. Automatic external SQL-query optimization method is where the principle of building queries regardless of applied database management system and its settings is explored. It would be interesting to explore the work of authors where they have proposed the energy-efficient query processing and optimization based on a database accelerator.
References
- Nicoleta Angelescu, Henri George Coanda, Ion Caciula*, Catalin Dragoi and Felix Albu., “SQL Query Optimization in Content Based Image Retrieval Systems”, IEEE 2016 International Conference on Communications (COMM)
- Varun Garg, “Optimization of Multiple Queries for Big Data with Apache Hadoop/Hive.”, IEEE 2015 International Conference on Computational Intelligence and Communication Networks (CICN).
- Sebastian Haas; Oliver Arnold; Stefan Scholze; Sebastian Höppner; Georg Ellguth; Andreas Dixius; Annett Ungethüm; Eric Mier; Benedikt Nöthen; Emil Matúš; Stefan Schiefer; Love Cederstroem; Fabian Pilz; Christian Mayr; René Schüffny; Wolfgang Lehner; Gerhard P. Fettweis, “A Database Accelerator for Energy-Efficient Query Processing and Optimization”, 2016 IEEE Nordic Circuits and Systems Conference (NORCAS) in Proc. Int. Conf.
- Myungcheol Lee; Miyoung Lee; ChangSoo Kim, “A JIT Compilation-based Unified SQL Query Optimization System”, 2016 IEEE 6th International Conference on IT Convergence and Security (ICITCS).
- M. Zagirnyak; P. Kostenko, “External optimization of SQL-query under conditions of databases structural uncertainty”, 2016 IEEE 17th International Conference Computational Problems of Electrical Engineering (CPEE)
Index Terms
Keywords