Search Results - SQL Query optimization

STRATEGIES FOR IMPROVING THE PERFORMANCE OF RUBY WEB APPLICATIONS: DATA CACHING AND SQL QUERY OPTIMIZATION

Authors: Topalidi A.

Subject Terms: data caching, SQL query optimization, web application performance, Redis, Memcached, ActiveRecord, N+1 queries

Advancements in SQL Query Optimization: A Review of Join Order and Index Selection

Authors: Nisuli Hettiarachchi Prasan Yapa

Source: 2025 5th International Conference on Machine Learning and Intelligent Systems Engineering (MLISE). :31-39

SPARK SQL QUERY OPTIMIZATION WITH REINFORCEMENT MACHINE LEARNING

Authors: Aakula, Ajay

ADVANCED QUERY OPTIMIZATION IN SQL DATABASES FOR REAL-TIME BIG DATA ANALYTICS

Authors: Rahman, Md Mostafizur Islam, Siful Kamruzzaman, Md et al.

Source: Academic Journal on Business Administration, Innovation & Sustainability; Vol. 4 No. 3 (2024): Academic Journal on Business Administration, Innovation & Sustainability; 1-14; 2997-9552

Index Terms: SQL Query Optimization, Multi-level Indexing, Query Rewriting, Dynamic Query Execution Plans, Big Data Analytics, info:eu-repo/semantics/article, info:eu-repo/semantics/publishedVersion, Peer-reviewed Article

URL: https://allacademicresearch.com/index.php/AJBAIS/article/view/77
https://allacademicresearch.com/index.php/AJBAIS/article/view/77/72
https://allacademicresearch.com/index.php/AJBAIS/article/view/77/72

The Examination of SQL Queries Efficiency in Chosen IT System

Authors: Krzysztof Barczak

Source: Journal of Computer Sciences Institute, Vol 28 (2023)

Subject Terms: 03 medical and health sciences, 0302 clinical medicine, databases, SQL query optimization, Electronic computers. Computer science, 0202 electrical engineering, electronic engineering, information engineering, Information technology, QA75.5-76.95, 02 engineering and technology, performance analysis, T58.5-58.64, testing

Access URL: https://doaj.org/article/9a9200af262249c58ce6bd01fcedff74

Spark SQL Query Optimization Based on Runtime Statistics Collection

Authors: Yong Zhao Rong Chen

Source: 2021 IEEE 6th International Conference on Cloud Computing and Big Data Analytics (ICCCBDA). :250-255

Subject Terms: 0202 electrical engineering, electronic engineering, information engineering, 02 engineering and technology

Access URL: http://ieeexplore.ieee.org/xpls/abs_all.jsp?arnumber=9442524
http://xplorestaging.ieee.org/ielx7/9442468/9442488/09442524.pdf?arnumber=9442524

Optimizing SQL Query Execution Time: A Hybrid Approach Using Machine Learning and Deep Learning Technique

Authors: Bethineni Saritha

Source: International Journal of Intelligent Systems and Applications in Engineering; Vol. 12 No. 4 (2024); 110-116

Subject Terms: Sql, Query optimization, machine learning, deep learning

File Description: application/pdf

Access URL: https://www.ijisae.org/index.php/IJISAE/article/view/6179

SQL Query Optimization in Distributed NoSQL Databases for Cloud-Based Applications

Authors: Aristeidis Karras Christos Karras Antonios Pervanas et al.

Source: Lecture Notes in Computer Science ISBN: 9783031334368

SQL Query Optimization Techniques

Authors: Kajal P. Pathak Priyanka R. Munot Dipali R. Patil

Source: IJARCCE. 8:87-90

Adaptive SQL Query Optimization in Distributed Stream Processing: A Preliminary Study

Authors: Darya Sharkova Alexander Chernokoz Artem Trofimov et al.

Source: Communications in Computer and Information Science ISBN: 9783030938482

SQL UŽKLAUSŲ OPTIMIZAVIMO TYRIMAS = SQL QUERY OPTIMIZATION RESEARCH

Authors: Jurgita Lieponienė

Source: Taikomieji tyrimai studijose ir praktikoje, Vol 13, Iss 1, Pp 94-101 (2017)

Subject Terms: sql query, database index, normalization of the database, denormalization of the database, Social sciences (General), H1-99

File Description: electronic resource

Relation: https://ojs.panko.lt/index.php/ARSP/article/view/40/27; https://doaj.org/toc/2029-1280; https://doaj.org/toc/2669-0071

Access URL: https://doaj.org/article/0eab8f59551940b484092b3fa656c273

External optimization of SQL-query under conditions of databases structural uncertainty

Authors: Mykhaylo Zagirnyak P. Kostenko

Source: 2016 17th International Conference Computational Problems of Electrical Engineering (CPEE). :1-4

Subject Terms: 0202 electrical engineering, electronic engineering, information engineering, 02 engineering and technology

Access URL: https://ieeexplore.ieee.org/document/7738723/

SQL Query Optimization by Predicting Multiple Logical Plans with Machine Learning

Authors: Punter, Wieger R.

Index Terms: Master, Master

URL: https://pure.tue.nl/ws/files/305006245/Punter_W.pdf
https://pure.tue.nl/ws/files/305006245/Punter_W.pdf

A novel approach for SQL query optimization

Authors: Fernaz Jasdanwala Sahista Machchhar Fazal Mithani

Source: 2016 IEEE International Conference on Computational Intelligence and Computing Research (ICCIC). :1-4

Access URL: https://ieeexplore.ieee.org/document/7919717/

SQL query optimization in Content Based Image Retrieval systems

Authors: Nicoleta Angelescu Catalin Dragoi Ion Caciula et al.

Source: 2016 International Conference on Communications (COMM). :395-398

Subject Terms: 0209 industrial biotechnology, 0202 electrical engineering, electronic engineering, information engineering, 02 engineering and technology

Access URL: http://ieeexplore.ieee.org/document/7528344
https://ieeexplore.ieee.org/document/7528344

Query Optimization using Sketches in Relational Database Systems

Authors: Izenov, Yesdaulet

Subject Terms: Computer science, Computer engineering, Information science, cardinality estimation, database, plan enumeration, query optimization, sketches, sql

File Description: application/pdf

Access URL: https://escholarship.org/uc/item/5k8334fs
https://escholarship.org/content/qt5k8334fs/qt5k8334fs.pdf

Improving SQL Performance Using Middleware-Based Query Rewriting

Authors: Bai, Qiushi

Subject Terms: Computer science, Database, Middleware, Query Optimization, Query Rewrite

File Description: application/pdf

Access URL: https://escholarship.org/uc/item/5pw8w7rj
https://escholarship.org/content/qt5pw8w7rj/qt5pw8w7rj.pdf

Optimization of Linear Recursive Queries in SQL

Authors: Carlos Ordonez

Source: IEEE Transactions on Knowledge and Data Engineering. 22:264-277

Subject Terms: 0202 electrical engineering, electronic engineering, information engineering, 02 engineering and technology

Access URL: http://yadda.icm.edu.pl/yadda/element/bwmeta1.element.ieee-000004815244
https://doi.ieeecomputersociety.org/10.1109/TKDE.2009.83
http://www2.cs.uh.edu/~ordonez/pdfwww/w-2010-TKDE-lrq.pdf
http://ieeexplore.ieee.org/document/4815244/
https://dblp.uni-trier.de/db/journals/tkde/tkde22.html#Ordonez10
https://www.infona.pl/resource/bwmeta1.element.ieee-art-000004815244

MPP SQL Query Optimization with RTCG

Authors: M. A. Sakkeer Jimson Johnson Shiju Andrews et al.

Source: Lecture Notes in Computer Science ISBN: 9783030047795

Access URL: https://dblp.uni-trier.de/db/conf/bigda/bigda2018.html#SridharSAJ18
https://link.springer.com/chapter/10.1007/978-3-030-04780-1_16
https://rd.springer.com/chapter/10.1007/978-3-030-04780-1_16

AI-driven SQL query optimization techniques

Authors: Juopperi, Tatiana

Subject Terms: fi=Tietojenkäsittely|sv=Informationsbehandling|en=Business Information Technology, SQL, query languages, databases, optimisation, artificial intelligence, database programs, machine learning, Query, relational databases, distributed systems, Degree Programme in Business Information Technology

Relation: https://www.theseus.fi/handle/10024/861818

Availability: https://www.theseus.fi/handle/10024/861818